Hi,
I can't seem to find this problem in the archives. Any ideas:
I have a form which the user inputs a date range into. The problem I have is if the report (behind the form) is run over say a 6 month period the report will take up more than one page. If you then hit the arrow which takes you to the last page, the totals are only calculated for the pages you have looked at and not all the pages in the report. If you scrolled through each page in turn the totals are fine. There is no page footer on the report so it's not like the calculations are being done per page. All the maths is done in the group footer.
Cheers
I can't seem to find this problem in the archives. Any ideas:
I have a form which the user inputs a date range into. The problem I have is if the report (behind the form) is run over say a 6 month period the report will take up more than one page. If you then hit the arrow which takes you to the last page, the totals are only calculated for the pages you have looked at and not all the pages in the report. If you scrolled through each page in turn the totals are fine. There is no page footer on the report so it's not like the calculations are being done per page. All the maths is done in the group footer.
Cheers