Fixed number of rows In Access Report

I am having tried a access 2007 report with fixed numbers of rows (records) per page. For example, I like to fix total number of records (rows) to 10 per page while underlying query might have 5 records in some criter开发者_如何学运维ia or 15 records in some case. If any idea, please share me.

TIA ProNek

You can us a pagebreak with the visible property set to false and then make it visible when a counter reaches the relevant number.

Further information: http://support.microsoft.com/kb/119075

You can count and insert page break on the report's body (or section) format event. This event fires on every record. You can place a pagebreak at the end of the section and make it visible when you need to print on next page.