Printable View
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?
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
If you are using Crystal Reports, there is a Suppress If Duplicate option on the Format screen.
great thanks to cjmcfg and brucevde... :thumb:
u both helped me :blush: