Hi Willianto,

Sadly there is no way to report pictures from general fields. You may find a workarround in Randy's idea. There is however another way which is complex to manage.

In the format event (CR 7.0 or above) of the report (can be captured with VFPcom.dll in VFP6 or by VFP7 natively) of either the RDC or CRPE automation controller you can change the disk location of the picture trhough the formattedpicture property (See developer.hlp). Though according the docs, this must be possible I never tried it myself.

In CR 8.5 there is another way, by reporting out of a database field (disk location, thus no embedded pictures). I agree this is a major PITA in CR. Pictures embedded in Access or SQL server table are supported, why FOX2X general fields are not is beyond me.

Walter,


>Hello everybody,
>
>Anybody know how to handle general field in Crystal Report? I am in a
>situation where I need to create a report with picture in it. Yes, i
>know i can use Picture/Ole Object from VFP's native report writer. But
>for some reason (which i won't mention here, otherwise this post will be
>too long) i have to use Crystal Report. I tried to insert
>(drag-and-drop) the general field in the CR Designer, but cr treated it
>as string (with zero length !?).
>
>Because I have try this way with no luck, i had an idea; What if I save
>the picture that i need to display in file something.bmp. I could
>generate a random-unique filename and put the file name in the field. I
>was hoping that in the crystal report, i can assign a picture with the
>file name in the field.
>Problem: I don't know how to assign a picture with the path in the field.
>
>Can anybody help me? I need to know how to use general field in cr (if
>possible) or how to assign a picture (in cr) where the picture file name
>is stated on the data field.
>
>TIA
>Willianto
>p.s I use VFP7 and CR 8