How do I link a table as Left Outer Join in a RDD

Yahoo Archive
1
I solved this. It helps it you save your changes before you test it.

Thanks to anyone who spent time in looking at this.

Mike



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
mike.numbers
Sent: Monday, July 01, 2013 3:19 PM
To: vantage@yahoogroups.com
Subject: [Vantage] How do I link a table as Left Outer Join in a RDD





I have added Part to the Job Traveler RDD and linked it to JobAsmbl. I need
this to be Left Outer Join since we occasionally have "parts on the fly". In
the Report Data Maintenance option, on the Relationships tab, with List
screen, there is a column for Join Type. Originally it was blank. I changed
it to "Left Outer". I also changed the link option in the Crystal report to
Left Outer Joint and Not enforced. I must be missing something, because I
don't get any data when I run the report for a "part on the fly". I could
not find any documentation on the Report Data Maintenance option on what
values were valid in the Join Type. Any ideas on what I should try next?
9.04.507a





[Non-text portions of this message have been removed]
2
I have added Part to the Job Traveler RDD and linked it to JobAsmbl. I need this to be Left Outer Join since we occasionally have "parts on the fly". In the Report Data Maintenance option, on the Relationships tab, with List screen, there is a column for Join Type. Originally it was blank. I changed it to "Left Outer". I also changed the link option in the Crystal report to Left Outer Joint and Not enforced. I must be missing something, because I don't get any data when I run the report for a "part on the fly". I could not find any documentation on the Report Data Maintenance option on what values were valid in the Join Type. Any ideas on what I should try next?
9.04.507a
3
Make sure when you link the tables in Crystal that you link from the JobAsml
table to the part table.



The arrow should be pointing to the part table.



The direction is important.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
mike.numbers
Sent: Monday, July 01, 2013 12:19 PM
To: vantage@yahoogroups.com
Subject: [Vantage] How do I link a table as Left Outer Join in a RDD





I have added Part to the Job Traveler RDD and linked it to JobAsmbl. I need
this to be Left Outer Join since we occasionally have "parts on the fly". In
the Report Data Maintenance option, on the Relationships tab, with List
screen, there is a column for Join Type. Originally it was blank. I changed
it to "Left Outer". I also changed the link option in the Crystal report to
Left Outer Joint and Not enforced. I must be missing something, because I
don't get any data when I run the report for a "part on the fly". I could
not find any documentation on the Report Data Maintenance option on what
values were valid in the Join Type. Any ideas on what I should try next?
9.04.507a





[Non-text portions of this message have been removed]