Jump to content


Check out our Community Blogs





- - - - -

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

  Posted by Barnsite, 17 December 2012 · 1886 views

programming
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):
Posted Image
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:
Posted Image
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.
http://feeds.wordpre...dpress.com/520/ Posted Image

Source

  • 0