Resources For IT Professionals
Post an article
Wikis - Page Details
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: How to Repeat Headers on Each Page

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 KeepWithGroup =  After 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
, , , , , , , [Edit tags]
Leave a Comment
  • Please add 2 and 3 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 27 Aug 2013 10:02 PM

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

  • 31 Aug 2013 9:05 PM

    SathyanarrayananS edited Revision 2. Comment: added reference link

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
  • Posted by
    on 27 Aug 2013 10:02 PM

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

  • Posted by
    on 31 Aug 2013 9:05 PM

    SathyanarrayananS edited Revision 2. Comment: added reference link

  • Posted by
    on 5 Sep 2013 10:55 PM

    Maheshkumar S Tiwari edited Revision 4. Comment: minor edit

  • Posted by
    on 1 Sep 2013 6:20 PM

    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.

  • Posted by
    on 5 Sep 2013 9:56 PM

    Nice and Useful Article Thanks

  • Posted by
    on 29 Aug 2013 10:04 AM

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

Page 1 of 1 (6 items)