Crystal Reports does not support General fields.


>Hi all
>I try to print some picture in crystal report from sql table
>In my Sql table i have a Image field
>all my picture a store in VFP table with a Gen filed
>
>I put my picture in the Image field this way
>
>USE c:\test.dbf ALIAS dbIm SHARED IN 0
>SELECT('dbIm')
>GO TOP
>DO WHILE !EOF()
> lstrsql = 'Insert into A_TmpInfoplan2 (ImgPlan,id_Client,Rs1) Values (?dbim.Imm,?Id_Cli,?Ch)'
> sqlexec(Z_Conn,lStrsql)
> SELECT('dbim')
> SKIP
>ENDDO
>
>In the Sql Enterprise maneger
>If I do
>Select ImgPlan from A_TmpInfoPlan I see
>0x151C3000020000000E000E001400220037056FFE56697375616C20466F7850726F005061696E742E506963747572650001050000020000000700000050427275736800000000000000000040B10100424D36B10100000000003604000028000000800100001E01000001000800000000000000000000000000000000000000
>Ok i suppose i'ts my .bmp and it's ok
>In crystal report when i drag my field ImgPlan from my table i see a blob object but no .bmb and nothing in the preview report
>
>Help please I'm starting to hate Crystal Report.
>
>Ben