Jasper: Excel report with two tabs.

[mannu shukla]

I want to generate an excel report with two tabs only. Actually I want to put summary section in second tab. I tried below tricks but not able to generate the desired report.

Approach 1: Set 'Ignore Pagination = true' and 'Summary on a New Page = true'
Report generated in one tab only. (Failed)

Approach 2: Set 'Ignore Pagination = false' and 'Summary on a New Page = true' and JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET = true
Report generated with more than two pages.(Failed. I only need summary section in second tab)

I will be very thankful if anyone can help me to resolve my problem.