Creating a Reporting Services Template

Many companies like to have a consistent look and feel across their applications. Some even make them part of the standards. As such, one may want to create a reporting services template that allows them to start off the report with objects or properties set accordingly. This saves a ton of time and gives that consistent look and feel. Creating a template that can be reused is very simple. All you have to do is create a new report, add your appropriate settings that you want to apply to your template and then save the rdl file and copy your rdl file into the path below.

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

You should see something like what is shown in figure 1 the next time you choose Add New Item.

Figure 1: Add Item Dialog Box

DOWNLOAD BrianMcDonalds_Template.zip

“..and until that day comes, keep your ear to the grindstone” – Good Will Hunting

Brian K. McDonald, MCDBA, MCSD
Business Intelligence Consultant – Pragmatic Works Consultants

Email: bmcdonald@pragmaticworks.com | Blog: BI Developer Network

Convert with DTS xChange  | Develop with BI xPress  | Process with TaskFactory | Document with BI Documenter