Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: getting unmatched records Post Reply Post New Topic
Author Message
regm2
Newbie
Newbie


Joined: 11 Sep 2014
Online Status: Offline
Posts: 2
Quote regm2 Replybullet Topic: getting unmatched records
    Posted: 19 Sep 2014 at 9:34am
Hi, I'm fairly new at Crystal Reports.
I need to pull data from one table (ordhdr) that doesn't exist in another table(ordcvgsvc). ordsys is the primary key. But I'm not sure how to do that.
 
Then from the resulting data I need to link to other tables to get info such as names, addresses etc.
 
Suggestions on accomplishing this?
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 22 Sep 2014 at 2:55pm
file >>new >> standard report>>
connect to your data source >>transfer all table u will use to selected tables>>next
join ordhdr table to ordcvgsvc table with left outer join
also join you dictionary table to
ordhdr

then i
n select expert putt
isnull({ordcvgsvc.any field})

IP IP Logged
regm2
Newbie
Newbie


Joined: 11 Sep 2014
Online Status: Offline
Posts: 2
Quote regm2 Replybullet Posted: 23 Sep 2014 at 1:34am
Thank You, that worked
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.029 seconds.