Emmitt,
Me either... here are the actual variables from the list variables.
8 : CURRENCY : D : PCRealSum = (.PCRealSum + .PcReal)
9 : CURRENCY : D : PCRealSum1 = (.PCRealSum1 + .PcReal)
Both of these should increment correctly per each detail line. They do.
At break, I clear PCReal.
41 : CURRENCY : F0 : PCRealSumt = (.PCRealSumt + .PcRealsum)
At the footer line, this should be the total , it is...
At the End of the report every number is correct. UNLESS, the detail
section went so far down the page as to need to put the footer on the
next page. Then both are off by exactly double the amount of that
whole section.
Again, if I clear the PCReaSumt at page break, the end report total
is right,(I have another accumulator for the total of those totals)
but the footer ends up null,
and the PCRealSum1 is off by the amount of the detail section that
was one page long.
Have I found a bug in version 7.5, and is this already addressed and
fixed in 7.6?
At 02:51 PM 6/11/2008, you wrote:
What I cannot figure is how your F0 is factoring into a variable
that is calculated at the Detail band. Something is amiss in there somewhere.
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 2:45 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: FW: [RBASE-L] - Reports -
Footercomputingtwice at page end
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]>
<mailto:[EMAIL PROTECTED]>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]>
<mailto:[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
Dan Champion
Service Department Manager
Vredevoogd Heating & Cooling
Grandville, MI. 49418
616-534-8271 x 14
