SSRS: Passing multi-value parameters in an URL

There is a lot of discussion on the forums about passing parameters to an SSRS report using an URL however one of the items that you rarely read about is the passing of multi valued parameters in an URL.

To do this, just pass the name/value pair, separated by the ampersand.

Syntax:
http://server/ReportServer?/dir/Report&rs:Command=Render
&Parameter=Value1&Parameter=Value2&Parameter=Value3

An actual example:
="http://server/ReportServer/Pages/ReportViewer.aspx?%2fDIR1%2fDIR2%2fDIR3&rs:Command=Render"
+"&Param1="+JOIN(Parameters!Param1.Value,"&Param1=")
+"&Param2="+JOIN(Parameters!Param2.Value,"&Param2=")

Example:
I made a very basic report that displays the actual Parameter Value that was fed to the report and split it with my MultiValue-function for use in a table:

Available Values set for the @MultiParam:

The URL I’m going to use to select two values out of the five default values:
http://<>/ReportServer/Pages/ReportViewer.aspx?%2fDB_ACPT%2fReportMultiParam&rs:Command=Render
&MultiParam=Value2&MultiParam=Value4

Result:

Advertisements

2 thoughts on “SSRS: Passing multi-value parameters in an URL

  1. Wow that was unusual. I just wrote an very long comment but after I clicked submit my comment didn’t show up. Grrrr… well I’m not writing all that over again.
    Anyway, just wanted to say great blog!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s