Crystal Report, Print fixed number of detail

Question

Hi,

i'm trying to print a report with a fixed number of detail on every page. the data for the report is taken from database.

say that a report has 13 detail records. i must print it on 2 pages, with the last page contains 3 true records and 7 empty records,

all i need to achieve is to extend the line separating each column in a record until the bottom of the report, so the 'Report Footer' will be printed at the same position on every page.

i've once done this with a way that i think not that good and dirty. i used an application DataSet, and i check the table in the dataset, if the records is not in the multiplication of 10, i add empty rows until it be.

is there any formula in CR for this?

Thank you