Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Address contact not showing Post Reply Post New Topic
<< Prev Page  of 2
Author Message
mgreen
Newbie
Newbie


Joined: 25 Oct 2010
Online Status: Offline
Posts: 7
Quote mgreen Replybullet Posted: 25 Oct 2010 at 9:00am
Ok I see now, yes i have multiple tables, so once I have the phone table expanded in the tree it gives me these three things in the tree : IDKEY, Phone_Number and LINK.  What do I click to change the join?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 25 Oct 2010 at 9:06am
go to Database Menu at teh top of Crystal
select DB Expert
click on the LINKS tab
You will see your tables and lines drawn beteen them.
THis is the diagram of how your tables are joined (and on what fields)
double click on the line joining your PHONE and CONTACTS tables
A box opens
on the lef tis  ajoin type
at the top of the link options it describes the join
if CONTACTS is listed first use a left outer join
if PHONES is listed first use a RIGHT outer join
Yo can also "enforce" in here but it is redundant to enforcing when you use the fields in the report itself.
Link type should remain as "="
Go back into your report and test it out.
If you are still missing data reverse the join type ...if you picked LEFT swithc to right, etc.
 
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 25 Oct 2010 at 9:07am
if you have more than these 2 tables you may need to change your other joins as well.
IP IP Logged
mgreen
Newbie
Newbie


Joined: 25 Oct 2010
Online Status: Offline
Posts: 7
Quote mgreen Replybullet Posted: 26 Oct 2010 at 4:50am

That was it!!! I changed them to a left outer join and the rest of my contacts showed up!

 
Thank you for your help!!!
IP IP Logged
<< Prev Page  of 2
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.