CODEWITHSUNDEEP
crystal-reports
mnu-nasir
mnu-nasir

Reputation: 1760

Crystal Report Record Selection Formula to Eliminate Duplicate Rows

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:

** *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

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.

  **Col_1      Col_2         Col_3**       
    0001       Apple         Nasir     
    0001       Apple         Nasir     
    0002       Orange        Babul     
    0003       Apple         Tutul     
    0004       Banana        Jasim     
    0004       Banana        Jasim

But I want to omit the duplicate data. So that the Crystal Report only shows the following data. 

**Col_1    Col_2     Col_3**       
  0001     Apple     Nasir     
  0002     Orange    Babul     
  0003     Apple     Tutul     
  0004     Banana    Jasim

Can anyone help me to write a crystal report record selection formula so that I may able to show the data as required? I am using Crystal Report 2008. Thanks.

Upvotes: 3

Views: 20938

Answers (3)

mnu-nasir
mnu-nasir

Reputation: 1760

I found a solution. Group by the all fields needed to show in the report. Then hide the details section. Then it is possible to show the distinct/ unique records.

All the best.

Upvotes: 4

Siva
Siva

Reputation: 9101

you can directly use the option Select Distinct Records available in Database menu... which will only select and show distinct records.

Upvotes: 2

cojimarmiami
cojimarmiami

Reputation: 659

you can create a formula that include those 3 columns(something like this Col_1 + Col_2 + Col_3), create a group based on that formula and place those 3 fields in that group.

Upvotes: 0

Related Questions