title: Jasper iReport Complex Crosstab Column and Row
body: <p>I want to create a crosstab report with Jasper iReport that has layout like this</p>
  
  <pre><code>**Date: 1 January 2012**
      Num  Transaction        Blue      Red       Total
      1   | Bank Wire     |     2   |    5    |     7
      2   | Credit Card   |     1   |    2    |     3
      3   | Cheque        |     1   |    1    |     2
      ------------------------------------------------
      Total 
      Bank Wire &amp; Credit  |     3   |    7    |    10
      ------------------------------------------------
      Total All           |     4   |    8    |    12  
  
  
  **Date: 2 January 2012**
      Num  Transaction        Blue      Red       Total
      1   | Bank Wire     |     0   |    1    |     1
      2   | Credit Card   |     2   |    2    |     4
      3   | Cheque        |     1   |    1    |     2
      ------------------------------------------------
      Total 
      Bank Wire &amp; Credit  |     2   |    3    |     5
      ------------------------------------------------
      Total All           |     3   |    4    |     7 
  
  
      --------------------------xx-----------------------
      --------------------------xx-----------------------
      Total 
      All Bank Wire 
      &amp; Credit            |     5   |    10   |    15
      ----------------------------------------------------
      Total
      All Transaction     |     7   |    12   |    19
      --------------------------xx-----------------------
      --------------------------xx-----------------------
  </code></pre>
  
  <p>It is very complex, and in my own logic thinking I feel like its a crosstab in a subreport? And also Crosstab doesnt allow addition of single column or row, only row groups so that is a bit difficult.. </p>
  
  <p>Right now I can only create a crosstab with a Transaction, Blue, Red and Total column, 
  and Total All Bank Wire &amp; Credit and Total All Transaction</p>
  
  <p>I still can't do Num column, though!</p>
  
  <p>Also, I can only make a crosstab counts in the whole date range (1 to 2 January) instead of for each date.. so I still can't do Total Bank Wire &amp; Credit and Total All according to each date</p>
  
  <p>Jasper iReport forum also doesn't seem to be active..  </p>