DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2494517 - Last Review: April 22, 2011 - Revision: 1.0

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.

CAUSE

This problem occurs because the values of hidden items are incorrectly cleared when the hidden items are processed on successive pages.

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

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.

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


APPLIES TO
  • Microsoft SQL Server 2008 R2 Reporting Services
Keywords: 
kbqfe kbfix kbexpertiseinter kbprb kbsurveynew KB2494517
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support