Oracle Analytics Cloud and Server

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

Page Break for Heading & Sub Heading

Received Response
71
Views
4
Comments

Summary

Page Break for Heading & Sub Heading

Content

Hello,

I have output as shown in the enclosed screen shot of an XML Publisher report.

Capture.JPG

As you can see the third sub heading which is Prod Main Seq : 30 is visible at the bottom of page 1.

I would like to have a page break for the sub heading.I have tried as below, but then each heading is one page.

Ideally, I would like to have page break for the first for-each-group which is the PROD_NUMBER and the sub-headings Prod Main Seq is not visible on one page, then it should be next page where it can visible as one category or group. Similar to Prod Main Seq : 10 and Prod Main Seq : 20, both are visible in one category or group.

Capture2.JPG

Answers

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

    Hi,

    Please add two change on your approach as mentioned in below snap

    1. User <?for-each-group@section:G_PROD_HDR;PROD_NUMBER?>  instead of <?for-each-group:G_PROD_HDR;PROD_NUMBER?> this will make sure that each new PROD_NUMBER should start with new page

    2. Add Table in Word with one row and one column and put the Prod Main Seq. with table layout inside the table as highlighted in the snap.

    Now for the outer table please make two property change

    1. Table Properties > Row > Uncheck Allow Row to Break across page.

    2. Table > Boarder and shading > Non... so that this table will hide to give you layout as only internal table. Please note I have not hide the outer table just to show how it appear with inner table actual layout will be as second snip

    image

    2 Snapshot

    image

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

    If I understand correctly....

    1. Output of each new Product Number (e.g. Product Number: P5900) should start with new page?

    2. Any one Prod Main Seq.(Prod Main Seq. 30)  should not split into two pages  in this case it should ideally come to one page?

  • Jacobelia S
    Jacobelia S Rank 5 - Community Champion
    1. Output of each new Product Number (e.g. Product Number: P5900) should start with new page?

    Yes, that's right.

    2. Any one Prod Main Seq.(Prod Main Seq. 30)  should not split into two pages  in this case it should ideally come to one page?

    Yes, one Prod Main Seq should not be split into two pages, ideally as one group. Ex. Prod Main Seq. 30 starting at the middle or bottom and remaining sub details should not appear on the succeeding pages.

    Regards

  • Jacobelia S
    Jacobelia S Rank 5 - Community Champion

    This has helped to resolve the issue, appreciated.