| Several duplicate history entries in Contact history report | |
Posted: Fri Feb 06, 2009 8:27 am |
Points: 0 |
|
animattor |
GoldMine Apprentice |
|
|
Joined: 07 Jan 2008 |
Posts: 10 |
|
|
|
|
|
|
|
|
EDIT: sort of resolved. See post below.
GMPE 8.03, SQL Server 2005, Crystal XI
I have created a contact history report that displays contact info and then recent hisotry activity. I thought it was all working correctly, and then I realized that it is duplicating history entries. So if I had entries
in a contact's history (in GM), when I run the report it will show
A.
B.
C.
A.
B.
C.
A.
B.
C.
Etc...
And it isn't consistent. Some records have no repeats, some records have many repeats (the number of times it repeats varies from 3-9 at least) I don't know if I'm dealing with a GoldMine issue, or an issue with the way i built the report.
The fields that are repeating are in the details section, and are set to suppress duplicates.
Also, I have checked several GM records that report as having duplicates, and there are no duplicates in the GM history file.
Any help appreciated. |
|
Last edited by animattor on Fri Feb 06, 2009 10:31 am; edited 1 time in total |
|
|
|
| | |
Posted: Fri Feb 06, 2009 10:30 am |
Points: 0 |
|
animattor |
GoldMine Apprentice |
|
|
Joined: 07 Jan 2008 |
Posts: 10 |
|
|
|
|
|
|
|
|
I found the cause of my problem.
I was using the selection expert in Crystal to limit the history records to those created after a certain date. When I removed this criteria from selection expert, the duplicates disappeared. |
|
|
|
|
Posted: Thu Apr 02, 2009 8:47 am |
Points: 0 |
|
GoldMineDataDiva |
GoldMine Journeyman |
|
|
Joined: 08 Sep 2006 |
Posts: 26 |
|
|
|
|
|
|
|
|
did you get help? It may be the linking of the tables that is doing this. I would like to see the report to help
Jill |
|
|
|
|
Posted: Thu Apr 02, 2009 1:02 pm |
Points: 0 |
|
DougCastell |
GoldMine Guru |
|
|
Joined: 15 Jun 2006 |
Posts: 1639 |
Location: Los Angeles, CA |
|
|
|
|
|
|
|
sounds like Crystal, as it does, automatically linked BOTH the recid and accountno fields.. Removing the recid auto-link is my guess at what fixed it up. |
|
|
|
|
ContactReview Forum Index » Crystal Reports
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
All times are GMT - 7 Hours
Page 1 of 1
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group Theme created by Vjacheslav Trushkin
|