Let’s get started…
Tools that you will need:
Design your report template using Microsoft Word and populate the document with variable placeholders.
Save this template as a Word 97-2003 document.
Download the latest Apache POI binaries. At the time of writing, the latest version is 3.9 and the utility needed is still under development. The two Java library (jar) files are highlighted.
Extract the package and change the current directory to the folder the files were extracted to.
For convenience, copy/move the template document to the same directories as the Java libraries.
Perform the Word to FO conversion. Enter the command as highlighted.
The contents of the FO file should be something similar to this:
Place the contents of this file - stuff between the <fo:root> element - within a transformation template.
Replace the placeholders defined in the Word document with elements.
Images would be removed and replaced by a placeholder comment tag.
Include the image file as <fo:external-graphic> elements.
Save the file with an XML extension. To see this template in action, click on the “Print” button here.
Known Issue: The graphics element renders correctly when using Oracle APEX Listener 2.0 embedded Apache FOP print rendering engine, but not on apex.oracle.com, which uses Oracle BI Publisher. I am still trying to figure out why and if you do know the reason, I’d be happy if you could share it with me. Thanks! :-)