Forum Discussion

StephanieLane's avatar
StephanieLane
Qrew Cadet
6 years ago

highlight most recent entry in group on report

I am trying to see if it is possible to highlight or conditionally format the most recent entry on a report _in each group_ - so if the report is grouped by Manager ID, and shows several updates per m...
reports and charts
Tips and tricks
StephanieLane's avatar
StephanieLane
Qrew Cadet
6 years ago
My key field is not the Record ID - it is the Manager ID....
Laura_Thacker's avatar
Laura_Thacker
Qrew Commander
6 years ago
The principle is the same.  You still want the maximum Record ID# for the child record; and to look that up into the child table so you can evaluate if the [Record ID#] = [Max Record ID#] to determine it is still the latest-child record for the parent record.