> >
> > 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