Business Objects and mySQL?

[txwylde]

I noticed that mySQL and BO has formed a partnership but have not heard anything with regards to whent his product is coming out. Anyone have any tricks getting mySQL to hook up to BO in the interim?
thanks!
Bill

 

[BruceBussell]

MySQL IMPORTANT ODBC Notes I learned while using Crystal 8.5 with MySQL 3.51

1-Users of the Crystal 8.5 Reports must Define a new MySQL 3.51 ODBC System DSN Connection and then you can put in your specific MySQL database setup info.

2-Then when you load Crystal 8.5, BE SURE to go to File\Logon, and Logon to your ODBC DSN connection FIRST. Then Load and Run your reports.

Otherwise, when you try to load and run each Crystal report for the first time on your system, you may get an error message box that says Crystal can't log on to your MySQL database.

-----------------------------

MySQL IMPORTANT JOIN TABLE LINKS Notes!!!:

The initial Crystal SQL generated FROM clause in a report with Linked Tables where two tables such as the EVENTS and EVENT_TYPE are joined, will generate a MySQL syntax error at runtime (ie) See below:
FROM
{ oj `EVENTS` EVENTS1 INNER JOIN `EVENT_TYPE` EVENT_TYPE1 ON
EVENTS1.`EVENT_TYPE` = EVENT_TYPE1.`EVENT_TYPE`}

But to get the report to run, you must go in to Crystal Reports and select Database -- SHOW SQL QUERY, and modify the SQL Query and remove the "oj" and outer brackets {} as follows
(ie):
FROM
`EVENTS` EVENTS1 INNER JOIN `EVENT_TYPE` EVENT_TYPE1 ON
EVENTS1.`EVENT_TYPE` = EVENT_TYPE1.`EVENT_TYPE`


!!! SUMMARY IMPORTANT NOTES: -- Whenever two or more MySQL ODBC Driver 3.51 Tables are joined in a Crystal 8.5 Report, one must currently go to the Database SHOW SQL QUERY section and remove the "oj" and outer brackets {} that are around the JOINS in the FROM clause, to avoid a MySQL syntax error when you try to run the report.

You need to do all your Visual Linking Table Joins first, and then INSERT at least ONE FIELD into the report FROM EACH JOINED TABLE , which will cause Crystal to put the joins in the FROM clause in the SHOW SQL QUERY section. Then go into the Database SHOW SQL QUERY statement, and remove the "oj" and outer brackets {} that are around the FROM clause, to fix the MySQl syntax error.

Then if you later go to Visual Linking and add more joined tables, you will need to go into SHOW SQL QUERY and manually add the new JOIN statements to the FROM section, as Crystal won't try to update this section after it has been manually modified by a user.