Crystal Reports 14.2.5.2618 sending different SQL query than 14.2.3.2132

[Former Member]

I recently purchased a new computer, and I downloaded the trial version of SAP Crystal Reports to that computer, which was version 14.2.5.2618.

I copied from my old computer all my old Crystal Reports, which was running a licensed version of Crystal Reports 14.2.3.2132

On my new computer, the reports won't work in Crystal Reports. They do work, however on the new computer using Logicity. So, I know the ODBC is working fine.

When i compare the SQL Query being sent by my old computer and the new computer, there are differences.

What are my options? Can I download the old build instead of the latest build?

[vitaly_izmaylov · Accepted solution]

I think the cause of the error is the special character (dash) in the Table name: syst-bill.Customers

Crystal Reports does not read it properly if there are no Quotations around the string like: "syst-bill"."Customers"

There is a registry key to resolve it:

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Database\QueryBuilder\NameBuilder]

"BackQuotation"="MYODBC5"

I think you have the registry key on other machine and that is why it works.

[Former Member]

Thanks! It worked.

[Former Member]

I'm querying a MySQL server.

My old computer used MySQL ODBC 5.3 ANSI Driver (32-bit)

On my new computer, I've tried with the same driver, as well as the newer MySQL drivers.

The error Crystal gives is "Failed to retrieve data from the database. Details: 42000:[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.32-78.1] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-bill.Customers Customer1 LEFT OUTER JOIN syst-bill.Accounts Account1 O' at line 1 [Database Vendor Code: 1064 ]

[vitaly_izmaylov]

Crystal Reports generates SQL query based on the driver.

Compare the ODBC driver versions on two machines.

Let us know what is the database and what is the difference in SQL.