> 1. Include a SUM OF VarName expression in the expression list, and make sure to > clear it at the appropriate break level.
I did this at first blush but got nada.. so I used the view. > 2. Do the calculation "live" in each footer with an expression like SUM > (ColName) IN TableName WHERE KeyCol = .vKeyValue. Make sure you set the proper > band for calculation of this value to avoid lots of overhead. I didn't try that.. Frankly, I have just started rehabing my old stuff that I run my internal business on and some of the stuff dates to around '88, so in 7.x it is a little creaky. What made me go to the view immediately, is I seemed to recall that the dbCalc was created out of necessity because some of the older stuff (like mine) was breaking in 7.x. I'll go back and have a look, but the view is working perfectly and the Report is pretty lean this way. > -- > Larry >
