Forums

by Christina >> Wed, 8 Jun 2005 9:44:51 GMT

Has anyone sucessfully got Crystal Reports to generate a report requiring an outer join on a Jade database?

Jade version : 6.0.22
Crystal reports version : 11

by Jade Support >> Thu, 9 Jun 2005 3:17:04 GMT

The JADE ODBC driver does not currently provide support for multiple outer joins. However if you're performing a LEFT or RIGHT OUTER JOIN it should work.

Crystal Reports v10 changed the syntax for their JOIN SQL statements, however hot fixes issued for JADE 6.0.18 and 6.0.19 resolved those issues and they shouldn't exist in 6.0.22. I suppose is possible Crystal Reports have changed the syntax again.

On the Crystal Reports web page is a program called SQLCON32 that's available for download. This program lets you analyze each step of the SQL process. If you're not able to get the outer join working successfully you may like to download the application and use it to analyise the query. You can then send the output to jadesupport@jadeworld.com, I'll have a look at it.

Regards,
Jade Support.

by Christina >> Thu, 9 Jun 2005 9:02:16 GMT

The single outer join does work just fine - sorry I should have been more explicit.

Would you expect the driver to support the case of a single outer join combined with one or more inner joins?