[RESOLVED] How to select Records

[adsmag]

Im currently using CR v9. Just want to ask how can i select records to display during runtime or in formula. I only want to display in my report the latest date but it keep on displaying all the available dates for a record. Pls help. urgent need. Thanks!

Sample:

KeyID Description Date
Smple-10 Sample Only April 18, 2007
Smple-10 Sample Only April 19, 2007
Smple-10 Sample Only April 20, 2007

What I want to display is only the April 20, 2007

[JaganEllis]

Two ways:

1) Group on the KeyID, sort descending on the date, print in the group header, suppress the details. (or sort ascending and print in the group footer)
2) Group on the KeyID, have a group selection formula to only select the maximum record per keyid, print in the group header or detail or footer. The group selection formula would be:
{table.date} = maximum({table.date}, {table.keyid})

[adsmag]

Thanks! It worked. :)