Suppress Duplicate records.
Posted on 2005-05-16
I have group1 that prints "x" amount of records in order to produce a separate report for each record. There are times when the records are duplicates, and I do not want to process the dups. I then have group2 that processes these same records, and lists them within each report. I need it to show the duplicates within the report, but not print it when processing group1.
I need suppress duplicate occurences within Group 1. Group1 is used specicially to print reports all the records processed.
However, I need all the records displayed within each report.
How can I create a suppression formula for group1 not to process duplicate records? I tried selecting distinct records within the Database menu without luck. Thanks...