Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. You cannot keep the column headers or the row headers visible when you scroll through a report in SQL Server 2008 Reporting Services

You cannot keep the column headers or the row headers visible when you scroll through a report in SQL Server 2008 Reporting Services

Symptoms

Consider the following scenario:
  • You upgrade a table from Microsoft SQL Server 2005 Reporting Services to SQL Server 2008 Reporting Services. Or, you create a new table in SQL Server 2008 Reporting Services.
  • You click to select the Header should remain visible while scrolling check box for Row Headers or for Column Headers in the Tablix dialog box in SQL Server 2008 Reporting Services.
In this scenario, you cannot keep the column headers or the row headers visible when you scroll through a report.

Note This issue does not occur when you create matrices.

↑ Back to the top

Cause

This problem occurs because the properties to enable the fixed headers feature have changed from SQL Server 2005 to SQL Server 2008. The structure of tables and matrices is replaced by a Tablix.

↑ Back to the top

Workaround

To work around this issue, use one of the following two methods.

Method 1: Keep the original structure of the current data region

  1. On the Report menu, click Grouping.
  2. In the Grouping pane, click the selector arrow in the upper-right corner, and then click Advanced.
  3. Select a Tablix member in the Row Groups or Column Groups pane that corresponds to a row or a column that you want to fix.
  4. In the Properties dialog box, set the FixedData property to True.
Note You can set the FixedData property to True only if there is no corresponding Tablix row header area or column header area in the data region.

Method 2: Add a row group or a column group to the Tablix

  1. To obtain the row or column grouping area in the Tablix, add a row group or a column group.
  2. After you add a row group or a column group, you can change the content in those areas as necessary. This reflects the content that you want to fix when you scroll.
Note When you create new tables in SQL Server 2008, add a row grouping area or a column grouping area to the table by adding row or column groups to the data region. Then, replace the content.

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

More Information

In a Tablix, there are explicit row header and column header areas of the data region that are defined by a double-dashed line. This line is visible on the design surface.

Tables that you upgrade from SQL Server 2005 do not generate a Tablix row header area or column header area. After you upgrade from SQL Server 2005, you may click to select the Header should remain visible while scrolling check box in the Tablix dialog box. This step does not generate fixed column headers or fixed row headers.

Assume that you define fixed headers in a table or in a matrix in SQL Server 2005, and then you upgrade to SQL Server 2008. The fixed header settings are translated to the new FixedData setting. This feature works correctly. If you do not enable this feature in SQL Server 2005, and you try to set it or change it by setting the FixedHeader property in SQL Server 2008, this feature does not work.

When you create new tables in SQL Server 2008, the default table placeholder does not have a Tablix row header or column header area. Therefore, setting the FixedHeader property does not perform as usual.

Microsoft intends to improve the user interfaces for this feature in the next version of SQL Server Report Builder and Report Designer.

↑ Back to the top

References

For more information about the Grouping pane, visit the following Microsoft Web site:
http://msdn.microsoft.com/en-us/library/cc281455(SQL.100).aspx
For more information about how to add or delete a group in a data region in Reporting Services, visit the following Microsoft Web site:
http://technet.microsoft.com/en-us/library/ms156487(SQL.100).aspx
For more information about how to keep headers visible while you scroll through a report, visit the following Microsoft Web site:
http://msdn.microsoft.com/en-us/library/bb934257(SQL.100).aspx

↑ Back to the top

Keywords: sql2008relnotereportingservices, sql2008relnote, kbprb, kbexpertiseadvanced, kbtshoot, kbfix, kbentirenet, kb

↑ Back to the top

Article Info
Article ID : 955822
Revision : 3
Created on : 4/20/2018
Published on : 4/20/2018
Exists online : False
Views : 106