Oracle Analytics Cloud and Server

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

Split Multiple columns across pages in BIP report

Received Response
52
Views
8
Comments

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

ABCDEFGHIJ
Data1Data1Data1Data1Data1Data1Data1Data1Data1Data1
Data2Data2Data2Data2Data2Data2Data2Data2Data2Data2
Data3Data3Data3Data3Data3Data3Data3Data3Data3Data3
Data4Data4Data4Data4Data4Data4Data4Data4Data4Data4
Data5Data5Data5Data5Data5Data5Data5Data5Data5Data5
Data6Data6Data6Data6Data6Data6Data6Data6Data6Data6
Data7Data7Data7Data7Data7Data7Data7Data7Data7Data7
Data8Data8Data8Data8Data8Data8Data8Data8Data8Data8
Data9Data9Data9Data9Data9Data9Data9Data9Data9Data9
Data10Data10Data10Data10Data10Data10Data10Data10Data10Data10

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
ABCDE
Data1Data1Data1Data1Data1
Data2Data2Data2Data2Data2
Data3Data3Data3Data3Data3
Data4Data4Data4Data4Data4
Data5Data5Data5Data5Data5
Page 2
FGHIJ
Data1Data1Data1Data1Data1
Data2Data2Data2Data2Data2
Data3Data3Data3Data3Data3
Data4Data4Data4Data4Data4
Data5Data5Data5Data5Data5
Page 3
ABCDE
Data6Data6Data6Data6Data6
Data7Data7Data7Data7Data7
Data8Data8Data8Data8Data8
Data9Data9Data9Data9Data9
Data10Data10Data10Data10Data10
Page 4
FGHIJ
Data6Data6Data6Data6Data6
Data7Data7Data7Data7Data7
Data8Data8Data8Data8Data8
Data9Data9Data9Data9Data9
Data10Data10Data10Data10Data10

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
ABCDE
Data1Data1Data1Data1Data1
Data2Data2Data2Data2Data2
Data3Data3Data3Data3Data3
Data4Data4Data4Data4Data4
Data5Data5Data5Data5Data5
Page 2
ABCDE
Data6Data6Data6Data6Data6
Data7Data7Data7Data7Data7
Data8Data8Data8Data8Data8
Data9Data9Data9Data9Data9
Data10Data10Data10Data10Data10
Page 3
FGHIJ
Data1Data1Data1Data1Data1
Data2Data2Data2Data2Data2
Data3Data3Data3Data3Data3
Data4Data4Data4Data4Data4
Data5Data5Data5Data5Data5
Page 4
FGHIJ
Data6Data6Data6Data6Data6
Data7Data7Data7Data7Data7
Data8Data8Data8Data8Data8
Data9Data9Data9Data9Data9
Data10Data10Data10Data10Data10

Regards,

Sambit

Answers

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

    Can you upload your rtf and sample xml

  • Sambit Kumar
    Sambit Kumar Rank 3 - Community Apprentice

    ​ 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
    ABCDE
    Data1Data1Data1Data1Data1
    :::::
    Data11Data11Data11Data11Data11

    Page 2
    F
    GHIJ
    Data1Data1Data1Data1Data1
    :::::
    Data11Data11Data11Data11Data11

    Page 3

    ABCDE
    Data12Data12Data12Data12Data12
    :::::
    Data20Data20Data20Data20Data20

    Page 4
    F
    GHIJ
    Data12Data12Data12Data12Data12
    :::::
    Data20Data20Data20Data20Data20

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    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

  • Sambit Kumar
    Sambit Kumar Rank 3 - Community Apprentice

    Hi

    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

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    follow below link,

    Handling Vertical Page Break in RTF Templates

    let me know if you have issues. Thanks

  • Vikram Unde
    Vikram Unde Rank 2 - Community Beginner

    I have same issue. Can anyone help at earliest?

  • Sambit Kumar
    Sambit Kumar Rank 3 - Community Apprentice

    Thanks for your suggestion.

    This solution worked fine for us!

  • Vikram Unde
    Vikram Unde Rank 2 - Community Beginner

    This is perfect solution, Thanks a lot !!!

    Enclosed the artifacts.