I need that the report could be exported to excel format with the autofilter and a crossbar on separate sheet. So for that purpose i set a "Break Before" property on one of the cells in first row in a crosstab. Works great - crosstab moves to separate sheet, but autofilter dissapears.
I use the following properties to place crosstab on the separate sheet:
<property name="net.sf.jasperreports.export.xls.break.before.row" value="true"/> <property name="net.sf.jasperreports.export.xls.sheet.name" value="Summary"/>
No answers yet