Troubleshooting "Duplicate Records" in Crystal Reports
July 8, 2009
Posted by on
If you haven’t discovered Ken Hamady, you need to check out his recent post on troubleshooting “duplicate records”. This is perhaps the most frustrating issue that report designers encounter when developing reports against Lawson tables.
If you don’t have a good grasp on the JOINs/relationships that are used in Lawson’s S3 databases, you can really get in trouble in a hurry. Some quick tips based on what I see quite often:
Again, just a few tips to help you whip your reports into shape, and keep you out of trouble with your DBA!