Unanswered: How to display fixed number of records per page in a report?
I'm using the Northwind Traders database as an example to create my own. I have tweaked the database to what I want and its almost perfect to my requirement. One problem I have is the display of rows to fill up a landscape sheet (which I will print twice as customer copy and company copy) on one sheet of paper. So if there is one order id with 4 order details of that order id I need to display the 4 plus an additional 6 blank order details to fill up the space. If 3 then 7. If 11 then 10 on one page with 1 on and 9 blanks.
Please let me know what information is required to help in this question so I can provide it. I can upload the database as well as it is if required.