HI
Every one Its Naseeb

I have a table
History (Emp_id, Year, Month, All/Ded, Amount, Type)
NOw in this table i have Record for each employee for each Allowance and each Deduction the entery that i do in the table is some thing like this

Emp_id Year Month All/Ded Amount Type
1 2001 Nov House_r 1000 Allowance
1 2001 Nov Gp_Fund 1000 Deduction
1 2001 Nov Income_tX 500 Deduction
2 2001 Nov House_r 2500 Allowance
2 2001 Nov Gp_fund 2000 Deduction

Now i want to make a payslip for each employee
in data report i want Deduction in one column and the Allowance in the other column How will i do that