> >
> > Thanking for reply,
> >
> > but I am sorry that I have not explain correctly. What I am doing that I am developing a payroll Package for my company and I have already done the master entry and monthly transaction entry module and both are working nice. Now i am confused that how to process that data and generate salary slips from it.
> > Please guide me. and give few example code if possible.
> >
> > Thanking you,
> > Sunil Pandey
>
> Sunil,
>
> Without knowing how you designed your tables, it would be a bit difficult to tell you how to proceed. The salary slips however, are basically a report. Treat them the same as you would any other report. Use a SELECT command to gather the data into a single "flat file" non-normalized cursor and then create the report over that cursor. Something like this:
>
>
> SELECT HourlyPayrollTable.*, Employee.EmpName, Employee.Address, ...
> FROM HourlyPayrollTable ;
> INNER JOIN Employee ON Employee.RecordID = MonthlyPayrollTable.EmployeeID ;
> WHERE HourlyPayrollTable.DateField >= ldPayrollPeriodStartDate AND ;
> HourlyPayrollTable.DateField <= ldPayrollPeriodEndDate AND ;
> llAnyOtherConditionsYouNeed ;
> ORDER BY HourlyPayrollTable.EmployeeID ;
> INTO CURSOR PayrollSlipsCursor
> REPORT FORM MyPaySlipsReport TO PRINTER PROMPT
> USE IN SELECT([PayrollSlipsCursor])
>
>
>
> Ken
> You shall know the truth - and the truth shall set you free. (John 8:33)
Thanks Mr.Ken
But I am sorry your Suggestion is out of range of our payroll Module and I try to understood but Can't understood.
so I request you to plese give the comlete Example.(If this is possible)
Thanking you.
Sunil