Jump to content
Changes to the Jaspersoft community edition download ×

Excel and long groups

2005 IR Help

Recommended Posts

By: Henrik Bentel - hbentel

Excel and long groups

2004-10-05 15:42



I have reports where the groups span multiple pages.

When I export to Excel, it seems to break to a new sheet for every page, unless I take everything on one page.


Question is: Is there currently a way to in the Excel export to break to a new sheet based on the group? Assuming only one group of course?








By: ani - vijani

RE: Excel and long groups

2004-10-06 20:40

Check if this code can be used in ur scenario.


JRXlsExporter exporter = new JRXlsExporter();

exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);

exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, destFile.toString());

exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);

exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);







By: Henrik Bentel - hbentel

RE: Excel and long groups

2004-10-07 08:56

Nope, this just prints everything on one Excel sheet.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...