When trying to retrieve data from an ODBC connection to a MYSQL database using CR 8.5, the "Show SQL Query" adds a one (1) to the end of each field name. When I link multiple tables and group on a field from one table and place a field from another table in the detail band (or any where) on the report I get an ODBC error referencing incorrect SQL syntax and showing the field in error with a one (1) added to the field name. Since this is an incorrect field name. I assume that`s why the error is generated. This error only occurs when fields from more that one table are added to
the report.
the report.