Select Most Recent Entry from Single Field that Returns Multiple Entries


Hey guys, need some quick direction on how to handle a data source that supplies multiple values/lines to my report.

In short, my report is for tracking trucks, and my last column is 2 fields combined to show the (a) status date and (b) status comments. It works perfectly, but as you can see from the sample of my report below, it returns multiple lines due to the data source consisting of multiple tracking updates for every load. That said, how do I select only the update with the most current date? If I can use the expression editor for this, that woud be awesome, but I'd sincerely appreciate any direction or advise.

Thank you!




zgadson's picture
Joined: Sep 24 2018 - 11:24am
Last seen: 4 months 4 days ago

0 Answers:

No answers yet