FIX: A hotfix is available for SQL Server 2000 Reporting Services Service Pack 2 (901383)

SYMPTOMS

This hotfix includes fixes for the following problems:

If you view the parameter lists in the HTML Report Viewer, characters in some languages appear reversed. This problem occurs because Verdana is the font that is used in the HTML Report Viewer. Verdana is used by default. The <HTMLViewerStyleSheet> configuration property lets the user to specify the default style sheet font in the viewer so that fonts are displayed correctly. The <HTMLViewerStyleSheet> property is missing from Microsoft SQL Server 2000 Reporting Services Service Pack 2 (SP2). This property is included in this hotfix.
If you render a report in MHTML, the report may have incorrect line breaking or random formatting problems. MHTML is used when you embed report contents in an e-mail message. This problem is a regression that is caused by a change in Reporting Services SP2. The regression addressed the requirement for shorter line lengths in e-mail messages.
If you leave and then return to the Schedule page from the Subscription Properties page, the dependent report parameters are disabled. The parameters are then reset to the first value or the default value. This problem occurs when a report subscription is created by using specific parameters, and the schedule is edited. The saved parameter is either disabled or changed to the first value or the default value in the parameter list.
If you export a table to a .csv file, the first row of data may be lost. If a report that has table details has a group expression or if the report does not have a detail row, the first row of data may be lost after the table is exported to a .csv file.

RESOLUTION

Hotfix information

To obtain this hotfix, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?amp;displaylang=en&familyid=7FFE50D4-AFF8-4C1E-9609-6798190C2D58&displaylang=en

back to the top

Prerequisites

To apply this hotfix, you must have Reporting Services SP2 installed on the computer. For more information about how to obtain Reporting Services Service Pack 2, click the following article number to view the article in the Microsoft Knowledge Base:

842440 How to obtain the latest service pack for SQL Server 2000 Reporting Services

back to the top

Restart information

You do not have to restart the computer after you apply this hotfix.

back to the top

Registry information

You do not have to change the registry.

back to the top

Hotfix file information

This hotfix contains only those files that are required to correct the issues that this article lists. This hotfix may not contain all the files that you must have to fully update a product to the latest build.

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.

SQL Server 2000 Reporting Services

  Date             Time     Version         Size          File name
--------------------------------------------------------------------------------------------------------
13-Jun-2005      14:42    8.0.1042.0      270,336       Microsoft.reportingservices.diagnostics.dll
13-Jun-2005      14:41    8.0.1042.0       57,344       Microsoft.ReportingServices.CsvRendering.dll
13-Jun-2005      14:42    8.0.1042.0      770,048       ReportingServicesWebUserInterface.dll
13-Jun-2005      14:42    8.0.1042.0      389,120       Microsoft.ReportingServices.HtmlRendering.dll
13-Jun-2005      14:42    8.0.1042.0      503,808       ReportingServicesWebServer.dll

Note Because of file dependencies, the most recent hotfix or feature that contains these files may also contain additional files.

back to the top