Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to pass Null value to Multivalue Parameters in SSRS Expand / Collapse
Author
Message
Posted Tuesday, September 3, 2013 2:51 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 5, 2013 6:12 AM
Points: 30, Visits: 76
Hi Folks,

Could you please help me out, how can I pass Null Values to Multivalue Parameters dropdown and how can I make the NULL as default when user first runs the report?

Many thanks for all your help.
Post #1491095
Posted Monday, September 16, 2013 12:35 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 3:52 PM
Points: 27, Visits: 153
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!
Post #1495237
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse