Suppress if duplicated

[maas]

Hello All,

I am having two rows which are duplicated and here is the structure in the details in my report.

Deal_no Comments Account No. Date Amount

How do I suppress the whole row based on the deal_no if it is duplicated. Is there is a way to do that in the select expert?

Thanks and regards

 

[fisheromacse]

you could use the following snippet by putting it in the details, suppress x+1 in the section expert.

{Table.deal_no}=previous({Table.deal_no})

 

[fisheromacse]

i forgot, you should add
Not(onfirstrecord)
before the rest of it.

 

[maas]

Thank you, I will try this and come back