Totals...?

[vbjohn]

On My Page Footer I have a field that says PAGE TOTAL and then on the Report Footer I have a field that says GRAND TOTAL.

Every time that I run the report it gives the Grand Total first instead of the Page Total. How can I switch it around?

John-

 

[The_Doc_Man]

You could try to force the report total to a page by itself by forcing a page break before the report footer section.

You would still have to ignore the page footer. Or perhaps put an "OnFormat" routine that tests whether there is no data on the page.

One sneaky way that this MIGHT (stress MIGHT) work is in the report class module, define a variable in the general definitions section, say

Dim boDtlOnPage as Boolean

Then, in the Page Header section, add OnFormat code that sets boDtlOnPage = False. This would work even if there is nothing in the page header.

In the Detail section, add OnFormat code that sets boDtlOnPage = True

In the Page Footer section, suppress the totals data for any footer where boDtlOnPage is still false.

 

[vbjohn]

I tried forcing a page break but it still does not look good at all...
and the MIGHT WORK didn't but that is expected.




John-

 

[simongallop]

As an UNTRIED idea how about either:

Having the Grand Total in the page footer and set it with an If statement saying If page number = final page then show otherwise hide

Or have a copy of the page total just above the Grand Total in the report footer and in this case say If final page then =PageTotal in Page footer AND also use an If statment on the page footer saying if final page then hide otherwise show.

If you need help then shout

HTH

 

[vbjohn]

Hmm

First.. How would I know how many pages are in the report?

Second.. I would not know the totals unless I program it in everytime that they run the report.


John-