We help IT Professionals succeed at work.

Crystal Reports and SQL Binary Data (Blob)

I wondered if you could help us with a Crystal Reporting issue.  We have some tables within an SQL table which store Documents (such as Word, PDF, Excel) as BLOB data.  We have been able to create crystal reports which utilise other data types, but have no idea where to start with binary data.  The basic idea is we would like to show the embedded document as part of the report.
Comment
Watch Question

Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
I have never used BLOB data in a report.

Have you tried just dragging the field onto the report to see what you get?

I know if you include a Word/PDF/Excel file in an OLE container on the report all you can get is page 1.  I would suspect the BLOB container would be the same, so if your problem is you can't page through it, I suspect that is the way Crystal designed the capability.

You could try using a URL to link to the file.

mlmcc