Hi, i'm building a report with Sales Invoice Header as a parent dataset and Sales Invoice Line as child dataset.
I want the report to generate 10 rows before page break.
1st. If the records per document no in sales line is less than 10 records, for example only 6 records, then it will generate 4 empty rows.
2nd. If the records per document no in sales line is more than 10 records, for example only 14 records, then it will show first 10 records then the remaining 4 is on next page.
How to generate empty sales line records for first case ? I heard some people suggest using integer however i never used it. Can someone explain to me using this example ? Thanks