We store status updates in a custom table on the Activity record. When retrieving status reports for reporting we need the 'latest report'; if we use a date range we retrieve multiple records for some activities.
I desperately need this as well - ability to filter on the most recent or max effective dated row in a custom table. When I pull a report it gives me all of the historical entries which isn't useful.
I desperately need this as well - ability to filter on the most recent or max effective dated row in a custom table. When I pull a report it gives me all of the historical entries which isn't useful.