How to check out or edit a SQL server report (.rdl) deployed to a sharepoint site

Posted on 2009-02-11
Medium Priority
Last Modified: 2013-11-28
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.
Question by:sqlagent007
  • 3
  • 2
LVL 85
ID: 23612699
You'd have to locate that document on the Sharepoint server. It's impossible to say where that would be; can you Search the Sharepoint site for that specific file name, assuming it exists? It may be stored on the SQL Server, which means you couldn't get to it via a simple search. If that's the case, then I'm not sure what you could do ...

Author Comment

ID: 23612941
I know exactly where the report is located. I am clicking around, but I can't figure out how to copy it locally.

Accepted Solution

sqlagent007 earned 0 total points
ID: 23613640
I feel stupid, this worked for me...."Actions" --> "View in windows Explorer" --> "copy (rdl) \ paste (rdl)"
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Expert Comment

ID: 37279348
Where do you see the "Actions" menu?

When I go to my http://localhost/reportserver, it is basically a page that opens that simply lists the rdl files (and I can click on each one of them to run the reports), but there are no menu options like 'Action'.
The screen just allows me to browse to the different reports, kind of like looking at an FTP site through Internet Explorer ...


Expert Comment

ID: 37279425
I found the "actions" menu by logging into sharepoint at http://localhost (vs. the /reportserver that I was going to earlier).
However, the action - menu does not have the option "view in windows explorer".
The only options are "open with report builder" (which doesn't work since SSRS is running within sharepoint), "subscribe" and "export" (which exports the report data, not the rdl).

How can I edit the rdl report?

Author Comment

ID: 37279468
I think you have to have "site admin" privileges. to see that option. The only way to edit the .rdl is to open it in VS or BIDS. BIDS is part of SQL server, although I don't think it installs by default.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question