Recurring schedules & reporting (crystal reports)
Posted: Sun Sep 03, 2017 5:02 am
Hi all, greetings from South America.
I have recently installed and have been playing around with Timetrex for my company. So far i think its a really great software package and addresses the immediate needs of my company.
Let me first briefly describe my scenario.
I have been using Crystal Reports to do some custom reporting. Example, i'm able to run a report which displays Lateness, time-off, reported sick, etc per employee and per department. It took some digging around and manually linking tables in Crystal, but i managed to have this working.
My concern is this: I need to run this report at the end of every month. However, i noticed in the "AddRecurringScheduleShift.php" that it clears out schedules older than 1 week. The problem is ...... in my Lateness report, one of the criteria it searches for is an "exception_policy.type_id = S4" (which is triggered when an employee is punched in after his/her scheduled start time. If the recurring schedule is cleared out after 1 week and i run my lateness report at the end of the month, will the "S4" exception be also cleared since the schedule is deleted?
Would i still be able to report on past schedules? If not, is there a way to change the schedule clearing behavior?
I have recently installed and have been playing around with Timetrex for my company. So far i think its a really great software package and addresses the immediate needs of my company.
Let me first briefly describe my scenario.
I have been using Crystal Reports to do some custom reporting. Example, i'm able to run a report which displays Lateness, time-off, reported sick, etc per employee and per department. It took some digging around and manually linking tables in Crystal, but i managed to have this working.
My concern is this: I need to run this report at the end of every month. However, i noticed in the "AddRecurringScheduleShift.php" that it clears out schedules older than 1 week. The problem is ...... in my Lateness report, one of the criteria it searches for is an "exception_policy.type_id = S4" (which is triggered when an employee is punched in after his/her scheduled start time. If the recurring schedule is cleared out after 1 week and i run my lateness report at the end of the month, will the "S4" exception be also cleared since the schedule is deleted?
Would i still be able to report on past schedules? If not, is there a way to change the schedule clearing behavior?