I have attempted to connect the report designer to a MySql database but the "Data Source Configuration Wizard" just exists.
I can get the new connection setup and tested correctly and get the list of Tables and Views. If I pick a table, view, or enter a select statement, the window just closes. In the case of a select statement, I get a "Error while running query, please verify that the syntax of the query is correct".
Should the report designer be able to work with MySql?
Thanks,
John
Hello John,
We have run some tests using a MySQL database and we found that there's an issue related to the way we handle the SQL queries for this DBMS, so maybe that's the problem you are running into. Could you tell us the NetAdvantage Reporting version and MySQL version you're using?The only workaround available right now would be that you consume your data using an object data source. You could create the object model yourself or you may try using Entity Framework to do it.
Regards,
Luis
Hello Luis,
The Infragistics version is 12.1 and the MySql version is 5.5.11.
We were hoping to just use this for a quick solution to do a report from raw data in the database which is only used for reporting (vs Crystal Reports). Since their is no existing object model for the information, I am hesitant to explore the object data source.
Is there any hope for a fix in the near future?
Hi John,
This bug will be fixed in the next SR, planned for early August.
If you need the fix sooner let me know.
Best,
Leo