SSRS: How to Repeat Headers on Each Page

SSRS: How to Repeat Headers on Each Page

This article shows an example of how to repeat headers on each page of SSRS report .

Consider this code block is my dataset query from AdventureWorks database:

SELECT TOP 100 BusinessEntityID,JobTitle,Gender 
FROM [HumanResources].[Employee]

Drag and drop Table from Toolbox - > ReportItems on to the body of the report under Design pane and assign the columns from Dataset to the Table .



If we click on Preview pane , we will notice report data gets displayed into three pages with no headers on all pages except the first page .



So to repeat headers on all pages :

Under Design Pane - > at the bottom Column Groups - > click on drop down (down arrow) - > Advanced Mode .



Once we selected Advanced Mode, we will be able to notice (static) in Row Groups and Column Groups at the bottom of Design pane .



Under Design Pane - > Row Groups - > click on (static) - > Press F4  - > Properties window will pop-up. 

In the Properties window - >Set KeepWithGroupAfter and RepeatOnNewPage = True.

If you want header to be frozen while scrolling down the report, set FixedData = True.



Now click on Preview pane and check all the pages for headers and scroll-down to check the fixed header.





Reference - http://technet.microsoft.com/en-us/library/dd207045.aspx
                     http://technet.microsoft.com/en-us/library/dd220509.aspx
Leave a Comment
  • Please add 8 and 6 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • SathyanarrayananS edited Revision 2. Comment: added reference link

  • Maheshkumar S Tiwari edited Revision 1. Comment: Added Tag and minor edit

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
  • Maheshkumar S Tiwari edited Revision 1. Comment: Added Tag and minor edit

  • Most commonly asked questions on MSDN SSRS forumn - how to repeat headers on each page and how to freeze the headers while scrolling , I hope above article with screenshots will be helpful for others :)

  • SathyanarrayananS edited Revision 2. Comment: added reference link

  • The word "forum" does not have a "n" at the end. You keep making the same typo in all your articles. Also, this article will benefit from the See Also section.

  • Nice and Useful Article Thanks

  • Maheshkumar S Tiwari edited Revision 4. Comment: minor edit

Page 1 of 1 (6 items)