Header and Footer should not be Occupy the Rows

[kunkasurendra]

HI,

I am facing the issue in the JasperServer, when I am trying to export the report to Excel(XLS , XLSX and CSV), Main problem is ,I have created the report with Page Header and Footer and exported in Jasperserver, When I am exporting to excel, Header and footer is getting displayed in between the rows.Because of this calculations are getting effected.

Please see the attached current and expected excel sheets with this post.

In Current Result.xls, Header is occupied the Row1, but In Expected result, I did not occipied any row.
In Current Result.xls, Footer is occupied the Row48, but In Expected result, I did not occipied any row.
In Current Result.xls, Header is occupied the Row51, but In Expected result, I did not occipied any row.

Is it possible to display the Current Result.xls as Expected Result.xls.

Is there any JasperReports API option is abailable to get this done?

Please help us in to resolve this issue.It is stopped to continue the developement work.
 

 

Thanks,

Surendra

[szaharia]

Hi,

Maybe here is the answer.

HTH,

sanda