Full outer join
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14243
Printed Date: 15 Jun 2024 at 4:38pm
Topic: Full outer join
Posted By: bpimental
Subject: Full outer join
Date Posted: 31 Aug 2011 at 2:14pm
I am currently running Crystal 9 through ODBC and need to do a full outer join. The option is greyed out in my link options box (and has been for years  ) making it difficult to pull in non-existing data from tables where the data does not exist for every record. Can anyone tell me if this is an issue with the version that I am using, the connection or tell me how I can 'activate' the full outer linking option so that it can be of use to me..........Please respond with any input that you have in reference to this.....  ------------- Thanks, Bryian |
Replies:
Posted By: DBlank
Date Posted: 01 Sep 2011 at 4:06am
| this might be more to do with your data source type. I could be wrong but I recall reading that certain source types do not support all join types (e.g. excel files). |
Posted By: bpimental
Date Posted: 01 Sep 2011 at 5:20am
|
The data sources types I am using are AS400-iSeries and Unix.....any additional input appreciated ------------- Thanks, Bryian |
Posted By: DBlank
Date Posted: 01 Sep 2011 at 5:24am
| i don't use those or your version but what I would do next is hook into some sql data source and see if your full outer join is enabled. If you don't have sql hook into the ms access db and see if it lets you do it. I know sql will allow for the full outer join and I am pretty sure access does. this at least will let you know your version supports full outer joins. |
Posted By: bpimental
Date Posted: 01 Sep 2011 at 5:28am
|
I'll give it a shot! Thanks for the input. ------------- Thanks, Bryian |