Show only duplicate records 1

[AuctionLamb]

Hi guys!!

Maybe I am doing something wrong here or just something small that I can't figure out. I have a view that brings back records. In my Crystal Report I want only to display the PRNumbers that is duplicated. I have tried the > "1" syntax but still get non duplicates back? In my view I have done a COUNT(*) on the PRNumber but then I have to group it and still gives me an error. So I have done a normal view that returns the records and let Crystal do the validation. HELP PLEASE!!

I am using CR 8.5

 

[Madawc]

Group by PRNumber. Count within each group - use a summary total. Then choose Report > Selection Formula > Group and select only those where the group count is greater than 1.

You'll find this gives you more lines than you want. Suppress either the group header / footer or the details.

Madawc Williams (East Anglia, UK)

 

[AuctionLamb]

THANKS!!