DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 889641 - Last Review: May 18, 2007 - Revision: 5.3

INTRODUCTION

This article describes late-breaking changes in Microsoft SQL Server 2000 Reporting Services Service Pack 2 (SP2) that are not documented in the sp2Readme_EN.htm file. This article also includes any corrections to the original sp2Readme_EN.htm file.

Note To download the sp2Readme_EN.htm file, visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyID=502c0d89-1308-4662-8f58-cec55ef1235b&DisplayLang=en (http://www.microsoft.com/downloads/details.aspx?FamilyID=502c0d89-1308-4662-8f58-cec55ef1235b&DisplayLang=en)

MORE INFORMATION

The following issues in SQL Server 2000 Reporting Services SP2 currently are not documented in the sp2Readme_EN.htm file:
  • You must restart the computer when you finish installing SQL Server 2000 Reporting Services Service Pack 2. You will be prompted to restart the system as soon as the Setup program finishes.
  • If you are installing SQL Server 2000 Reporting Services SP2 by using a command-line command, and you want to suppress the post-Setup restart, use the following command:
    REBOOT = ReallySuppress
  • To disable client-side printing, you must set the EnableClientPrinting property to False. Then, you must restart Microsoft Internet Information Services (IIS) for the new property to take effect.
  • With SQL Server 2000 Reporting Services SP2, the Microsoft .NET Framework string comparison method is now used for sort expressions in the report definition. This is a change from earlier releases. In earlier releases, the SQL Server string comparison library was used. In some locales, report data may have a different sort order when it is processed by using SQL Server 2000 Reporting Services SP2. For more information about this method, visit the following Microsoft Developer Network (MSDN) Web site:
    http://msdn2.microsoft.com/en-us/library/aa331848(VS.71).aspx (http://msdn2.microsoft.com/en-us/library/aa331848(VS.71).aspx)
The following items are not documented correctly in the Readme.htm file:
  • Section 4.4.3 Hiding Parameters in a Published Report:

    Currently, the readme file includes the following text:
    In SP1, you can clear the Prompt User check box to hide the parameter fields and values in the report.
    However, this text is not correct. You should click to select the Prompt Users check box. Then, you should clear the Prompt User field in Report Manager to successfully hide the parameter fields and values.
  • Section 4.2.1 Chart Datapoints:

    This problem only affects Line and Area charts. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
    883675  (http://support.microsoft.com/kb/883675/ ) FIX: Invalid values appear in a chart if you change the default color for the value series of the chart in SQL Server 2000 Reporting Services Service Pack 1
  • Section 4.1.2 - Programmability/APIs

    This section lists the following properties for the client print ActiveX control that are not available from that control:
    • LocaleID
    • CultureInfo
    The following properties are available on the print control but are not documented in the Readme.htm file:
    • Culture
    • UICulture
    • Authenticate
    For more information about these properties, visit the following MSDN Web site:
    http://msdn2.microsoft.com/en-us/library/aa237388(SQL.80).aspx (http://msdn2.microsoft.com/en-us/library/aa237388(SQL.80).aspx)
  • Section 4.2.7 - Default Style Sheet

    This section refers to a <HTMLViewerStyleSheet> property. This is not included in SP2, but this is included in the hotfix that is available at the following Web site:
    http://www.microsoft.com/downloads/details.aspx?FamilyId=7FFE50D4-AFF8-4C1E-9609-6798190C2D58&displaylang=en (http://www.microsoft.com/downloads/details.aspx?FamilyId=7FFE50D4-AFF8-4C1E-9609-6798190C2D58&displaylang=en)

REFERENCES

For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
842440  (http://support.microsoft.com/kb/842440/ ) How to obtain the latest service pack for SQL Server 2000 Reporting Services
889640  (http://support.microsoft.com/kb/889640/ ) A list of the bugs that are fixed by SQL Server 2000 Reporting Services Service Pack 2

APPLIES TO
  • Microsoft SQL Server 2000 Reporting Services
Keywords: 
kbtshoot kbsqlserv2000reportservsp2fix kbinfo KB889641
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support