Reputation: 1036
I have several date parameters in my SSRS report. I check "Allow null value" and "No default value". When I preview the report in Visual Studio, the NULL checkbox next to the date is checked, just what I want. However, when I run this same report in the browser, the NULL checkboxes are NOT checked. If I specify a default value of (Null) I get the same exact results.
Upvotes: 1
Views: 3225
Reputation: 1
Once report is uploaded, go to Manage -> Parameters -> and check the "use defaul values" check box
Upvotes: 0
Reputation: 6508
You must have to check parameters on report server and make sure Has Default is checked along with the Null.
Upvotes: 1
Reputation: 1036
Did some more digging and found this answer that solved the problem. Apparently the server is not smart enough and has to manually be set.
Null checkboxes are not checked on load of SSRS report in browser. Why?
Upvotes: 2
Reputation: 10870
I believe you just need to set the Default value to NULL to make it work the way you expect.
Upvotes: 0