Repeat Table Header On Each Page Of The Report

In the SSRS 2008,  table headers won’t repeat on every page by default when you print or export or print preview the report. To configure the repeat table header in this scenario, you can change the xml behind the RDL file.

Search for TablixRowHierarchy for the given Tablix control and look for the section with a TablixMember and KeepWithGroup

        <TablixRowHierarchy>
          <TablixMembers>
            <TablixMember>
              <KeepWithGroup>After</KeepWithGroup>
            </TablixMember>            <TablixMember>
              <Group Name=”Details2″ />
            </TablixMember>
          </TablixMembers>
        </TablixRowHierarchy>

Update the TablixMember with two additional element properties – RepeatOnNewPage and KeepTogether.

        <TablixRowHierarchy>
          <TablixMembers>
            <TablixMember>
              <KeepWithGroup>After</KeepWithGroup>
              <RepeatOnNewPage>true</RepeatOnNewPage>
              <KeepTogether>true</KeepTogether>            </TablixMember>            <TablixMember>
              <Group Name=”Details2″ />
            </TablixMember>
          </TablixMembers>
        </TablixRowHierarchy>

Save the RDL file and repeating header rows should be visible when you print preview, print, or export the report.

Table headers will repeat on every page by default when you print, print preview, or export the report.

Haven Tested yet. Will test soon as i get this information from Google. If possible to work i will upload the step soon.