Dan, Suggest you report this as a error to the RDCC.
Jim --- Dan <[EMAIL PROTECTED]> wrote: > 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 > Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293
