Problem with left outer join with Crystal Report XI R2 using an universe

[Former Member]

A Crystal Reports XI R2 report using an universe links two tables, one being an left outer join, do not returns data correctly. It return data like an inner join. The SQL statement generated is incorrect and multiple Select statements using External Join are being seen within the SQL statement instead of a single SQL.

[Former Member]

is the datasource a stored procedure?

[Former Member]

Our report is connected to an universe. The universe is connected with oracle table.

[Former Member]

Hi Michel,

What type of connection you are using for universe? If you are using ODBC can you test the universe by changing the connection type to native connection?

I think there might be a problem with ODBC drivers

Regards,

Raghavendra

[Former Member]

We do not use a ODBC connection. We use a standard oracle connection.