Post reply

Display "All" for Header in case of Multiple Parameter

  • June 10, 2014 at 9:50 am

    #287424

    I am trying to display multiple parameter in the header when a person selects them from a list.

    So, I use this in the text box expressions:

    = "Gross Total For : " & Join(Parameters!TeamName.Value, ",")

    How can I select the "Select All "Option and display "All" instead of displaying 50 names.

  • June 10, 2014 at 4:17 pm

    #1720599

    Here's a couple of ways to try assuming that you're filling your list from a query.

    ="Gross Total For : " & iif(Parameters!TeamName.Count = count(Fields!TeamName.Value,"DataSetName"),"All", Join(Parameters!TeamName.Value, ","))

    ="Gross Total For : " & IIF(COUNTROWS("DataSetName").Equals(Parameters!TeamName.Count),"All", Join(Parameters!TeamName.Value, ","))


    Everything is awesome!

  • June 11, 2014 at 9:13 am

    #1720785

    Will try. Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply