Hi Craig
I Know i have forgot to tell that the type of ImgPlan field in the sql table was Image.

After the post of this message i have made some test with another computer and i found that something have corupt my crystal report.
I have reinstall my crystal report and everything work fine. I can see my picture now

Thanks.



>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