Here’s the problem statement:
You’ve a multi select parameter on your SSRS report and you need a way to display that on that the SSRS report. (Note: It’s a good practice because when the report is printed out the parameter values that were selected gets displayed and the consumer know that’s right off the bat.) – So how do you do that?
You added an expression on your report and double clicked on the parameter. If you do so, something like this will show up on your expression values: =Parameters!ProductCategory.Value(0) and after you changed Value to Label “=Parameters!ProductCategory.Label(0)” – here’s what you get on the report:
Solution:
I learned this trick via this stackoverflow thread.
Go back to expression and set the value of the expression to:
[code language=”sql” gator=”false”]
=Join(Parameters!ProductCategory.Label,",")
[/code]
And after I did that, it fixed the problem!
I hope this gives a good starting point!