Return ONLYrecords for 1st date after a specific date

[oanion]

I'm using Crystal Reports XI with SQL Server 2000. I have the following scenario. If a patient has a discharge date of 03/15/2009, I only want to choose records for the patient for only the 1st service date AFTER the discharge date. For instance a patient has the following records:

DISCHARGE DATE SERVICE DATE SERVICE
03/15/2009 03/25/2009 Massage Therapy
03/15/2009 03/25/2009 Chiropratic Therapy
03/15/2009 03/27/2009 Blood Work

The first service date after the discharge date is the 25th,
therefore, the formula should only return the 1st two records for the patient.

By the way, I'm grouping on the patient ID, which makes the output look as I've shown above.

 

[CoSpringsGuy]

could you use the section expert and use a formula to supress the records with a formula like this

{DOS} <> minimum({DOS},{patientID})

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection