Invalid Image error when printing blob image fields from MS SQL Server database

rbuser

Hi,

Report Builder can not generate a report when I try to print images from
blob fields stored in MS SQL Server databases...
in other parts of my app I worked around this problem by loading the
blob content into an AdoBlobStream and manually search for the beginning
of the actual image (as there is some other data inserted before) and
create the required image type which can be displayed without problems.
At what point can I do this process in Report Builder so the image can
be displayed in the print preview and printed? I am generating the
report via a custom wizard...

Cheers,
merrit

nicocizik

Hi Merrit,

Take a look at the following example on using the nwOLE library to extract
BLOB images from SQLServer or Access.

http://www.digital-metaphors.com/tips/LoadImageFromSQLServer.zip


--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Thanks a lot for the example, it works!
But why do the images look distorted in the preview window? When I print
them they look fine but the preview just looks weird (the colors are
wrong and the images look all dotted and not like photos)

Cheers
Merrit