How to allow blank values for multitple parameters

Question

I have multiple parameters for a report in SSRS Report Builder. I want all the parameters to allow blank values if no selection is necessary, but when I try to run the Report, the first parameter will allow a null/blank value and it will prompt me for the rest of the parameters. Is there any way around this?

Answer 1

1. Set Allow Blank Value(and/or Allow NULL Values) for all the parameteres.

   

2. If the Available values are set, make sure your available values for the parameter brings Blank(and/or NULL) values.

   If it comes from query. Update your query something like this:

   SELECT FieldX FROM Table1 WHERE blah=blah UNION
SELECT '' UNION
SELECT NULL

   If it is specify values then specify Blank and NULL values

   

3. Set the Default values to pull the blank(OR NULL) depending on your requirement. For Blank leave the value as empty.

   

4. Final thing your query which produces the data can handle Blank(and/or NULL) values.