Passing Multiple values to SSRS via a URL

Question

I have a report in SSRS 2008 with a drill through report which I invoke from an URL. I need to pass the values of a paramater that may have multiple values selected via the URL. Is there a way to convert the parameter's values to something that I can pass via the URL?

---

Ockert

Answer 1

To pass the parameters explicitly, try this:

http://<servername>/Reportserver?%2fFolderName%2fReportName&rs:Command=Render&Param1=Sales&Param2=Client&Param3=No


Otherwise, if you want to pass parameters that are pre-existing in the originating report, try something more like:

="http://<servername>/Reportserver?%2fFolderName%2fReportName&rs:Command=Render&Param1="+Parameters!Parameter1.Value+"&Param2="+Parameters!Parameter2.Value+"&Param3="+Parameters!Parameter3.Value

Hth...

Answer 2

The problem is not passing single value parameters. To use your sample if Parameter1 was configured to allow multi select and the user have selected more than one value, how can I pass all the selected values to the target report's Param1 parameter? ...Param1="+Parameters!Parameter1.Value(0)+ "," + Parameters!Parameter1.Value(1)... does not work

---

Ockert

Answer 3

Use Join function. It depends, an example would be: =Join(Parameters!Parameter1.Value, ",")

To construct a URL, use like Aaron example:
="http://<servername>/Reportserver?%2fFolderName%2fReportName&rs:Command=Render&Parameter1=" & Join(Parameters!Parameter1.Value, "&Parameter1=")

hth.

---

Chicagoan ...