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

[Bill Eyring]

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
>