HI Emmitt,
Yes, I saw that... I actually did that same exact scenario... and
in this one case for this report (A report that works very well
except in this instance) that variable also comes up with the wrong answer.
It is as though, when the detail from one section of the report
ends exactly when the page is full, and the footer is placed on the
next page, it recalculates the whole break section so both the
accumulater variables (the one that is the accumulator for the
accumulator, and the one that you suggest which is the accumulator
for the first variable end up being more than they should be, by
exactly as much as that sections total would be.
Again, this only happens when the report has just enough detail lines
for that particular break to make it need to push the footer to the
next page. Otherwise everything adds up correctly.
Starting to pull my hair out... :)
At 02:08 PM 6/11/2008, you wrote:
Dan,
Note that my example has vpcmaaccsumt being calculated in the DETAIL
band, not F0.
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 1:41 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: FW: [RBASE-L] - Reports - Footer
computingtwice at page end
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: '[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
Dan Champion
Service Department Manager
Vredevoogd Heating & Cooling
Grandville, MI. 49418
616-534-8271 x 14
