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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only