Joins Options Disabled in Crystal

building reports crystal reports
1

Hi,

Right outer join and Full outer join options are disabled in crystal.
My report data is based on data from 2 different databases (Oracle and Db2). I have pulled one table from Oracle and one table from DB2, I need a full outer join between these tables but in the join options full outer join is disabled. I have tried creating sql commands one at Oracle side and One at DB2 side and checked the join options, I see the same issue.

I have noticed that when i pull 2 tables from the same oracle database or same db2 database , all the 4 join options are enabled.

When does crystal disable the right and full outer join? is it based in the database? or crystal does not allow full joins when querying across different databases?

Please help me out.

reachme (BOB member since 2012-02-14)

2

When pulling data from multiple databases OR multiple commands, Crystal does the following:

  1. Pull all of the data from the first database.
  2. Pull all of the data from the second database.
  3. Join/Filter the data in memory (usually with lots of disk swapping!).

It’s because of step 3 that you’re running into issues. Crystal only knows how to do equal and (I believe) left outer joins in memory, so the other options are disabled.

Is there a way to set up something like a dblink in your Oracle database that will pull the DB2 data? If so, you would probably be better off doing that and then creating either a view or a stored procedure that would pull your report data so that you don’t have this issue.

-Dell

hilfy :us: (BOB member since 2007-04-16)