Page number issue using nested for-each@section in BI Publisher

User_J83AL

Hi Everyone,

we have a report, for each member, it has two parts with different headers,each part may be across multiple pages,
now the report only has one problem, page number are reset for the two parts
what we expect is each member has its own page number system, but within the member we require it has a continuous page number across the two parts

for example,
member(XXX-XX8-356), each part has 1 page
expected: 1,2
actual result:1,1

we have a for-each@section for members, and within it, another for-each@section:xdoxslt:foreach_number, if we put initial-page-number:'auto' within the 2nd one, the page number within the two parts are continues, but the whole report has one page number system, not reset for each member

Could someone help this? Very appreciated!!!

see attachments for xml/rtf

Members.zip

Thanks

Riyaz Ali-Oracle

Check if this helps:

1. Use initial-page-number="1" at the Member Level

Apply initial-page-number="1" to the outer for-each@section (for members).
This ensures that each member starts at page 1.

2. Ensure Continuous Numbering Across Parts

Instead of using initial-page-number="auto" in the inner section, try removing it.
This should allow the numbering to continue across the two parts.

3. Use xdoxslt:get_page_number()

You can manually control the page numbering using:
xml

<?xdoxslt:get_page_number()?>

Check the below:

Page number issue using nested for-each@section in BI Publisher - Oracle Forums

Reset Page Number in RTF Template — oracle-mosc