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.
  • StephanieLane's avatar
    StephanieLane
    Qrew Cadet
    6 years ago
    Well I tried that, and it was checking the box on dates that are earlier than the latest update... 
  • StephanieLane's avatar
    StephanieLane
    Qrew Cadet
    6 years ago
    It really needs to be based on that date field.....
  • Laura_Thacker's avatar
    Laura_Thacker
    Qrew Commander
    6 years ago
    Can you call me please at 626 771 0454