title: Crystal Report Record Selection Formula to Eliminate Duplicate Rows
body: <p>I have created a view in oracle database. The view represents the following data. There are some duplicate data is available in that view. I need to have these duplicate data also. The data represents are:</p>
  
  <pre><code>** *Col_1     Col_2     Col_3      Col_4***
      0001      Apple     Nasir      Cat
      0001      Apple     Nasir      Rat
      0002      Orange    Babul      Cat
      0003      Apple     Tutul      Cow
      0004      Banana    Jasim      Goat
      0004      Banana    Jasim      Goat
  </code></pre>
  
  <p>Now I have used this view as data source of my Crystal Report. I am showing only Col_1, Col_2, Col_3 columns record in my crystal report. So the crystal report is showing the following data.</p>
  
  <pre><code>  **Col_1      Col_2         Col_3**       
      0001       Apple         Nasir     
      0001       Apple         Nasir     
      0002       Orange        Babul     
      0003       Apple         Tutul     
      0004       Banana        Jasim     
      0004       Banana        Jasim     
  </code></pre>
  
  <p>But I want to omit the duplicate data. So that the Crystal Report only shows the following data. </p>
  
  <pre><code>**Col_1    Col_2     Col_3**       
    0001     Apple     Nasir     
    0002     Orange    Babul     
    0003     Apple     Tutul     
    0004     Banana    Jasim   
  </code></pre>
  
  <p>Can anyone help me to write a <strong>crystal report record selection formula</strong> so that I may able to show the data as required? I am using Crystal Report 2008.
  Thanks.</p>