I know that the function control can't be placed on the page footer section. Just wondering if there's a way around this restriction so I can get the total for the page.

e.g. A long list of values, no grouping, and for every page the total for that page only. At the end of the report would be the grand total = sum of all OR sum of page totals.

I hope it's possible. Thanks for your time.