[SOLVED] SQL Server 2012 Reporting Services Report Viewer – The parameter does not default to NULL

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:

Report Viewer Default NULL not checked

Report Viewer Default NULL not checked

This happened even though I made sure the setting “Allow null value” was applied in the Report Builder:

Report Builder Parameters Properties

Report Builder Parameters Properties

I binged a bit and found this post on MSDN forum, answered by Charles Wang, and his tip worked. Here are the steps:

  1. Go to your Report Manager, find your report and select “Manage“.
  2. Click on the “Parameters” tab on the left panel.
  3. Check the box “Has Default” for your parameter and click the “Apply” button.
    Report Manager Parameters Properties

    Report Manager Parameters Properties

  4. Voilà ! Now the box is checked in the Report Viewer:
    Report Viewer Default NULL is now checked

    Report Viewer Default NULL is now checked

I hope this helps,
Emmanuel

Advertisements
This entry was posted in Computer, HOWTO, SQL Server, Tip and tagged , , , , , , , . Bookmark the permalink.

3 Responses to [SOLVED] SQL Server 2012 Reporting Services Report Viewer – The parameter does not default to NULL

  1. Travis says:

    Thank you very much. I worked on this for hours, feeling a little silly now.

  2. nayariht says:

    thank you it works!

  3. Daniel says:

    Muchas gracias! Me salvaste el día!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s