web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums 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) Share

Report

Report

Posted on by CC-24020107-0

76

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)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Saif Ali Sabri 2,439 Moderator on at

Like (1)

Report
Copy link

Link copied!
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"

Select the Table (Tablix) Control:

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

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.

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

Apply Changes & Save.

Step 2: Enable "Repeat Headers" in Tablix Properties

Select the Tablix (the whole table, not just a single row).

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

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.

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

Run the report in Preview Mode and check if headers repeat across all pages.

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.

Was this reply helpful? Yes No
CC-24020107-0 76 on at

Like (0)

Report
Copy link

Link copied!

Hi, thanks for the answers, but it seems not work for my report. The header still not get repeated in every page.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

Giorgio Bonacorsi 802

#2

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

#3

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