Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Non-Match Linked Files Post Reply Post New Topic
Author Message
rskoncepts
Newbie
Newbie


Joined: 11 Feb 2010
Online Status: Offline
Posts: 2
Quote rskoncepts Replybullet Topic: Non-Match Linked Files
    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.
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet 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.
IP IP Logged
rskoncepts
Newbie
Newbie


Joined: 11 Feb 2010
Online Status: Offline
Posts: 2
Quote rskoncepts Replybullet Posted: 11 Feb 2010 at 1:53pm
Thanks kevlray. I'm coming to the same conclusion as you. I appreciate your reply.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.