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 ABCDEFGHIJData1Data1Data1Data1Data1Data1Data1Data1Data1Data1Data2Data2Data2Data2Data2Data2Data2Data2Data2Data2Data3Data3Data3Data3Data3Data3Data3Data3Data3Data3Data4Data4Data4Data4Data4Data4Data4Data4Data4Data4Data5Data5Data5Data5Data5Data5Data5Data5Data5Data5Data6Data6Data6Data6Data6Data6Data6Data6Data6Data6Data7Data7Data7Data7Data7Data7Data7Data7Data7Data7Data8Data8Data8Data8Data8Data8Data8Data8Data8Data8Data9Data9Data9Data9Data9Data9Data9Data9Data9Data9Data10Data10Data10Data10Data10Data10Data10Data10Data10Data10 Requirement: To split the data so that each page will have only 5 columns and 5 rows as below: *page sequence is important* Page 1ABCDEData1Data1Data1Data1Data1Data2Data2Data2Data2Data2Data3Data3Data3Data3Data3Data4Data4Data4Data4Data4Data5Data5Data5Data5Data5Page 2FGHIJData1Data1Data1Data1Data1Data2Data2Data2Data2Data2Data3Data3Data3Data3Data3Data4Data4Data4Data4Data4Data5Data5Data5Data5Data5Page 3ABCDEData6Data6Data6Data6Data6Data7Data7Data7Data7Data7Data8Data8Data8Data8Data8Data9Data9Data9Data9Data9Data10Data10Data10Data10Data10Page 4FGHIJData6Data6Data6Data6Data6Data7Data7Data7Data7Data7Data8Data8Data8Data8Data8Data9Data9Data9Data9Data9Data10Data10Data10Data10Data10 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 1ABCDEData1Data1Data1Data1Data1Data2Data2Data2Data2Data2Data3Data3Data3Data3Data3Data4Data4Data4Data4Data4Data5Data5Data5Data5Data5Page 2ABCDEData6Data6Data6Data6Data6Data7Data7Data7Data7Data7Data8Data8Data8Data8Data8Data9Data9Data9Data9Data9Data10Data10Data10Data10Data10Page 3FGHIJData1Data1Data1Data1Data1Data2Data2Data2Data2Data2Data3Data3Data3Data3Data3Data4Data4Data4Data4Data4Data5Data5Data5Data5Data5Page 4FGHIJData6Data6Data6Data6Data6Data7Data7Data7Data7Data7Data8Data8Data8Data8Data8Data9Data9Data9Data9Data9Data10Data10Data10Data10Data10 Regards, Sambit

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Split Multiple columns across pages in BIP report

Sambit Kumar

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

Find more posts tagged with

Accepted answers

All comments

Brajesh Shukla-95078

Can you upload your rtf and sample xml

Sambit Kumar

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

Venkat Thota - BIP

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.