title: Jasper report sum group totals in separate group and report summary
body: <p>I have a report that is structured as follows:</p>
  
  <p>Column header section
  -all static text headers</p>
  
  <p>Group A Header:
  ID</p>
  
  <p>Group B Header:
  Date</p>
  
  <p>Group C Header:
  Currency Type</p>
  
  <p>Detail Band:
  Different Currency Values</p>
  
  <p>Group C Footer:
  Total Currency Value by Currency Type</p>
  
  <p>Summary Band</p>
  
  <hr>
  
  <p>What I now need is to add totals per currency type per ID as well as totals per currency type overall in the summary e.g.:</p>
  
  <pre><code>ID: 1234
  Date:  01/01/2003
  Currency: USD 
  50 USD 
  25 USD
  10 USD
  USD Total: 85
  
  Currency: EUR
  30 EUR
  20 EUR
  EUR Total: 50
  
  Date: 01/05/2004
  Currency: USD 
  50 USD 
  25 USD
  10 USD
  USD Total: 85
  
  Currency: EUR
  30 EUR
  20 EUR
  EUR Total: 50
  
  1234 Totals: 
   USD 170
   EUR 100
  
  
  Report Totals:
   USD 170
   EUR 100
  </code></pre>
  
  <p>I've tried a lot of different things. I've added variables with increment or reset group of ID to get those totals in the ID footer but they always just sum the complete values across currencies without taking currency type into consideration. I've tried to use subreports in those places that do the summation in their own reports in groups without success (always empty/null in main report regardless of data connection being passed). I'm using eclipse with the jaspersoft studio plugin, so the UI design is very limiting. Mainly trying to do it all through modification of the .jrxml directly. </p>
  
  <p>Any help would be greatly appreciated. 
  Thanks!</p>