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
5 comments:
Excellent, this is just what I needed!
your awesomeness is awesome!!!!!!!
Thank you. Exactly what I required.
Works perferctly Thx
Hi, I have deployed the reports ussing SSRS. can i know where SSRS reports stores in report server. can i get a full path. so i can go forward. i know it will store in th catolog table. but i require full path of catalog.
I am using rsscripter to automate the reports. but there i hv to give the outputpath. that has to be in SSRS reports path. where they r actually storing.
Pls let me know the extact path. so i can go further.
Thanks
Many many thanks.
Post a Comment