I created a crystal report that shows a list of people that had a urine culture. Here is sample data that is generating on the report:
Patient Name Encounter Date Culture results Next Encounter Date
Patient 1 02/12/2013 No Growth 03/08/2012
Patient 2 03/08/2012 E. Coli 06/28/2013
Patient 3 06/28/2013 No Growth 03/11/2013
What I need to see for 'Next Encounter Date' is the next encounter date in database for Patient 1....not the next encounter date for the records in report. If Patient 1 came back for an encounter on 2/25/13 for a follow-up visit I need to see the 2/25/13 in Next Encounter Date column. If Patient 1 hasn't been back for another visit I want to leave this blank for Patient 1.
Next (patient_encounter_enc_timestamp) is giving me the dates shown in column above.
I tried Maximum (patient_encounter_enc_timestamp) but it shows me 6/28/2013 since that is the max date in the records shown.
Any help would be appreciated.