I came across a weird behavior with reports today. I was trying to add a new parameter with NULL default value to an existing report in SQL Server 2012 Reporting Services, and when viewing the report, the “NULL” checkbox would not be checked by default:
This happened even though I made sure the setting “Allow null value” was applied in the Report Builder:
I binged a bit and found this post on MSDN forum, answered by Charles Wang, and his tip worked. Here are the steps:
- Go to your Report Manager, find your report and select “Manage“.
- Click on the “Parameters” tab on the left panel.
- Check the box “Has Default” for your parameter and click the “Apply” button.
- Voilà ! Now the box is checked in the Report Viewer:
I hope this helps,