How to Retrieve Duplicate Data 1

[austin22]

Hello,

I am using Crystal 8.5 and I am needing some help with a formula.

Here is how my data looks:
Grouped by License # and then by Name
______________________________________
Doe, Jane License #555KL5
Duck, Donald License #555KL5
_______________________________________

I want to be able to retrieve data with different names but the same license number for each name only....eliminate the other data.

 

[lbass]

Insert a group on License # and then go to report->selection formula->GROUP and enter:

distinctcount({table.name},{table.license#}) > 1

This will display on the dupes. You will then have to use running totals if you plan any calculations across displayed groups, since non-group selected records would still contribute to the more usual inserted summaries.

-LB

 

[austin22]

Thanks a bunch. I was missing the >1 piece. Thanks again.
austin22

 

[austin22]

One more issue. I have determined the dupes and now I want to further the filtering of my data by showing cases with the same offense date. Here is what I have:

Group One

Doe, Jane 06.04.06 555KL5
Duck, Donald 06.04.06 555KL5

Doe, John 12.15.06 555KL5
Duck, Daffy 12.31.06 555KL5

I now, want to show cases with the same offense date and same license number.

I am using Crystal 8.5. Thanks for your help.

 

[austin22]

Revised - ;-)

One more issue. I have determined the dupes and now I want to further the filtering of my data by showing cases with the same offense date. Here is what I have:

Grouped by License number and then by Name
_______________________________________
1 Doe, Jane 06/04/06 555KL5
2 Doe, Jane 06/04/06 555KL5

3 Doe, Jane 12/15/06 555KL5
4 Duck, Daffy 06/04/06 555KL5
________________________________________
I now, want to show cases with the same offense date and same license number. In this example case numbers 1, 2 and 4 will need to display on the report.

I am using Crystal 8.5. Thanks for your help.

 

[lbass]

distinctcount({table.name},{table.license#}) > 1 and
distinctcount({table.date},{table.license#}) = 1

-LB

 

[austin22]

Thank you for your help.