Where is the published RDL file located?

Question

When publishing a report service report. Where is the .RDL file located on the server?

Can I reload the .RDL file through viewing through Report Manager? But where is this file located on the report services server?

thank

Answer 1

This is not a file on the server. It is stored as a BLOB in the ReportServer database.

(In the catalog table, to be precise, in SSRS 2005)

Answer 2

This page shows how to get this with T-SQL.

http://mscrmuk.blogspot.com/2009/05/reading-rdl-definitions-directly-from.html

Jeff

Update : here is the corresponding request in case the blog post disappears in the future:

select convert(varchar(max), convert(varbinary(max), content)) from catalog where content is not null 

Answer 3

The following query specifically provides a blob report

  SELECT Name, convert (varchar(max), convert (varbinary(max),[Content])) AS ReportRDL FROM [dbo].[Catalog] where TYPE =2 

Answer 4

There is another way to open a report in Report Builder. Then click the file → save as, and then save it in the right place.

Another way: when you open the report URL in Internet Explorer, when you hover over the report, you will see a drop-down list, and you can download the report.

Hope this helps.