Hi,

I have two tables

salded :- store the all deduction

emp head amount
A01 LOAN 50.00
A02 PF 75.00

salern :- store the all earning
emp head amount
A01 BS 500.00
A01 HRA 50.00
A02 BS 400.00
A02 HRA 50.00


When i prepare the report in crystal report it will show the
report like this
Emp. Name :- A01

Earning Head Amount Deduction head Amount
------------------------- ------------------------
BS 500.00 LOAN 50.00
HRA 50.00 LOAN 50.00
---------------------------------------------------------
TOTAL : 550.00 100.00
---------------------------------------------------------
NET SALARY : 450.00
-------------------------



Report would be like this:-
---------------------------

Emp. Name :- A01

Earning Head Amount Deduction head Amount
------------------------- ------------------------
BS 500.00 LOAN 50.00
HRA 50.00
---------------------------------------------------------
TOTAL : 550.00 50.00
---------------------------------------------------------
NET SALARY : 500.00
-------------------------

Can anybody guide how to achive the result.


Thanks