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

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,

Greg  
gpbcobbAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
frodomanCommented:
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: http://support.businessobjects.com/library/kbase/articles/c2015692.asp

frodoman
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
gpbcobbAuthor Commented:

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.

Greg
0
 
frodomanCommented:
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.

frodoman
0
 
gpbcobbAuthor Commented:
Thanks for your help.

At least I know that it is not possible (and probably would not have been very efficient anyway)
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.

All Courses

From novice to tech pro — start learning today.