How to suppress duplicate fields (not records) ?

[timbaktuu]

Hi Everyone,

How do I suppress duplicate fields (not records) in detail section:

the data is as follows

9:00 Kathy
9:00 Kathryn
9:00 Lee
14:00 Matthew

I want to show it like


9:00 Kathy
Kathryn
Lee
14:00 Matthew

(Plz ignore the names formatting)

I tried Suppress if duplicate and even the Suppress & X+2 and entered {Time}=Previous{time}

but did not work. Using V 8.5 Please advise. Thanks !!

 

[kray4660]

Right click on the field, choose format field. Common tab. Click on the check box 'Suppress if Duplicated'. I have not used this in a long time, but it should work.

 

[lbass]

Supress if duplicated should work, so I wonder whether your time field is actually different from the display. You might try using a suppression formula like this:

time(hour({table.datetime}),minute({table.datetime}),0) =
previous(time(hour({table.datetime}),minute({table.datetime}),0))

-LB