Page Numbers are not incrementing sequentially.

Bhavani Rikkula

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

Sumanth V -Oracle

@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

Hi Sumanth,

Tried this but issue remains same.

Thanks,

Bhavani

Sumanth V -Oracle

@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

Hi Suman,

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

Thanks,

Bhavani

Sumanth V -Oracle

@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

Hi Sumanth,

Sharing you the screenshot.

Thanks,

Bhavani

Sumanth V -Oracle

@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

Hi Sumanth,

Tried it issue persists.

Thanks,

Bhavani

Mallikarjuna Kuppauru-Oracle

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

Hi Arjun,

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

Thanks,

Bhavani

Mallikarjuna Kuppauru-Oracle

Hi @Bhavani Rikkula

What is your BIP version ? are you using onprem or cloud ?

Regards,

Arjun

Bhavani Rikkula

Hi @Mallikarjuna Kuppauru-Oracle

Am using cloud version.

Thanks,

Bhavani

Dir_Pal

Please share your sample Data and RTF where we can resolve the issue. if the above solutions didn`t worked for you.

Bhavani Rikkula

Hi @Dir_Pal ,

Sharing you the sample data and RTF.

Thanks,

Bhavani

Repair_Costs_by_Cust_Temp_V10.rtf

Repair Costs by Customer Xml.xml

Dir_Pal

This issue happens when you apply Page Break. As suggested by @Sumanth V -Oracle That should work if you are able to fix the PB issue.

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

Bhavani Rikkula

Hi @Dir_Pal ,

I have fixed page break(removed page break) and tried but issue remains same .

Attached RFT .Let me know if am missing anything

Repair_Costs_by_Cust_Temp_V10.rtf

Thanks,

Bhavani

Dir_Pal

Hi @Bhavani Rikkula Will check out today . But before did u tried this scenario

Bhavani Rikkula

Hi @Dir_Pal ,

Thank you for your inputs tried it but issue remains same.

Thanks,

Bhavani

BoredApe

Hi @Bhavani Rikkula Can you Please check this out

Repair_Costs_by_Cust_Temp_Test.rtf

Bhavani Rikkula

Hi @BoredApe ,

Thanks for your inputs,If we remove for each section for legal entity then legal entity Id will be same through out the report we need to group by legal entity if you see previous output legal entity id is different for page 1 and page 2 .

Thanks,

Bhavani