November 30, 2009 at 9:42 am
I am writing reports in SSRS 2008 using parameters with multiple values allowed for selection. I put a text box in the report header with the expression =Parameters!Loc.Value(0) by selecting the parameter from the list of parameter fields in the expression builder. However, when I preview the report, only the first parameter value displays in the text box. In other words, if the user selects values A, B and C for the parameter, only A will appear in the header where the list is supposed to display.
Any help is much appreciated. I am a relative newbie to SSRS.
Diana
November 30, 2009 at 4:39 pm
Hi. This is a common requirement. Probably what you need is this expression in the textbox:
=Join(Parameters!YourParameterName.Label, ", ")
OR
=Join(Parameters!YourParameterName.Value, ", ")
depending which you want to display.
Note that the (0) in your example is simply retrieving the first selected item in the parameter array.
December 1, 2009 at 7:50 am
Thank you so much! Glad it was something so simple!:-D
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply