Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Split Multiple columns across pages in BIP report

Summary
Split Multiple columns across pages in BIP report
Content
Hi,
Can anyone help me with the below scenario:
Sample Data having: 10 columns and 10 rows
A | B | C | D | E | F | G | H | I | J |
Data1 | Data1 | Data1 | Data1 | Data1 | Data1 | Data1 | Data1 | Data1 | Data1 |
Data2 | Data2 | Data2 | Data2 | Data2 | Data2 | Data2 | Data2 | Data2 | Data2 |
Data3 | Data3 | Data3 | Data3 | Data3 | Data3 | Data3 | Data3 | Data3 | Data3 |
Data4 | Data4 | Data4 | Data4 | Data4 | Data4 | Data4 | Data4 | Data4 | Data4 |
Data5 | Data5 | Data5 | Data5 | Data5 | Data5 | Data5 | Data5 | Data5 | Data5 |
Data6 | Data6 | Data6 | Data6 | Data6 | Data6 | Data6 | Data6 | Data6 | Data6 |
Data7 | Data7 | Data7 | Data7 | Data7 | Data7 | Data7 | Data7 | Data7 | Data7 |
Data8 | Data8 | Data8 | Data8 | Data8 | Data8 | Data8 | Data8 | Data8 | Data8 |
Data9 | Data9 | Data9 | Data9 | Data9 | Data9 | Data9 | Data9 | Data9 | Data9 |
Data10 | Data10 | Data10 | Data10 | Data10 | Data10 | Data10 | Data10 | Data10 | Data10 |
Requirement:
To split the data so that each page will have only 5 columns and 5 rows as below:
*page sequence is important*
Page 1 | ||||
A | B | C | D | E |
Data1 | Data1 | Data1 | Data1 | Data1 |
Data2 | Data2 | Data2 | Data2 | Data2 |
Data3 | Data3 | Data3 | Data3 | Data3 |
Data4 | Data4 | Data4 | Data4 | Data4 |
Data5 | Data5 | Data5 | Data5 | Data5 |
Page 2 | ||||
F | G | H | I | J |
Data1 | Data1 | Data1 | Data1 | Data1 |
Data2 | Data2 | Data2 | Data2 | Data2 |
Data3 | Data3 | Data3 | Data3 | Data3 |
Data4 | Data4 | Data4 | Data4 | Data4 |
Data5 | Data5 | Data5 | Data5 | Data5 |
Page 3 | ||||
A | B | C | D | E |
Data6 | Data6 | Data6 | Data6 | Data6 |
Data7 | Data7 | Data7 | Data7 | Data7 |
Data8 | Data8 | Data8 | Data8 | Data8 |
Data9 | Data9 | Data9 | Data9 | Data9 |
Data10 | Data10 | Data10 | Data10 | Data10 |
Page 4 | ||||
F | G | H | I | J |
Data6 | Data6 | Data6 | Data6 | Data6 |
Data7 | Data7 | Data7 | Data7 | Data7 |
Data8 | Data8 | Data8 | Data8 | Data8 |
Data9 | Data9 | Data9 | Data9 | Data9 |
Data10 | Data10 | Data10 | Data10 | Data10 |
Is this possible in XML Publisher report? Please suggest.
However, I am able to break the pages but the page sequences are not as per the requirement:
Page 1 | ||||
A | B | C | D | E |
Data1 | Data1 | Data1 | Data1 | Data1 |
Data2 | Data2 | Data2 | Data2 | Data2 |
Data3 | Data3 | Data3 | Data3 | Data3 |
Data4 | Data4 | Data4 | Data4 | Data4 |
Data5 | Data5 | Data5 | Data5 | Data5 |
Page 2 | ||||
A | B | C | D | E |
Data6 | Data6 | Data6 | Data6 | Data6 |
Data7 | Data7 | Data7 | Data7 | Data7 |
Data8 | Data8 | Data8 | Data8 | Data8 |
Data9 | Data9 | Data9 | Data9 | Data9 |
Data10 | Data10 | Data10 | Data10 | Data10 |
Page 3 | ||||
F | G | H | I | J |
Data1 | Data1 | Data1 | Data1 | Data1 |
Data2 | Data2 | Data2 | Data2 | Data2 |
Data3 | Data3 | Data3 | Data3 | Data3 |
Data4 | Data4 | Data4 | Data4 | Data4 |
Data5 | Data5 | Data5 | Data5 | Data5 |
Page 4 | ||||
F | G | H | I | J |
Data6 | Data6 | Data6 | Data6 | Data6 |
Data7 | Data7 | Data7 | Data7 | Data7 |
Data8 | Data8 | Data8 | Data8 | Data8 |
Data9 | Data9 | Data9 | Data9 | Data9 |
Data10 | Data10 | Data10 | Data10 | Data10 |
Regards,
Sambit
Answers
-
Can you upload your rtf and sample xml
0 -
PFA the sample xml and rtf file.
Here I have considered 5 columns and 20 rows.
And based on the row width, a page can accommodate maximum 11 rows. So, my expectation is :
Page 1 A B C D E Data1 Data1 Data1 Data1 Data1 : : : : : Data11 Data11 Data11 Data11 Data11 Page 2 F G H I J Data1 Data1 Data1 Data1 Data1 : : : : : Data11 Data11 Data11 Data11 Data11 Page 3
A B C D E Data12 Data12 Data12 Data12 Data12 : : : : : Data20 Data20 Data20 Data20 Data20 Page 4 F G H I J Data12 Data12 Data12 Data12 Data12 : : : : : Data20 Data20 Data20 Data20 Data20 0 -
please read the document carefully ,
<?horizontal-break-table:5?>
Here “5” represents number of columns to be repeated starting from left. If no columns should repeat than use “0” or leave blank as shown
The above lines states that if you give any number ,for example say 3 ,page 1 of first 3 columns will get repeat if page extends ,if you give 0 ,then it wont repeat any page 1 columns in page 2.
So in your case give number as 0 ,Thanks
0 -
Thanks for your update!
However, as per your suggestion in the article, using 'Horizontal page break' will help us in repeating a fixed number of columns on each page.
Like-
Page#1 will have:
Column1 Column2 Column3 Column4
Page#2 will have:
Column1 Column2 Column5 Column6
But this is not our requirement.
We don't want the columns to 'repeat' on subsequent pages, rather we want the columns to be splitted across as the pages like-
Page#1 will have:
Column1 Column2 Column3
Page#2 will have:
Column4 Column5 Column6
Please let us know if you have any suggestions for this.
Regards,
Sambit
0 -
follow below link,
Handling Vertical Page Break in RTF Templates
let me know if you have issues. Thanks
0 -
I have same issue. Can anyone help at earliest?
0 -
Thanks for your suggestion.
This solution worked fine for us!
0 -
This is perfect solution, Thanks a lot !!!
Enclosed the artifacts.
0