HOW TO: Repeat Header Rows in SQL Reporting Services 2008

Can’t get table (Tablix) headers to repeat on each page in SSRS 2008, no matter what you do, or how many checkboxes you tick?

If you have styled your Tablix as a tabular layout, you can pretty much forget the Tablix properties form. Instead, try the following:

  1. Ensure that Advanced Mode is selected in Row and Column Groups
    rsadvanced
  2. Select the (Static) rows in the Row Groups section. In the example below, we have 2 (Static) Row Groups that need to repeat on each page.
    static group
  3. Set the Properties as follows:
    1. RepeatOnEachPage : True
    2. FixedData: True
    3. KeepWithGroup: After

      rowprops

About the Author