Passing multiple values for a single parameter in Reporting Services

sql reporting-services parameters query-string
Scott and the Dev Team picture Scott and the Dev Team · Feb 4, 2009 · Viewed 284.6k times · Source

I have several Multi-Select parameters in my report. I am trying to find a way to pass in multiple values for a single parameter in the web query string? If I pass in a single value, it works fine.

The report runs fine selecting multiple choices for a single param. My trouble lies in the web query string.

Answer

Ed Harper picture Ed Harper · Feb 6, 2009

Although John Sansom's solution works, there's another way to do this, without having to use a potentially inefficient scalar valued UDF. In the SSRS report, on the parameters tab of the query definition, set the parameter value to 

=join(Parameters!<your param name>.Value,",")

In your query, you can then reference the value like so:

where yourColumn in (@<your param name>)

Related questions

Passing multivalue parameter to a subreport

I'm having a problem when working with multivalue parameters between reports. I have a main report in which I have defined a multivalue paramer, which I use to run a SQL query to populate its dataset. The parameter is used …

Read More
SSRS Grey out Parameter based on result from other Parameter

I wondered if it was possible to grey out a parameter based on the the result from another parameter? In this case, if specify date is set to 'No' then Start Date and End Date should be greyed out. As …

Read More
SSRS - How to add a default value to a parameter with Available Values from a query?

I have an SSRS report which contains a parameter ID, which will display sales totals for a person with selected ID. I get the options for the parameter by selecting "Get values from a query" under the Parameter's "Available Values" …

Read More