How to check out or edit a SQL server report (.rdl) deployed to a sharepoint site
Posted on 2009-02-11
I have used SSRS before to edit and publish reports to the SQL server reporting server, and I was able to edit these by going to the properties of the report, then saving the .rdl file locally and opening it with an SSRS project.
The sharepoint developer for our company has moved onto better things, and now I need to edit one of the .rdl files I asked him to publish.
How do I get it out of sharepoint and onto my desktop? I have clicked myself into insanity. I feel like I am in a circle looking for the corner.
Please give me step by step instructions on how to edit this (.rdl) file and check it back in so every one else uses the new .rdl file. I need to add a column to the query.
To add a slight bit of complexity, I don't think I have any of the tools like report designer, or any of the sharepoint tools. I would need to copy the .rdl file locally, the edit it with BIDS, then check it back in.