Microsoft KB Archive/897123

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

Article ID: 897123

Article Last Modified on 4/12/2005

-

APPLIES TO


 * Microsoft SQL Server 2000 Reporting Services Service Pack 1

-





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)



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=&quot;hide&quot;,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 &quot;Applies to&quot; section.



Steps to reproduce the behavior
 Create a report that is based on the customers table in the Northwind database Create a report string parameter that is named Hide.  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=&quot;hide&quot;,TRUE,FALSE)  Deploy and then view report. Specify hide as the report parameter.</li> Export the report to Excel. Notice that the table is displayed in the Excel worksheet.</li></ol>

Keywords: kbtshoot kbbug kbfix kbcode kbsqlserv2000reportservsp2fix KB897123

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.