Karen,
I found the problem. Once again something simple. I also want to try to use the compID of the dbcalc in a breakfooter to calculate an average in that same footer. Below is the code I am using trying to follow what you had sent earlier regarding a report footer dbcalc. I put this in the Before Generate EEP of the break footer. SET VAR vSDays TEXT SET VAR vDorders TEXT GETPROPERTY Comp_CountC VALUE vDOrders GETPROPERTY Comp_SumSdays VALUE vSDays SET VAR vDOrders INTEGER SET VAR vSDays INTEGER SET VAR vAvgShipd = (.vSDays/.vDOrders) PROPERTY Comp_AvgD CAPTION .vAvgShipd RETURN I am only getting an 0 for the var SvgShipd Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, May 05, 2010 9:31 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Using SUM OF in two page report DBCalcs will automatically reset in the band you put them in. It eliminates one of the steps you had to do in the "old" days where you had to specify that the total had to be reset. OTOH: if you wanted a running total in the break footer, then I think you couldn't use a DBCalc unless there's a way of turning off the reset that I don't know about. Karen I have been following this thread with interest. I am interested to know if you can RESET the DBCalc that resides in a breakfooter? I have a compid (Comp_CountC) associated with my dbcalc count(Control#) and want to reset it based on each customer. Would I be better to use the old way of COUNT for break footers. Jim
