Databases Reference
In-Depth Information
7.
The last step of the process is to create a button to print the report. The next
screenshot shows you how to do this:
8.
Test the report by running the page. In this example, when I press the
PRINT_REPORT
button, I'm getting a PDF document with the chart
included in it.
How to add dynamic images to a report
For static images it's pretty straightforward. Just place the static images into your
RTF layout, using MS Word and BI Publisher Desktop. For dynamic images, well
that's a little more complicated.
When talking about dynamic images, what I mean is the images that are stored in
BLOB columns in database tables. To include the image in the PDF, you need to take
care of the following:
• The image needs to be included in the generated XML representation of the
report data and the RTF report layout needs to include instructions on what
to do with the image information stored in the XML data.
• Before BLOB columns can be included in the XML export, they need to
be converted to CLOB by using base64 encoding and the report template
needs to reference the image data column by using an XSL-FO expression.
So the reports template needs to reference the image data column, using
XSL-FO expression.
Keep in mind the 32K limit on report columns.
