I have a report that displays employees (EMPLOYEE) that work at particular school sites (SCHOOL) with the dates and hours worked. What type of formula do I need to eliminate the school record from my report if a certain employee hasn't worked there yet?

 

Would this be an 'IF' / 'THEN' statement?

 

Thanks for your help

Crystal Reports Xl

LABOR.LABORCODE = General Employee Info, labor code
LABTRANS.REFWO = Employee labor code, date, time, refnum
WORKORDER.WONUM = Work order (wonum) to track school labor

 

These are all linked inner join, laborcode to laborcode, refnum to wonum.

 

I can view all of the records. I have these grouped by school which are displayed in the Group Header, and in the Detail row I have the employees. I can retreive and view all of the records. However, I would like to remove a school from the report if a specific employee hasn't charged any time to it.