SAP Knowledge Base Article - Public

1212811 - Timberline ODBC driver prevents multiple outer joins in Crystal Reports 8

Symptom

In Crystal Reports 8 using the Timberline ODBC driver, a report with one outer join is created successfully.

Howerver, if more than one outer join is used to link tables from the database, the second outer join will be converted to an inner join. The data will not be displayed properly.

Cause

This behavior occurs because the Timberline ODBC driver supports ANSI 89 SQL syntax. Multiple left outer joins are not supported in Crystal Reports unless the ODBC driver is ANSI 92 compliant.

Resolution

To workaround this issue

  1. Create a main report with two tables that are linked with a left outer join using {oj} syntax.
  2. Create linked sub-report(s) for each additional table.
    By default, Crystal Reports links sub-reports to the main report using a left outer join.

This workaround only results in two levels of left outer joins, one for the main report and one for the sub-report(s).

Keywords

Timberline ODBC outerjoin innerjoin outjoin.reg Seagate Crystal Reports ODBC Connectivity outjoin.reg Timberline ODBC Driver , c2008059 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

SAP Crystal Reports 8.0