FIX: A hidden text box value that is referenced in the Tablix header is displayed only on the first page when you export a report to any hard page-break rendering format in SQL Server 2008 R2 Reporting Services

Article ID: 2494517 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

Consider the following scenario:
  • You have a computer that has Microsoft SQL Server 2008 R2 Business Intelligence Development Studio (BIDS) installed.
  • You use BIDS to create a report.
  • You add a Tablix data region to the report body.
  • You set the value of the HIDDEN property to TRUE for a text box in the Tablix header. This text box is also known as a hidden text box.
  • You reference the value of the hidden text box from the ReportItems collection in the page header or footer.
  • You preview the report and then export it to any hard page-break rendering format. For example, you export the report to a PDF-formatted or TIFF-formatted file.

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.
Back to the top | Give Feedback

CAUSE

This problem occurs because the values of hidden items are incorrectly cleared when the hidden items are processed on successive pages.
Back to the top | Give Feedback

RESOLUTION

Service pack information for SQL Server 2008 R2

To 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:
2527041
(http://support.microsoft.com/kb/2527041/ )
How to obtain the latest service pack for SQL Server 2008 R2
Back to the top | Give Feedback

STATUS

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.
Back to the top | Give Feedback

MORE INFORMATION

For more information about BIDS, visit the following MSDN website:
Introducing Business Intelligence Development Studio
(http://msdn.microsoft.com/en-us/library/ms173767.aspx)
For more information about the Tablix data region, visit the following MSDN website:
Understanding the Tablix data region
(http://msdn.microsoft.com/en-us/library/bb677552.aspx)
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684
(http://support.microsoft.com/kb/968382/ )
Description of the standard terminology that is used to describe Microsoft software updates

Back to the top | Give Feedback

Properties

Article ID: 2494517 - Last Review: April 22, 2011 - Revision: 1.0
APPLIES TO
  • Microsoft SQL Server 2008 R2 Reporting Services
Keywords: 
kbqfe kbfix kbexpertiseinter kbprb kbsurveynew KB2494517
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top