Crystal Reports: Using right table as a filter to left table data
Posted on 2013-06-21
I have two tables joined in my report. The Left table contains all the data elements (fields) I want to display in my report. The right table contains a list of data (a single field) with values matching some of the entries in left table for the linked field (PATIENT_NAME).
I would like to display all PATIENT_NAME entries NOT found in the right table. essentially using the right table as a list of PATIENT_NAME entries to filter out of the report. If the name exists in the right table I do not want that name displayed on the report.
How can I best accomplish this request?