SSRS Multi Value Parameter. Check whether “Select All” is selected

To check if user select all values from a multivalued parameter, add a text box and add this as expression of that text box.

=iif(Parameters!MULTI_VALUED_PARAMETER_NAME.Count = COUNTROWS("MULTI_VALUED_PARAMETER_DATASET_NAME"),"ALL SELECTED","; SELECTTED_VALUES:  " + Join(Parameters!MULTI_VALUED_PARAMETER_NAME.Value, ","))
Advertisements
By simplemsexchange Posted in SSRS

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s