You can get the VFP General field to work if you use ODBC or ADO to get at the data. Unfortunately, there is a bug in CR9 that prohibits VFP from using the formatting event interfaces, so you can't use a filename to dynamically change the picture. However, you could do it with a VB COM object.
>I'm trying to insert a custom picture into Crystal Reports 9 (using VFP7).
>
>* I can't get Crystal to recognise General fields from FOX2X files.
>* I can't work out how to get VFP to generate something in Crystal's BLOB format.
>* I've tried the oleObject.FormattedPicture = LoadPicture() as suggested in the Help file, but it doesn't seem to recognise the object that is returned by Fox's LoadPicture.
>
>The method that did work for me with Crystal version 8.5 was to use the AddPictureObject() method and and the object at runtime, but in version 9 the licence does not allow that (without spending $200/user for the report creation licence). I don't want to create a report, I simply want a picture to appear which will alter based on any of a filename specified in a field or variable, or the contents of a general field.
>
>I'd be very grateful for any suggestions - I've searched the web (both Fox and Crystal sites) to no avail.
>
>Many thanks
>Ben Hambidge
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer