Jump to content

Check out our Community Blogs

- - - - -

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

  Posted by Barnsite, 17 December 2012 · 2681 views

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


  • 0

My Picture

0 user(s) viewing

0 members, 0 guests, 0 anonymous users


Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download