Find newest date on group of records CR 2008 2

[NiteClerk]

Hi,

I have CR 2008 Developer 12.0.0.683

I'm trying to find the most recent date record in a group. I have two linked tables {Equip} and {WO}. In Report/Selection Formula/Records I've selected the Equipment I want by
{Equip.SiteID} = "mysite" AND
{Equip.LSCode} = "L"

I have over 7000 records that meet this criteria. I want to print out only the latest record for each Equipment number. Request Date is stored in {WO.RequestDate}. I have over 30,000 results from the raw data dump. I group by {Equip.CostCenter}, then {Equip.EqNum}

How do I select only the most recent RequestDate for each Equipment number?
Thanks. -Bob-

 

[elsenorjose]

Not sure how it's done in 2008 but in XI, I would go into Report > Selection Formula > Group and enter the following:

{WO.RequestDate} = MAXIMUM({WO.RequestDate},{Equip.EqNum})

Give that a try and see if it works.

 

[NiteClerk]

Thanks elsenorjose! That did the trick.