Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Crystal Reports 8.5 / XI R2 : Table Links Post Reply Post New Topic
Author Message
Alpicus
Newbie
Newbie


Joined: 24 Sep 2009
Online Status: Offline
Posts: 2
Quote Alpicus Replybullet Topic: Crystal Reports 8.5 / XI R2 : Table Links
    Posted: 24 Sep 2009 at 4:57am
Hi Everyone,

Is someone know the matched items between the 3 options in "CR 8.5 - Visual Linking Expert" and the multiple options in "CRXI R2 - Database Experts - Links" for every link options :

In CR 8.5 : under section "When linking to two files from this file" :
- Look up both at the same time
- Look up all of one, then all of others
- Look up all combinations of the two files

In CRXI R2 :
- Join type : inner join / left outer join / right outer join / full join
- Apply join : do no apply / apply from / apply to / apply in both ways

I need to convert hundreds of reports and don't want to miss the right options.

Thanks for your future replies.

Phil
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 25 Sep 2009 at 5:31pm
What type of database are you connecting to?
 
There really is no direct relationship between the two types of link options.  For the XI join types, you need to look at it based on the fact that you're linking "From" one table "To" another.  In database terms, the "From" table is on the left and the "To" table is on the right.  Based on that, here's the definitions:
 
Inner join - only include the data that matches in both tables based on the field in the link.
 
Left outer join - include all of the records in the left (from) table even if they don't match any records in the right (to) table.
 
Right outer join - include all of the records in the right (to) table even if they don't match any records in the left (from) table.
 
Full join - include all records from both tables.
 
I've been working with XI since shortly after it came out - I've NEVER had to use the Apply join options - I leave them at the default.
 
-Dell
IP IP Logged
Alpicus
Newbie
Newbie


Joined: 24 Sep 2009
Online Status: Offline
Posts: 2
Quote Alpicus Replybullet Posted: 29 Sep 2009 at 1:43am
Hi,
 
In CR8.5, I'm connected to xBase. In CRXI, to SQL Server 2008.
 
Thanks for ur reply.
 
Phil
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.