View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.
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:
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.
Other posts by PatrickLeBlanc