web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / SSRS report repeat tab...
Finance | Project Operations, Human Resources, ...
Suggested Answer

SSRS report repeat table static row with table data

(3) ShareShare
ReportReport
Posted on by CC-24020107-0 65
Hi all, 
 
I be required to repeat the header for existing standard Customer Account Statement report in each page. I try several ways like repeat with and repeat column headers... However, I still did not manage to achieve my desire result. 



 
Can anyone advise how can I repeat this header?
Categories:
Dynamics 365 Finance
I have the same question (0)
  • Suggested answer
    Saif Ali Sabri Profile Picture
    Saif Ali Sabri 2,354 Moderator on at

    If the headers in your Customer Account Statement SSRS report are not repeating on each page, follow these steps to ensure that the headers remain visible throughout the report.

    Step 1: Enable "Repeat Header Rows on Each Page"

    1. Select the Table (Tablix) Control:

      • Click anywhere inside your table (Tablix) to select it.

    2. Open "Row Groups" Pane:

      • If not visible, go to View > Grouping Pane.
      • In the Row Groups section, locate the (Static) member that corresponds to the header row.

    3. Set Header Row Properties:

      • Click the small triangle next to (Static) and select Properties.
      • In the Properties window:
        • Set KeepWithGroup = After
        • Set RepeatOnNewPage = True
        • Set KeepTogether = True

    4. Apply Changes & Save.

    Step 2: Enable "Repeat Headers" in Tablix Properties

    1. Select the Tablix (the whole table, not just a single row).
    2. In the Properties pane, check:
      • RepeatColumnHeaders = True
      • RepeatRowHeaders = True
      • FixedHeader = True (if needed for freezing headers in interactive reports)

    Step 3: Verify and Adjust Page Breaks

    1. Check Page Break Settings:

      • If page breaks are applied incorrectly, remove or adjust them.
      • Select the table, go to Properties, and ensure that PageBreak is set correctly.

    2. Ensure Group Headers Are Set to Repeat:

      • In the Row Groups pane, select the parent group (if applicable).
      • Right-click and choose Group Properties.
      • In the Page Breaks tab, ensure:
        • "Between each instance of a group" is checked (only if needed).

    Step 4: Preview and Test the Report

    1. Run the report in Preview Mode and check if headers repeat across all pages.
    2. If the issue persists, try adjusting the Row Height in the header row to ensure it is not being pushed off the page.

    Final Notes:

    • If your report uses a Matrix (instead of a Table), apply the same RepeatOnNewPage setting in the Column Groups section.
    • If exporting to Excel, ensure the FixedHeader option is enabled to keep headers visible while scrolling.
  • CC-24020107-0 Profile Picture
    CC-24020107-0 65 on at
    Hi, thanks for the answers, but it seems not work for my report. The header still not get repeated in every page.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 659

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 465 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 304 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans