I use APEX 4.2.
I have the following query as SQL text for a Report Queries in Shared Components:
'<img style="border: 4px solid #CCC; -moz-border-radius: 4px; -webkit-border-radius: 4px;" '||
apex_util.get_blob_file_src('P22_CUSTOMER_IMAGE', customer_id) ||
'" height="75" width="75" alt="Photo Customer" title="Photo Customer" />') customer_image,
I am unable to have the image printed on the PDF report. Even when the P22_CUSTOMER_IMAGE is defined as session state item.
Does someone knows how to print such image/BLOB in a PDF report?
Thanks by advance.
I believe you will need to use a custom layout built using an XML stylesheet editor... : http://www.oracle.com/technetwork/developer-tools/apex/learnmore/custom-pdf-reports-1953918.pdf
Indeed, I would need a custom layout.
Unfortunately, it seems (according to this white paper) not possible with the APEX listener only. I would need a third pary tool. A pity...
For me strange, that I cannot generate such a report having images or pictures in a pre-definied report layout... Maybe a future enahancement for Oracle.