Points: 7933

2/28/2014 9:40:49 AM

SSRS - Handling an ALL parameter

* This article, and all our great SQL Server Reporting Services documentation, Is available on the SQL Server Reporting Services menu

I handled a support call today to help a developer handle a parameter that was in a dropdown list that had an 'All' at the top of it. Note that this is not the 'multi select' functionality that SSRS supports, just a dropdown list that has the word 'All' at the top. The screen shot below shows how to handle this issue.
Version: Unknown or N/A
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables