I would group on the type field and put a summary field in the group footer. I would also hide the Details section so that you don't see all the individual records. This will get you the top part of the report that you need.
For the last part (3+1-4), you need to do a manual running total. It looks at the group field to determine whether it should be added to the running total or subtracted from it. Something like this:
Global NumberVar GroupTotal;
if {table.acct type} = 1 OR {table.acct type} = 3 then
GroupTotal := GroupTotal + {table.amount}
else
GroupTotal := GroupTotal - {table.amount};
Edited by BrianBischof - 11 Apr 2008 at 10:52am
IP Logged
