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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.