highline
December 20th, 2005, 11:13 AM
My managers are lazy people. We have a time and attendance report that is generated from our ERP system's data that currently shows each day an employee worked, their clock in and clock out times for a selected date range. They want me to change it so it shows dates that the employee did not work as well. I can't seem to figure this out. The table I am getting the info from has a record for each day that the employee was present and clocked in. It does not store a record for days when the employee was not present.
So basically the report currently looks like this:
Joe
12/12/05 9am to 4pm
12/13/05 9am to 3pm
12/15/05 9am to 4pm
Notice that it doesn't show a blank for the 14th, which was when Joe was absent. Basically they would like a line there that would show 12/14/05 and then blanks for the time in and time out fields.
Any ideas?? I've been pulling my hair out trying to get this there, but I can't seem to make it show all of the days in the range regardless of it that employee was present for that day.
So basically the report currently looks like this:
Joe
12/12/05 9am to 4pm
12/13/05 9am to 3pm
12/15/05 9am to 4pm
Notice that it doesn't show a blank for the 14th, which was when Joe was absent. Basically they would like a line there that would show 12/14/05 and then blanks for the time in and time out fields.
Any ideas?? I've been pulling my hair out trying to get this there, but I can't seem to make it show all of the days in the range regardless of it that employee was present for that day.