1 Reply Latest reply: Sep 23, 2013 10:14 AM by YannC RSS

    Including dynamically generated jpg files in a report in PDF

    YannC

      Hi all,

       

      hope I'm in the right forum.

      We have an issue with images we must include in a report, when the report output format is PDF.

      We are using these versions for Reports etc... :

      Report Builder 10.1.2.0.2

      ORACLE Server Release 10.1.0.4.2

      Oracle Procedure Builder 10.1.2.0.2

      Oracle ORACLE PL/SQL V10.1.0.4.2 - Production

      Oracle CORE    10.1.0.4.0    Production

       

       

      We need to include in a report a image (jpg or png) which is provided (and created dynamically) by NWA Quality Analyst.

      We use a BoilerPlate Field, and in the hyperlink property, we have something like  :

      http://myserver/XBAR_GRAPH.NWG?CachedFile=something,etc.><IMG SRC="http://myserver/XBAR_GRAPH.jpg?CachedFile=....

       

      Works fine when getting the report in HTML output format.

      But doesn't work when the report is in PDF output format. Seems to be a security constraint of PDF.

       

      Question 1 : Has anybody already faced a similar issue ? And solved it ?

       

      We tried to include a jpg file located anywhere on our server, it works fine, BUT in our case, the jpg file returned by NWA Quality Analyst is not stored anywhere (generated on the fly)

      Question 2 : is there a way, in PL-SQL (in beforereport trigger) to call the URL, get the file returned and save it somewhere ?  Or display it as a image ?

       

      Thanks for any idea and help effort.

       

      (French translation available on demand as my english is not so good ;-)