Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SSRS - Time Saver using Templates

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

Template Screenshot

 

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

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.