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



“..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: | Blog: BI Developer Network

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


No comments.

Leave a Comment

Please register or log in to leave a comment.