Repeat tablix headers and groupings on subsequent pages

  1. Select the left top corner of the table to select the entire table.
  2. In the Column Groups section, select the three-dot menu icon () and then select Advanced.
  3. Select the header row of your table in the Row Groups section.

  4. Select the properties icon () and set the following properties:
    1. In the Miscellaneous section, set the following properties:
      1. Select the Keep Together checkbox.
      2. Select After from the Keep With Group dropdown.
      3. Select the Repeat On New Page checkbox.
    2. In the Visibility section, select the Visible checkbox.
  5. Select the grouping row that includes all the child elements and footer in the Row Groups section.

  6. Select the properties icon () and set the following properties:
    1. In the Miscellaneous section, clear the Fixed Data and Keep Together checkboxes.
    2. In the Visibility section, select the Visible checkbox.

    If a report has multiple grouping levels, these properties apply to each group.

  7. Select the static row that represents only the grouping row, excluding any child rows or footers.

  8. Select the properties icon () and set the following properties:
    1. In the Miscellaneous section, set the following properties:
      1. Select the Keep Together checkbox.
      2. Select After from the Keep With Group dropdown.
      3. Select the Repeat On New Page checkbox.
    2. In the Visibility section, select the Visible checkbox.

    If a report has multiple grouping levels, these properties apply to each group's static row.

  9. Select the details row.

  10. Select the properties icon () and set the following properties:
    1. In the Miscellaneous section, clear the Fixed Data checkbox and select the Keep Together checkbox.
    2. In the Visibility section, select the Visible checkbox.
  11. Select the grouping footer row.

  12. Select the properties icon () and set the following properties:
    1. In the Miscellaneous section, do the following:
      1. Clear the Fixed Data, Keep Together, and Repeat On New Page checkboxes.
      2. Select Before from the Keep With Group dropdown.
    2. In the Visibility section, select the Visible checkbox.

      If a report has multiple grouping levels, these properties apply to each group's footer row.

  13. Select Save Report.