E-Verify Reporting - find latest case status

[Adam_S]

Hi - 

I am looking to report on all employees who don't have at latest E-Verify case - their latest E-Verify should have a status of 'Employment Authorized'. We have scenarios where an employee will have had multiple E-Verify cases submitted but I need a Story report that will evaluate all of the cases submitted for an employee and tell me the status of the latest case that was submitted.

I cannot seem to determine how to compare multiple rows of data and only keep the row that has the latest date (Case Closure Date).

Is it possible to do this in a Story report?

Thanks

[subbareddyven]

Hi @Adam_S ,

Please check below blog, you can fetch latest record and filter on status 'Employment Authorized'

Determination of the newest = latest record for no... - SAP Community

Regards,

Subbu

[Adam_S]

Hi Subbu - thank you for this link - it appears it may work for us. I will go through the steps in further detail and see if we run into any issues.