• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1604
  • Last Modified:

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.
0
Jonathan Mellon
Asked:
Jonathan Mellon
1 Solution
 
mlmccCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now