highlight most recent entry in group on report

Question

I am trying to see if it is possible to highlight or conditionally format the most recent entry on a report&nbsp;_in each group_ - so if the report is grouped by Manager ID, and shows several updates per manager (see below), I want the latest entry to be a different color or highlightedID&nbsp; &nbsp; &nbsp; &nbsp;Date&nbsp; &nbsp; &nbsp; Update&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;notes1234_1234&nbsp; 7/10/19&nbsp; update here&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; notes and such1234&nbsp; 7/1/19&nbsp; &nbsp; another update here&nbsp; &nbsp;more notes1234&nbsp; 6/15/19&nbsp; another one&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; blah blah_5678_5678&nbsp; 7/9/19&nbsp; &nbsp; update and what not&nbsp; &nbsp;some notes5678&nbsp; 7/5/19&nbsp; &nbsp; here is an update&nbsp; &nbsp; &nbsp; &nbsp; note note note5678&nbsp; 5/15/19&nbsp; again with an update&nbsp; &nbsp;notes and notes and notesSo the first lines for each ID would be highlighted (the one on 7/10/19 for 1234 and the one on 7/9/19 for 5678)Please help!!&nbsp; And thanks in advance :)

laurathacker · Answer

This answer assumes:1.&nbsp; Your ID (group value) is a related-reference field table parent record value2.&nbsp; That your report will always include the latest note/entryIn your Parent &lt; Child relationship, build a summary-field to bring back the&nbsp;Maximum [Record ID#] from the child table.&nbsp; Call this field [Max Notes Rec ID#]In your Parent &lt; Child relationship add the new [Max Notes Rec ID#] as a Lookup field back into the child-tableIn your child-table, build a formula-checkbox field [Latest Note].&nbsp; Formula: [Record ID#] = [Max Notes Rec ID#]In your report, you can then use Row colorization on the rows where the [Latest Note] checkbox is TRUE.

ryanstanford1 · Answer

To piggy back on QBPros_IDS response, this was exactly what I was thinking, but they beat me to it.

stephanielane · Answer

My key field is not the Record ID - it is the Manager ID....

laurathacker · Answer

The principle is the same.&nbsp; 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 · Answer

Well I tried that, and it was checking the box on dates that are earlier than the latest update...&nbsp;

Forum Discussion

highlight most recent entry in group on report

Related Content

Restful API Report digesting JSON

Summary Reports

embedded reports

Report Formulas

Button to print embedded report without showing the report on the form