I'm working on a Crystal report for our GoldMine database. I have it set up to display contact information for each record, and then in the details it displays the history records for each contact. it is all working fine, until I set up parameters with the selection expert.
If I use the "state" info from the contact record, it works fine. But if I use "ZIP code" info I get duplicate entries in of the history records.
The Contact records don't duplicate but some of the contacts have several duplicate history records when the report is run.
This also happens if I use the age of the history records as a criteria for the select expert.
I have checked the records against our GoldMine database, and there are not actually duplicates there.
Any help appreciated.
matt
GoldMine 8.03, Crystal XI, and SQL Server 2005