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