I want to print a payroll register report showing the types of taxes and deductions that were taken out of an employees paycheck. There are 4 basic fields: strTaxCode curTaxAmount strDedCode and curDedAmount. The fields are paired, code and amount (strTaxCode="StateNY" and curTaxAmount=$123.45). If the code in a record is blank then amount should be 0. There can be a different mix of tax codes and deduction codes for each employee. Generally there are 8 tax lines and 0 to 12 ded lines on the check stub for any given employee. My problem is trying to print more than one code per detail line when each code is an individual record and how to accumulate grand totals for each individual code that is used during that payroll run when the type and number of codes can vary. My layout per employee is something like this...
empid name tcod tamt tcod tamt dcod damt dcod damt
tcod tamt tcod tamt dcod damt dcod damt
...(etc until all codes printed)
This basic layout, or one similiar, is so the report will be as short as possible. I dont want to print the same number of lines per employee if they dont need it. The reports are filed so they need to be printed.
Thanks for any help and I hope my description is clear enough. Thanx.
empid name tcod tamt tcod tamt dcod damt dcod damt
tcod tamt tcod tamt dcod damt dcod damt
...(etc until all codes printed)
This basic layout, or one similiar, is so the report will be as short as possible. I dont want to print the same number of lines per employee if they dont need it. The reports are filed so they need to be printed.
Thanks for any help and I hope my description is clear enough. Thanx.