printing report if no corresponding data is in a file 1

[kimprogrammer]

Hello
I was wondering if I could get some help understanding the approach I need to create a report.

I have an employee master file and a paycode file that data is entered for every payroll.

I need a report that lets me know which employees have not has data entered for them. So I need records on the employee master that have not records in the paycode file.

I'm not sure how to begin with this and would appreciate the help.

 

[lbass]

Sorry, but the {@inrange} formula should have been:

if isnull({SwipeAccumulativeHours.EmpNum}) or
{SwipeAccumulativeHours.PPDay} < {?PayPeriodStartDate} [red]or[/red]
{SwipeAccumulativeHours.PPDay} > {?PayPeriodStartDate} + 13 then 0 else 1

-LB

 

[kimprogrammer]

Great thank you so much for your time and patience - I have learnt a fair bit more about CR from doing this report.