Search code examples
reporting-servicestextboxssrs-2008runtime-errorexpression

#Error in SSRS expression

In my report, I have to include All Courses info(in the report) which is in parameter(selected value)

I am using this expression in checkbox:

="Course: " & Parameters!Course.Label

But this throws an #Error when I run the report. Any idea where am I going wrong.

Thanks, Ar

Solution

  • Try this:

    ="Course: " & Join(Parameters!Year.Label, ",")

    If your parameter is multivalue it is necessary to join the labels it returns, if you select multiple values the join() function will return comma separated values.