RRDI Report showing latest test execution results

We have a situation where Test Cases are linked to more than one Test Script. I'm trying to design a report using RRDI which shows the latest results for each test execution but my report picks up all the previous results.The report currently looks like:
Test Case ID, Test Case Name, Test Script ID, Test Script Name, Execution Date, Result
1,                     Sample TC,           8,                 Ts1,                      Date1,              Pass
2,                     Sample TC 2,        10,                Ts2,                      Date2,             Fail
                                                      10,                 Ts2,                     Date3,            Inconclusive

In this instance, I would only want to pull out the results from Date3 for Test Case ID 2 and exclude results for Date2