I am developing an accounting application in VFP5 (re-writing from 2.6 where every report I produced I coded by hand, the long way) and I am having trouble figuring out how to show opening balances on a single line for each account (total of all transactions before the chosen period). Is this something I have to collapse into a single detail line in a prepare-the-data routine before I invoke the report or is there a way in the report itself to collapse several but not all detail lines.

Any help, even a general direction in which to go, would be greatly appreciated.

Reg