I just find a function to display multiple values horizontally on SSRS report separated by comma which are selected by a user using multi value parameter on report dialog. The function name is Join, which takes the the report parameter as its first input and delimiter as second input. The syntax is shown below:

=Join(Parameters!MyMultivalueParameter.Value,”,”).

The above expression will display all the values separated by comma which are selected by a user on report dialog using multi select parameter.

Advertisements