Home Forums Reporting Services Reporting Services Display "All" for Header in case of Multiple Parameter RE: Display "All" for Header in case of Multiple Parameter

  • 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!