title: Ireport 5.0 Multiple Sheet Export to Excel
body: <p>I am attempting to split my report into multiple Excel sheets when I export from Jasperserver.</p>
  
  <p>Report Structure - Main page with four subreports.  A group header and footer for each subreport, the header contains the subreport element while in the footer I have placed page break elements with the property..</p>
  
  <pre><code>&lt;property name="net.sf.jasperreports.export.xls.break.after.row" value="true"/&gt; 
  </code></pre>
  
  <p>Placing the Pbreaks in the header/footer doesn't seem to make a difference and each subreport has ignore pagination checked (true).</p>
  
  <p>The main report has this property,</p>
  
  <pre><code>&lt;property name="net.sf.jasperreports.export.xls.one.page.per.sheet" value="true"/&gt;
  </code></pre>
  
  <p>I have read through similar questions on here and have not been able to produce any results with many different combinations.  Not sure if my problem is specific to Ireport 5.0.  </p>
  
  <p>EDIT: Per Zoran's suggestion, I got the report working! (now if only it wouldn't run out of memory) Here's the XML behind the text field.</p>
  
  <pre><code>&lt;textField&gt;
  &lt;reportElement uuid="73dc8dab-6ebf-4f47-bf8c-a1ab6b4b0454" x="0" y="0" width="100" height="1"&gt;
  &lt;property name="net.sf.jasperreports.export.xls.break.after.row" value="true"/&gt;
  &lt;/reportElement&gt;
  &lt;textElement/&gt;
  &lt;/textField&gt;
  </code></pre>