Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Sunil Pandey
  Where is Sunil Pandey?
 Rajkot
 India
 Sunil Pandey
 To: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 Tags
Subject: RE: Transaction solution
Thread ID: 154184 Message ID: 154862 # Views: 1 # Ratings: 0
Version: Visual FoxPro 3 Category: Foxite: feedback
Date: Thursday, December 20, 2007 6:53:32 AM         
   


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

ENTIRE THREAD

Transaction solution Posted by Sunil Pandey @ 12/13/2007 4:34:32 AM
RE: Transaction solution Posted by Vladimir Zhuravlev @ 12/13/2007 6:56:03 AM
RE: Transaction solution Posted by Sunil Pandey @ 12/18/2007 8:27:03 AM
RE: Transaction solution Posted by Ken Murphy @ 12/18/2007 12:41:14 PM
RE: Transaction solution Posted by Sunil Pandey @ 12/20/2007 6:53:32 AM
RE: Transaction solution Posted by Ken Murphy @ 12/20/2007 1:22:37 PM
RE: Transaction solution Posted by Ken Murphy @ 12/13/2007 1:21:32 PM
RE: Transaction solution Posted by Benny Thomas @ 12/14/2007 1:11:37 PM