Hmm, I thought clearing those on page break was going to be the answer but now the footer has no numbers in on page two (since they were cleared)... arghh..
The total worked though.



At 01:24 PM 6/11/2008, you wrote:
Also, set vpcmaaccsumt to clear at F0.

Emmitt Dove
Manager, DairyPak Business Systems
Evergreen Packaging, Inc.
[EMAIL PROTECTED]
[EMAIL PROTECTED]
(203) 643-8022

From: Emmitt Dove [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2008 1:24 PM
To: '[email protected]'
Subject: RE: [RBASE-L] - Reports - Footer computing twice at page end

Dan,

Change this:

 CURRENCY  : F0 : vpcmaaccsumt = (.vpcmaaccsumt + .vpcmaaccsum)
To this:

 CURRENCY  : D : vpcmaaccsumt = (.vpcmaaccsumt + .vpcmaacc)
Since vpcmaaccsumt is accumulating vpcmaaccsum, which is in turn accumulating vpcmaacc, the result should be as desired.

Emmitt Dove
Manager, DairyPak Business Systems
Evergreen Packaging, Inc.
[EMAIL PROTECTED]
[EMAIL PROTECTED]
(203) 643-8022

From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dan
Sent: Wednesday, June 11, 2008 10:20 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Reports - Footer computing twice at page end



Hi,

  Strange behavior on one of my reports.
I have a variable (vpcmaacc) on a form that displays in the detail section.
I have another variable (vpcmaaccsum)  that = the sum of the varible1

CURRENCY  : D : vpcmaaccsum = (.vpcmaaccsum + .vpcmaacc)

this works fine;
I have a third variable (vpcmaaccsumt) that = the sum of vpcmaaccsum

 CURRENCY  : F0 : vpcmaaccsumt = (.vpcmaaccsumt + .vpcmaaccsum)

This computes in the footer of the one and only break on the form.

This works fine too....
EXCEPT if the page fills and the footer is printed on the next page. Then it adds the sum twice and throws off the report total.

Ideas?

Dan Champion
 Service Department Manager
Vredevoogd Heating & Cooling
    Grandville, MI. 49418
        616-534-8271 x 14


Dan Champion
 Service Department Manager
Vredevoogd Heating & Cooling
    Grandville, MI. 49418
        616-534-8271 x 14
     

Reply via email to