Article ID: 897123 - View products that this article applies to.
This article has been archived. It is offered "as is" and will no longer be updated.
Beta InformationThis 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)
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.
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:
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:
(https://support.microsoft.com/kb/842440/ )How to obtain the latest service pack for SQL Server 2000 Reporting Services
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.
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.
Steps to reproduce the behavior