Skip to content

Display ALL when (Select All) in Multi-value parameter selection

September 24, 2014


Let’s say we are using a Multi-value parameter and requirement is to show selected values in report output. Then simply we can use following expression

=Join(Parameters!YourMultivalueParameterName.value,”,”)
But if list of available values are too big and requirement is to show ALL in report output instead of huge list in case of (Select All) 

 then we can use following expression
=IIF(Parameters! YourMultivalueParameterName.Count=Count(Fields!DataSetFieldName.Value, “Name OF Your DataSet”),”ALL”,Join(Parameters! YourMultivalueParameterName.Value,”,”))

From → SSRS

Leave a Comment

Leave a comment