1351240 - Full Outer Join Greyed Out in Crystal Designer XI R2

In  Crystal report, If we have 2 queries from same universe,  when we link them at in Crystal Report the FULL OUTER JOIN option is greyed out.

1. Create a Crystal Report based off a universe using two queries of the same universe.
2. When we try to join two queries the Full Outer Join is Greyed out.

• The Universe joins are defined in the Universe.
• In CR we only have the SQL query and not enough information to perform a full outer join.
• the ability to use Full Outer Joins even in the universe is driver dependent- some drivers can relay that and some are not outer join capable

In order to get a full outer join functionality in Crystal, it should be defined at the Universe level.  It is not possible in Crystal Designer.

If it is not possible in the designer:

1. Open Designer
2. Import the universe
3. GO  to file parameters
4. On the Parameters Tab change the value for the ANSI92 argument to "yes" then click OK
5. Save the Universe
6. save the universe and export it back

Again this ability is driver dependent. For instance, this will not work with the DB2 I series drivers

Crystal Reports, Universe, Full Outer Join, XI 3, XI 3.1 XI R2, XI 3.x, ANSI92 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

SAP Crystal Reports XI R2