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 :
Microsoft Dynamics NAV (Archived)

add a page break after a certain amount of lines

(0) ShareShare
ReportReport
Posted on by 109

At first I'm new to editing reports. I'm working on a custom sales - invoice report (rdlc layout). I copied the existing one and changed a few things. I added a page footer and the company infos that I need. In the existing sales - invoice report there was a separated total table which I merge with the item table by adding the same amount of rows to the item table and insert the same informations and row visibility expressions. Now I have an issue with the table where the whole table is printed on a second page though there is enough space on the first page (at least it looks like there is enough space). To solve this I thought about adding a page break after a certain amount of rows in the table. I found a tutorial on youtube where the guy was adding a group to the table (https://www.youtube.com/watch?v=nBYn1DU3VMQ). For the group he used the expression "=Ceiling(RowNumber(Nothing) / 10)" to add a page break after the 10th row. I tried to do the same in my table but I can't use "Nothing" in my expression. This is the error message I get. Below you can the table and the row groups. It would be really nice if someone can tell me how I can add a page break, because right now the report is garbage without it...

Bildschirmfoto-2019_2D00_01_2D00_09-um-10.08.40.png

Bildschirmfoto-2019_2D00_01_2D00_09-um-10.09.14.png

Bildschirmfoto-2019_2D00_01_2D00_09-um-10.09.21.png

*This post is locked for comments

I have the same question (0)

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans