Picture in data report

[elibb]

hi, im using a datareport to print some data i have in an access database, in one of the filels i save directory paths for different pictures. The datareport takes that fields as text, so i want to put an imgage control and make its picture the one thats on the path. ive tried this:

DataReport1.Sections("Sección1&quot.Controls & _
Set .Item("image1&quot.Picture = LoadPicture(.item & _("txtPic1&quot.text)

txtpic1 is bounded to the picture field on the database, but i cannt make it work.

any ideas??

thank You very much.

Eli

 

[briggsy79]

ive been trying to do this for a while now, and u cant
i got a reply from MS and they said it is a limitation of the datareport
bu ti think u can load the picture into a temp file then display that

Hope that helps

 

[elibb]

can you tell me how to do that?
its driving me crazy...

thank you very much
Eli

 

[briggsy79]

This might work, I dont know if it does yet because i am yet to try it, but someone sent me this code.

Dim loStream As ADODB.Stream
Set loStream = New ADODB.Stream

loStream.Type = adTypeBinary
loStream.Open
loStream.Write loRecordset.Fields("ImageField&quot.Value
loStream.SaveToFile App.Path & "\Test",
adSaveCreateOverWrite
Set Datareport1.Sections("Section3&quot.Controls("Image1&quot.Picture = LoadPicture(App.Path & "\Test&quotloStream.Close
Set loStream = Nothing

Hope it works!!!

 

[elibb]

ill try it and let you know, thank you very much.

Eli

 

[am24]

Using the Data report in VB6 to produce my reports sometimes my reports print sometimes no. Also, when I send the report to the screen sometimes the report appears fine, other times I get a blank report. I have tried using an ADO recordset as the source and also the VB6 data environment as the source. What could be the problem? Should I use crystal reports instead of the Data Report Designer tool in VB6?