Joined: 04 Nov 2009
Online Status: Offline
Posts: 123
Posted: 03 Dec 2009 at 3:05pm
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.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged