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

Posted on 2009-02-11
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
    LVL 84
    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 ...
    LVL 1

    Author Comment

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

    Accepted Solution

    I feel stupid, this worked for me...."Actions" --> "View in windows Explorer" --> "copy (rdl) \ paste (rdl)"

    Expert Comment

    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

    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?
    LVL 1

    Author Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Hello, In my precious Article  ( saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
    Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now