Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Showing dynamic images in BI Publisher PDF report

Roel HartmanFeb 16 2012 — edited Feb 23 2012
I defined a RTF report layout in BI Publisher. Almost done, but one requirement missing...
I should be able to include a dynamic image (so every "object" on the report has it's own image).
At first I embedded the base64 converted image in the XML output, but then I am running into the 32K limit. (Small pictures render fine).
Although Marc Sewtz sort of promised in June 2008 (!) : "One issue, which we'll address in the next version of Application Express, is the 32k limit on report columns." on his blogpost http://marcsewtz.blogspot.com/2008/06/one-question-about-pdf-printing-feature.html , it still not addressed.

So I tried to embed the image in the report using a trick described on the forum (and BIP documentation), by embedding a dummy picture and set the "Alt-text" of the picture to
(as an example) : url:{'http://www.oracleimg.com/us/assets/oralogo-small.gif'}.
The strange thing is, that works fine for HTML Output and Excel output, but not for Word and PDF (why it does work for Excel and not for Word is very mysterious....). And of course I need a PDF output.

I also tried to embed a FO snippet:
<fo:block>
<fo:external-graphic src="url:{'http://www.oracleimg.com/us/assets/oralogo-small.gif'}" />
</fo:block>
But that doesn't (seem to) work on any output...

But
<fo:block>
<fo:external-graphic src="D:\Users\rhartman\Documents\PrintScreen Files\Screenshot004.jpg" />
</fo:block>
does produce the image on the PDF output.

So who has an idea how to solve this issue?? You'll be rewarded with a lot of pionts ;-)

TIA
Roel
This post has been answered by Carsten Czarski-Oracle on Feb 16 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 22 2012
Added on Feb 16 2012
10 comments
29,417 views