Hi All,

I have a requirement to display latest meeting status of an employee. But in the report I am getting 2 records for an employee, the meeting date is same but the Last Update Date is different.

I found some info on MOSC where they said we can use the filter as LAST_UPDATE_DATE = MAX(LAST_UPDATE_DATE BY EMP_ID), but it didn't work.

I also tried with Meeting_Id instead of Last_Update_Date and also tried RANK() & TOPN().

In the report, the fields are coming from 3 Subject Areas, so when I use RANK(), TOPN() or the filter above, we are getting ODBC errors and when used in a simple report, the output doesn't change.

Any pointers on this will help a lot.

For ex:

Emp     Meeting Id     Meeting Date     Last Update Date     DATE_FROM     DATE_TO     Performance

ABC     100002          15-06-2016          15-06-2016               15-06-2016        31-12-4712     Above Expectations

ABC     100003          15-06-2016          24-06-2016               15-06-2016        31-12-4712     Met Expectations

Expected Output:

Emp     Meeting Id     Meeting Date     Last Update Date     DATE_FROM     DATE_TO     Performance

ABC     100003          15-06-2016          24-06-2016               15-06-2016        31-12-4712     Met Expectations

Thanks,

Divya