I am using Oracle APEX(22.1) for web Applications and APACHE-FOP(2.6) print server to generate PDF.
We have a functionality in Oracle APEX. Which is Users can create Templates using Rich Text Editor page item in Oracle APEX. Below is an example.
We are storing that template in "Templates" table.
and Content is stored like below in Database.
I am working on preparing XSL-FO layout to display the content in PDF. I created a Report Query with "Select content from templates" and Below is Data XML for the report Query.
<?xml version="1.0" encoding="UTF-8"?>
<DOCUMENT>
<ROWSET>
<ROW>
<NAME>TEST</NAME>
<DESCRIPTION><p><strong> Program Details:</strong></p>
<p><strong>Reimbursement for ABC Users:</strong></p>
<p> 1-2 Students <em><strong>$300</strong></em> </p>
<p> 3-5 Students <em><strong>$500</strong></em></p>
<p><strong>Hotels for ABC Users:</strong></p>
<p> 1-2 Students <em><strong>$100</strong></em></p>
<p> 3-5 Students <em><strong>$300</strong></em></p>
<p> </p>
</DESCRIPTION>
</ROW>
</ROWSET>
</DOCUMENT>
Below is XSL-FO layout code. which is used in report Layouts.
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fo="http://www.w3.org/1999/XSL/Format" xmlns:xlink="http://www.w3.org/1999/xlink" version="2.0">
<xsl:template match="/">
<fo:root>
<fo:layout-master-set>
<fo:simple-page-master master-name="A4" page-width="216mm" page-height="279mm" margin-top="1cm" margin-bottom="1cm" margin-left="1cm" margin-right="1cm">
<fo:region-body margin="0.0cm" />
</fo:simple-page-master>
</fo:layout-master-set>
<fo:page-sequence master-reference="A4">
<fo:flow flow-name="xsl-region-body">
<xsl:if test="DOCUMENT/REGION/ROWSET/ROW | /DOCUMENT/ROWSET/ROW | /ROWSET/ROW">
<xsl:for-each select="DOCUMENT/REGION/ROWSET/ROW | /DOCUMENT/ROWSET/ROW | /ROWSET/ROW">
<fo:block>
<xsl:value-of select="DESCRIPTION" />
</fo:block>
</xsl:for-each>
</xsl:if>
</fo:flow>
</fo:page-sequence>
</fo:root>
</xsl:template>
</xsl:stylesheet>
Below is the OUTPUT.
But this output is wrong. it is supposed to be displayed as User's entered in Rich text item. Please help me how to achieve this Using Oracle APEX and XSL-FO.