Report for missing data

[cindyrella]

I'm a new user of Crystal Reports 5. I need to write a report to validate data in File1 from File2.

Scenario:
File1 has vendor codes. File2 is the vendor master. I want a report of File1 records where the vendor code is not found in File2. What I get is just the opposite (I only get records where the vendor code in File1 is found in File2). I'm using ODBC and have manually linked the vendor code fields in the 2 files. I have tried ISNULL and =NULL and ="". Formatting is not especially important since report will probably only be used to correct the data.

Any help would be greatly appreciated. I apologize in advance if this is a silly question.

Thanks.

 

[GJParker]

You will need to make your join type a LEFT OUTER JOIN.

HTH

Gary Parker
Systems Support Analyst
Manchester, England

 

[cindyrella]

Gary,
Thanks so much. It's all so easy when you know what you're doing!