Optional SSRS Parameters - by bt_avalonbay

Status : 


Sign in
to vote
ID 771255 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 11/15/2012 8:02:40 AM
Access Restriction Public


There have been a lot of posts regarding this request over the years, and most have workarounds involving either "inclusive/exclusive" parameter values and/or logic blocks (IF) in your SQL or stored procedures. I do however have a case where I think this would be of value. Please suspend logic for a moment as I'm trying to keep it simple. If a table contains records for the following mix of vehicles and color
Car                 Red
Car                 Blue
Truck              Red
Truck              Black
ATV                Red
ATV                Green
and users are provided with 2 parameters that limit vehicles and colors to those for which a user might be primarily responsible (not used to restrict users' access to records but as a guide and to improve the user experience; assuming there are 50 vehicle types and 1000 colors), what might allow users to filter on ALL Red vehicles (including ATV) if their parameter options for vehicle are limited to Car and Truck?

Just an example, but I'm sure there are others that would benefit from a checkbox that enables/disables the use of parameters. Of course, the underlying SQL/stored procedure would have to accommodate the presence or absence of the filter criteria.
Sign in to post a comment.
Posted by Microsoft on 11/13/2014 at 10:33 AM
Thank you for submitting this feedback. After carefully evaluating all of the suggestion items in our pipeline, we are closing items that we will not implement in the near future due to current higher priority items. We will re-evaluate the closed suggestions again in the future based on the product roadmap.
Thanks again for providing the product suggestion and continued support for our product.
Matt Jones
SQL Server Tiger Team
Posted by Microsoft on 9/13/2013 at 12:10 PM
Thank you for this feedback. It will be forwarded to the appropriate team to consider a an enhancement in a future release.
Posted by Marlon Ribunal on 11/30/2012 at 10:05 AM
Will this be solved through TSQL. You can make a parameter optional (my example here: http://dbalink.wordpress.com/2009/08/11/how-to-report-authoring-in-ssrs-2005-%E2%80%93-part-v-pimp-your-parameters/) and inlcude "ALL" parameters. My example on "ALL" parameter is not complete but it a good place to start, check http://dbalink.wordpress.com/2008/10/18/the-all-parameter-in-sql-server-reporting-services-2005/