LastEntry in a Group
in a report I need to inherit the status of a group form its last entry in a group.
I have a ticket system with n action entries for each ticket. The list is grouped by ticketid. Only if the last action entry is resolved then the ticket itself will be qualified as resolved.
Edited by: Patrick Jox on Sep 18, 2008 11:28 AM
If you have any date field for entry then use it in record selection formula and check ascending order. Now place the fields in group footer that shows the last entry data for each group. If you want to see the data in group footer level then change the order to descending and place the fields in group header.