Something is lost in translation here, so let me see whether I understand your question.
You want to show just the last record for each group for the current year. Is that correct?
If so, you don't need the Group Selection Editor. Instead, I would do something like this:
1. In the Record Select Expert, edit the selection formula and add something like the following to it:
{MyTable.MyDateField} <= Date(Year(CurrentDate), 12, 31)
This will give you only the data for this year.
2. In the report, suppress the details section. Put your data in the Group Footer section.
3. If you need the data in the Group Header, set the group to sort Descending and use the Group Header section instead of the footer.
-Dell
IP Logged
