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

ContactReview Forum Index » Crystal Reports » Dupe Record Check
Post new topic  Reply to topic View previous topic :: View next topic 
Dupe Record Check
PostPosted: Wed Sep 27, 2006 9:29 am Points: 0 Reply with quote
goodlookin1
GoldMine Apprentice
Joined: 28 Jun 2006
Posts: 21
Location: Sacramento, CA




Hey guys,

Some time ago, I noticed that we had a lot of duplicate records in the contact2 of our Goldmine (dBase version). About 20 records have 3 duplicate account numbers and the rest of the 300 records are 2 account numbers for each record.

Well, I dont remember when or, more importantly how, I generated a list of all of the duplicate entries, but I did. I dont know if I used Stonefield Query, Crystal Reports or something in Goldmine. But I need to re-generate that list somehow.

I have already ran the SQL query in GM to verify we still have dupe accountno's:

Code:
SELECT COUNT(*), accountno FROM contact2 GROUP BY accountno HAVING COUNT(*)>1


But the problem is that when I get that information, only the accountno's show up. I need the company name to show up as well.

Any Ideas how I can do this in Crystal Reports? I have tried everything I can think of, but it I always end up with a statement like "This function cannot be used because it must be evaluated later" when I use this code:

Code:
distinctcount({Contact1.ACCOUNTNO}) >= 2


I think it is evaluating the data already in the report, rather than the data within Goldmine. And since there is no data in the report at the time of refreshing, it fails to do anything.

Any help would be appreciated.

Thanks!
View user's profile Send private message Visit poster's website

PostPosted: Wed Sep 27, 2006 2:13 pm Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1639
Location: Los Angeles, CA




I dunno about Crystal reports, but a nice easy uery in the GoldMine SQL Query tool could accomplish it:

Code:
select contact, company from contact1 where accountno in (SELECT accountno FROM contact2 GROUP BY accountno HAVING COUNT(*)>1)

_________________
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

PostPosted: Wed Mar 28, 2007 5:22 pm Points: 0 Reply with quote
Andrea Dominguez
n00b
Joined: 28 Mar 2007
Posts: 9




when you see lovegrams like that you need to add to the top of your formula:

whileprintingrecords;

that is when it will get evaluated - after it opens and right before it paints to your screen. By not adding it says to the report when it opens immediately start working this.
View user's profile Send private message

Dupe Record Check
  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