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.
Printable View
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.
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})