Discussions

Expand all | Collapse all

Show only last value / entry

  • 1.  Show only last value / entry

    Posted 09-05-2017 19:42
    I have two tables in one to many relationship, and idea is following:
    - One project can have many log entries.
    I know how to create a table report, and sort, but what I need is a way to show only the date of last entry for the project? 

    Can this be done, and how?

    Thank you.


  • 2.  RE: Show only last value / entry

    Bronze
    Contributor
    Posted 09-05-2017 19:44
    I think you could try a summary field and setting it to Maximum Record ID. That should be the most recent related record. 


  • 3.  RE: Show only last value / entry

    Posted 09-05-2017 20:20
    If you want to know the maximum of the date field in a child table then make a summary field on the relationship  of the maximum of the date field in the child table.


  • 4.  RE: Show only last value / entry

    Posted 09-05-2017 20:22
    if you just want to show the whole entry for the log child table but only show the  entry which is the last one, then  do that summary date field and look it up back down to the Log entries.

    Then filter the embedded report where the date = summary maximum date.