SAP Knowledge Base Article - Public

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.

Reproducing the Issue

  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