BLOB fields & Crystal

[Vanderlei Silva]

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

Any ideas?

[Hack]

What language are you using for your front end?

[Vanderlei Silva]

The front end language is C and uses Java to connect to the back end.