>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
Perhaps you can set your report up in such a way that you can issue the SUMMARY clause of Report Form command so that only the fields or variables contained in group footers gets printed. I have a few reports that I've setup to always run with the SUMMARY clause in order to provide mostly subtotals, then anything that typically would be shown in the detail band I move into a group footer and use PRINT WHEN conditions to make it work the way I need too. HTH
Roxanne M. Seibert
Independent Consultant, VFP MCP
Code Monkey Like Fritos