Excel and long groups

[2005 IR Help]

By: Henrik Bentel - hbentel

Excel and long groups

2004-10-05 15:42

Hi

 

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);

exporter.exportReport();

 

 

 

 

 

By: Henrik Bentel - hbentel

RE: Excel and long groups

2004-10-07 08:56

Nope, this just prints everything on one Excel sheet.