[RBASE-L] - Re: Reports - Footer computing twice at pageend

[Dan]

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: rbase-l@rbase.com [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