SSRS (Matrix): How to Repeat Headers on Each Page and Keep Headers Fixed while Scrolling

SSRS (Matrix): How to Repeat Headers on Each Page and Keep Headers Fixed while Scrolling

This article is an outcome of my answer to this question on MSDN SSRS forum . Previously I wrote similar article on SSRS: How to Repeat Headers on Each Page  and keep headers fixed while scrolling for a table.  In this article , let us see an example on how to repeat headers on each page  and keep headers fixed while scrolling for a matrix with column groups.

Consider this query from AdventureWorks database as my dataset:

SELECT TOP 500 SalesOrderID,LineTotal
FROM [Sales].[SalesOrderDetail]

I have Matrix on the report body as shown below:




To repeat headers on each page  and keep headers fixed while scrolling for a matrix :

Right-click on the matrix, Tablix Properties ... - >  General - >  Column Headers - >
Select the options :
Repeat header columns on each page
Keep header visible while scrolling




Now click on Preview, we can notice the headers repeated on each page  and headers fixed while scrolling  (as shown below) :

  


See Also  

SQL Server Reporting Services Portal
List of Award Winning TechNet Guru Articles
Sort by: Published Date | Most Recent | Most Useful
Comments
Page 1 of 1 (8 items)