How to copy a report in SQL Server Reporting Services 2008

Question

I have a report that I created in SQL Server Reporting Services 2008.

I now want to create a new report, that is very similar that the one I already created.

How do I do that without writing the report from scratch? Can I just copy the .rdl to a new name? How will Visual Studio "pick that up"?

Thanks!

Answer 1

Just one last comment on Amarundo's callout:

"Diego, that's the thing. I can right click the report (under Solution Explorer) and select copy, but can't find where to past. Or if I copy the .rdl file, I don't know how to add that to my project."

If you right-click on a report item in the Solutions Explorer, the Copy option is available. However, the Paste option never becomes visible, even when you have a report item in your clipboard. However, the object is there, and you can paste it by pressing ctrl+v.

I think it was just a UI miss on Microsoft's part.

Answer 2

I confess that I did not know the answer to this question, so I tried. I copied and renamed one of my reports, added it to my project, uploaded to SSRS and ran it.

Seems to be working fine, so I guess the answer is yes