How to open files stored in the database from a crystal?

building reports crystal reports
1

Hello everyone,

I’m wondering if I can create a crystal report based on the files/attachments info. stored in the database. I want to open the actual file(s) (word docs, pdf, text files, etc.) stored in the table(oracle) from crystal report.

Is this possible? If yes can anyone please explain me how to achieve it in detail.

Thanks,
Kum

kum007 (BOB member since 2007-06-08)

2

Hi,

I know you can do this with pictures, but Im not sure about other types of doc. You see all those formats are probably stored as binary in your db in a blob or similar. Crystal needs something to convert them, that thing, specifically, is called OLE however, OLE doesnt really work with binary streams. OLE is a windows component by the way.

ABILtd :uk: (BOB member since 2006-02-08)