After struggling in understanding what was wrong, I did the following:
I had Java 1.6 45 32 bit installed and working fine. "Please make sure JRE version 1.6 or later is installed"
Use to add the XSL template result on the same line, and do not forget to add to close the call.I tried to install Oracle BI Publisher Desktop 11.1.1.7 on my Windows 64 laptop for Microsoft Office 2013 32bits and I got the following error: In your main document insert a Microsoft Word field with the below code: So, we can just call our subtemplate where we want the template to appear. When you define an internal subtemplate in your main BI Publisher template there is of course no need to import that subtemplate.
The xsl:value part will select the html2fo function using the xdoxslt library with the HTML_TEXT data element as an input. In there is a fo:inline with a number of layout properties including our font-family and font-size attributes.
The above code defines an XSL template with the name HTMLTEXT. Insert a Microsoft Word field with the below code: On the actual fo:inline definition we’ll set the used font, in my example Calibri and our font-size 12. In this subtemplate definition we need to define a fo:inline block with our call to HTML2FO. What we will do is to use an XSL subtemplate definition within our main BI Publisher RTF template. Also note that the html2fo function will not use the standard RTF default font setting as defined in your BI Publisher properties, so we need a way to change the font used in our converted html2fo html text. Our main BI Publisher RTF template has Calibri 12 as the standard font, however the HTML font used in this case is Arial 12. The html2fo function will use a default font for the converted result. The strong tag is converted to bold, the i tag to italic, paragraphs are added, and the bullet and numbered list is displayed. Let’s first display this HTML_TEXT element in our BI Publisher template by inserting a Microsoft Word field with the below code: Īs can be seen BI Publisher now displays our HTML correctly in the BI Publisher generated document. We want to have this same structure in our BI Publisher document. The HTML contains tags to display bold text (…) and italic text (….), paragraphs (…), an unnumbered or bullet list (…) and finally a numbered list (…). This is a piece of text in HTML, the word HTML should be bold.This is a new paragraph.It contains also a number of standard HTML tags like italic as the next part italic textWe can also have a bullet list like this: Item 1Item 2Or a numbered one like this: Item 1Item 2]]>Īs can be seen above the HTML text within the HTML_TEXT element is enclosed by CDATA tags to preserve the HTML tags within the XML structure. We have the below XML data available to us: In order to keep the same layout across our BI Publisher document we also need a way to change the font for the displayed HTML to reflect the same standard font-type and font-size. When you implement the HTML2FO function in your document you’ll soon notice that the font being used for your HTML will differ from the font used in your document. The way to handle this request is to use the function HTML2FO which can be used within your BI Publisher template. The displayed HTML in BI Publisher should also use the layout tags as provided within the HTML code. I’ve got the requirement to display HTML, stored within the Oracle database, inside a BI Publisher document.