Newbie - Suppress Duplicate Records 1

[sandy1447]

I'm a new Crystal IX user. I've read all the threads about removing duplicate records and still need assistance.
Data looks like this:

MR # Procedure Start Time End Time
123 Diag Cath 8:55AM 9:45 AM
123 Inter Cath 8:55AM 10:36 AM
456 Diag Cath 11:10 AM 11:55 AM
456 Cath, PV 11:10 AM 12:05 PM
789 Diag EP 2:45 PM 3:50 PM
789 Int EP 2:45 PM 4:57 PM

I need only one occurence for each MR# to print, the one with the longest duration.

 

[kskid]

[ol]
[li]Are the times in datetime format? if so, create the following formula[/li]

//@duration
datediff("s",{StartDate},{EndDate})


[li]Then group by name[/li]

[li]Insert a sort on @duration in descending sequence[/li]

[li]Move all the fields into the group header[/li]
[/ol]

-lw

 

[sandy1447]

kskid, when you say "group by name", what field are you referring to?

 

[kskid]

MR #

 

[sandy1447]

Worked, thanks!!!