FIX: A hidden report table may unexpectedly appear in an Office Excel worksheet when the table was exported from SQL Server 2000 Reporting Services (897123)


The information in this article applies to:

  • Microsoft SQL Server 2000 Reporting Services, Service Pack 1 (SP1)

Beta Information

This article discusses a Beta release of a Microsoft product. The information in this article is provided as-is and is subject to change without notice.

No formal product support is available from Microsoft for this Beta product. For information about how to obtain support for a Beta release, see the documentation that is included with the Beta product files, or check the Web location where you downloaded the release.
Bug #: 302241 (SQLBUDT)
SQLBUDT:302241

SYMPTOMS

A report table may unexpectedly appear in a Microsoft Office Excel worksheet that was exported from Microsoft SQL Server 2000 Reporting Services. This issue may occur even if you set the Visibility Hidden property of the table to True.

Notes
  • The Visibility Hidden property functions correctly when you export the report to an HTML document or to a Tagged Image File Format (TIFF) file.
  • This issue only occurs in SQL Server 2000 Reporting Services Service Pack 1.

CAUSE

This issue occurs when the Visibility Hidden property for the table is based on an expression. For example, the following expression should set the Visibility Hidden property of the table to True when the value of the Hide parameter is set to hide: 
IIF(Parameters!Hide.Value="hide",TRUE,FALSE)

RESOLUTION

To resolve this issue, download and then install SQL Server 2000 Reporting Services Service Pack 2 (SP2).

For more information about how to obtain the latest SQL Server 2000 Reporting Services service pack, 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

WORKAROUND

To work around this issue, enter the expression in the Visibility Hidden property of the table rows. Additionally, if you use groups in your report, enter the expression in the Visibility Hidden property of the groups instead of the table rows.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

Steps to reproduce the behavior

  1. Create a report that is based on the customers table in the Northwind database
  2. Create a report string parameter that is named Hide.
  3. In the report layout, click the table, and then set the Visibility Hidden property for the table to the following expression: 
    =IIF(Parameters!Hide.Value="hide",TRUE,FALSE)
  4. Deploy and then view report. Specify hide as the report parameter.
  5. Export the report to Excel. Notice that the table is displayed in the Excel worksheet.
Modification Type:MajorLast Reviewed:4/12/2005
Keywords:kbSQLServ2000ReportServSp2fix kbcode kbBug kbtshoot kbfix KB897123 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.