-1
I am using SAP Crystal Reports 2013 (not the viewer), and working on a form with an ODBC (RDO) Data Source Connection, which was set up in the ODBC Data Source Administrator application using MySQL ODBC 5.1 Driver.
The software incorrectly generates the SQL query that it uses to refresh/pull the data without quotes (All ODBC (RDO) connections are supposed to automatically generate this to prevent this exact type of issue). This is an issue because the data source has column names that contain characters that require them to be surrounded in quotes. This version and later of the Crystal Reports software will not allow you to directly edit the SQL query.
Updating the column names in the table I am pulling from is not an option, and I would rather not have to recreate the entire form using a query in the "add command" feature of the Database Expert. Is there any fix?
Feel free to suggest clarifications instead of downvoting and moving on. This issue took forever to solve and I want anyone in this situation to be able to just look it up instead of waiting a few weeks for IT or stress out for a few hours like I did. – Kyle S – 2019-01-18T17:52:49.490