CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Report custom object and showing only the latest record help

edited May 23, 2013 9:11AM in CRM On Demand - Reports and Dashboards (MOSC) 2 commentsAnswered ✓
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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center