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 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 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:

824684 Description of the standard terminology that is used to describe Microsoft software updates

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.