only show duplicates

[giggles7840]

ok, question, i need to show only the duplicate rows. I looked through some old threads and tried reversing the process of eliminating dups....

i am using:

previous({LsaAcct.BranchNbr})<> {LsaAcct.BranchNbr}

this is almost great. it shows me which records are the dups, but it only shows one line. I need this report to show every dup line.

For instance:

right now i see:
Group1
DetailDup1

I need to see:
Group1
DetailDup1
DetailDup1
DetailDup1

How do i bring back my hiding records?

 

[dgillz]

Is there one field or a series of fileds that makes this a duplicate row? If so please advise the deatails and I will show you how to do this.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[synapsevampire]

What constitutes a dupe is key as many consider a single column repeqting a dupe, when a dupe really means that every column of the rows duplicate.

One way you might do this is to group on some field that should be unique but is duplicated and select Report->Edit Selection Formula->Group

Place something like:

distinctcount({table.field}, {table.group}) > 1

-k

 

[giggles7840]

its just one column determining what is a dup.

 

[giggles7840]

yeah this wont work:
distinctcount({table.field}, {table.group}) > 1
any other suggestions you could give me?

the dup isnt a true dup, its one column that has duplicate values and i only need to show the records where the values are duplicated.

please help. thanks, danielle

 

[MrBillSC]

Use the "Previous", "Next", "OnFirstRecord", and "OnLastRecord" functions.
In the Detail section, suppress if:
(OnFirstRecord and "Next" <> to current record) OR
(OnLastRecord and "Previous" <> to current record) OR
(Not (OnFirstRecord) and Not(OnLastRecord) and
"Next" <> current record and "Previous" <> current record

MrBill

 

[lbass]

You should first group on the duplicate field and then go to report->edit selection formula->GROUP and enter:

count({table.grpfield},{table.grpfield}) > 1

This will show only the records that are duplicated (for that field).

-LB

 

[safari7391]

Crystal Reports XI
Windows 2000 Pro
Access Database
ODBC connection

I am having a problem with duplicate records in the detail section. These records are to show as a single record so I can be able to sort on them through a parameter.

How they are shown now - Example:

Group1
DetailUser1
DetailUser2
DetailUser3
DetailUser2
DetailUser4

As you can see the DetailUser2 is showing up twice.

How I would like them to look - Example:

Group1
DetailUser1
DetailUser3
DetailUser2
DetailUser4

I am using the following formula under the Section Expert in the Detail Suppress section, but its not suppressing all of the duplicates.

not onfirstrecord and
{@Agent_Name} = previous({@Agent_Name})

 

[lbass]

Add a sort on {table.detailuser}--then the suppression should work. Go to report->sort records and add the field there.

-LB

 

[safari7391]

Thank you LB for the tip.