Find "Next" date

[karen6sons]

I have a report where I have to supply the "next" date for a specific event. There may be a number of event dates coming up in the future, but I only want to display the next one.

[JaganEllis]

Group by event. Record selection by date > currentdate.

Option 1)
Sort by date ascending. Print in the group header.

Option 2)
Use the group selection formula to get the minimum date per event, e.g. {table.date} = minimum({table.date}, {table.event})