SQL Scrapbook

Short and simple SQL Server posts

Posts Tagged ‘reverse engineering rdl

How to generate RDL file from report manager?

leave a comment »

Your boss asked you to change a report that’s currently in production. You realize that you don’t have a RDL or a solution file for that dirty report. What do you do?
The process of regenerating the rdl from a report on the report manager is slightly different in 2005 and 2008.
2005: Navigate to the report properties page. In the report definition section click edit, a file download page will appear, click save and specify the location where you want to save the rdl file.
2008: On the open menu of the report click download and specify the location where you want to save the rdl file.

Once you have the rdl file you can add this as an existing item to a report server project.

Written by sqlscrapbook

December 28, 2010 at 8:27 pm

Posted in SSRS

Tagged with ,