Generating PDF files using Oracle BI Publisher is pretty straightforward. If you have tables in your RTF template, and if the rows have a specific height and width, the PDF output would have exactly the same properties.
But, that isn’t the case with RTF output. For this particular case I had to work on, the report had to be generated in RTF format, so that, users can edit the RTF output if required, as deploying PDF editors on all systems to edit PDF output wasn’t a viable option. But, BI Publisher removes any row height properties when the output is in RTF format.
Here’s a screenshot of the RTF template:
Here’s the output in PDF format, with the row height retained:
Here’s the RTF Output with all row height properties lost:
I raised an SR with Oracle and it appears that this is a limitation even with the latest versions of Oracle BI Publisher for Desktop, which might be fixed in future releases. I still had to find a way to retain the row height, and this is what I did – I added an invisible column in the RTF template with some content, which also needs to be invisible as well (set the font color to be the same as the background – in this case white).
Provided below is a screenshot of the RTF Template with placeholder text and column:
This is how the RTF output looks like after the placeholder text and columns have been hidden – this is a workaround for the RTF template to retain row height, whereas width can be retained by clicking on the Preferred Width checkbox
If you’ve encountered this issue and have found different ways to solve it, please let me know and I’ll update the post with these details.
Have fun! 🙂