Page break in Excel and repeated Header on every page

0

Hello!

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"/>
..

            <textField>
                <reportElement x="1020" y="0" width="10" height="15" forecolor="#FFFFFF" uuid="73246961-8f9a-45f4-8991-b5352aaf31b3">
                    <property name="com.jaspersoft.studio.unit.height" value="px"/>
                    <property name="net.sf.jasperreports.export.xls.break.before.row" value="true"/>
                    <printWhenExpression><![CDATA[$F{PAGER_NEW}.equals("1")]]></printWhenExpression>
                </reportElement>
                <textFieldExpression><![CDATA[$V{Var1}]]></textFieldExpression>
            </textField>


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

Like 

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
Feedback
randomness