Print Page | Close Window

Non-Match Linked Files

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9098
Printed Date: 06 May 2024 at 10:26pm


Topic: Non-Match Linked Files
Posted By: rskoncepts
Subject: Non-Match Linked Files
Date Posted: 11 Feb 2010 at 12:55pm
I'm linking 2 files and want only records that have no match with my second file. Have played with Link Options with no success. Any help would be appreciated.


Replies:
Posted By: kevlray
Date Posted: 11 Feb 2010 at 1:31pm

I can't think of a way of doing that in Crystal.  I have written a VBA program to do it (it wasn't pretty).  The problem with the links in CR is that if you do a '!=', then any record that does not match the current one it is looking at will be returned. 

My VBA code also required that the records be sorted so that I could spot 'missing' records.
 
Lots of luck.

Posted By: rskoncepts
Date Posted: 11 Feb 2010 at 1:53pm
Thanks kevlray. I'm coming to the same conclusion as you. I appreciate your reply.


Print Page | Close Window