Excel report with a sheet per group

Thank you Lucian,

Those properties works fine. The only restriction is they only can be use with JRPrintElement, and Group isn't an instance of this class.

I resolved it adding a line at group footer with line width 0 (invisible). I set the net.sf.jasperreports.export.xls.break.after.row property to true in the line and the report break in each group.

I don't know if it was the best solution or you have another suggestion.

Miguel

Thank you for your post. I was able to generate a sheet per group using net.sf.jasperreports.export.xls.break.before.row.

However, I have another little issue : I don't know how to set the sheets' names.

I have 3 reports (3 jrxml) which generate an unique Excel file with 3 sheets. I tried setting the sheets' names with net.sf.jasperreports.export.xls.sheet.names.sheet1, net.sf.jasperreports.export.xls.sheet.names.sheet2 and net.sf.jasperreports.export.xls.sheet.names.sheet3 properties. The name of the first sheet is OK but the sheets 2 and 3 are named with the name of the first sheet following by 2 and 3.

For example, if the names are "toto", "titi" and "tutu", the sheets' names will be "toto", "toto 2" and "toto 3".

Are you able to define the sheets' names correctly ?

How did you export the 3 reports to the same XLS file? Using batch export (JASPER_PRINT_LIST export parameter)?

I use Java API :

        JasperPrint jasperPrintFeuilleTexte = JasperFillManager.fillReport(DirectoryLocator.getIntradocDir() + "custom/CustomizedContribution/resources/reports/stats-texte.jasper", paramsTexte, new JREmptyDataSource());
        JasperPrint jasperPrintFeuilleStatsPDV = JasperFillManager.fillReport(DirectoryLocator.getIntradocDir() + "custom/CustomizedContribution/resources/reports/stats-pdv.jasper", new HashMap(), statsPdvDataSource);
        JasperPrint jasperPrintFeuilleStatsCentrale = JasperFillManager.fillReport(DirectoryLocator.getIntradocDir() + "custom/CustomizedContribution/resources/reports/stats-centrale.jasper", new HashMap(), statsCentraleDataSource);
        List pagesStatsPDV = new ArrayList(jasperPrintFeuilleStatsPDV.getPages());
        for(int count = 0; count < pagesStatsPDV.size(); count++)
        {
            jasperPrintFeuilleTexte.addPage((JRPrintPage) pagesStatsPDV.get(count));
        }
        List pagesStatsCentrale = new ArrayList(jasperPrintFeuilleStatsCentrale.getPages());
        for(int count = 0; count < pagesStatsCentrale.size(); count++)
        {
            jasperPrintFeuilleTexte.addPage((JRPrintPage)pagesStatsCentrale.get(count));
        }
 

What exporter class did you use? The JRXlsExporter or the JExcelApiExporter?

JRXlsExporter

Where did you set the 3 sheet name config properties? In a jasperreports.properties file or in the first report template?

I tried in different locations :

- in the first report template

- in each report template

- in the JRXlsExporter parameters : exporterXLS.setParameter(JRXlsExporterParameter.SHEET_NAMES, new String[]{"toto", "titi", "tutu"});

I have the same results with all these locations.

Thank you

Thomas

I am using JasperReports 3.6.1.

Thomas

lucianc
Wrote:

Hi.

could anybody paste the code to use this properties. I don't know how i should use them.

Thank's a lot

I am still wondering if there is someone who can help me find the answer to my questions.

Great thanks...

The forum is working, but not necessarily in an "urgent" mode.

The properties I mentioned need to be set at element level, as documented.  So you'd have something like below in your report.

Regards,

Lucian

<textField>
	<reportElement x="0" y="0" ...>
		<property name="net.sf.jasperreports.export.xls.break.before.row" value="true"/>
	</reportElement>
</td></tr></tbody></table>

 Export time settings on iReport are not magically set in JasperServer - you'll have to find /WEB-INF/classes/jasperreports.properties and set them there.

1. Add this net.sf.jasperreports.export.xls.one.page.per.sheet and its value:true to the report's properties.

2. Add Group Band and give Group Expression in Group Header or in Group Footer.

3. Add a Page Brake in Page footer or Group footer or after the crosstab data or data.

4. Check on ignore pagination.

Result: You will find the Excel report with a sheet per group.