Dynamics Community Forum Thread Details

add a page break after a certain amount of lines

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