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]> 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] 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] 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
