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
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.