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-
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-