title: Display the first row in each group
body: <p>I have problem to display the first row in in each group in Reporting Service.</p>
  
  <pre><code>City     Name     Cash
  ----------------------
  Boston   James     10
        Mattias    5
        Adam       4
  
  LA    Sara      34
        Sakura    23
  
  NY    Melissa   69
        Jessica   34
  </code></pre>
  
  <p>I have used group on in row groups at Column City.</p>
  
  <p>The requested result would be:</p>
  
  <pre><code>City     Name      Cash
  -----------------------
  Boston   James      10
  LA    Sara       34
  NY    Melissa    69  
  </code></pre>