Oracle Transactional Business Intelligence

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

BIP Keep rows grouped together so they don't break between pages

Received Response
417
Views
2
Comments
KDR
KDR Rank 3 - Community Apprentice

We have a custom PO BIP report and each record (PO line) of the PO is comprised of three rows within a table structure (for-each repeating element). The issue we're facing is that at the bottom of each page part of the line record is getting broken to the next page.

The screenshot below is an example of our PO output in PDF format. The record highlighted in Green is what every record should look like, with all three rows being displayed together on the same page. The example highlighted in Red (Line # 31) has the last 2 rows for it getting pushed to the next page. Sometimes only the last row of the record gets pushed to the next page.












We want all the rows for a record to stay together on the same page, so that if they all will not fit then the entire record should go to the next page. In the above example the Line #31 record should have all went to the next page (page 3) instead of being split across both pages as you see. Essentially we are looking for a way to group the rows together within the repeating element contained in the table.

This is what we have tried doing so far:

In MS Word, select the entire table, then select Table Properties, select Row tab, uncheck the below property (Allow row to break across pages) :








Select entire table, then in Paragraph settings select (check) the following options in the Line and Page Breaks tab:









Despite setting these options, the line records are still being split into different pages. How can we avoid this? I can provide the actual RTF file and sample XML if you would be helpful to anyone.

Answers

  • KDR
    KDR Rank 3 - Community Apprentice

    Any feedback on this?

  • govWorker
    govWorker Rank 1 - Community Starter

    Hello.
    I just came across your request for BI help.
    I have the same issue, but… the settings you provided above actually fixed my report so thank you very much. Specifically, the Paragraph settings.
    Thanks again for posting.