Display ALL when (Select All) in Multi-value parameter selection
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,”,”))
Leave a Comment