How to 2 cross tab data set value get in 2 different excel tab ?

[naveendewase]

Hi, I have 2 cross tab one for question type rating one for question type essay .

for each question type i need different excel tab

when we exporting data into excel so data fill on 2 tabs.

also their is provision of jasper for multitabs on jasper studio according to dataset .

its very argent 

Thanks,

Naveen Dewase

[butlerc]

<?xml version="1.0" encoding="UTF-8"?>

Hopefully the source is also availabel here, incase it's not.

Add a report level property: net.sf.jasperreports.export.xls.one.page.per.sheet set the value to true

This property will force a new tab on every page, so if your using crosstabs - you should add pagebreak element between your crosstabs, you might need to play with the settings a bit as depending on how large your crosstabs are they may already go over multiple pages.

NOTE: This will only work with the xlsx pagination export option on Jasperserver, it will work fine in Studio regardless.