What is wrong with this code?

• compufreak

  SSC Eights!

  Points: 951

  More actions

  October 28, 2014 at 6:59 am

  #291975

  =IIF(Parameters!Section.Count=Count("SectionName", "section"),"ALL",Join(Parameters!Section.Value,","))

  i am trying to display "ALL" but it is not working out.

  i have even tried this :

  =IIF(Parameters!YourParameter.Count=Count(Fields!DataSetFieldName.Value, "Name OF Your DataSet"),"ALL",Join(Parameters! YourParameter.Value,","))

  and it does not work out.

  any suggestions guys?

• syedathariqbal

  Hall of Fame

  Points: 3175

  More actions

  November 10, 2014 at 3:30 am

  #1757378

  Shouldn't second "Count" be "CountRows" ?

  try something like below

  =IIF(Parameters!YourParameter.Count=CountRows(Fields!DataSetFieldName.Value, "Name OF Your DataSet"),"ALL",Join(Parameters! YourParameter.Value,","))

  <I haven't tested above, kindly give it a try>

• compufreak

  SSC Eights!

  Points: 951

  More actions

  November 24, 2014 at 3:06 am

  #1760436

  thanks man for the response.

  i just added the number of rows and it worked perfectly