If you are only concerned with displaying dat you can

group on the "item"

sort on the date field descending

palce the fields date field in the group header

hide your details and group footer

-hiding data does not remove it formthe report so dat ais still included in your calcuations unless you explicitly exclude them using variable formulas or running totals.

- whenever yuo place table fields on headers it will display the first record that exists after that header is preinted (e.g. the first row of a group or the report). If you place a field int he footer is displays the last row of data before that footer is printed (e.g. the last row of a group or the last row of a report).