I am almost there. Here is what I ended up doing.  Grouped by location and then Event ID.
Then created the formula :
NthLargest (1,{SiteInspectionDetail.InspectDate} ,{DriveMaster.DriveID});
and inserted in the Event ID Group Header. This gave me the most current inspection date. I then moved the Detail fields to the same group header with the exception of the date. I then surpressed the details and header # 1 row and I now am almost there.  Now I have to figure out how to filter by that most recent inspection date and the event date with a formula.

Flanman