I am using Crystal Reports 9.0. We are in the process of converting to a mysql database. I am having trouble displaying reports that have a left outer join on the web (we are using RDC not RAS). I have made entries into the registry to solve the left out join issue. I am able to view the reports withing crystal, but when they are called over the web I receive the following error.
-2147189166Failed to open a rowset. Details: 42000:[MySQL][ODBC 3.51 Driver][mysqld-4.0.12-max-nt]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 '((((`applicant` `APPLICANT` INNER JOIN `scholarship` `SCHOLARSH0
Crystal Reports ActiveX Designer
An Error has occured on the server in attempting to access the data source
After doing some testing, I determined if a report has only two tables that are connected with a left outer join the report will display fine. When I add another table and add a field from that table to the report, I received the above error message. It didn't matter if the relationship was an inner join, left outer join, or right outer join. I am also able to paste the sql statement generated in crystal into the mysql control center and it runs fine. I am not certain why I am receiving this error.
-2147189166Failed to open a rowset. Details: 42000:[MySQL][ODBC 3.51 Driver][mysqld-4.0.12-max-nt]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 '((((`applicant` `APPLICANT` INNER JOIN `scholarship` `SCHOLARSH0
Crystal Reports ActiveX Designer
An Error has occured on the server in attempting to access the data source
After doing some testing, I determined if a report has only two tables that are connected with a left outer join the report will display fine. When I add another table and add a field from that table to the report, I received the above error message. It didn't matter if the relationship was an inner join, left outer join, or right outer join. I am also able to paste the sql statement generated in crystal into the mysql control center and it runs fine. I am not certain why I am receiving this error.