Display multi-value parameters

In SQL Server 2008 Reporting Services all the values from a multi-value parameter can be displayed using the JOIN function as below:

Join(Parameters![parameterName].Label,”, “)

The second parameter accepted by this function being the separating character.  It took me a lot of trawling through BOL to find this.

Advertisements

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