I'm unsure how to get this function to work correctly in crystal reports, however, I can clearly get this work from a query directly from sql.
Anyhow, I have multiple links setup in crystal reports the very last table that's link is where the data becomes duplicated, because of how are web application is storing the data. Where this data may become unique is using the "CreationTimeStamp" field from that table. But I can't get crystal to show to only show the results based of the most recent time stamp created. Also I not viewing the creationTimeStamp anywhere on the report. I'm just using to suppress or filter out the data that I want.