Categories
- All Categories
- 13 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.6K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BIP RTF Template modification - how to repeat "header table" when page changes?

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
Answers
-
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.
0 -
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
0 -
Attached the template (second table in it) and xml data.
BR,
Mari
0 -
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
0 -
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.
0 -
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
0 -
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 –
- 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.
- 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.
0 -
@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).
0