There are times when you want to display in a textbox on your report the value of a multi valued parameter. If blank is a valid value for your parameter, you don’t want to display the comma in your textbox that follows the blank
For example:
, Bird, Cat, Dog, Fish
What to do:
1) Sort your values in ascending order. The blank parameter will show up first.
2) In your textbox expression, type the following:
=join(Parameters!NonHumans.Value, ",").Remove(1,1)
The result will be as above but without the iniitial comma.
Bird, Cat, Dog, Fish