How to copy a report to build another report

  • Please excuse my noobness at this, but I have never used Reporting services before.

    Question:

    How can you copy one report, and use that copy to build another report?

  • stephen99999 (1/30/2012)


    How can you copy one report, and use that copy to build another report?

    In your BIDS project choose a existing report and select the original rdl file. After importing the report rename it to your new reportname.

    If you're using SQL 2008 R2 you might also have a look into reportparts in Reportbuilder 3.0 http://msdn.microsoft.com/en-us/library/ee635721.aspx and

    (http://channel9.msdn.com/Blogs/ashishjaiman/SSRS-2008-R2-Report-Parts).

    If not, creating your own templates might help. I also use my own templates which include standard features like a company logo, default header and footer text, colorscheme etc.

    Just google for SSRS templates and you will find loads of examples.

    [font="Verdana"]Markus Bohse[/font]

  • MarkusB (1/31/2012)


    stephen99999 (1/30/2012)


    How can you copy one report, and use that copy to build another report?

    In your BIDS project choose a existing report and select the original rdl file. After importing the report rename it to your new reportname.

    If you're using SQL 2008 R2 you might also have a look into reportparts in Reportbuilder 3.0 http://msdn.microsoft.com/en-us/library/ee635721.aspx and

    (http://channel9.msdn.com/Blogs/ashishjaiman/SSRS-2008-R2-Report-Parts).

    If not, creating your own templates might help. I also use my own templates which include standard features like a company logo, default header and footer text, colorscheme etc.

    Just google for SSRS templates and you will find loads of examples.

    Markus,

    Thank you for the links. The first one you had took me directly to what I needed: step-by-step instructions. Very helpful! This will save me from posting a lot of questions lol!

    Stephen

  • If you going to use the set-up alot, make a template. saving the rdl file in %Program Files%Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject\

    Ian Cockcroft
    MCITP BI Specialist

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply