Can you verify that the linking between the tables is accurate? Inappropriate linking will produce duplicate data.
Alternatively, if the links are correct, you could create a group in the report, and place your data in the group footer instead of the details section, which will return the last value per group returned from the database. You could also use the previous or next functions to produce the same thing.
Naith