I have a custom report that I created several years ago using data from my ERP system (DBA/Evo~ERP). Just recently, I have an anomaly that has surfaced. I have manually stepped through the linked data files and the duplication does not exist in the data. The odd thing is that it only seems to affect a single part number in our item master.
I found a link to a whitepaper from Crystal Decisions titled "How to troubleshoot duplicate records from displaying on a report" that was written for Crystal Reports 9 but says it is applicable to earlier versions as well. After reviewing, I am inclined to think that this is a data corruption problem. Is there any way to detect such corruption and repair it?