How to report portal entry with highest date

[Andrew5]

I have program that tracks student progress. There is a portal that has, among other things, a date with his current status. The portal has a date with each status, up to about 10. How to make a report that shows the name with only the current (highest date) status from the portal and not all of the related contents of the portal? Thanks.

- The relevant parts of the tables are:

Main table fields:

name

main_key

----

Child table fields:

status_date

status_type

child_key

fk_main_key

[comment]

There are several ways to do this - here's one that's very cheap to implement: place a one-row portal to child on the parent's layout, make it sort by status_date, descending and place the status field inside it.

[Andrew5]

I should have thought of that dead simple idea. Thanks.