Mandatory Education Reports

Lawson 8.03

I wrote a report using PATRNHIST, EMPLOYEE to capture the Employee Training/Course history. There are a few Mandatory Courses that encompass several Course Numbers - For example: BLS Course is


select {PATRNHIST.COURSE}
case "2C00000001":
ToText({PATRNHIST.DATE_COMPLETED}, "M/dd/yyyy")
Case "2C00000002":
ToText({PATRNHIST.DATE_COMPLETED}, "M/dd/yyyy")
case"2C00000003":
ToText({PATRNHIST.DATE_COMPLETED}, "M/dd/yyyy")
case"1C00000001":
ToText({PATRNHIST.DATE_COMPLETED}, "M/dd/yyyy")
default:
""

Now I have the detail field as this above formula - then I am Grouping by another formula simply for the Proper Name (Last, First, Middle) and I am then doing an NthLargest on this Course Formula to get the most recent Date completed - However, for some reason it is not getting the most recent dates on several records? Any ideas on how to do this another way or??

Thanks!