http://www.sqlservercentral.com/blogs/marcbeacom/2007/07/15/sql-server-reporting-services-_2800_ssrs_2900_-templates-and-styles/

Printed 2014/10/20 03:30PM

SQL Server Reporting Services (SSRS) Templates and Styles

By Marc Beacom, 2007/07/15

Ever wanted to change the default template and style for the Reporting Services Wizard?  Just think how much time this would save of repetitive work inserting images, formatting colors and text.

Well there are two files that maybe of interest to you; StyleTemplates.xml and Report.rdl.  If you are familiar with style sheet concept of web development then the function of the StyleTempletes.xml is basically the same.  StyleTemplates.xml is responsible for the default font color, size, etc... of the report.  This file is used when you are selecting the style on the "Choose the Table Style" window of the report wizard.  You are able to create several different styles within this one file.  This makes it convenient especially if you are a consultant and developing reports for your customers, that use different fonts, colors, etc...

The Report.rdl you can setup headers, footers and any standard controls.  I've setup a report.rdl file that contains my company's standard report header along with report details such as report run date, run by, etc...  One unfortunate downside of this is that you can only have one active default report.rdl file used by the wizard.  So if you have modified the report.rdl file with you a standard configuration, but need to create many reports with a different configuration utilizing the report wizard, it gets a little tricky.  First of all, you need to determine if taking the time to create multiple report.rdl templates is worthwhile.  If so, the only way I know of right now to utilize more than one report.rdl file for the report wizard is to create several of them and manually rename the files when you need a different configuration.

These files are typically located at:

 



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