Article ID: 955822 - View products that this article applies to.
Consider the following scenario:
Note This issue does not occur when you create matrices.
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.
To work around this issue, use one of the following two methods.
Method 1: Keep the original structure of the current data region
Method 2: Add a row group or a column group to the Tablix
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
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.
For more information about the Grouping pane, visit the following Microsoft Web site:
http://msdn.microsoft.com/en-us/library/cc281455(SQL.100).aspxFor 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).aspxFor more information about how to keep headers visible while you scroll through a report, visit the following Microsoft Web site:
Article ID: 955822 - Last Review: March 19, 2009 - Revision: 2.0
Contact us for more help
Connect with Answer Desk for expert help.