How to pass Null value to Multivalue Parameters in SSRS

Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

oscarooko SSC-Addicted Points: 445 More actions · Answer 1

1)Click to open up the parameter folder in your report solution

2)Right click on the appropriate parameter that you want to pass a null value on

3)Under the "General" tab, make sure the "Allow Null Value "check box is selected.

4) Under the "Default Value" tab, select "Specify Value"

When you run the report, you should have the option to select multiple values or a null.

I hope that helps!