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) :

Leave a Comment
  • Please add 1 and 8 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Naomi  N edited Revision 2. Comment: Minor edit

  • Maheshkumar S Tiwari edited Revision 1. Comment: Added tags

Page 1 of 1 (2 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
Page 1 of 1 (5 items)