Setting up a Multi Valued Parameter List in Reporting Services

So you've managed to set up a dropdown pick list for your Reporting Services report, now they want to be able to pick multiple values at once - users! It's incredibly easy to do though. We'll repeat the lesson showing how to build the picklist, and then show you the two extra steps needed to support multiple values.

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Dave on 4/16/2010

Any idea how this works for other data types? I notice in the video the Parameter is set to 'Text' and you are just providing a number, so for an IN list (1,2,3) works fine. What about if you are checking off names? Does the report build an IN list of ('Mark','Jim','Bob') with the single quotes added?

Bryan Geiger on 4/16/2010

Would be nice to see that same functionality but with a store procedure

Joe on 4/16/2010

I only way have have found to use stored procedures with multi valued report parameters is that you have to join the comma delimited list to create a single parameter to pass into the stored procedure. Then the stored procedure should spits the joined list back out using a user defined function. Here is a good example http://munishbansal.wordpress.com/2008/12/29/passing-multi-value-parameter-in-stored-procedure-ssrs-report/

Clayton Smith on 4/16/2010

You can also have multiple default values forma multi valued list. To do that all you do is create a select query of the values and assign that to the default value part of the parameter.

Gary Fairchild on 4/16/2010

How can I allow the user to select none so all the events showup in one report.

Mark E. Siltala on 4/16/2010

Very good info - I'm sure I'll be using it soon!

Sean on 4/16/2010

What version of SSRS is this? I am still using SQL 2005 and it looks nothing like this demo.

Cosmin Tornea on 4/16/2010

cool

Cosmin Tornea on 4/16/2010

cool

Jamshid Nouri on 4/17/2010

greate demo

Munna Bhai on 4/18/2010

Andy, Thanks for sharing another great video.

gal on 4/22/2010

Great one!

10D36A835F on 5/12/2010

Good

Steve Culshaw on 5/29/2010

More good content

Jason Yousef on 10/1/2010

thanks

Jason Yousef on 10/1/2010

thanks

Dima on 11/19/2010

Thank you, I watched it second time and I like it.

Malintha on 11/2/2011

very good