Display Dynamic Picture Stored in Database

[malleyo]

I'm using CR 8.5 with RDC and ADO, and SQL Server 2005. The pictures are .jpg's and are stored in an Image type column in a Picture table. I'm using ADO within VB to pull back a list of pictures from the Picture table and then passing the ADO recordset to Crystal (using a Blob field for the Image). Crystal is correctly adding all 10 records to the report, but the Blob field is blank instead of showing the picture.

How can I get the pictures to display dynamically from the database?


*RESOLVED* - I didn't realize that my code was taking the ADO recordset and stuffing the data into a CDO Rowset and passing the CDO Rowset to Crystal instead of the ADO recordset. CDO Rowset doesn't support Blob fields.

[queenannsrev]

I am having the same issue but I am very new to Crystal. I don't understand all that you said. I am using Crystal XI. Can you tell me what a Blob field is and a CDO Rowset. If you could give me any information it would be a big help. Thanks

RESOLVED* - I didn't realize that my code was taking the ADO recordset and stuffing the data into a CDO Rowset and passing the CDO Rowset to Crystal instead of the ADO recordset. CDO Rowset doesn't support Blob fields