Clever Geek Handbook

Crystal Report selection formula to eliminate duplicate rows

I created a view in oracle database. The view presents the following data. There are some duplicate data in this view. I also need this duplicated data. The data is:

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

I have now used this view as the data source for my Crystal Report. I only show columns Col_1, Col_2, Col_3 in my crystal report. Therefore, the following data is displayed in the crystal report.

  **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 duplicate data. To have the Crystal Report display only 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 write a crystal report logging report formula so that I can show the data as needed? I am using Crystal Report 2008. Thanks.

+3


source to share


3 answers


I found a solution. Group by all fields to be displayed in the report. Then hide the details section. You can then show individual / unique records.



All the best.

+2


source


you can directly use the option Select Distinct Records

available in the menu Database

... which will only select and display individual entries.



+2


source


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

0


source






More articles:


All Articles