Note: You should follow Oracle® BI Publisher Report Designer's Guide (section “Creating an RTF Template”).

We use for template design Microsoft Excel 2003 or higher within the framework of our solution. Load the existing multisheet template into Microsoft Excel and add markup to the template layout to create the mapping between the layout and the data source.

Then save the finished template as “XML Spreadsheet”.


How to create Placeholders
How to define Groups
How to regroup the XML Data
How to define If statements
How to define Choose statements
How to use Extended SQL and XSL Functions
How to define Sorting
How to use Variables
How to define Dynamically Worksheets based on the Dataset