A programmer can be assign to multiple projects, so the name is duplicate in the Report.

I need to select the row o registry for each Resource with the last date that he will assign.

For example:

Resource                  Date

Juan Perez            3/2/2014

Pedro Diaz            5/5/2014

Juan Perez            6/7/2014

Mery Combes       10/10/2014

Mery Combes        3/9/2014

When I create the Report my result should be:

I need to show only one record with the max date.

I hope someone can help me.

Thanks