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?
CrypticSolutionAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

digital_thoughtsCommented:
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.
0
CrypticSolutionAuthor Commented:
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....
0
digital_thoughtsCommented:
Ok, if you go to your web interface to your report server, usually http://servername/reports -- then browse to the report, click the "Properties" tab at the top, then on the General tab/button, right above the "Apply", "Create Linked Report", "Delete" and "Move" buttons, do you have a "Report Definition" section? If so, click the "Edit" link to download the .rdl file, make the changes, then click the "Edit" link to upload the change.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.