[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 162
  • Last Modified:

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?
0
CrypticSolution
Asked:
CrypticSolution
  • 2
1 Solution
 
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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now