Jump to content
We've recently updated our Privacy Statement, available here ×

Select Most Recent Entry from Single Field that Returns Multiple Entries


zgadson

Recommended Posts

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!

Zach

 

 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...