Ask Search:
Vadim LenderVadim Lender 

Most recent created related record report

I would like to create a report that shows me the primary record and the most recently created related record.  Example: account report listing the account and the most recently created case for each account.  Thanks!
Aaron DeRanAaron DeRan
Are you looking for one report that gives you an Account and the most recently created related record of ANY object type? If so, there is no report functionality to support that and if at all possible it would involve extensive custom code.

If you want to run a report that gives you an Account and specifically the most recent Case, then you are going to first need to involve an Apex trigger that calculates the most recent created date of the Cases related to an Account and populates that in a field that can be reported on. It is possible but not without custom code.

Now, you can use a Rollup Summary field to calculate a field related to the most recent opportunity and report on that, but any other object related to Accounts would require code.