Search code examples
sqlreporting-servicesparametersreportingservices-2005reportparameter

SSRS report parameter - single selection dropdown with ''select all''

I am re-creating a report that have been built with some obscure reporting technology and the report have some parameters (dropdown box filters). All the dropdown allow only one value to be selected at a time, but also include the 'All' selection at the top of the list. So you can see the report without filter(All) or filter it on a single value selection. Is this possible in SSRS?

PS: I would do it with multi value and the same query in default value to select all, but since I have 6 parameters, the main query ends up with 6 "WHERE...IN..." clause and takes more then 15 minutes to run.

Any suggestion would be greatly appreciated.

Elound.

Solution

  • Add a value to each drop-down with "All" for the label and value.

    Then in your SQL you handle each parameter with the value of the parameter that was passed, OR if the value was "All" then don't filter by that parameter.

    Something like:

    WHERE (SomeColumn = @SomeParameter OR @SomeParameter = 'All')