Export subreports in multiple worksheets in excel

Hi,

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.

net.sf.jasperreports.export.xls.break.before.row

net.sf.jasperreports.export.xls.break.after.row

also tried setting following property

net.sf.jasperreports.export.xls.one.page.per.sheet

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