Export Excel - One table per sheet

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:


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?

helloterence's picture
Joined: Jul 23 2013 - 8:34am
Last seen: 9 years 3 weeks ago

1 Answer:

Try with sub reports!

pssp25's picture
Joined: Feb 28 2013 - 6:58am
Last seen: 9 years 8 months ago