Wednesday, 4 February 2009

SSRS: Changing the Stylesheet in Reporting Services

This blog applies for both SQL Server Reporting Services 2005 & 2008.

There are 2 steps to modifying the stylesheet -


Step 1: Create the stylesheet
1-Navigate to :\Program Files\Microsoft SQL Server\MSSQL.n\Reporting Services\ReportServer\Styles


2-Modify the stylesheet as appropriate and then save in the style folder

Step 2: Point to the new StyleSheet
1-Navigate to:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services


2-Modify the RSReportServer.config file and add the following text:






3-Now navigate to: http://ServerNameHere/ReportServer and select your reports.

Alternatively you can just add the StyleSheet to the URL:

&rc:Stylesheet=MyStyleSheet

No comments:

Post a Comment