How To Set Up A Working Report Mult-Value + (Select All) Filter Dropdown in SSRS 2005
Tone' ShelbyMicrosoft® Power BI, Power Apps & O365 Design, Development
I build, provide, educate & evangelize innovative data insight & business productivity solutions.
http://linkedin.com/in/toneshelby
Published:
Updated:
Browse All Articles > How To Set Up A Working Report Mult-Value + (Select All) Filter Dropdown in SSRS 2005
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.
Comments (0)