How to show the most current results with more than one value.

[kate8]

Hi everyone,
I have a report. I need to show the patients the most current test results. I group the patient as group 1, then group the result time as group 2. And sort decent. But each patient has more than one result in the same day. If I show all the info (Name, DOB etc.) in the group 2 header, only one result will show. How can I show all the results in that day?
I remember that I had done it before but could not think of how to do it now. And I need to have it done today.

Thanks a lot for any helps and suggestions.

 

[kate8]

I got it.
Go to select expert , Select Group Selection,
Enter the formula: {table.resultDate} = Maximum ({table.resultDate}, {table.PatientID})