- 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.
Note This issue does not occur when you create matrices.
Method 1: Keep the original structure of the current data region
- On the Report menu, click Grouping.
- In the Grouping pane, click the selector arrow in the upper-right corner, and then click Advanced.
- 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.
- In the Properties dialog box, set the FixedData property to True.
Method 2: Add a row group or a column group to the Tablix
- To obtain the row or column grouping area in the Tablix, add a row group or a column group.
- 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.
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.
Article ID: 955822 - Last Review: Mar 19, 2009 - Revision: 1