Oracle Analytics and AI

KDR

Hello all - I am struggling to setup my RTF template to display a column heading table at the top of each page when there is more then 1 page. I have set the Word Table/Row properties "Repeat as header row at the top of each page" to be selected, and also used the <?for-each@section:to be used just before and after the column heading table and the data table. This is to be output in PDF format.

Essentially I just want these column headings (shown here in the Red highlighted area) on the first page, to be duplicated at the top of each subsequent page after

I suspect either I'm not using the <?for-each@section:<Group Name> with the correct Group Name element, and/or I don't have the code placed in the correct location on the RTF template. I attached both the RTF template, and a sample XML file.

I appreciate your help with this!

RFSReceiptTravelerReport Barcode V12-forEachTest1.rtf

RFS Receipt Traveler Multi Line DM_Altered.xml

Dimple-Nagesh-Support-Oracle

Hello @KDR,

Please find the below documents:

https://community.oracle.com/products/oracleanalytics/discussion/14748/bip-rtf-template-modification-how-to-repeat-header-table-when-page-changes  

https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-design/insert-components-template.html#GUID-810DE89F-26FF-405E-9CF4-C9B3A90814ED  

Below is the reference documentation for the same –

• Design the Template
• Define Groups of Repeating Fields
• Repeat a PDF Template by Using the document-repeat-elementname Form Field

If you are using RTF template then you could pretty much use all MS word functionality, along with BI Publisher features from plug in to format the contents.

1. Create the repeating group in the BI Publisher toolbar in MS word, “Insert” section. Refer to documentation - “Insert a Repeating Group”
2. Identify what you are grouping by and whether there is a page break on this grouping.
3. If the data model already sorts this data correctly, you can check “Data already sorted” or use the “Sorting” tab to manually sort after data retrieval.
4. Next, select the Table properties after highlighting the rows you want to REPEAT. Check the Rows, “Repeat as header row at top of each page”.

This should enable printing the desired header content at the top of each page, followed by the “repeat as header rows” on each repeating page until the end of repeating section in the template.

Also review these : https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-6379E5BD-1CE4-4F9D-B311-F33098866FE6.htm  

Please try the above and confirm if that helps.

Thanks,
Dimple N