CODEWITHSUNDEEP
reporting-servicespowerbireportbuilder
PAVAN
PAVAN

Reputation: 31

Custom value using Cascading Parameter in ssrs /report builder

I have scenario i have a dataset which is used for cascading parameter which is able to select multi select values . I need to display the selected values in the report . So if all values are selected in parameters should display as "ALL " , ELSE if any values selected should display as selected values in the report

Note : parameters are cascading type . Assue data sets has more than one column

Upvotes: 0

Views: 248

Answers (1)

papermoon88
papermoon88

Reputation: 476

In your header section, create a placeholder and use this in the expression:

=switch(Parameters!folder.Count = CountRows("your_dataset"),"Value (s): All",
    Parameters!folder.Count <> CountRows("your_dataset"), "Value (s): " + (JOIN(Parameters!folder.Label,", ")))

Replace your_dataset with the dataset used for your parameter. It will display "Value (s): All" when all values are selected, otherwise it will display the selected values separated by comma.

Upvotes: 0

Related Questions