Sybase Philippines

Sir/Madam:

Can anyone please help me? I need to design an INCOME STATEMENT and BALANCE SHEET report using datawindow of PB. How do I go about it?

For example:

Income
income account 1 amount 1 amount 1
income account 2 amount 2
income account 3 amount 3

Less: Operating Expenses
expense account 1 amount 1
expense account 2 amount 2
expense account 3 amount 3

amount

NET Income amount

Thanks in advance.

try to make a group datawindow, select your income table and expense table. Use your account number as group head. Insert a computed field in your detail band with a formula subtracting expense field (EA) from income field (IA). Then sum up IA and EA.

[account 1]

[ income amount 1(IA)]----------[expense amount 1(EA)]--------[cmptd_fld1 (IA - EA)]


[SUM(IA for all)]-----------------[SUM(EA for all)]------------------[SUM(cmptd_fld1 for all)]

[ cmptd_fld2(sum_ia - sum_ea)]


Your cmptd_fld1 and cmptd_fld2 should be balance if entries are correct.