Picking specific record from multiple records

[Freefall27]

I am running CR XI and pulling my data by ODBC driver from an Oracle database. I have a report which pulls information on work order tasks which need to be completed. Each time a rep goes in and enters a new task another date and time stamp is placed on a new record. I need to only display the first or earliest record based on time stamp. All records will have the same information with the exception of the time stamp of the new task.

Current Report Output
Work Order Task Ready Time Due Date
1234 Install 11/01/2005 3:10:21PM 11/10/2005
1234 Install 11/01/2005 3:09:34PM 11/10/2005
1234 Install 11/02/2005 3:19:20PM 11/10/2005


Desired Outcome (Only show record with earliest date.
Work Order Task Ready Time Due Date
1234 Install 11/01/2005 3:09:34PM 11/10/2005

Thanks for your help

 

[IdoMillet]

Group by Work Order and sort by date.

Place the information you want to show in the Group Header and suppress the detail section. The group header shows information from the first record within the group.

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com