Dividing reports into pages

I am displaying tabular reports and the report is set to dataset. I want to display only 10 records per page. How do I do this.

Thanks,

Sai Abhiram Bandhakavi

Have you looked in to custom code. Off the top of my head I don't know of another way to determine a page break other than groupings. So you could set a calculated field value based on some function through custom code to increment a number on everything 10th record.

The custom code would be a simple add one to a public variable when run... So in the calculated field you could use the IIF(RowNumber(Nothing) mod 10 = 0, <true>, <false>) to fire on every 10th record... or something similar.

Check this out. I'll run some tests as time permits. If nothing else I hope I provided some ideas.