We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

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

Medium Priority
1,189 Views
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.
Comment
Watch Question

Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
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 ...
sqlagent007Technology professional

Author

Commented:
I know exactly where the report is located. I am clicking around, but I can't figure out how to copy it locally.
Technology professional
Commented:
I feel stupid, this worked for me...."Actions" --> "View in windows Explorer" --> "copy (rdl) \ paste (rdl)"

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Commented:
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 ...

Commented:
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?
sqlagent007Technology professional

Author

Commented:
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.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.