Export subreports in multiple worksheets in excel


I’ve going through lot of posts to make export to excel in multi tab working on JasperReportsServer.

I’ve 3 sub reports which are needed to be exported in separate tabs in excel. Tried various approaches as below

added following properties in jrxml in line element in each subreport. The set up works without any issues in Jaspersoft Studio i.e. development environment. However when I put the report to JasperReportsServer, I get the exported excel in one tab only.



also tried setting following property


thirdly, Have also set on JasperServer, in WEB-INF/classes/jasperreports.properties,

# report exporter hints override export parameters net.sf.jasperreports.export.parameters.override.report.hints=false

Not sure if I need to update anything in the export parameters (parameters to the exporter classes) defined in WEB-INF/applicationContext.xml

There are numerous posts suggesting fix however I could not get this working. Would be great if any pointers on same are provided.

Thank you in advance...

sach411's picture
Joined: Mar 26 2015 - 10:51am
Last seen: 4 years 4 months ago

Dear all, Any inputs on same? 

May be some working example will help


sach411 - 8 years 1 week ago

1 Answer:

my experience is that



do work only in some type of elements, such as static field, textfield and so on. It did work fine when placed in the very first (left-top) such element.


pickl's picture
Joined: Jun 30 2016 - 6:43am
Last seen: 1 year 11 months ago