Extract non duplicate records from spreadsheet?

[CherrySoda]

I'm using Crystal 10 with an Excel spreadsheet as one datasource and in Interbase db as another. They are linked by a Client_ID field.

Some of the records on the excel spreadsheet have the same Client_ID. I only want to extrace records where the Client_ID only appears on the spreadsheet once.

So for example,

Name Client_id
Jim 1234
John 4567
Mary 7890
Jim 1234
Bill 5469

The report would only extact John, Mary, and Bill because the Client_id 1234 is there twice. I know that I can build a formula in the field supress formula section, but I would much rather not even have the duplicated not make it that far. Can I use the selection criteria too accomplsh this?

Also, I would like to be able to do the opposite. Pull only the records where the Client_id is listed more than once.

 

[dgillz]

Use a GROUP selection, rather than a record selection. Group by client ID and the criteria would be where the count by client ID = 1.

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

http://www.gainfocus.biz

"What version of URGENT!!! are you using?