Create RTF template using XML BI Publisher

Purpose: In this post we will see how to create a RTF template.

Steps:

·       

           Before creating the rtf template you need XML dataset. You can create it using simple PL/SQL Program (Click here).

 ·       Download and install Java and BI Publisher Tool.

·         Open the MS – Word and you will see Add-Ins tab at the top of the screen.

·         Click on Add-Ins -> Data -> Load XML Data and upload the xml file.

 

·         Click on Insert -> Table Wizard.

·         Select Table and click on next button.

·         Select the columns you want to display in your output and click on next button.

·         If you want create group then select or click on finish button.

·         Now the table has been created with the columns that you have selected.

·         Now we will add header and the parameters list in the report output.

·         Select the top row of the table and right click on it and Insert -> Insert Rows Above.

·         Select all the cells in the new row and right click and merge cells.

·         Select centre alignment and type the Report Header.

·         Similarly add few more rows between header row and column name header row.

·         Select all the cells between Report header row and column header row except the first two columns and select Borders and shading.

·         Select the Box option and click on Ok button.

·         Now we will add a few fields one by one. Click on Add-Ins -> Insert -> Field.

·         Click at the place where you want to place the field and then select the field from the block and click on insert button. You can double click on the field in the block also.

·         Similarly add other fields.

·         To add the page number select Insert -> Page Number -> Bottom of Page -> Plain Number 3.

·         Now it’s time to see the output. Click on Add-Ins -> Preview -> PDF.