The query Crystal Reports generates looks like the following: SELECT h.BINNUMBER, h.BINCOUNT, l.LOTID, l.DEVICEPASSPERCENT, r.COMPANYID FROM (REPORTHEADER r INNER JOIN LOTINFO l ON r.REPORT_ID=l.REPORT_ID) INNER JOIN HARDWAREBINS h ON r.REPORT_ID=h.REPORT_ID
and here is the error I get from Crystal and SQL Studio 4200:[SAP AG][SQLOD32 DLL][MaxDB]Syntax error or access violation;-5015 POS(86) Missing keyword:SELECT. Any recommendations? Keith Arnold -----Original Message----- From: Keith [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 01, 2005 10:50 AM To: Maxdb Subject: Crystal Reports and MaxDB - sql generation We have several clients that use Crystal Reports 9 to generate reports from their data warehouses. The db versions are a mix of 7.4 and 7.5. When creating a report that joins more than 2 tables the SAPDB ODBC driver return a syntax error. It appears that the ODBC driver does not like the syntax that Crystal Reports uses in its synthesized sql statement. I have tried running in Oracle and ANSI modes but it makes no difference. Any thoughts on how I may get around this problem? Keith Arnold -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
