Tuesday, February 14, 2012

Display Dynamic Picture Stored in Database

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.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

No comments:

Post a Comment