Post reply

Multi-value parameters and multiple datasets

  • July 29, 2010 at 12:25 am

    #227265

    Hi,

    I'm an absolute beginner in SSRS. I know this topic has been done to death...but didn't get what I was looking for.

    I have 4 parameters, one single valued and others multi-valued. Each combination of values selected by the user should be displayed in two different pages serially. The second page should also display data from another dataset.

    I tried using listboxes and tables for displaying the parameter values properly but it's not working. Please tell me how to go about this. Thank you!

    I'm using VS 2005 btw...

  • July 30, 2010 at 8:05 am

    #1200345

    To display the multivalue parameters, use the following syntax in a textbox. =Join(Parameters!Test.Value, ", ")

    If you need to display the contents of the multivalue paramater in a table, create a dataset and pass in the parameters using the Join function. Once the values are in a dataset then it would be easy to display them in a table.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply