Link to home
Start Free TrialLog in
Avatar of CrypticSolution
CrypticSolution

asked on

Manually Updating a parameter to a deployed report in SQL server 2000 Reporting Services

Hi I need to add a new value to an existing parameter on old report deployed on an SQL 2000 servers, so I don;t have to reinstall VS 2003! I was hoping I could just find an XML file on the server and add the value, but I can't find where the report is deployed and I don't know anything about the structure on the DB is there a way to this without modifying the source and redeploying?
Avatar of digital_thoughts
digital_thoughts

What do you mean by "add a new value to an existing parameter", I'm assuming you have a drop down with selectable values that you have manually entered on the report?

If you have the source for the report, in any text editor you can open the .rdl file, find you parameter and add another value in the XML, then upload the report to your report server.
Avatar of CrypticSolution

ASKER

you assumed correctly, however I upgraded the source for the report in VS 2005 and not realizing it's incompatiable with SQL reporting server for 2000,  I thought the file was in source safe, but it wasn't so now short or going back and redoing the whole report, I was hoping I could manually do on the server....
ASKER CERTIFIED SOLUTION
Avatar of digital_thoughts
digital_thoughts

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial