de dupe records??? 1

[ombina]

Hi,

If I have:

222
222
333
333
333
444
555
555

How can I make it unique.

Thanks,

Ricky

Thanks,

Ricky

 

[lbass]

If the entire row is duplicated, you can go to database-> and check "select distinct records." If you just want to get rid of field duplicates, you can go to format field and check "suppress duplicate records." If you want to suppress an entire row based on duplicate records, you can go to format section->details->suppress->x+2 and enter:

{yourfield} = previous({yourfield})

Another method is to group on the duplicated field and drag fields into the group header or footer and then suppress the details. If you choose the suppression route, suppressed records will contribute to summaries, so you should use running totals or conditional formulas for counts, etc.

-LB