Article ID: 2494517 - View products that this article applies to.
Consider the following scenario:
In this scenario, the hidden text box value in the page header or footer is displayed only on the first page of the exported report. You expect this value to be displayed on all pages of the exported report.
Note This same behavior occurs after you deploy the report to the report server and then export it to any hard page-break rendering format by using Report Manager, a Webservice API, or a similar method.
This problem occurs because the values of hidden items are incorrectly cleared when the hidden items are processed on successive pages.
Service pack information for SQL Server 2008 R2To resolve this problem, obtain the latest service pack for SQL Server 2008 R2. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/2527041/ )How to obtain the latest service pack for SQL Server 2008 R2
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
This problem was first corrected in SQL Server 2008 R2 Service Pack 1 for SQL Server 2008 R2.
For more information about BIDS, visit the following MSDN website:
Introducing Business Intelligence Development StudioFor more information about the Tablix data region, visit the following MSDN website:
Understanding the Tablix data regionFor more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/968382/ )Description of the standard terminology that is used to describe Microsoft software updates