A Sense of Style

We do not have access to the source code of the Report Manager pages, so we cannot make changes to the way they function. However, because these pages are ultimately HTML pages sent to a browser, we can make changes to the way the pages look. This is done through a cascading style sheet (CSS).

The ReportingServices Style Sheet

The look of the Report Manager is controlled by the ReportingServices.css cascading style sheet. The default location for this file is

 C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\                                    ReportManager\Styles\ReportingServices.ess

(There is also a cascading style sheet in this folder that controls the look of the web parts used to display reports in SharePoint.)

Let’s take a look at the steps necessary to make a change to the cascading style sheet.

Modifying the ReportingServices Style Sheet

The following procedure changes the fonts for both the name displayed at the top of the Report Manager pages and the text showing the current folder.

1. Make a backup copy of the ReportingServices.css file.

2. Open the ReportingServices.css file in Notepad.

3. Locate the entry for msrs-lowertitle.

4. Change the font-size entry from medium to small to decrease the size of the current folder text.

5. Locate the entry for msrs-uppertitle.

6. Change the font-size entry from x-small to large to increase the size of the name.

7. Add the following text immediately below the font-size entry:

    font-weight:bold;

8. Save your changes to the ReportingServices.css file and exit Notepad.

   Note 

   You need to remove any cached copies of the ReportingServices.css file from your browser before the changes to this style sheet can take effect.

9. Open the Report Manager in your browser, if it is not already open. Or, if it is already open, navigate to a new folder in the Report Manager. You see the name at the top of the page now appears in large, bold text and the text showing the current folder is smaller.