Page break in Excel and repeated Header on every page



I have huge report which generated in XLSX format. Count of rows over 3 000 000

For correct all rows divided by some principal and i get many pages in Excel . On every page count rows < 1 000 000

So i made it this way: 

    In SQL request  i make Page-switcher like this

<field name="PAGER_NEW" class="java.lang.String"/>

<variable name="Var1" class="java.lang.String"/>

                <reportElement x="1020" y="0" width="10" height="15" forecolor="#FFFFFF" uuid="73246961-8f9a-45f4-8991-b5352aaf31b3">
                    <property name="" value="px"/>
                    <property name="net.sf.jasperreports.export.xls.break.before.row" value="true"/>

So work perfect but I want header on every page will the same


Page0  - header - detail data

Page1 - header - detail data

PageN - header - detail data


Now :

Page0  - header - detail data

Page1  - detail data

PageN  - detail data


How i can do it?



sharkoff76's picture
Joined: Jan 21 2020 - 12:07am
Last seen: 1 month 3 weeks ago

0 Answers:

No answers yet