Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Crystal Reports and SQL Binary Data (Blob)

Posted on 2012-03-13
3
Medium Priority
?
1,578 Views
Last Modified: 2012-08-13
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
Comment
Question by:Jonathan Mellon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 37715483
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question