Reading RDL Definitions directly from a ReportServer database
Just a quick post: I recently had to extract the report definitions (RDL) directly from a ReportServer database, as the ReprtServer installation was broken. This should be straightforward, but requires some work to convert the data to a readable format. This can be done with the following SQL query:
select convert(varchar(max), convert(varbinary(max), content))
from catalog
where content is not null
This was originally posted here.
*This post is locked for comments