Displaying an imported PDF File from an Oracle BLOB into Crystal XI

Posted on 2006-06-08
Last Modified: 2012-06-21
I am designing a report which displays data items from an Oracle data source.  As an appendix, I want some pre-defined PDF files to be displayed.

My solution has been to load the PDF into an Oracle BLOB field.

However, when I add this field to the report, nothing is displayed.  It works fine for jpg files, so I was hoping that the same principle applied to PDF files.

Is there a better way to do this?  I don't really want to create a report (or subreport) with the same information as the PDF.  I just want to import it into the report for displaying.

Many thanks,

Question by:gpbcobb
    LVL 42

    Accepted Solution

    The documentation I've seen says that you can't embed a PDF sucessfully into Crystal but it does suggest some alternatives - basically convert the PDF to a different format that is supported (i.e. - Word.doc, etc.) and use that instead.

    Here's the link:


    Author Comment


    I wasn't really intending to use OLE, since I thought that by doing this, you need to double click on the object to open it when running the report.

    I had intended to view the file like a bitmap, but it looks like I won't be able to do this.  I get the same results if I import a Word document into the BLOB field.

    Unforunately, if I have to convert to a Word document, I may decide to just develop the data myself as a sub-report.

    LVL 42

    Expert Comment

    The sub-report is probably going to be your best bet.  Seemed you didn't want to go that route so I was looking for other options for you.


    Author Comment

    Thanks for your help.

    At least I know that it is not possible (and probably would not have been very efficient anyway)

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now