Post reply

How to copy a report to build another report

  • January 30, 2012 at 3:03 pm

    #250423

    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?

  • January 31, 2012 at 5:47 am

    #1440536

    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]

  • January 31, 2012 at 7:02 am

    #1440607

    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

  • January 31, 2012 at 12:03 pm

    #1440879

    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