MySQL Bugs: #24372: Crystal Reports XI crashing when report has an image field

Bug #24372	Crystal Reports XI crashing when report has an image field
Submitted:	16 Nov 2006 19:30	Modified:	14 Jun 2007 23:14
Reporter:	Erica Moss	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	3.51	OS:	Windows (XP sp2)
Assigned to:	Mark Matthews	CPU Architecture:	Any

Description:
There is a report amongst the Crystal Reports XI sample report collection called Product Catalog.rpt, which has an image field.  When the sample data is exported from the original mdb format to MySQL, and then this report is readdressed to the MyODBC version of the data, crashes will ensue.

It is possible to open the report and to curser through the records.  However if you select Report|Check Dependencies, or if you try to export the report from File|Export, then the application crashes.

If you delete this field from the record then the above operations work fine.

How to repeat:
To reproduce these problems you'll need to use the tests from the SVN repo:
svn+ssh://user@bk-internal.mysql.com/connectors-svnroot/odbc-testing/crystal-tests

Follow instructions in the README to get the data installed.  The report in question is the MyODBC version, /mysql/ODBCProduct Catalog.rpt

Open it, type CTRL+r to fetch the data 
Select Report|Check Dependencies, or File|Export

Note this will not happen with the original version of the report found in /access/Product Catalog.rpt which still uses the data found in the sample xtreme.mdb database.

Open, Refresh, Print report in question

Attachment: odbcproduct catalog.pdf (application/save, text), 107.08 KiB.

Accompanying logs

Virus scan engine found a threat. This file might be infected. Attachment: Bug24372-logs.exe (application/x-msdos-program, text), 142.71 KiB.

Tested this against 3.51.15.  Problem seems to be resolved. Image fields are displaying, and the report can be exported and the dependencies checked.