Oracle Communities

Oracle Analytics and AI

Child Item

BIP RTF Template modification - how to repeat "header table" when page changes?

User_0PDV4

Summary

BIP RTF Template modification - how to repeat "header table" when page changes?

Content

Hello,

I'm fighting with a (Oracle based) BIP rtf template and now I'm lost. I have account data coming in and of course some accounts do have more data than others. That causes my table to grow so long that it goes over several pages and that's ok. I have table headers on each page but how can I "copy" or repeat the account information - that seems to be in it's own table - to each page? You can see from the picture what I mean.

I have zero experience with this so I really need "insctuctions for dummie".

Thanks in advance,

Mari

Find more posts tagged with

Accepted answers

All comments

Venkata Allam-Oracle

You can use subtemplate(s) to achieve this feature.

You have to call sub-template from main template

Review Report Designer's Guide to know details about Sub-templates.

User_0PDV4

I read the documentation but didn't understand how should I modify this to get it work. Do you have any tips how to do it easily?

BR,

Mari

User_0PDV4

Attached the template (second table in it) and xml data.

BR,

Mari

Brajesh Shukla-95078

You can very much do it using repeating header feature of XML publisher use <?for-each@section:GROUPNAME?>

You can see example of repeating header under

Wiindow Start Menu > BI Publisher Desktop\samples\RTF templates\Advanced\RepeatingHeader

Ravi Chamarty

As per Oracle documentation, you cannot use variables/form fields in header and footer section. so, you want to use them in the body and intend to repeat it. Use the below and place the section that you want to repeat above. Sub templates will also help as suggested

<?start:body?>

<?end body?>

I had a similar requirement and I used the above and it worked just fine.

Anandula

Hi,

select the row which you want to repeat and right click on it . go to table propertes -> row tab -> check repeat as header in each page

Antariksh Kar-Oracle

Here is the suggested approach, assuming BIP report layout/format etc. is being controlled using PDF or RTF templates.

Below is the reference documentation for the same –

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.

Create the repeating group in the BI Publisher toolbar in MS word, “Insert” section. Refer to documentation - “Insert a Repeating Group”
Identify what you are grouping by and whether there is a page break on this grouping.
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.
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.

Gianni Ceresa

@Antariksh Kar-Oracle , that's great, but it's better to not resurrect 7+ years old posts that have been migrated across a few forums.

If a question is old (2 years or more), let's leave it where it is, how it is…

If somebody has the same question they better post a new one, so they can also provide all the details required (while here the original poster is not even active on the forum anymore).