Display Unmatched Record

[rekhatr10]

Hi everyone,

I have to write a reports where I have to display the account number if it does not have any matching record in the doc table.
eg.
appt Doc
1234 1234
04/21 04/21
23444 23444
04/21 03/21

so 23444 does not have a mathcing record in doc for the date 04/21. My record criteria would be the account & the date. Please suggest how I could I could diplay on the report 23444 without getting the match of 23444 03/21.

Thank you very much
Rekha

 

[Madawc]

In Crystal 8.5, you should be able to do a left-outer join from appt to Doc, using both the account number and the date.

Use a suppression formula, something like

not isnull({Doc.Acno})

This should leave you with just the cases that lack a match.

Madawc Williams
East Anglia, Great Britain