Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Find newest date on group of records CR 2008 2

Status
Not open for further replies.

NiteClerk

Technical User
Nov 9, 2009
15
US
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-



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

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

Give that a try and see if it works.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top