Service Pack 2 for SQL Server 2000 Reporting Services

March 2005

© Microsoft Corporation, 2005. All rights reserved.

The Reporting Services documentation team welcomes your comments about this Readme documentation. You can send e-mail feedback using the link below. All feedback must be in English. If you are using a non-English browser and are configuring Outlook Express for the first time, you may need to click the link again after Outlook Express is configured. Users of Asian language browsers should ignore any corrupted characters that appear in the subject line or body of the e-mail message. To submit written feedback about this document, click here:   Submit feedback.


1.0 Introduction

1.1 Overview of SP2 Installation

1.2 Identifying the Current Version of Reporting Services

1.3 Updating Books Online

2.0 Downloading and Extracting SP2

3.0 Service Pack Installation

3.1 Back Up Your Report Server Databases

3.2 Installing SP2

3.3 Installing SP2 on a Report Server Web Farm

3.4 Command Line Options

3.5 Removing SP2

3.6 Rebuilding an SP2 Installation

4.0 Documentation Notes

4.1 New Functionality

4.1.1 Reporting Services SharePoint Web Parts

4.1.2 Direct Report Printing from Internet Explorer

4.2 Report Design and Processing

4.2.1 Chart Data Points

4.2.2 Log Timer Events

4.2.3 List Widths

4.2.4 Tables with Details Sections

4.2.5 PDF Files

4.2.6 Wide Columns

4.2.7 Default Style Sheet

4.2.8 Excel Rendering Extension

4.2.9 PDF Rendering Extension

4.2.10 Chart Enhancements

4.2.11 External Images

4.2.12 New Lines in Expressions

4.2.13 Size Limits in Report Designer

4.2.14 Preview Cache in Report Designer

4.2.15 Hyperlink Protocols

4.3 Reporting Services Programming

4.3.1 HTTP Headers

4.3.2 New URL Access Parameters

4.3.3 Custom Authentication Cookies

4.3.4 Report Server System Properties

4.4 Management and Deployment

4.4.1 Zero-Byte Attachments on Lotus Domino Server v. 5.0.9a Mail Servers

4.4.2 Enterprise Deployment Model Tag in BOL

4.4.3 Hidden Parameter Support

4.4.4 New Configuration Settings

4.4.5 Security Concerns About Integrated Security and Elevated Permissions

1.0 Introduction

This release of Microsoft® SQL Server™ 2000 Reporting Services Service Pack 2 (SP2) includes bug fixes and some functional enhancements. This Service Pack is cumulative; therefore, when installing SP2, the SP1 enhancements are also installed. To view a list of the bug fixes in SP2, see Microsoft Knowledge Base article 889640. To view a list of the bug fixes in SP1, see Microsoft Knowledge Base article 839796.

Late-breaking information that was not available in time to be included in this Readme file will be published on the Microsoft Product Support Services Web site in Microsoft Knowledge Base article 889641.

Key Functional Enhancements

Key Bug Fixes

1.1 Overview of SP2 Installation

Reporting Services SP2 is an update that you can apply to an existing installation of Reporting Services or an existing installation of Reporting Services with Service Pack 1 (SP1). You can run SP2 by double-clicking the self-extracting executable or by extracting the files and running Setup from the command line.

Note  Setup upgrades only the components that are currently installed. If you subsequently install additional components, you must rerun SP2 Setup to update those components.

SP2 Setup does the following:

This service pack is independent of service packs for SQL Server 2000. It is recommended that you apply the latest service pack for SQL Server before you install this service pack.

1.2 Identifying the Current Version of Reporting Services

