Where does a published RDL file sit?

Question

Hi,

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

Answer 1

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)

Answer 2

This page shows how to retrieve this using T-SQL

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

Jeff