Report

[naseeb]

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

[ralph]

I would create a dynamic recordset formatted the way you want it to appear in the report. It can then be filtered to produce a subset per employee (I'm assuming you want a separate report per employee). Then base the reports on the subsets at run time. The dynamic recordset would be initially populated from the table recordset in code.

The other option is to format your own report with the printer object.