repeating header in BI publisher template

rtf bi-publisher xml-publisher oracle-xml-publisher
Siddharth Srivastava picture Siddharth Srivastava · Jun 28, 2016 · Viewed 11.3k times · Source

I am trying to design a template in BI publisher for the xml file generated by oracle BI PUBLISHER.

I want my header part to repeat on all the pages like if the data is printed across pages the header portion related to the data should be printed on all the pages.

I tried to include the repeating group in header and its end tag in body, but its not working for me.

header section is related to body and each group can have different headers Can any one help me on this?

Answer

Ranjith R picture Ranjith R · Jun 29, 2016

Assuming you have a two level hierarchy in the xml, you want the value for level1 to be repeated across pages, if data in level2 overflows. This can be achieved with the <?for-each@section:LEVEL?> command

<?for-each@section:LEVEL1?>
<?for-each:LEVEL2?>
<?name?>
<?end for-each?>
<?end for-each?>

Now you need to give <?LEVEL1?> in your header. It will be printed across pages when its Level2 records overflow.

Related questions

Oracle BI Publisher auto width of excel columns

When creating a BI Publisher rdf template in Microsoft Word, with intended output to Microsoft Excel; is there a way to specify that a table should use auto width for the columns in the Excel output. By default, when you …

Read More
Increment Counter in For-Each Loop for RTF Template

I am trying to increment COUNTER variable by 1 inside a for-each loop of BIP report using below code. However, COUNTER variable are not incremented not matter how many loop there is. Can someone please guide me how to do this. …

Read More
fast way to copy formatting in excel

I have two bits of code. First a standard copy paste from cell A to cell B Sheets(sheet_).Cells(x, 1).Copy Destination:=Sheets("Output").Cells(startrow, 2) I can do almost the same using Sheets("Output").Cells(startrow, 2) = Sheets(sheet_).…

Read More