Jim: It's a pretty powerful tool once you get the procedures down! First, is your control with the compid of Comp_AvgD a regular label control? Make sure it's not a variable or db label. If it's okay, then I suggest you trace thru code and carefully watch your variables to see if they are evaluating okay.
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 > > > >
