Default Values for parameters not working in SSRS with SharePoint integration

I faced this problem while trying to set default values to parameters in a report that resides within the SharePoint site.

It turned out that once a report is uploaded to SharePoint, the default values for parameters are maintained in the server, so subsequent changes to the default values will have no effect after saving or overwriting the report in the server.

To solve this, delete the report from the server and upload the report again. Quite stupid, but it works.

Leave a Reply

Your email address will not be published. Required fields are marked *