Report By Abscent Matched record

[MickeD]

We need to create a report which shows only records from master table that NOT HAVE A MATCHED RECORD in the secondary (child) table.

 

[LindaC]

If you use a left outer join between you 2 tables it will print every record where there is a match and every record from the main table which has no match from the child table.&nbsp;&nbsp;You can then supress the records which have a match.<br>The SQL joins are explained in the online help in Crystal. <p>LindaC<br><a href=mailto:lcastner@co.orange.ny.us>lcastner@co.orange.ny.us</a><br><a href= > </a><br>

 

[MickeD]

Thank you LindaC for advise.<br>But this solution is not exactly solve our problem.<br>We are using Dbase (.dbf) tables and can't use SQL on it.<br>Is there another way (using formulae of CR or somthing like this)?

 

[LindaC]

In menu Report¦Edit Selection Formula¦Report will bring up 'Record Selection Formula Editor'.&nbsp;&nbsp;How about:<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Mast-key &lt;&gt; child-key<br> <p>LindaC<br><a href=mailto:lcastner@co.orange.ny.us>lcastner@co.orange.ny.us</a><br><a href= > </a><br>