Force report footer location in subreport (1 Viewer)

[Chrisopia]

I have a report, with a sub report.

The sub report has a determined height, and can't grow or shrink.
It has enough height for 25 rows, which will never be filled for this purpose.

I need a totals box to appear after the 25th row, but it will only show at the bottom of the list, regardless of the number of rows.

I have a =sum([Price]) control box in the report footer, is there a way to make the report footer go to the bottom of the pre-defined height?

My other option was to place the =Sum([price]) on the parent form, but that got messy with Reports![rptSheet].[rptSheetSub]!Report.[Price]
It didn't like it, nor did the sum function.

 

[vbaInet]

I need a totals box to appear after the 25th row, but it will only show at the bottom of the list, regardless of the number of rows.

I have a =sum([Price]) control box in the report footer, is there a way to make the report footer go to the bottom of the pre-defined height?

Those two sentences got me confused. Does the report currently print a fixed number of rows when previewed? And will the query or table for the report always return exactly 25 records at all times?