http://www.sqlservercentral.com/blogs/sqldownsouth/2012/06/27/how-to-create-reporting-services-2012-report-templates/

Printed 2014/04/23 04:59PM

How to Create Reporting Services 2012 Report Templates

2012/06/27

When I started writing this blog I realized it has been several months since my last post.  I guess that is what happens when you try to write two books at the same time.  Oh well, on to the post.  Back in November of 2009 I published a blog titled, How to Create a Reporting Services 2005/2008 Template.

The post explained how to create a reusable template report.  The steps to accomplish this in SSRS 2012 remains the same, however the directory where the template must be stored has changed.  Once you have designed the template, copy it to the following directory:

C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject

Now when you create a new report a new template choice will be available.  As you can see in the screen shot below I have created a Company Base Report Template:

image

Instead of redesigning headers and footers on each report, you can now reuse a template to ensure a level of consistency for your reports.

Talk to you soon,

Patrick LeBlanc, founder www.sqllunch.com.


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.