Where are my reports?

reporting-services ssrs-2008 rdl reportmanager
Chris Halcrow picture Chris Halcrow · Aug 1, 2013 · Viewed 10.9k times · Source

I can see the SSRS reports via the Report Manager in the browser. I know what database server it's pointing to.

How do I find where the source .rdl files are kept?

Answer

Ian Preston picture Ian Preston · Aug 1, 2013

The source file is stored in the ReportServer database of the SSRS instance you're looking at.

See Report Server Database in Books Online:

The report server database is a SQL Server database that stores the following content:

Items managed by a report server (reports and linked reports, shared data sources, report models, folders, resources) and all of the properties and security settings that are associated with those items.

You can download these RDL files through Report Manager.

In SSRS 2008 you will need to go to the report Properties and choose Edit -> Report Definition.

For SSRS 2008R2, you can just choose Download from the report's dropdown.

See Download \ Export RDL files from Report Server for more explicit details.

Related questions

Alternate rows background color in a group

I have following situation: Report with nested groups, whether group column has value 1 or 2. Next child group has 2 groups for each parent group, so for parent group 1 there is two child groups (1-1 and 1-3), and also for parent group 2 …

Read More
How to create totals row for grouped columns

If have an rdlc-report with grouped columns within a tablix (table). I want to add a footer row that spans all dynamically created columns and shows a total for all columns together. How can I tell to a cell that …

Read More
How to convert .rpt file to .rdl file

I need to convert several .rpt file(crystal reports) to rdl files(ssrs reports). How to generate .rdl file dynamically? Is there any link that will provide all the list of formulas to convert ?

Read More