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

Question

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.

It's not only possible, it's easy. What part of it do you have a question about? — Tab Alleman
On a single-value parameter (a dropdown that allow you to select one value at a time) how to add a value that select all — Elound

Tab Alleman Tab Alleman · Accepted Answer · 2014-11-03T19:45:24

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')

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

1 Answers