Page header repeating twice

[ankushchhabra]

 Hi Everyone,

 

I want column header to appear on every page in report and only once in excel export. So i moved all the column textbox to page header band and set the following properties in jasperreport.properties.

net.sf.jasperreports.export.xls.exclude.origin.band.1=pageHeader

net.sf.jasperreports.export.xls.exclude.origin.band.2=pageFooter

net.sf.jasperreports.export.xls.exclude.origin.band.3=columnHeader

net.sf.jasperreports.export.xls.exclude.origin.band.4=columnFooter

net.sf.jasperreports.export.xls.exclude.origin.keep.first.band.5=pageHeader

 

Now, I am facing an issue of page header getting repeated twice in excel export. First it occur on very first row and then repeat

itself on 50th row.

 

Thanks and Regards,

Anksuh

 

[jogjoe]

to get optimal Excel export we use following Properties  :

net.sf.jasperreports.export.xls.exclude.origin.band.1=pageHeader

net.sf.jasperreports.export.xls.exclude.origin.band.2=pageFooter

net.sf.jasperreports.export.xls.exclude.origin.keep.first.band.1=columnHeader

net.sf.jasperreports.export.xls.remove.empty.space.between.rows=true

net.sf.jasperreports.export.xls.remove.empty.space.between.columns=true

 

Regards

Joe