How to get .rdl file of the Reports on Report Server

 

Question:

Do you want to have copy of a report on the ReportServer?
What would be the case when, tt was not saved in SourceSafe. Is there a way to get the .rdl file for that report copied to local computer from the ReportServer?

Answer:

For SQL Server 2005 Reporting Services

1. Go to Report on Report Manager
2. Click properties of Report
3. Under the report definition you will see Edit and Update link.
4. if you click on Edit you can open or Save the RDL files

For SQL Server 2008 Reporting Services

1. Go to Report on Report Manager
2. Click properties of Report
3. Select Download on the top right corner
4. Now you can open or Save the RDL files