Active TopicsMemberlistSearchHelpRegisterLogin

Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: Full outer join Post Reply Post New Topic
Author Message
bpimental
Newbie
Newbie
Avatar

Joined: 31 Aug 2011
Location: United States
Online Status: Offline
Posts: 5
Quote bpimental Replybullet Topic: Full outer join
    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 Cry) 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..... Smile
Thanks,
Bryian
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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).
IP IP Logged
bpimental
Newbie
Newbie
Avatar

Joined: 31 Aug 2011
Location: United States
Online Status: Offline
Posts: 5
Quote bpimental Replybullet 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
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.
IP IP Logged
bpimental
Newbie
Newbie
Avatar

Joined: 31 Aug 2011
Location: United States
Online Status: Offline
Posts: 5
Quote bpimental Replybullet Posted: 01 Sep 2011 at 5:28am
I'll give it a shot!  Thanks for the input.
Thanks,
Bryian
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.018 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.