Dan, What's your pass set to on the report? I think the default is 2.
Jan -----Original Message----- From: Dan <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 11 Jun 2008 12:05:07 -0400 Subject: [RBASE-L] - Re: Reports - Footer computing twice at pageend Thanks Bill, Right DBCalc isn't going to cut it. the report works perfectly for every technician until one of the breaks is over a page long. When the footer gets printed on page two, then the total of vpcmaaccsumt is double the value it should be. It is as though it is calculated at the bottom of the page, but than can't fit, so it recalculates (which would add that amount again to it) and prints it on the next page. I think clearing the vpcmaaccsumt on the PAGE BREAK is going to be the answer, just would not have thought it would calculate twice. At 11:25 AM 6/11/2008, you wrote: Dan DBCalc cannot be used on variables. Possiblities; 1. Look at which variables get cleared after each break, chances are your not clearing variables on the break. For the break look at Reset Variables. You may have to reset the variable vpcmaaccsum. Also try this; set v vpcmaaccsum=sum of vpcmaacc set v vpcmaaccsumt=sum of vpcmaacc clear the variable vpcmaaccsum on the break 2. Try checking Keep Break Together for the Report Break Field. Hope this helps. Bill Eyring -----Original Message----- From: [email protected] [ mailto:[EMAIL PROTECTED] On Behalf Of Albert Berry Sent: Wednesday, June 11, 2008 10:55 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Reports - Footer computing twice at page end Use a DB calc rather than the old style summing variables. Dan wrote: > > >> 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
