I have a table in SQL which has this column called account.
i have 5 accounts say A,B,C,D and E. Suppose E is lending $1000(calculated using some logic in SQL) to all 4 others so i want to display 1000 in all 4 ie
A 1000
B 1000
C 1000
D 1000

and E as
E -4000

and grand total as 0(1000+1000+1000+1000-4000).
How to do this in Crystal Reports.
I hope i making sense here ...