Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Repeat header rows on each page in a Report

(0) ShareShare
ReportReport
Posted on by

Hi,

I have  a report with a table with several adjacent groups. If I put the corresponding properties, just repeat the header in the first group.
How can I make the header repeat for all the groups I have?

Thanks.

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: Repeat header rows on each page in a Report

    Yes, I thought about that, too.

    When my supervisor reviews it, I will put the solution that we have applied.

    Best Regards.

  • Tina Menezes Profile Picture
    2,582 on at
    RE: Repeat header rows on each page in a Report

    Hi

    In your scenario you will need to create a header for every row group because the main header cannot be repeated for every group. It will only be repeated on every page for the first group. So you will need to create a header for every group and then follow the same steps for every group to repeat on every page as given in my blog because every header row that you add will now appear as a static column in advanced mode.

  • Community Member Profile Picture
    on at
    RE: Repeat header rows on each page in a Report

    Yes, this is for a Report that has column groups, but not in my Report. In this case only there are adjacents row groups, as you can see in the picture. And I'd like repeat the header on each page, but how I said, only repeat for the first group 'Code_SalespersonPurchase1'.

    3652.LayoutReport.png

    The only solution I see is to put a header for each group, but this would look bad visually.

  • Tina Menezes Profile Picture
    2,582 on at
    RE: Repeat header rows on each page in a Report

    Hi,

    You should set RepeatOnNewPage, fixed data and keep with group properties for the  column grouo of your report after going to the advanced mode and then to the static part of your columns in the same way how I have mentioned in my post for row group.

    You can read 'To display a static row or column on multiple pages' section in the below link:

    docs.microsoft.com/.../display-row-and-column-headers-on-multiple-pages-report-builder-and-ssrs

  • Community Member Profile Picture
    on at
    RE: Repeat header rows on each page in a Report

    Hi,

    These are the groups in the Report:

    gruposReport.png

    If you try to give repeat on new page true for Row groups, only work for the first group.

    For the Columns group no Works in this case.

    Thanks. 

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Repeat header rows on each page in a Report

    Hi Llumiua,

    As per tina suggested post but you also try to give repeat on new page true for Column Groups also.

    4130.Capture2.PNG

    Thank You

    Ramesh

    --

  • Community Member Profile Picture
    on at
    RE: Repeat header rows on each page in a Report

    Hi Tina,

    I used this properties, but it doesn't work to all of groups adjacents, only works with the first group.

  • mmv Profile Picture
    11,467 on at
    RE: Repeat header rows on each page in a Report

    Hi,

    As mentioned in Tina's post, you need to set the "RepeatOnNewPage" property to True for all the rows to be repeated.

  • Suggested answer
    Tina Menezes Profile Picture
    2,582 on at
    RE: Repeat header rows on each page in a Report

    Hi,

    You can refer my blog using the below link for the steps to repeat header rows on every page of a report.

    [View:https://tinamenezesdynamicsnavblog.wordpress.com/2017/08/02/procedure-to-repeat-table-header-rows-on-every-page-of-a-report-in-dynamics-nav/]

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans