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
330
Views
29
Comments
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

Welcome!

It looks like you're new here. Sign in or register to get started.
«13

Answers

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

  • Rank 3 - Community Apprentice

    Hi Sumanth,

    Tried this but issue remains same.

    Thanks,

    Bhavani

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

  • 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

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

  • Rank 3 - Community Apprentice

    Hi Sumanth,

    Sharing you the screenshot.

    Thanks,

    Bhavani

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

    Hi Sumanth,

    Tried it issue persists.

    Thanks,

    Bhavani

  • 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

  • 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

Welcome!

It looks like you're new here. Sign in or register to get started.