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 :
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 ;-)
we found a solution for our issue :
we generate the png file from the QA server using UTL_HHTP package, with a defined name.
Then we get this image in our report, in PDF format output.
May this help...
If you got question...