hiii All,

i am a newbie in Crystal report, now i wanna to create a balance sheet report for my accounting software.

the report contain 3 major column for each account, that is Beginning balance, mutation(change) and ending balance. Each column depends on their normal balance.

i have some table, that is account table n transaction table (like a journal)

u can see the simple report, below this text

Account   beginning bal    mutation           ending bal
                Debit | Credit   Debit | Credit    Debit | Credit 
Bank          500        -        100      -           600       -
Tax            100        -           -        50         50         -
income         -         1000    50      100         -         1050


Note:
in Beginnin & ending bal, the value's position depend on the normal balance


Any body have an idea?
or have some experience to create a balance sheet?
or have an example, please reply me.
Thanks.

Regards,
Harry