Hello.I am working on a report to track absences from one db into my payroll db.
The abscnece db creates a csv file that contains three columns: employee ssn, reason code, days absent.
The first db does not contain any leave balances.
The second db (an informix db via an odbc connection) contains the leave balances.
I created one report that has two grouings: the first is a grouping on the ssn, the second grouping is the reason code. I have summed the days absent and placed the sum in the group footer for second grouping. Every other section is suppressed.
The reason code from the csv file is also the pay code in my payroll db (ex: 400 reason code = sick leave which in my payroll db 400 = sick pay).
In the group 2 footer, I have inserted a formula to subtract the leave balance from the sum of days taken. If the difference is positive I know that the employee has enough days and should not be docked, therefore the reason code/pay code should remain the same.
If the difference is negative, then the employee should be docked for the amount of days the difference is negative. I would need a different reason/pay code (400 should become 600)
I hope this makes sense.
Thanks in advance.
The abscnece db creates a csv file that contains three columns: employee ssn, reason code, days absent.
The first db does not contain any leave balances.
The second db (an informix db via an odbc connection) contains the leave balances.
I created one report that has two grouings: the first is a grouping on the ssn, the second grouping is the reason code. I have summed the days absent and placed the sum in the group footer for second grouping. Every other section is suppressed.
The reason code from the csv file is also the pay code in my payroll db (ex: 400 reason code = sick leave which in my payroll db 400 = sick pay).
In the group 2 footer, I have inserted a formula to subtract the leave balance from the sum of days taken. If the difference is positive I know that the employee has enough days and should not be docked, therefore the reason code/pay code should remain the same.
If the difference is negative, then the employee should be docked for the amount of days the difference is negative. I would need a different reason/pay code (400 should become 600)
I hope this makes sense.
Thanks in advance.