Changing Default Parameter Value SSRS (SQL Server Reporting Services) 2008

If you’re here you have probably found that if you’ve deployed a report to your server updating the default parameter values and redeploying has no effect on the server report.

E.g. I had a report with an integer parameter with a default of 25 that had been deployed to the server. On my development machine I updated the default value and redeployed the report. However, when I ran the report the default value hadn’t changed.

The reason for this is that the parameters are managed on the server once the report has been deployed. So to change them you need to log in to your reporting services on your server (you’ll have a screen something like the one below):

ssrs1

To update your parameters, select “Manage” from the drop-down list on the report you want to change. You should see a screen like below:

ssrs2

Click on the “Parameters” option on the left-hand side and you will be taken to a screen that allows you to update parameter options for the report.

Be First to Comment

Leave a Reply