Unanswered: identify missing records in Crystal 10 report
I am trying to identify employees who have not submitting a timesheet. A timesheet is required each week. I am not sure how to join the tables so the employee who has not submitted a timesheet will have a blank field where there should be a timesheet number.
So, if the controller enters in the current date parameters of the pay period, the list would show that John Smith's timesheet is submitted where Jane Doe's timesheet is missing.