CODEWITHSUNDEEP
reporting-servicesssrs-2014
John
John

Reputation: 1247

SSRS Report Parameter Default Null Value not Applied

I have a SSRS report with a single integer parameter.

Using Report Builder I've:

However, when the report is requested from the server, the parameter is empty (rather than Null) and the Null checkbox isn't ticked.

Upvotes: 6

Views: 6969

Answers (2)

Mindy Grubbs
Mindy Grubbs

Reputation: 21

I was able to resolve this issue by clicking on the drop-down menu to the right of the report name (on the SSRS report page). Select "Manage" > Select "Parameters" tab > check the "Has Default" boxes for the parameters that show "Null" as the default values. This fixed it for me.

Upvotes: 2

John
John

Reputation: 1247

Even though the report was being saved with the change, this wasn't being observed when it was rendered and returned by the server.

I had to use 'Save As' to save the report as a different name to get the change to apply. I could then delete the original report and rename the revised report to that of the original.

Upvotes: 5

Related Questions