Exporting SSRS Report Definitions from the Web Site


By:   |   Updated: 2010-05-04   |   Comments   |   Related: > Reporting Services Report Builder

Problem

You need to edit a SSRS report, but you do not have the source code. How do you get it?

Solution

SQL Server Reporting Services supports saving a report file definition from an online report as a RDL file. This option is only available for report definitions. Data sources and linked reports are not supported. The difficulty in using this option is finding it. The instructions below have been tested on both SQL Server 2005 and 2008 Reporting Services. Once you exported the report definition, you can edit it through Business Intelligence Development Studio (BIDS) or upload it to another Report Server Site.

Step 1 - Open browser and go to your Report Server web site and the folder with the report

You need to edit a SSRS report, but you do not have the source code. How do you get it?


Step 2 - Click Show Details
go to your Report Server web site and the folder with the report


Step 3 - Click Edit to left of the report
Click Edit to left of the report


Step 4 - On the Properties tab, find the "Report Definition" section. Click Edit. You will be prompted and you should choose Save. Make sure the "type" of the file is Report Definition File (RDL) suffix.
On the Properties tab, find the "Report Definition" section.


Make sure the "type" of the file is Report Definition File (RDL) suffix


Editing the Report

You can now edit the report through Business Intelligence Development Studio (BIDS). First, you should create a new solution for a Report Server Project and then add the RDL you saved as an existing item.  Once this is done you an edit the report just like any other report.

BIDS Example


Moving the Report

You can also use the RDL file to move the report to another Reporting Services server. Simply go to the Reporting Services server, move to the folder you want the report added and click the "Upload File" button and upload the RDL file you just saved. Make sure your data source is correct and you should then be able to run the report on the new server.

You can also use the RDL file to move the report to another Reporting Services server
Next Steps


Last Updated: 2010-05-04


get scripts

next tip button



About the author
MSSQLTips author David Bird David Bird has years of IT Experience working as a DBA and programmer on Windows, UNIX, and mainframes.

View all my tips





Comments For This Article





download


Recommended Reading

Enter and Edit Data in SQL Server Reporting Services

SQL Server Reporting Services Report Builder with DAX Query Support

Introduction to SQL Server 2008 Report Builder 2.0

SQL Server Reporting Services Report Builder Manual Data Sources

SQL Server Reporting Services Report Builder 2012 Security





get free sql tips
agree to terms


Learn more about SQL Server tools