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
Subscribe to:
Post Comments (Atom)
 
No comments:
Post a Comment