How to handle multiple group details in Jasper?
<p>I have this set of records:</p>

<p>colors table.</p>

<pre><code>color_group | color_name | color_no
Primary     | Red        | 1
Primary     | Blue       | 3
Primary     | Yellow     | 2
Secondary   | Green      | 8
Secondary   | Violet     | 1
Secondary   | Orange     | 7
Others      | Pink       | 6
Others      | White      | 4
Others      | Black      | 5
</code></pre>

<p>I want to generate report like this.</p>

<pre><code>Primary
  Red        1
  Blue       3  
  Yellow     2
Secondary
  Green      8
  Violet     1
  Orange     7
Others
  Pink       6
  White      5
  Black      4
</code></pre>

<p>how can i display it like this in jasper report?</p>