If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

BLOB fields & Crystal

I have a BLOB field that I want to pull into a report. The data in this BLOB field originates from an incident management software application as attachments. The field value in question contains the attachments; word docs, excel files; sometimes multiple files. The incident management software also encrypts the attachments, which is a different problem entirely. Is there some trick to get this data to display?

I tried inserting the BLOB field (got a blank field value), inserting an OLE object and pasteing the BLOB value (got incomplete encrypted file values) and lastly I tried pointing the OLE object to an HTML file (this worked the best, but the file was still encrypted).