| Dupe Record Check | |
Posted: Wed Sep 27, 2006 9:29 am |
Points: 0 |
|
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! |
|
|
|
|
| | |
Posted: Wed Sep 27, 2006 2:13 pm |
Points: 0 |
|
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) |
|
|
|
|
|
Posted: Wed Mar 28, 2007 5:22 pm |
Points: 0 |
|
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. |
|
|
|
|
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
|