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):


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:


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.

This entry was posted in Programming and tagged , , , , , . Bookmark the permalink.

Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s