Showing multivalue parameter list in Report Header

• diana.bodell-1122803

  Old Hand

  Points: 300

  More actions

  November 30, 2009 at 9:42 am

  #213048

  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

• ezytime

  SSCommitted

  Points: 1846

  More actions

  November 30, 2009 at 4:39 pm

  #1085589

  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.

• diana.bodell-1122803

  Old Hand

  Points: 300

  More actions

  December 1, 2009 at 7:50 am

  #1085816

  Thank you so much! Glad it was something so simple!:-D