CODEWITHSUNDEEP
reporting-servicesreporting
tidge
tidge

Reputation: 447

SQL Reporting Services - COPY reports to another folder

This is stupid that I can't figure out how to do this. I'm in the SQL Reporting Services Report Manager website. I have some reports in a folder. I want to copy those reports to a different folder so that I can point those reports to a different datasource. I still need the original reports in their original folder, pointing to their original datasource.

It's very easy to select reports via checkbox and use the Move functionality, but there doesn't appear to be a way to copy?

Any ideas.

Upvotes: 6

Views: 34810

Answers (7)

user3680976
user3680976

Reputation: 69

Backup the reporting databases from the source and restore it to the destination. Easy peasy.

Upvotes: 0

JamesL
JamesL

Reputation: 11

Within the Browser, if you open the folder then use the drop down there is a Download option.

I compared the file sizes between download and save-as and found them different, so I prefer the download option.

Upvotes: 1

Clint Hillerman
Clint Hillerman

Reputation: 31

This is a little late, but just in case someone else stumbles upon this thread. I find the easiest way is to click the drop down arrow to the right of the report you would like to copy. Select "Edit in Report Builder". Once that's open just "Save As". Works like a charm.

Upvotes: 3

Stewart L
Stewart L

Reputation: 21

Only way I know is manually, one by one. This is in SQL2005.

Navigate to the location of the report(s) Show details Click the Edit icon next to the report On the General tab under the "Report Definition" section, click "Edit" This prompts a Save File dialogue box. Save the .rdl file somewhere. Repeat ad nauseum... Now you can import those reports you've just saved to your new location.

After I wrote this I saw this was the same answer as jimconstable above! Damn!

Upvotes: 2

BlueQuail
BlueQuail

Reputation: 41

I know this question is old but here is how I copy a report to another folder: I open the original report in Report Builder and use 'save as'.

Upvotes: 3

nunespascal
nunespascal

Reputation: 17724

There is no easy way to copy reports in report manager.

I wrote a tool to help me copy reports between servers, you can use the same to copy on the same server too.

http://code.google.com/p/reportsync/

Upvotes: 9

jimconstable
jimconstable

Reputation: 2388

I don't think these is a simple way to do this. You could pull them all out by going to each report->properties tab->edit. This will let you download the report. Then you can upload it again to another folder. But that sounds like a PITA.

You would be probably be best off the upload from the BIDS to a different folder.

Upvotes: 0

Related Questions