Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by (8Microsoft Community Contributo)
  • When: 1 Sep 2013 1:16 AM
  • Last revision by (eMicrosoft Partne)
  • When: 17 Sep 2013 1:02 PM
  • Revisions: 5
  • Comments: 5
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  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

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

, , , , , [Edit tags]
Leave a Comment
  • Please add 2 and 6 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 1 Sep 2013 7:12 AM

    Naomi  N edited Revision 2. Comment: Minor edit

  • 1 Sep 2013 2:55 AM

    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)