asm
Jul 6th, 2007, 02:31 AM
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
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