LastEntry in a Group

[Former Member]

Hi,

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.

Any ideas?

Kind regards

Patrick

Edited by: Patrick Jox on Sep 18, 2008 11:28 AM

[Former Member · Accepted solution]

Hi Patrick,

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.

Regards,

Raghavendra

[Former Member]

When you're at the Group Footer, you have the values of the last items in your group. Just put your formula to do whatever you need to do there.