Good day everyone.

Using CR XI, working on an SQL database.

I am trying to modify an existing report by excluding both the master and all detail records if a condition is met on at least one of the detail records.

The "master" file contains client information and is linked to a "details" file that contains treatment records. Each client can have one or more treatments, so this is a one-to-many relationship. My problem is that if at least one of the detail records has a treatment called "HOM", then I want to supppress that record, along with all other treatment records for that client, AND the master client record. In other words, if a client has a "HOM" treatment, I don't want that client's master record or details record to show on the report. However, if a client does not have any "HOM" treatments, then I want to report on him/her.

Second part (here I'm being greedy) is to figure out a way to count all the records I exclude (but I'll be satisfied with getting the first part figured out).

Thanks in advance for any suggestions or ideas that you can provide.

Regards,
RompinRonny