Hi, I seem to be having trouble figuring out how to get two tables to print on separate sheets when exporting to Excel. My report simply consists of a header, group header (table 1), and group footer (table 2). I am looking for table 1 to display on a sheet labeled "Results" and table 2 to be on a sheet labeled "Summary".
Report layout:
Header
Group 1 Header 1
Group 1 Footer 2
I currently have the net.sf.jasperreports.export.xls.break.after.row set to "true" on my table 1 found on Group 1 Header 1. After running the report on the Jasper server and choosing export as Excel, everything shows up on one sheet. What am I doing wrong?