CR 9

The problem is if an employee is Paid, their Hours Paid appear in the TABLE.Non_Vac_Hrs
BUT if they didn't report any hours in the LABOR_TICKET table for the week in which they were paid, they are excluded from the report.

I need a way to make the employee appear in the Main report even though there are no details in LABOR_TICKET.HOURS_WORKED /  LABOR_TICKET.TRANSACTION_DATE  for them.

MAIN REPORT:
(Grouped by Employee & Date weekly)

GroupName1 LABOR_TICKET.EMPLOYEE_ID (linked to TABLE.Mfg_ID)
GroupName2 LABOR_TICKET.TRANSACTION_DATE}, "weekly"

LABOR_TICKET.TRANSACTION_DATE are daily
TABLE.for_Wk_Ending are Saturday only

Details are LABOR_TICKET.HOURS_WORKED  (there are anywhere from 1 line to 50 lines per single day per employee)


since the labor is reported daily, I have grouped it into weeks. The group name is equal to Sunday's date so I created a formula to determine the last day, Saturday, of that Group.
@WeekEndingDT = CDateTime (GroupName ({LABOR_TICKET.TRANSACTION_DATE}, "weekly")) +6



I have a Subreport that brings in the hours paid for the week ending "XXX" which is a Saturday date.

TABLE.Non_Vac_Hrs  is hours paid
TABLE.for_Wk_Ending is linked to @WeekEndingDT

I'm confused by your reply.

It doesn't matter whether my employees are active or not.  Actually, if they were active during the reporting Date Range and inactive at the time of report generation, that would omit them from the report.

The goal is trying to find the employees who are getting paid for the week and failing to post any time on any day during that week to a job in house.

As soon as I put the labor times posted into the details those employees who fail to report their labor are immediately dropped from the Crystal Report.

Also, the "month" has nothing to do with the report.