SSRS- default value for paramater works in design but not Sharepoint

Question

I have a date parameter that allows NULL. I set the default to NULL and it works fine in the design environment (checkbox is checked). When I push it to SharePoint and try to execute the report, the NULL checkbox is not checked. Any idea why?

I am using SP 2012 and SSRS 2012.

Does the report already exist on SharePoint, and you are making modifications to it? — R. Richards
It exists. I just updated it. If I delete it, the subscriptions will be lost. — user1612851

Hannover Fist Hannover Fist · Accepted Answer · 2016-08-31T23:16:14

Unfortunately, when you change parameters, the report must be deleted and re-deployed.

There's a 7 year old Connect issue open with Microsoft that they haven't gotten around to fixing yet.

https://connect.microsoft.com/SQLServer/feedback/details/299372/report-parameter-defaults-not-updated-during-deployment

SSRS- default value for paramater works in design but not Sharepoint

1 Answers