How to copy SSRS 2005 reports from one folder to another

If you ever need to copy reports from one folder to another folder on SSRS 2005 server.

• on the same server
• it is copy not move
• you do not have the BIDS source project
• The report copies need to point to a different data source

This tedious task can be done as follows:

• With the web browser in the reporting services home folder, create the new folder
• to copy a report from the source folder to the destination folder
• with the web browser go to the source folder
• select ‘Show details’
• click on the Edit icon next to the report name
• in the edit page, click on the edit link, this will download a copy of the report, with rdl extension.
• Store the file on your pc.
• browse to the target folder you have created in the 1st step
• click on ‘upload file’
• Select the .rdl report file you have just downloaded.
• Upload the file
• to change the datasource of the reports in the new folder
• If the reports were using shared datasource then create a new Data source in the Data Sources folder.
• browse to the folder with the new report
• select ‘Show details’
• click on the Edit icon
• in the menu on the left click on ‘Data Sources’
• 
• Select a shared datasource, click on the Browse button.
• In the Location Home/Data Sources select the new datasource.
• now you should be able to open the report