Sub-report needed?

[gk17]

I need a report that does the following but don't know where to start with this:

- Look for the first entry for PERPROVADD under Audit column with Status = C.
- Look for Audit = UNCOMPLETE and then Audit = CANCEL AFTER it's passed midnight for the Change Date.

I'm looking for exams that have been uncompleted (Audit = UNCOMPLETE) and cancelled (Audit = CANCEL) any time after midnight when it's already performed (Audit = PERPROVADD).

Need the entire row returned for those 3 criteria (PERPROVADD, UNCOMPLETE & CANCEL).

Wasn't sure if I should use a sub-report to pull this information or everything can be done in the main report.

Any help is greatly appreciated.

Thanks.