Multiple Paremeter in Header

• sharonsql2013

  SSCertifiable

  Points: 5908

  More actions

  October 29, 2014 at 2:37 pm

  #291620

  I am trying to display "All Teams" wherever I select "Select All" from Multiple values displayed in parameter.

  In the Query I am passing the where as where team = @TEAM.

  In the Parameters I have selected Allow Multiple Options.

  In the Header when I pass = Join(Parameters!TEAM.value, ", ") It brings up 20 names in the header. Instead I want it to display "ALL teams" , How can I achieve this?

• sharonsql2013

  SSCertifiable

  Points: 5908

  More actions

  October 29, 2014 at 2:51 pm

  #1755644

  Well, This did the trick...IIF(Parameters!TEAM.Count =Count(Fields!TEAM.Value, "Parameter"),"All Group",Join(Parameters!TEAM.Value, ", "))