how to display multivalued parameter value in SSRS text box

reporting-services ssrs-2008 ssrs-2008-r2 ssrs-tablix ssrs-grouping
SqlLearner picture SqlLearner · Sep 23, 2014 · Viewed 14.1k times · Source

I am having a multivalued parameter 'client',i have almost 60 values in the client parameter,my requirement is display the selected client values in the header text box but when i select 'SELECT ALL' option in the parameter i should display just 'ALL' rather than displaying all the 60 values.

I am using the below expression to display parameter values which is working fine

="For Client -" & Join(Parameters!Client.Value, ",")

now how can i display 'ALL' rather than displaying all the client values when i select 'Select ALL' option?

Answer

Aftab Ansari picture Aftab Ansari · Sep 23, 2014

Try this:

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

Related questions

How to hide parameter based on another parameter value in SSRS

Hi I have 2 parameters param1 and param2. param1 has values true and false.my requirement is if i select true in param1 then param2 should be hidden and if i select false in param1 then param2 should be visible. can …

Read More
How to align different Tablix in SSRS

I have a SSRS report in which i need to align multiple tablix in same Order as i need to export to EXCEL The other tablix's is just a copy of the first tablix with only change of data set.…

Read More
Interactive sorting In SSRS on Values - Matrix report

I want a interactive sorting in SSRS matrix report. From database we are getting 3 columns -PrimaryKey,Columns and Value. We are grouping rows by Primary Key and grouping column by Columns and use Value as data. My Matrix Report - …

Read More