multi-value parameter in header

• Marianne L Collins

  SSCommitted

  Points: 1895

  More actions

  September 7, 2007 at 4:07 pm

  #174628

  Hi.  I'm using Reporting Services 2005.  We generally put our parameter values in the header (so that the user will know what the parameters are when the report is exported to excel).  However, it doesn't work when I have a multi-value parameter.  I thought, since the parameter is passed to the stored procedure as a string, it should show up the same way in the report.

  I created a text box in the header with the expression "=Parameters!OperatingUnitName.Value" but when I generate the report, the text box shows "#Error".  I have also tried "=Parameters!OperatingUnitName.Label"

  Any ideas on how to get those values in my page header?

  Thanks, Marianne

• Marianne L Collins

  SSCommitted

  Points: 1895

  More actions

  September 7, 2007 at 5:19 pm

  #732296

  I just found the answer:  =Join(Parameters!OperatingUnitName.Value, ", ")

  http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2014867&SiteID=1