This seems like it should be easy, but SSRS has nothing built in to allow you to do this. I searched an couldn’t come up with a solution that fit all my requirements for a report. There are ways to default the selection list to every value in the list, but I needed to add…
Tag: Filters
SQL Analysis Services
Reports in SSRS with Multi Value Parameters and NULL Values
by Bo Jensen •
If you are creating a SSRS report in Visual Studio 2008 and would like a parameter to display multiple values including NULL values, you will get a message saying, “A multi-value parameter cannot include null values”.
SQL Analysis Services
SSRS optional parameters settings
by Bo Jensen •
Recently I had to create couple SQL Server Reports (SSRS) with optional parameters built in. It took me a while to refresh memory how this can be done. It was very simple to create reports and processes behind, but connecting these two were are little bit challenging – stored procedure was tested and worked fine,…
SQL Analysis Services
Optional filter in SSRS | Musings by Generator
by Bo Jensen •
I am astonished that this is not a feature in SSRS. How can you expect business users to create expressions to handle an optional filter. So for those looking how to do an optional filter on a parameter, here is how to do it: