Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Closed
729
Views
8
Comments
User_0PDV4
User_0PDV4 Rank 4 - Community Specialist
edited Sep 24, 2024 4:24PM in Oracle Analytics Publisher

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".

rapsa.png

Thanks in advance,

Mari

Answers

  • Venkata Allam-Oracle
    Venkata Allam-Oracle Rank 4 - Community Specialist

    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
    User_0PDV4 Rank 4 - Community Specialist

    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
    User_0PDV4 Rank 4 - Community Specialist

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

    BR,

    Mari

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    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
    Ravi Chamarty Rank 4 - Community Specialist

    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
    Anandula Rank 3 - Community Apprentice

    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
    Antariksh Kar-Oracle Rank 1 - Community Starter

    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.

    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.

  • @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).

This discussion has been closed.