[RESOLVED] eliminate duplicate field data

[ashly]

hello everyone,

i have a table which contains fields as below:

DateIn, TimeIn
------- -------

example data are:

DateIn TimeIn
------- --------
07/20/2007 09:00:00 AM
07/20/2007 11:00:00 AM
07/20/2007 02:00:00 PM


I now wish my report to look like as below:

___________________________________
DateIn TimeIn
___________________________________
07/20/2007 09:00:00 AM
11:00:00 AM
02:00:00 PM


i want the DateIn value shows 1 time only, anyone have any guide for me?

[cjmcfg]

I've done what i think you're trying to do several times...
Create A group sort by the date (That should put the date[s] in order and list them only once if they're duplicates. If that causes any issues you could also try moving the data (times) into that same Group Header.

Chris

[brucevde]

If you are using Crystal Reports, there is a Suppress If Duplicate option on the Format screen.

[ashly]

great thanks to cjmcfg and brucevde...

u both helped me