CharlieSC


In my shop we hired a contractor who build our SQL Server 2005 Reporting Services reports on his laptop. After a tiff between him and our manager, he left with the laptop and we no longer have the source code for these reports. We have backups, but not the latest.

These reports ARE deployed to our production server, but I need to know if it's possible to reconstruct the RDL for the reports from the database contents. I understand that the report contents are encrypted and I'm guessing the RDL is in the Catalog.Content column.

Is there a way to recover the RDL for deployed reports or do we have to resort to the legal system




Re: Reconstructing RDL from the ReportServer database

guyinkalamazoo3


Sorry to hear about your plight. You can open SQL Server Management Studio to connect to your report server. In there, find your report files, right-click on them and say Edit Report...This will save the .rdl file to a location that you choose.

Hope this helps.






Re: Reconstructing RDL from the ReportServer database

Jarret

Hello Charlie,

Here's a query you can use to get the XML (for the RPT file) from the database, but you may have some issues with the length of the field.

select convert(varchar(max), convert(varbinary(max), content))

from reportserver.dbo.catalog

where content is not null

Another way, is to get them straight from Report Manager (http://ServerName/Reports). Drill down to one of your reports and go to the Properties tab. From here, there is an Edit link. Click on this and it will ask you to download the rdl file.

Hope this helps.

Jarret






Re: Reconstructing RDL from the ReportServer database

CharlieSC

Thanks guyinkalamazoo3. This is a really good and simple idea!



Re: Reconstructing RDL from the ReportServer database

CharlieSC

Thanks, Jarret. This is a great idea!

Charlie