Mandatory Education Reports

Sort:
You are not authorized to post a reply.
Author
Messages
mil0n023
Veteran Member
Posts: 63
Veteran Member
    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!
    M. C. Miller
    Analyst
    Salem, Oregon
    You are not authorized to post a reply.