57

When publishing a reporting services report. Where does the actual .RDL file sit on the server?

I can redownload the .RDL file via browsing through the report manager? But where is this file situated on the reporting services server?

Thanks

4 Answers4

58

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

(In the Catalog table to be precise on SSRS 2005)

Extended Answer

ashveli
  • 248
  • 6
  • 28
gbn
  • 422,506
  • 82
  • 585
  • 676
30

This page shows how to retrieve this using T-SQL

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

Jeff

Update: here's the relevant query, in case that blog post disappears in the future:

select convert(varchar(max), convert(varbinary(max), content))
from catalog
where content is not null
Jim DeLaHunt
  • 10,960
  • 3
  • 45
  • 74
Jeffrey Bradley
  • 666
  • 6
  • 4
  • `catalog` is located in the ReportDatabase for SSRS inside SQL server. – Steam Apr 06 '14 at 06:08
  • btw, I tried this on sql server 2008r2 and I got a blank column. – Steam Apr 06 '14 at 06:08
  • This is awesome! I had to locate dependant reports for a table and above logic combined with a LIKE saved me many mins and hrs of effort. :) – Kent Pawar Apr 09 '15 at 06:49
  • 3
    Keep in mind that varchar(max) can return gigabytes worth of data, so the results in the SSMS results grid may not show the entire RDL content. I had to right click on the column and choose 'Save Results As...' to get the whole RDL. – Baodad May 19 '16 at 20:16
  • Is there any way to add a new URL link which will redirect to a new web page from the SSRS location? Kind of a link to new application from SSRS location itself? – RedBottleSanitizer Dec 13 '21 at 18:20
7

Following query specifically provide the report's blob

 SELECT Name, convert (varchar(max), convert (varbinary(max),[Content])) AS ReportRDL
 FROM [dbo].[Catalog] where TYPE =2
Atur
  • 1,712
  • 6
  • 32
  • 42
4

One way to achieve this is open the report in Report Builder. Then click on file -> save as, then save it in the desired location.

Another way, When you open the report URL in the Internet Explorer,on hovering the report you'll see a drop down and there is an option to download the report.

Hope this helps.

ashveli
  • 248
  • 6
  • 28