Follow our news:

Follow canonburysvcs on Twitter Follow Canonbury Services on Facebook Follow Canonbury Services' news by RSS Follow Canonbury Services' news by Atom Follow Canonbury Services' news by email


GM Notes fields in Crystal Reports

28/04/2011 – in Crystal

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.