Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
BIP Keep rows grouped together so they don't break between pages
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
-
Any feedback on this?
0 -
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.0