you need another formula to set the balance value to 0 and place that in the group header
or
You can also create one formula field called RowBalance (or whatever) as
{Command.Debit}-{Command.Credit}
then use a crystal running total as
in Field explorer right click on Running Total and select new
name = GroupBalance (or whatever)
field to summarize = @RowBalance
type = sum
evaluate for = each row
reset = on change of group (select desired group here)
Edited by DBlank - 14 Apr 2015 at 2:20am
IP Logged
