Crystal Reports Outer Join

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Outer Join

Author	Message
Aarav Newbie Joined: 03 Aug 2010 Online Status: Offline Posts: 12	Topic: Outer Join Posted: 18 Aug 2010 at 8:22am
	Hi, I have two tables name DMS and Jan. DMS table holds all SSN while Jan table holds SSN which submitted in JAN. The common key betweent two table is SSN. I need to create a report where the data pulls all DMS SSN which does not match with JAN table. Please Help. Thanks, Aarav.
	IP Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	Posted: 18 Aug 2010 at 11:32am
	It has been a while since I have done this, but I think if you do an inner join and a != link type it might work. Hopefully someone else has done it more recently than me.
	IP Logged

sukhveer Newbie Joined: 18 Aug 2010 Online Status: Offline Posts: 22	Posted: 18 Aug 2010 at 9:08pm
	you can create a left outer join between DMS and Jan tables. type "isnull(Jan.SSN)" in your record selection formula. then, display records from DMS table on your report. You should be good!
	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.027 seconds.