Suppressing duplicate detail lines

[TimothyP]

I did attempt to perform a search on the site but the search facility was down for maintenance.

How do I suppress duplicate detail lines in my report?
I only have one table in my report.

Thanks
TimothyP

 

[Chasidy]

You can format the fields individually on the report but going into format and saying "Supress if duplicated". You can also do more complex formula if you use the formula button to the side of suppress.

 

[TimothyP]

Chasidy,

Thank you for your response, however, this solution only suppresses the specific field form displaying more than once. The rest of the record still displays.

I do not want the duplicate detail record to show at all.

 

[Chasidy]

Ok - I'm newer at this newsgroup stuff - let me have another try.

Go to format section under the formula editor for suppress. if the duplicated information is technically a "distinct" id, you can use the formula

not (previousisnull({gift.giftid})) or {gift.giftID} = previous(gift.giftid})

This requires the report to be sorted (at some level) on the gift id.

This will suppress the entire duplicate record based on a duplicated field. This will not work however, if the duplicate data is not "distinct" (ie. two people with $100 gifts will cause the second person to be suppressed when they shouldn't).
- Chasidy

 

[kenhamady]

If all of the fields used by the report are duplicates, then you can go to the Database menu and use the Select-Distinct option at the bottom.

If not all are duplicates, you can group on the duplicate field(s) and then suppress the details, moving all of the display fields to the GF. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[shaunk]

Just a word of caution about suppressing which you probably already know.
Just because the fields are suppressed does not mean that they are excluded from summary calculations. It merely stops them from being displayed/printed.

 

[Transcend]

I think Ken is on the right track,

group on the field that is duplicating then display the details in the group footer.

Transcend

 

[TimothyP]

How can I group on multiple fields and place all of the details in one group footer?

If the Job ticket AND the Product id are the same, I do not want it on the report. I do not have any totaling issues at this time.

Date Job Ticket Product ID Qty
6/3/02 JT001 12345 5
6/3/02 JT001 12999 1
6/3/02 JT002 44444 3
6/3/02 JT003 77777 2
6/3/02 JT003 77777 2 (suppress this line)
6/3/02 JT004 77777 5
6/3/02 JT005 34642 2
6/3/02 JT006 12453 9

Thank you all for the knowledge!

 

[kenhamady]

Create a formula that combines (concatenates) these two fields, and group on the formula. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com