title: Grouping records in JasperReports
body: <p>I have a problem with JasperReports. I want to group the records depending on one specific column's value.</p>
  
  <p>For example input data:</p>
  
  <pre><code>Name--email--PledgeType--amount
  aaa--aa@yahoo.com--1--20.00
  bbb--bb@yahoo.com--2--30.00
  ccc--cc@gmai.com--1--35.00
  ddd--dd@gmai.com--2-- 40.00
  </code></pre>
  
  <p>The output report will be grouped by the "PledgeType" value (1, 2, ... number):</p>
  
  <pre><code>Total for group one: 55.00
  Name email         amount
  aaa  aa@yahoo.com 20.00
  ccc  cc@gmai.com  35.00
  ------------------------------------
  Total for group two: 70.00
  Name email         amount
  bbb  bb@yahoo.com  30.00
  ddd  dd@gmai.com   40.00
  </code></pre>
  
  <p>Can JasperReports solve this problem? how?</p>