title: Crystal Reports - Select distinct records in group
body: <p>I'm trying to figure out how to show distinct records in groups in crystal reports.  The view I wrote returns something like this:</p>
  
  <pre><code>Field 1  |  Field 2  |   Field 3
  ----------------------------------
      10   |   111     |  Record Info 1
      10   |   111     |  Record Info 1
      10   |   222     |  Record Info 2
      20   |   111     |  Record Info 1
      20   |   222     |  Record Info 2
  </code></pre>
  
  <p>The report groups are based off field one, and I want distinct fields 2 and 3 for each group:</p>
  
  <pre><code>Field 1  |  Field 2  |   Field 3
  ----------------------------------
      10   |   111     |  Record Info 1
      10   |   222     |  Record Info 2
      20   |   111     |  Record Info 1
      20   |   222     |  Record Info 2
  </code></pre>
  
  <p>Field 2 and 3 are always the same, Field 1 acts as an FK reference to any entries in the view.  Selecting <code>distinct xxx</code> in the view isn't really viable due to the huge amount of columns being brought in.</p>
  
  <p>Can this be done in CR?</p>
  
  <p>Cheers</p>