Oracle Analytics Publisher

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

Page Numbers are not incrementing sequentially.

Received Response
294
Views
28
Comments
Bhavani  Rikkula
Bhavani Rikkula Rank 3 - Community Apprentice

Hello all,

Am working on a requirement in which I have a header to be repeated dynamically I have used <?start:body?> and <?end body?> and able to achieve it but we should use for each section for group that should be repeated

Assuming there is a two level hierarchy in the xml, I 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?>

Since I used <?for-each@section page numbers are incrementing section wise but not page wise I have also enabled page number format as continue from previous section but no luck.

Please share your inputs.

Thanks,

Bhavani

«13

Answers

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @Bhavani Rikkula - Go to page footer and copy and paste the below script.

    <?fo:page-number?> of <?fo:page-number-citation:xdofo:lastpage-joinseq?>

    <fo:page-number>: This is the object, which is used to represent the current page-number.

    <?fo:page-number-citation:xdofo:lastpage-joinseq?>This is the syntax, which is used to represent the total number of pages.

    See this helps in achieving your requirement.

  • Bhavani  Rikkula
    Bhavani Rikkula Rank 3 - Community Apprentice

    Hi Sumanth,

    Tried this but issue remains same.

    Thanks,

    Bhavani

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist
    edited June 2024

    @Bhavani Rikkula - Ensure that the <?page-number?> and <?total-page-count?> fields are placed in the header or footer, which is outside the <?for-each@section?> construct.

    The page numbering should continue across sections because the @section attribute will not influence the page numbers placed in the header or footer if it's defined outside.

  • Bhavani  Rikkula
    Bhavani Rikkula Rank 3 - Community Apprentice

    Hi Suman,

    I have placed <?page-number?> and <?total-page-count?> in header but it is not printing anything.

    Thanks,

    Bhavani

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @Bhavani Rikkula - Please share the screen shot of the template showing how the <?page-number?> and <?total-page-count?>  has been placed. Thanks.

  • Bhavani  Rikkula
    Bhavani Rikkula Rank 3 - Community Apprentice

    Hi Sumanth,

    Sharing you the screenshot.

    Thanks,

    Bhavani

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @Bhavani Rikkula - Please try below steps:

    • Place the cursor where you want the page number to appear.
    • Go to Insert > Quick Parts > Field.
    • In the Field dialog box, select Page from the field names list.
    • Click OK to insert the page number field.
    • Then use the below BI Publisher code and check once.
      Page <?page-number?> of <?page-total?>

  • Bhavani  Rikkula
    Bhavani Rikkula Rank 3 - Community Apprentice

    Hi Sumanth,

    Tried it issue persists.

    Thanks,

    Bhavani

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @Bhavani Rikkula,

    you need to use the place holder and then set the page numbers. use below for more information.

    https://orclapp.blogspot.com/2012/12/how-to-add-page-number-to-xml-publisher.html

    Regards,

    Arjun

  • Bhavani  Rikkula
    Bhavani Rikkula Rank 3 - Community Apprentice

    Hi Arjun,

    I tried this before even formatted page numbers to print it from previous section but issue remains same.

    Thanks,

    Bhavani