title: SSRS 2008 R2 - 'Complex' Grouping
body: <p>I have to create a report that requires grouping that doesn't seem to be straight forward in SSRS.</p>
  
  <pre><code>COL_ID   |    COL_FIELD1|  COL_FIELD2   | COL_FIELD 3
  ---------------------------------------------------------------------------
           |      ABC     |       |     CBA        
      1    |      DEF     |   5   |     LOT        
           |      GHI     |       |     JKH        
  ---------------------------------------------------------------------------
      2    |      UIO     |   7   |     JHG       
  ---------------------------------------------------------------------------
      6    |      PLK     |   6   |     HHJ        
           |      GTR     |       |           
  ---------------------------------------------------------------------------
  </code></pre>
  
  <p>Column COL_ID is the ID and identifies all 'cases'. If multiples cases under one ID,
  have the same values in a column the cells should be vertically merged and the value
  should be displayed only once.</p>
  
  <p>I hope the example table illustrates how it should look like.</p>
  
  <p>Any suggestions?</p>
  
  <p>Many thanks!</p>