>> 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.
This _should_ work (I have reports that use this old technique) so there may have been something wrong with the expressions. I've noticed, however, that v7 is extremely particular about accepting expressions that involve aggregate functions. > 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. If it works, it sounds like a perfectly reasonable implementation to me (and now you have those calculations available for other reports and other uses). One word of caution -- I've found in many situations when I base a report on a view and print the report with messages on that R:Base is throwing a very large number of spurious I/O errors. Therefore, I usually project my view into a temp table and base the report on that. -- Larry