To identify which version of Reporting Services you have installed, type the URL of the report server (for example, http://<exampleWebServer>/reportserver). Version information is located at the bottom of the page. The final product release is version 8.00.743.00 and Service Pack 1 is version 8.00.878.00.

1.3 Updating Reporting Services Books Online

SP2 does not upgrade Reporting Services Books Online. However, you can download the current version (January 2004) from Microsoft. To download the documentation update, go to Reporting Services Books Online January 2004 Update.

2.0 Downloading and Extracting SP2

SP2 is distributed as a self-extracting download file that can be downloaded from Microsoft. For more information about the download location, go to the Reporting Services Web site.

3.0 Service Pack Installation

To install SP2, use the installation instructions in the following sections. It is not necessary to stop or pause the Report Server Windows service or Report Server Web service prior to running SP2 Setup.

Note that SP2 Setup is localized into all of the SQL Server languages. SP2 Setup will detect the language that was in effect on your computer when you installed the final release of Reporting Services; the Setup user interface and error messages appear in that language.

Remote installation of SP2 is not supported. SP2 installation will fail if Reporting Services components (final product release) are not installed.

Reporting Services cannot be installed on computers running Microsoft Windows XP Professional 64-bit Windows on Windows (WoW).

File and Component Changes

SP2 modifies the following files and components:

SP2 does not modify the following items:

3.1 Back Up Your Report Server Database

Before installing SP2, back up the reportserver and reportservertempdb databases. If you haven't done so already, you should also back up a copy of the database encryption keys (for more information, see Managing Encryption Keys). In addition, back up your Symmetry Key by using rskeymgmt.exe, and then store it in a safe location.

Installing SP2 modifies the databases, making them incompatible with pre-SP2 versions of Reporting Services. These backups will therefore be useful if you decide to reinstall SQL Server 2000 Reporting Services without SP2.

3.2 Installing SP2

Run SP2 Setup from one of the following locations:

SP2 Setup displays a dialog box that displays the End User License Agreement (EULA) and then prompts you to install.

Upgrading the Report Server Database

Setup will use your domain account credentials (Windows integrated security) to upgrade the report server database. You must have database owner (dbo) level permissions on the report server database to perform the upgrade. If you want to use different credentials, you should run SP2 Setup from the command line.

Setup Log Files

You can view log files to troubleshoot installation problems or to verify installation. SP2Setup writes status messages, errors, and warnings to two different log files:

To view the log files, click Start, click Run, type %temp% in the Run dialog box, and click OK. Browse the Temp folder contents to find the log file you want.

After SP2 Setup Is Complete

After SP2 Setup is complete, you may need to restart the system. After the system restarts (or after Setup completes without requesting a restart), open Services in Control Panel to make sure that the Report Server Windows service is running. You should also open Report Manager and view reports to ensure that your installation is working.

Be sure to back up the upgraded reportserver and reportservertempdb databases. You do not need to create a new backup of the encryption keys or adjust any settings. SP2 does not modify connection information or invalidate the pre-SP2 encryption capability of your report server.

3.3 Installing SP2 on a Report Server Web Farm

If you have deployed Reporting Services on a Web farm, you must run SP2 Setup on each computer that hosts a Reporting Services component. This includes each report server in the cluster, and the computer that hosts the shared report server database.

You should take the servers offline until all of the report server nodes and the database are upgraded (that is, stop IIS and the Report Server Windows service). Once you start installing SP2, you need to install SP2 on all nodes. Otherwise, the remaining report server nodes will not work until they have been upgraded to use the SP2 database format.

Adding a Node to a Web Farm Running SP2

After a report server cluster has been upgraded to SP2, you cannot use Setup to automatically point a new report server instance or node to an existing report server database. Instead, use the following steps to create new report server nodes:

3.4 Command Line Options

You can run SP2Setup from the command line to perform a silent installation or to specify a non-default account for upgrading the report server database (by default, SP2Setup uses the credentials of the user who is running Setup). The following parameters can be used:

The following example illustrates the syntax for specifying command line options:

SP2Setup.exe /q rssetupaccount=<mydomain>\<myusername> rssetuppassword=<mypassword>

3.5 Removing SP2

To revert to the version that you were running before installing SP2, you must uninstall Reporting Services and then reinstall it without applying SP2 afterwards. There is no separate uninstall program for SP2. If you applied a Quick Fix Engineering (QFE) fix to your RTM or SP1 Reporting Services installation, you must reapply that QFE fix to the instance. To uninstall Reporting Services, use Add or Remove Programs in Control Panel.

Note that the report server database, upgraded to the SP2 format, is not removed when you uninstall the product. You must manually remove the SP2 version of the report server database and restore the version that was part of the pre-SP2 installation.

3.6 Rebuilding an SP2 Installation

If you need to rebuild a Reporting Services installation that has been upgraded to SP2, do the following:

4.0 Documentation Notes

This section documents the functional enhancements introduced in SP2. This section is not meant to be a description of all of the fixes provided in SP2. For a complete list of these fixes, see Microsoft Knowledge Base article 889640.

New in SP1. Corrections to the developer documentation are now available. To view the updates, see the following Microsoft Knowledge Base articles.

4.1 New Functionality

4.1.1 Reporting Services SharePoint Web Parts

New in SP2. A set of Reporting Services SharePoint Web parts are installed with SP2. These Web parts are called Report Explorer and Report Viewer. Using Report Explorer, you can browse available reports on a report server. Using Report Viewer, you view reports hosted on a report server. Included with Report Explorer is a subscription function that allows you to receive reports by e-mail. Both Web parts are optimized to run within the SharePoint environment; however, they can be run as standalone components also.

These Web parts will work on SharePoint (SharePoint Portal Server or Windows SharePoint Services) and Microsoft SQL Server 2000 Reporting Services SP2.

Note   To use the Reporting Services SharePoint Web parts, Report Server and Report Manager must both be installed.

Installing Web Parts

Web parts are delivered to a SharePoint server as a cabinet (.cab) file. If you want users within your organization to use this functionality, run the Stsadm.exe tool on the .cab file. To learn more about the Stsadm.exe tool and deployment of Web parts for Microsoft Windows SharePoint servers, see the Microsoft Developer Network Web site.

To install the .cab file from the command line, run the following code:

C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\BIN\STSADM.EXE -o addwppack -filename "C:\Program Files\Microsoft SQL Server\80\Tools\Reporting Services\SharePoint\"

To run a Web part on SharePoint, the control must be added to the <SafeControls> section of the Web.config file for each virtual server that uses the Web part. While the Stsadm.exe tool automatically adds the control to the <SafeControls> section for the virtual server specified on the command line, you need to add the control to the <SafeControls> section of the Web.config file for each additional virtual server.

If you use the -globalinstall switch to add the Web parts to the global assembly cache (GAC), the strong name for the assembly must be used instead of the friendly name in the Web.config file.

When creating new virtual servers, you can add the Web part assembly to the <SafeControls> section of the default configuration file you are using. For more information about adding custom configuration settings for extending virtual servers, see the Microsoft Developer Network Web site.

Adding the Web Parts to a Web Part Page

Once the Web parts are installed, users can then add Report Explorer and Report Viewer Web parts to a Web Part Page through the Sharepoint window.

To add the Report Explorer and Report Viewer Web Parts to a Web Part Page

  1. From an existing site in SharePoint, click the Create button in the SharePoint toolbar.

  2. Scroll down to the Web Pages section, and then click Web Part Page.

  3. Type a name, select a layout template, and then enter the location where you want to save your Web Part Page.
    The Web Part Page appears and is divided into sections called zones.

  4. Click the Create button at the bottom of the page.

  5. From the new page, click Modify Shared Page, point to Add Web Parts, and then click Browse.

  6. Select the name of the gallery where the Reporting Services Web parts were installed.

  7. From the Web part list, select the Report Explorer Web part or the Report Viewer Web part, and then drag it to the zone where you want the Web part to appear.

Connecting Reporting Services Web Parts

If you add the Report Explorer and the Report Viewer Web parts to the same SharePoint page, you can connect them so that when you select a report in the Report Explorer, the report appears in the Report Viewer. If the Report Explorer and Report Viewer are not connected, the selected report appears in a separate page.

To connect the Report Explorer and Report Viewer Web Parts

  1. Click Modify Shared Web Part.

  2. On the Report Explorer toolbar menu, click the down arrow, point to Connections, point to Show Report In, and then click Report Viewer.

  3. Click OK.

4.1.2 Direct Report Printing from Internet Explorer

New in SP2. Users can print reports directly from Internet Explorer. To support this functionality, a downloadable ActiveX control is used. The control’s .cab file is hosted on the report server and is downloaded by the client on request.

When you request a report, the HTML Viewer returns the report along with a toolbar for navigation. The toolbar contains a Print button that displays a Print dialog box when clicked. Using the dialog box, you can make standard Windows printing selections including orientation, page size and page range. When the printer settings are selected, you can select Print to print the entire report or a range of pages within the report, or Preview to preview the report in a separate preview pane.

Note   By design, changes to the page orientation and margins do not persist in Reporting Services. Therefore, the page orientation and margin settings are returned to their default state every time you click the Print icon.

Direct Report Printing System Requirements

The computer must be running one of the following browsers:

The computer must be running one of the following operating systems:

Enabling Direct Report Printing

Administrators of Reporting Services have the option of enabling or disabling the client-side printing option for users. The option is defined by a new report server system property called EnableClientPrinting.

The EnableClientPrinting system property values are as follows:

Value Type Description
True Boolean Enables client printing through the use of a printing control. The control is downloaded the first time the feature is used in order to enable client printing.
False Boolean Client printing through the HTML Viewer control is not enabled.


In addition to printer settings, the print dialog box is customized to include a button for print preview. When the Print Preview button is selected, a new preview pane is displayed that provides users with the ability to preview the first page of the report. In addition, you can browse to any page within the report as it becomes available. Print Preview provides the following capabilities.

Page Rendering and Preview

If the user selects preview from the print dialog box, the page is rendered in the Preview window. Preview has the following characteristics:

Paper Size and Margins

To allow you to specify the default page size and margins in your reports, six properties (PageHeight, PageWidth, LeftMargin, RightMargin, TopMargin, and BottomMargin) are extracted from the report definition when the report is published and added to the item properties collection on the server. Depending on your browser language, margins are displayed in either inches or millimeters.

When the print control is launched, the PageHeight and PageWidth properties are used to select the closest paper size available for the current printer. If the PageWidth is greater than the PageHeight, the orientation is set to Landscape; otherwise it is set to Portrait. These properties are overwritten each time a report is updated using SetReportDefinition.


The RSClientPrint object is used to gain access to the ActiveX control and its methods and properties programmatically. The RSClientPrint object can be used by developers who want to enable the client-side printing feature in third-party toolbars or viewers. The properties of this object are as follows:

Name Type RW Default Description
MarginLeft Double RW Report setting Gets or sets the left margin. The default value if not set by the developer is 0.0.
MarginRight Double RW Report setting Gets or sets the right margin. The default value if not set by the developer is 0.0.
MarginTop Double RW Report setting Gets or sets the top margin. The default value if not set by the developer is 0.0.
MarginBottom Double RW Report setting Gets or sets the bottom margin. The default value if not set by the developer is 0.0.
PageWidth Double RW Report Setting Gets or sets the page width. The default value, if not set by the developer, is the default print page width.
PageHeight Double RW Report Setting Gets or sets the page height. The default value, if not set by the developer, is 0.0.
LocaleID Int32 RW Browser Locale The locale ID.
CultureInfo String RW Client culture This value is used to define date/time formatting.

The above properties can be used to initialize the print preview and print properties of a report.


Name Description
Print Prints the report.

Print Method

Prints the report.

Argument I/O Type Description
ServerPath In String The server name including virtual root of the report server.
ReportPathParameters In String The full path name to the report in the report server namespace including any parameters.

For example:

“/AdventureWorks Sample Reports/Employee Sales Summary&EmpID=123”

ReportName In String The name of the report.

4.2 Report Design and Processing

The following enhancements apply to reports, report processing and rendering, and Report Designer.

4.2.1 Chart Data Points

New in SP2. With SP2, Reporting Services now displays only valid data points when previewing a chart within a report. In SP1, when the default color of the value element or the value series was changed and the report chart was previewed, data points that were not valid were displayed. For example, data points with NULL values appeared in the chart. This behavior no longer occurs.

4.2.2 Log Timer Events

New in SP2. SP2 includes updates that prevent the trace log file from increasing in size unexpectedly. This update also prevents numerous messages from being repeatedly logged to the file. ReportServerService_<timestamp>.log is the Reporting Services trace log file for the Report Server Windows service and the Web service. By default, this file is located in the <Installation Drive>:\Program Files\Microsoft SQL Server\<Your_SQL_Server_Instance_name>\Reporting Services\LogFiles folder.

4.2.3 List Widths

New in SP2. When exporting a report to a PDF format, the width of a list with an embedded matrix is based on the items that appear on the page. Previously, a list that contained an embedded matrix may have grown wider unexpectedly or added blank pages to the report when the report was exported to a PDF format.

4.2.4 Tables with Details Sections

New in SP2. A table with a hidden or removed details section displays correct page breaks when rendered as an image or PDF file. Previously, a table with a hidden or removed details section would insert page breaks in unexpected locations.

4.2.5 PDF Files

New in SP2. Third-party PDF readers can now display PDF files generated by Reporting Services.

4.2.6 Wide Columns

New in SP2. Reports with columns that are wider than 1726.5 points can be successfully exported to Microsoft Excel now. Previously, these reports appeared correctly when viewed as Web-based reports. However, an error message was displayed when attempting to export the report to Excel.

4.2.7 Default Style Sheet

New in SP2. The <HTMLViewerStyleSheet> property has been added to the Reporting Services configuration file so that you can specify a new default style sheet for your HTML Viewer.

4.2.8 Excel Rendering Extension

New in SP1. Significant improvements have been made to the Excel rendering extension. The output format produced by the rendering extension has changed. Improvements include the following:

4.2.9 PDF Rendering Extension

New in SP1. Various improvements to pagination and matrix performance in PDF files have been made in SP1. If you have been experiencing pagination or matrix performance issues in the PDF rendering extension, see Microsoft Knowledge Base article 839796 for a complete list of fixes.

4.2.10 Chart Enhancements

New in SP1. Two enhancements have been made to the charting component in SP1: labels can now be placed outside of pie charts, and the style of chart value elements can now be changed.

Pie Chart Labels

Previously, point labels in pie charts were only displayed inside of the chart. In SP1, you can now place point labels outside the chart. To place point labels outside the chart, you must select a position for the point labels.

To change the position of point labels in a pie chart

  1. Using Report Designer, create a pie chart. For more information about creating a chart, see "Adding a Chart" in Reporting Services Books Online.

  2. In Layout view, right-click the chart, and then click Properties.

  3. On the Data tab, in Values, select the [Value] value series.

  4. On the Appearance tab, click Point Labels.

  5. In Position, clear Auto, and then select a button other than the center button.

Note Selecting the top, top right, right, bottom right, bottom, bottom left, left, and top left buttons indicate that the point labels are displayed around the outside of the chart. Selecting Auto or the center button indicates that point labels are displayed inside the chart.

Chart Styles

Chart styles have been enhanced for SP1. Previously, the style of a chart value element (for example, a bar or pie slice in the chart) could not be changed in Report Designer. Colors were limited to the automatic palette for the entire chart; you could not choose the colors that were assigned to each element. With SP1, the line style and fill color for an element can be edited using Report Designer. You can also use expressions to control these styles.

To edit the style of a chart element

  1. Using Report Designer, create a chart. For more information about creating a chart, see "Adding a Chart" in Reporting Services Books Online.

  2. In Layout view, right-click the chart, and then click Properties.

  3. On the Data tab, in Values, select the value to edit, and then click Edit.

    Note   If there is only one value series in the chart, select [Value].

  4. On the Appearance tab, click Series Style.

  5. On the Border and Line tab, select the line style, width, and color. To use an expression, click the Expression (fx) button next to the desired option.

  6. On the Fill tab, select the color, gradient, and gradient end color. To use an expression, click the Expression (fx) button next to the desired option.

Note   Providing a static value will cause all chart elements for that value series to display using the same style. For example, selecting Red for the fill color will cause all bars to become red, overriding the automatic color assignment from the chart palette. To provide different styles based on field or other values, use an expression. If you use an expression for fill color, the chart elements will be white in Layout view, but will display properly when the report is run.

Note   A fill color of Transparent will cause the chart elements to display using the automatic color assignment from the chart palette.

4.2.11 External Images

New in SP1. You can now include external images in reports. External images are typically accessed through a URL. An external image in a report has a Source property of External. The Value property contains the URL to the image, for example, http://<servername>/images/image.jpg.

When the report is previewed in Report Designer, preview uses the credentials of the user to display the image. When the report is run on the report server, the report server uses the unattended execution account to retrieve the image. If the unattended execution account is not specified, the image is retrieved using no credentials (anonymous user account). If either of these accounts have insufficient rights to access the image, the image will not be displayed in the report. For more information about setting the unattended execution account on the report server, see "Configuring an Account for Unattended Report Processing" in Reporting Services Books Online.

4.2.12 New Lines in Expressions

New in SP1. Previously, expressions had to be contained on a single line. With SP1, expressions can include a new-line character. New-line characters include carriage return (CR), line feed (LF), carriage return and line feed (CRLF), paragraph separator (Unicode 2029), and line separator (Unicode 2028). The new-line characters are replaced with a space when the report is processed.

4.2.13 Size Limits in Report Designer

New in SP1. The following changes have been made to page and body size in Report Designer:

4.2.14 Preview Cache in Report Designer

New in SP1. Caching has been added to preview in Report Designer. When a report is previewed, the data for the report is stored in a file on the local computer. When the same report is previewed again with the same query, parameters, and credentials, Report Designer uses the cache file instead of rerunning the queries in the report. This increases performance of preview in Report Designer.

The data file is saved with the following filename: The file is located in the same directory as the RDL file. The file is not deleted when Report Designer is closed.

The preview cache feature can be turned off through a configuration setting. For more information, see New Configuration Settings.

4.2.15 Hyperlink Protocols

New in SP1. Previously, all URLs in reports were limited to the protocols http:, https:, file:, ftp:, mailto:, and news:. These restrictions have been removed for hyperlinks. Hyperlinks can now contain any protocol identifier. Restrictions on other URLs, such as those for images, remain unchanged.

4.3 Reporting Services Programming

The following section includes new information for developers in Reporting Services.

4.3.1 HTTP Headers

New in SP2. Currently, a Secure Sockets Layer (SSL) certificate is required for each report server. In Internet deployments, a common approach for providing SSL connections is to terminate the SSL session at the firewall using a router. With SP2, this scenario is now supported. To enable this scenario, a router must translate the HTTPS requests into HTTP requests, for example, and the HTTP responses into HTTPS responses. To indicate to the report server that this is the deployment scenario, the router must add the FRONT-END-HTTPS: on header to the HTTP request before sending it to the report server. In response to this request header, the report server will generates URLs prefixed with HTTPS regardless of the protocol used to initiate the request. The URL is generated in the following form: HTTPS://<Host>/<RSName>. By implementing this solution, users internal to the organization can continue to access the report server by using a Web address in the following format: HTTP://<Host>/<VirtualDirectoryPath>.

In order to implement this functionality, do the following:

The report server responds to the following HTTP headers when processing end-user requests.

HTTP Header Description
FRONT-END-HTTPS When the router is configured to add the FRONT-END-HTTPS: on to the request header, the report server determines the root of the URL(s) returned by the report server for interactive requests. To send e-mail with links, unattended execution requires the URLRoot property to be set. Configuring the URLRoot property enables the Secure Sockets Layer (SSL) translation for users running with load balance terminated SSL connections.
Host The HOST request header field specifies the Internet host and port number for the resource being requested. This information is obtained from the original uniform resource identifiers (URI) provided by the user or referring resource.

Both the HOST request header and the FRONT-END-HTTPS: on header are used when the FRONT-END-HTTPS: on header is passed by the router. For more information about Internet standards, visit the Internet Engineering Task Force (IETF) Web site.

4.3.2 New URL Access Parameters

New in SP1. The following table describes the new URL access parameters for Reporting Services SP1.

Use this parameter To
rs:ParameterLanguage Provide a language for parameters passed on a URL that is independent of the browser language. The default value is the browser language. The value can be a culture value, such as en-us or de-de.
rc:Parameters Show or hide the parameters area of the toolbar. If you set this parameter to a value of true, the parameters area of the toolbar is displayed. If you set this parameter to a value of false, the parameters area is not displayed and cannot be displayed by the user. If you set this parameter to a value of Collapsed, the parameters area will not be displayed, but can be toggled by the end user. The default value of this parameter is true.
rc:Stylesheet Specify a style sheet to be applied to the HTML Viewer.

Additional Information

New in SP1. The rs:ParameterLanguage URL access parameter alleviates a problem in which culture-sensitive report parameters, such as dates, times, currency, and numbers, are interpreted using the browser language. With rs:ParameterLanguage, the URL is now interpreted independently of the browser. For example, if the report server is set to a regional setting of German, but a user is accessing a URL to a report using a browser that is set to English-United States, parameter values that are passed to a report server will be misinterpreted. Consider the following URL to a report:


In the above case, the server, running under a culture of "de-de", generates a URL either through an e-mail subscription or a hyperlink. The hyperlink indicates that the report should be parameterized by a start date of October 4, 2003, and an end date of October 11, 2003, according to German date/time standards. However, a user that is accessing the URL through a browser set to "en-us" forces the server to interpret the values as April 10, 2003, and November 10, 2003, under United States English date/time standards. This is incorrect. To fix the problem, rs:ParameterLanguage can be used to override the browser language for parameter interpretation:


In addition to a value of true and false for the URL access parameter rc:Parameters, you can now pass a value of Collapsed. When using rc:Parameters=Collapsed on a URL, the parameters area of the HTML Viewer is collapsed out of sight, but can still be toggled by the user. A value of false completely removes the parameters area from the HTML Viewer toolbar and makes it unavailable to the end-user.

The rc:Stylesheet parameter adds functionality to the HTML Viewer by enabling custom styles. The value of the parameter is the name of the style sheet (without the .css extension) that you want to apply to the HTML Viewer. For example, if the parameter rc:Stylesheet=fancy is specified, the fancy.css style sheet in the styles directory is applied. The style sheet must be a valid Cascading Style Sheet (CSS) file and be located in the styles directory. This directory is located by default at C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\Styles. The following example demonstrates how to add custom styles to the HTML Viewer:


If a style sheet is not specified, an internal default style sheet is applied. This default style sheet is also available in the styles directory for use as a template to create other style sheets.

4.3.3 Custom Authentication Cookies

New in SP1. Reporting Services SP1 has improved how Report Manager transmits cookies when using a custom security extension. In the previous version of Reporting Services, Report Manager transmitted only those cookies through HTTP requests specific to the report server. In SP1, the Web service proxy that Report Manager uses to communicate with the report server can now transmit additional cookies. You can enable Report Manager to transmit these additional cookies through to the report server by adding a PassThroughCookies element to the Report Manager configuration file. Transmitting additional cookies is helpful in a single sign-on authentication solution that requires not only the report server authentication cookies, but also cookies from a third-party authentication system.

To enable additional cookies to be transmitted through http requests when using Report Manager, set the following elements in the RSWebApplication.config file:


4.3.4 Report Server System Properties

New in SP1. SP1 includes two new system properties that you can read or set. The following table includes these new properties as well as the complete, updated set of system properties for a report server:

Property Description
SnapshotCompression New in SP1. Defines how snapshots are compressed. The default value is SQL. The valid values are as follows:

SQL = Snapshots are compressed when stored in the report server database. This is the current behavior.

None = Snapshots are not compressed.

All = Snapshots are compressed for all storage options, which include the report server database or the file system.

EnableIntegratedSecurity New in SP1. Determines whether integrated security is supported for report data source connections. The default is True. The valid values are as follows:

True = Integrated security is enabled.

False = Integrated security is not enabled. Report data sources that are configured to use integrated security will not run.

For more information about why you would set this property, see Security Concerns About Integrated Security.

SiteName The name of the report server site displayed on the user interface. The default value is SQL Server Reporting Services. This property can be an empty string. The maximum length is 8,000 characters.
SystemSnapshotLimit The maximum number of snapshots that are stored for a report. Valid values are -1 through 2,147,483,647. If the value is –1, there is no snapshot limit.
SystemReportTimeout The default report processing time-out value, in seconds, for all reports managed in the report server namespace. This value can be overridden at the report level. If this property is set, the report server attempts to stop the processing of a report when the specified time has expired. Valid values are 0 through 2,147,483,647. If the value is 0, reports in the namespace do not time out during processing. The default value is 1800.
UseSessionCookies Indicates whether the report server should use session cookies when communicating with client browsers. The default value is True.
SessionTimeout The length of time, in seconds, that a session remains active. The default value is 600.
EnableMyReports Indicates whether the My Reports feature is enabled. A value of True indicates that the feature is enabled.
MyReportsRole The name of the role used when creating security policies on user's My Reports folders. The default value is My Reports.
EnableExecutionLogging Indicates whether report execution logging is enabled. The default value is True.
ExecutionLogDaysKept The number of days to keep report execution information in the execution log. Valid values for this property include 0 through 2,147,483,647. If the value is 0 entries are not deleted from the Execution Log table. The default value is 60.

4.4 Management and Deployment

This section documents the user interface enhancements to Report Manager and provides updated information about report server deployment scenarios.

4.4.1 Zero-Byte Attachments on Lotus Domino Server v. 5.0.9a Mail Servers

New in SP2. Previously, you might have received zero-byte file attachments in e-mails generated by Microsoft SQL Server 2000 Reporting Services subscriptions when using an IBM Lotus Domino Server v. 5.0.9a mail server. Because of formatting differences, the mail server could not load the attachment. With SP2, IBM Lotus Domino servers can load a Reporting Services attachment and the reports appear correctly.

4.4.2 Enterprise Deployment Model Tag in BOL

New in SP2. The <ReportServerExternalUrl> tag in the RSWebApplication.config file appears incorrectly. In BOL, the tag appears as <ReportServerExternalURL>. This tag is case-sensitive and should appear as <ReportServerExternalUrl> instead.

4.4.3 Hiding Parameters in a Published Report

New in SP1. In Report Manager, you can now set parameter properties in a way that allows you to achieve two objectives simultaneously:

Previously, the only way to hide a parameter value was to clear the Prompt User check box in the Parameters properties page. However, a side effect of clearing the check box was that you could no longer specify a parameter value for the report at run time. This limitation has been removed. In SP1, you can clear the Prompt User check box to hide the parameter fields and values in the report. Doing so does not introduce restrictions on how you subsequently set the parameter value externally at run time.

4.4.4 New Configuration Settings

New in SP1. SP1 Setup does not modify, add, or remove settings in your configuration files. However, SP1 does introduce new configuration options that you can use to change your Reporting Services installation. Each setting has a default value that is used by Reporting Services components. These values are specified in program files. You can use the default values that are provided, or add settings to a configuration file to specify different values that override the defaults.

The following configuration settings have been added in SP1 so that you can specify how temporary snapshots are stored. The report server adds temporary files as needed and then removes them when a user session or subscription process is complete. To enable this feature, you must modify configuration settings in RSReportServer.config. This feature is not enabled by default. By default, a report server stores temporary snapshots in the reportservertempdb database.

Note    In addition to new configuration settings, a new system property (SnapshotCompression) has been added so that you can compress the snapshots before they are stored. Snapshot compression reduces the amount of space consumed by snapshots. Compressing snapshots also improves scalability if you have many users accessing report execution snapshots. You may encounter some performance degradation if you enable compression. Another reason for compressing snapshots is that it reduces contention issues in a report server database if you are deploying Reporting Services in a report server Web farm. For more information, see Report Server System Properties.

New Configuration Settings for Temporary Snapshots

The following configuration settings can be added to RSReportServer.config.

Setting Description Value
WebServiceUseFileShareStorage When set to True, the Report Server Web service stores cached reports and temporary snapshots (created for the duration of a user session) in the file system. True

False (default)

WindowsServiceUseFileShareStorage When set to True, the Report Server Windows service stores temporary snapshots (created for the duration of a user session) in the file system. True

False (default)

FileShareStorageLocation Specifies a folder on the file system for storing temporary snapshots. You can specify one folder. Although you can specify a UNC path, doing so is not recommended. The default value is c:\program files\Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles.

Example RSReportServer.config File

Use the following example to guide you in adding these settings to your configuration file. The new settings are in bold.

<Add Key="SecureConnectionLevel" Value="0"/>
<Add Key="InstanceName" Value="MSSQLSERVER"/>
<Add Key="ProcessRecycleOptions" Value="0"/>
<Add Key="CleanupCycleMinutes" Value="10"/>
<Add Key="SQLCommandTimeoutSeconds" Value="60"/>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DatabaseQueryTimeout" Value="120"/>
<Add Key="RunningRequestsScavengerCycle" Value="60"/>
<Add Key="RunningRequestsDbCycle" Value="60"/>
<Add Key="RunningRequestsAge" Value="30"/>
<Add Key="MaxScheduleWait" Value="5"/>
<Add Key="DisplayErrorLink" Value="true"/>
<Add Key="WebServiceUseFileShareStorage" Value="false" />
    <Path> XXXXX </Path>

New Configuration Setting for Report Designer Preview Cache

The following configuration setting can be added to RSReportDesigner.config.

Setting Description Value
CacheDataForPreview When set to True, the Report Designer stores data in a cache file on the local computer. For more information, see Preview Cache in Report Designer. True (default)


Example RSReportDesigner.config File

Use the following example to guide you in adding these settings to your configuration file. The new setting is in bold.

  <Add Key="SecureConnectionLevel" Value="0" />
  <Add Key="InstanceName" Value="Microsoft.ReportingServices.PreviewServer" />
  <Add Key="SessionCookies" Value="true" />
  <Add Key="SessionTimeoutMinutes" Value="3" />
  <Add Key="PolicyLevel" Value="rspreviewpolicy.config" />
  <Add Key="CacheDataForPreview" Value="true" />

4.4.5 Security Concerns About Integrated Security and Elevated Permissions

New in SP1. If a report is run by a user who has elevated permission on the server that hosts the data source, your SQL server can be exposed to a security threat if the report query contains malicious Transact-SQL statements (for example, statements that create unauthorized logins, or introduce erroneous data). For example, if an attacker publishes a report that contains a malicious query, the query will be processed under administrator credentials if either of these conditions is present:

To mitigate this threat, follow one or more of these recommended security practices:

The use of integrated security to access external data sources poses a special concern for report users, who may not know that their security token is being passed to an external data source (users are not warned in advance of running a report that the report is configured to use integrated security). In addition, users may not have the same concerns about opening a report as they would if they were opening an e-mail attachment from an unknown source. However, the security risks are the same in both scenarios. A malicious query can damage or compromise a server in the same way a malicious script that is exposed through a hyperlink or hidden in an e-mail attachment can damage or compromise a workstation.

Note that if you disable integrated security, any report data source that is currently configured to use integrated security (or subsequently configured to use integrated security after the feature is disabled) will no longer run. The following error is returned when integrated security is not supported on your report server: "This data source is configured to use Microsoft Windows NT integrated security but Windows NT integrated security is disabled for this server."

To disable integrated security, use script or code to modify the EnableIntegratedSecurity system property (for more information, see Report Server System Properties). For more information about creating and running scripts, go to Scripting with the rs Utility and the Web Service.