Download a report from Reporting Services.

Hi,

I have a report that′s already in the reporting service (2000 and 2005 - both systems), that I need edit in order to make some changes, but the person who did the report already deleted the source. I only have the one that had been uploaded to the reporting services. In there i only see an option to upload the report, but not to download.

Is there any way that i can download the report from the reporting services?

Thanks.

Yes, you can download the .RDL file using the "Edit" link on the Report Manager report properties page, the SOAP API method GetReportDefinition, and in Management Studio by right-clicking on the report and selecting "Edit Report".

Keep in mind that the RDL you get out of the server will be exactly the RDL you last published, but it will NOT include changes made to data sources and parameters after the RDL was published.