CR 11

Trying to suppress duplicates and the suppress duplicate tick box seems to do nothing.

so I created the following...

I have a formula field called DUP that contains the following formula is the suppress button in format field...

if {@DELTYPE}= previous ({@DELTYPE}) then 'true' else 'false'DUP

and in another formula field I have..

{@DUP}='TRUE'

The problem is if a duplicate exists that is not directly above it will not be suppressed.

Can anyone help with this?


Thanks

if @DelType is a combination of fields in the data, you can group by it, then they will be next to each other. Though in effect that is kevlray's answer of grouping and suppressing the details and only showing the header or footer of the group.

Why not sort on the field? That way, duplicates will be above it.