Displaying of Blobs on a Crystal Report

[fparkerropes]

I have some images(stored as Blobs) that I want to print in a Crystal report. They are stored in a SQL Server 2000 database as an Image data type. I use Crystal 10. I created a quick little report to read these & print a report. All that came out was a box(I had the field bordered). The image did not display. How do I get them to display? Do I need Crystal 11?

 

[Turkbear]

Hi,
We use Oracle not SqlServer but we did find that until CR XI, we could not display that type of data ( BLOB in Oracle)





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[hilfy]

We were able to display images in CR 8.5 by using an OleDB connection to the database instead of the native connection. In XI we use the native connection.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[fparkerropes]

Thanks. I have upgraded to Crystal 11. The Blob is is actually stored as an image data type in the database. I dragged the field to the report but it still did not display. I tried to add an OLE object & use the graphics location formula in format graphic editor. No luck because you can't use a blob as part of a formula.

 

[fparkerropes]

I just found out that the images in the Blob are GIF. Could this be my problem? Has anyone been able to access this kind of image?