web
You’re offline. This is a read only version of the page.
close
Skip to main content
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

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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans