Jasper Reports - How to Create One Sheet per Group in Excel Export



I am attempting to design some reports in Jaspersoft Studio. The end goal is to incorporate the compiled reports into a Java application (using Jasper Reports Library), but I am doing the initial design in Jaspersoft Studio. I have a need to create an Excel export with one tab per group. It works fine EXCEPT in the case when a group spans multiple pages; in such cases, the group is split into multiple tabs.

I have referenced https://community.jaspersoft.com/wiki/splitting-excel-output-multiple-tabs and some questions on this community forum but have yet to find a solution.

What I have tried:

1. Setting "net.sf.jasperreports.export.xls.break.after.row" equal to true in my group footer and "net.sf.jasperreports.export.xls.one.page.per.sheet" to true. Result: Described above. Some groups take up more than one sheet.

2. Same as (1), but checking Ignore Pagination and setting "net.sf.jasperreports.page.break.no.pagination " to "apply". Result: All groups on one page.

3. Setting "net.sf.jasperreports.export.xls.break.after.row" equal to true in my group footer and "net.sf.jasperreports.export.xls.one.page.per.sheet" to false. Result: All groups on one page.

Group definition:

<group name="PropertyGroup">
            <band height="25">
                <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.grid.JSSGridBagLayout"/>
                    <reportElement mode="Opaque" x="0" y="0" width="555" height="25" uuid="e128eeba-9972-4aaa-94a3-eae4ca1b0f65">
                        <property name="com.jaspersoft.studio.unit.height" value="px"/>
                        <property name="com.jaspersoft.layout.grid.x" value="1"/>
                        <property name="com.jaspersoft.layout.grid.y" value="-1"/>
                        <property name="com.jaspersoft.layout.grid.weight.x" value="1.0"/>
                        <property name="com.jaspersoft.layout.grid.weight.y" value="1.0"/>
                        <property name="com.jaspersoft.layout.grid.rowspan" value="1"/>
                        <property name="com.jaspersoft.layout.grid.colspan" value="1"/>
                        <property name="com.jaspersoft.layout.grid.weight.fixed" value="false"/>
                    <textFieldExpression><![CDATA["#" + $F{store}]]></textFieldExpression>
            <band height="15">
                <property name="net.sf.jasperreports.export.xls.break.after.row" value="true"/>

Any advice would be appreciated. If this is an option that is better performed programmatically through the library that is an option as well.


kmarchewa's picture
Joined: Aug 23 2019 - 10:43am
Last seen: 1 month 5 days ago

1 Answer:


You could try the property keepTogether:

<group name="group1" keepTogether="true">

anji.viper's picture
Joined: Mar 8 2017 - 2:59am
Last seen: 4 weeks 1 day ago