How To Set Up A Working Report Mult-Value + (Select All) Filter Dropdown in SSRS 2005

Published on
7,327 Points
Last Modified:
Tone' Shelby
I build, provide, educate & evangelize innovative data insight & business productivity solutions.
1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String

2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success

Example:    @cst_key varchar(max)

3. Set  the WHERE clause to use a split string function so it can parse out the comma seperated values into an array & back out to the calling procedure.

If you already have one that splits strings into a comma seperated value, that will work fine but if you do not,
you can find a handy one here by Expert; chrismc @ http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_23470331.html

Then plug it into the WHERE Clause of your Stored Procedure


       ([cst_key] IN (SELECT VALUE FROM [dbo].[ufn_Split](@cst_key))


Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Join & Write a Comment

Overview of OneDrive and collaboration.
This is Part-2 of Learning to use the Power of Mailwasher Pro so if you haven't watched Part-1 yet, I urge you to do so before watching this video. Click this link to watch Part-1 (https://www.experts-exchange.com/videos/56638/Learn-to-use-the-POWER…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month