[RBASE-L] - Re: FW: [RBASE-L] - Reports - Footer computingtwice at page end

[Dan]

Emitt,
  Yes, I had tried that,
CURRENCY  : D : vpcmaaccsumt = (.vpcmaaccsumt + .vpcmaacc)
 and it behaves the same way. I think it is Something about the 
footer being on the second page makes it compute twice.

However clearing the variables at page break seems to have fixed it.

Now, I have the Keep break together (ON)


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: 'rbase-l@rbase.com'
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: rbase-l@rbase.com [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