Ever since the advent of GoldMine PE 8.5 the notes fields in the various tables have been changed to ‘image’ type fields in the SQL database.

This gives Crystal Reports some problems. You can’t just place a notes field on your report any more; or rather you can, but you won’t see anything worthwhile.

The image field has to be converted to text before it can be used. To do this, create a new SQL Expression Field in Crystal’s Field Explorer and type the following (this example is for the Cal table, so just change the table name as necessary):

{fn Convert({fn Convert(“CAL”.”NOTES”,sql_varbinary )},sql_varchar )}

Save the expression and insert it into your report as normal.