Display Parameter(Multi-value) in Report

Question

Hi, Can anyone tell me how to display all the selected value of my multi value parameter in SSRS report. When giving parameter.value option it gives error.

Thanks in advance. Suni

Answer 1

You can use the "Join" function to create a single string out of the array of labels, like this:

=Join(Parameters!Product.Label, ",")

Answer 2

I'm not sure if this is what you're looking for: http://dbalink.wordpress.com/2008/10/18/the-all-parameter-in-sql-server-reporting-services-2005/ . Give it a shot.

Answer 3

=Join(Parameters!Product.Label, vbcrfl) for new line

Answer 4

I didn't know about the join function - Nice! I had written a function that I placed in the code section (report properties->code tab:

Public Function ShowParmValues(ByVal parm as Parameter) as string
   Dim s as String 

      For i as integer = 0 to parm.Count-1
         s &= CStr(parm.value(i)) & IIF( i < parm.Count-1, ", ","")
      Next
  Return s
End Function