locked
Get back the rdl file from report server folder RRS feed

  • Question

  • Hi,

    Does any one know how to get back a report (rdl) file from report server. I deployed my report and lost it on my local machine. I want to get it from report server. i am an administrator to the reports folder on that machine.

    http://Reportserver/reports

     

    Appreciate your help on this.

     

    Thanks,

    Tuesday, October 21, 2008 10:26 PM

Answers

  • Go to the Report Manager, click on the report you need back, go to the Properties tab on the top and click on Edit in the Report Definition section.


    Regards,
    Krisztian

    Tuesday, October 21, 2008 10:43 PM
    Answerer
  •  

    Hello,

     

    This Query is used to get the Reports XML Schema which are on Report server.

     

    SELECT Path, Name,

    SourceCode = CAST(CAST(content AS VARBINARY(max)) AS XML)

    FROM ReportServer.dbo.Catalog

    WHERE Type IN (2,6)

    ORDER BY Path, Type, Name

    Wednesday, October 22, 2008 7:02 AM

All replies

  • Go to the Report Manager, click on the report you need back, go to the Properties tab on the top and click on Edit in the Report Definition section.


    Regards,
    Krisztian

    Tuesday, October 21, 2008 10:43 PM
    Answerer
  • Another way is to do it through a 3rd party tool Reporting Service scriptor, which could be used for reverse engineering Visual Studio Report Projects from a Report Server

     

    http://www.sqldbatips.com/showarticle.asp?ID=62

     

     

    Wednesday, October 22, 2008 5:39 AM
  • Hi,

     

    We can Also Get it from the Report Server Database.

    All the Reports deployed to the Server get stored in Catlog table in Binary data format and we need to convert it into XML file. And that XML file Will be your actual Report.

     

     

    Reply me if it Helps...

    Wednesday, October 22, 2008 6:40 AM
  •  

    Hello,

     

    This Query is used to get the Reports XML Schema which are on Report server.

     

    SELECT Path, Name,

    SourceCode = CAST(CAST(content AS VARBINARY(max)) AS XML)

    FROM ReportServer.dbo.Catalog

    WHERE Type IN (2,6)

    ORDER BY Path, Type, Name

    Wednesday, October 22, 2008 7:02 AM
  • When I go to the Properties tab, I do not see an Edit tab....is this a permissions issue?   Is there any other workaround I can do to see the XML schema?  I tried to run the query below but I get a message that I do not have permission to view the ReportServer database.
    Friday, July 27, 2012 3:35 PM
  • this works as a charm. I had done the following:

    SELECT Path, Name,

    SourceCode = CAST(CAST(content AS VARBINARY(max)) AS XML)

    FROM ReportServer.dbo.Catalog

    WHERE Type IN (2,6) and Name = <name of the report to be recovered>

    ORDER BY Path, Type, Name

    then I copied the SourceCode field results into an empty dummy .rdl file in VS 2017 (The version I use)

    It worked like magic. thank you!

    Thursday, October 3, 2019 9:27 PM