Home Forums Reporting Services Reporting Services 2005 Development Repeating TABLE Header on each page of the report when you print the exported to excel report. RE: Repeating TABLE Header on each page of the report when you print the exported to excel report.

  • March 11, 2010 at 8:04 am

    #1132059

    Hi All,

    If its SSRS 2008, make available the "Grouping window" by right clicking on report and selecting "Grouping" from menu.

    1. Select "Advanced Mode" ( click on small arrow on right corner of grouping toolbar) this will display all rows of tablix control.

    2. Click on the desired static row and press F4 to display properties window.

    3. Set "RepeatOnNewPage" to "True" and

    4. Set "KeepWithGroup" to "After"

    5. Set the property same for all static row in same hierarchy i.e if you have 3 rows before group header in tablix then you need to set these properties for all. otherwise SSRS will display an error.

    thanks