Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » Crystal Reports » Several duplicate history entries in Contact history report
Post new topic  Reply to topic View previous topic :: View next topic 
Several duplicate history entries in Contact history report
PostPosted: Fri Feb 06, 2009 8:27 am Points: 0 Reply with quote
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
    A.
    B.
    C.

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
View user's profile Send private message

PostPosted: Fri Feb 06, 2009 10:30 am Points: 0 Reply with quote
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.
View user's profile Send private message

PostPosted: Thu Apr 02, 2009 8:47 am Points: 0 Reply with quote
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
View user's profile Send private message Send e-mail Yahoo Messenger MSN Messenger

PostPosted: Thu Apr 02, 2009 1:02 pm Points: 0 Reply with quote
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.

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

Several duplicate history entries in Contact history report
  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  

  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin