Share via

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

  • Article

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
My SSRS Articles