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.