If your SSRS report has a multivalue parameter and you would like to display the values that were selected on the report itself, use the JOIN functions to list them delimited by commas (or whatever other character you'd like). Just insert a text box on your report and insert the following expression:
=JOIN(Parameters!YourParameterName.Value, ", ")
So if for example your parameter allows you to choose the name of a country, the output using the above expression after selecting a few countries would be something like this:
Canada, Brazil, Dominican Republic, Cuba, USA, Italy
=JOIN(Parameters!YourParameterName.Value, ", ")
So if for example your parameter allows you to choose the name of a country, the output using the above expression after selecting a few countries would be something like this:
Canada, Brazil, Dominican Republic, Cuba, USA, Italy
Posts
0 comments:
Post a Comment