SQL Server Reporting Services (SSRS) – How to remove the first character of a multi valued report parameter when displaying the parameter in a textbox

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

Leave a Reply