Report custom object and showing only the latest record help
Hi, I have 2 custom objects which have a parent- child relationship. So Custom object 4 can have many custom objects 5 linked to it.
In my report i want to show only the latest custom object 5 that was linked to the custom object 4 based on a date on the custom object.
So for eg.
Custom Object 4 name | Custom Object 5 name | Date on custom object 5 | Status
A |1 | 12/12/2012
A |1 | 12/12/2013
B |2 | 12/12/2011
B |2 | 12/12/2012
B |2 | 12/12/2013
C |3 | 12/12/2012
What i want to see is:
Custom Object 4 name | Custom Object 5 name | Date on custom object 5 | Status
A |1 | 12/12/2013
B |2 | 12/12/2013
C |3 | 12/12/2012
Is there a way to filter so that if custom object 4 has more than 1 record linked to it ONLY the latest record shows up?
In my report i want to show only the latest custom object 5 that was linked to the custom object 4 based on a date on the custom object.
So for eg.
Custom Object 4 name | Custom Object 5 name | Date on custom object 5 | Status
A |1 | 12/12/2012
A |1 | 12/12/2013
B |2 | 12/12/2011
B |2 | 12/12/2012
B |2 | 12/12/2013
C |3 | 12/12/2012
What i want to see is:
Custom Object 4 name | Custom Object 5 name | Date on custom object 5 | Status
A |1 | 12/12/2013
B |2 | 12/12/2013
C |3 | 12/12/2012
Is there a way to filter so that if custom object 4 has more than 1 record linked to it ONLY the latest record shows up?
0