Hi All,
I have one data visibility problem. Please help me out. kindly refer the below given example.
I am trying to generate PDF file using Java, with the help of "Dynamic Report" framework.
If I have 20 records with 20 columns, and my PDF page can contain only 10 records with 10 columns at a time. In this case my data is coming like on first page of PDF; first 10 records are displaying with first 10 columns, on second page next 10 records are displaying with first 10 columns and then remaining columns of first 10 records are displaying on next page and so.
But I want my output to be like on first page my first 10 records should come with first 10 columns and then on second page next 10 columns of first 10 records should display instead of next records' first 10 columns.
Because if I have thousands of records, in this case it is weird to display remaining columns of my first 10 records after my thousandth record.
Kindly suggest me the solution.
Additional information: org.apache.poi version : 3.7
Current output (If I have 10 records with 8 columns and each page can contain only 5 records with 5 columns):
Col1
Col2
Col3
Col4
Col5
Val1_1
Val1_2
Val1_3
Val1_4
Val1_5
Val2_1
Val2_2
Val2_3
Val2_4
Val2_5
Val3_1
Val3_2
Val3_3
Val3_4
Val3_5
Val4_1
Val4_2
Val4_3
Val4_4
Val4_5
Val5_1
Val5_2
Val5_3
Val5_4
Val5_5
Col1
Col2
Col3
Col4
Col5
Val6_1
Val6_2
Val6_3
Val6_4
Val6_5
Val7_1
Val7_2
Val7_3
Val7_4
Val7_5
Val8_1
Val8_2
Val8_3
Val8_4
Val8_5
Val9_1
Val9_2
Val9_3
Val9_4
Val9_5
Val10_1
Val10_2
Val10_3
Val10_4
Val10_5
Col6
Col7
Col8
Val1_6
Val1_7
Val1_8
Val2_6
Val2_7
Val2_8
Val3_6
Val3_7
Val3_8
Val4_6
Val4_7
Val4_8
Val5_6
Val5_7
Val5_8
Col6
Col7
Col8
Val6_6
Val6_7
Val6_8
Val7_6
Val7_7
Val7_8
Val8_6
Val8_7
Val8_8
Val9_6
Val9_7
Val9_8
Val10_6
Val10_7
Val10_8
Expected output :
Col1
Col2
Col3
Col4
Col5
Val1_1
Val1_2
Val1_3
Val1_4
Val1_5
Val2_1
Val2_2
Val2_3
Val2_4
Val2_5
Val3_1
Val3_2
Val3_3
Val3_4
Val3_5
Val4_1
Val4_2
Val4_3
Val4_4
Val4_5
Val5_1
Val5_2
Val5_3
Val5_4
Val5_5
Col6
Col7
Col8
Val1_6
Val1_7
Val1_8
Val2_6
Val2_7
Val2_8
Val3_6
Val3_7
Val3_8
Val4_6
Val4_7
Val4_8
Val5_6
Val5_7
Val5_8
Col1
Col2
Col3
Col4
Col5
Val6_1
Val6_2
Val6_3
Val6_4
Val6_5
Val7_1
Val7_2
Val7_3
Val7_4
Val7_5
Val8_1
Val8_2
Val8_3
Val8_4
Val8_5
Val9_1
Val9_2
Val9_3
Val9_4
Val9_5
Val10_1
Val10_2
Val10_3
Val10_4
Val10_5
Col6
Col7
Col8
Val6_6
Val6_7
Val6_8
Val7_6
Val7_7
Val7_8
Val8_6
Val8_7
Val8_8
Val9_6
Val9_7
Val9_8
Val10_6
Val10_7
Val10_8
Thanks in advance!
Regards
Shikha