Community
Showing results for 
Search instead for 
Do you mean 
Reply

Link Group Table to Contact Using Crystal Reports

Copper Contributor
Posts: 23
Country: USA

Link Group Table to Contact Using Crystal Reports

Hello:

I have been using Crystal reports to write reports from our ACT Database. All has been great until now I would like to do some reporting on Groups. I cannot figure out how to link the Group table to the Contact table as there does not seem to be uniqueidentifer field. I have tried linking from Contact_opportunity to Group_opportunity to Group table with no success.

The Group table only has one uniqueindentifier which is GROUPID. I can in no way figure out how to link it back to a contact.

 

The report I am trying to create is to simply list a contact and all of the groups it is a member.  Has anyone has experience using crystal and could tell me how they linked their tables? (Inner, Left Outer, Right Outer, etc.)

 

These are the tables I am using.

COMPANY

CONTACT

CONTACT_OPPORTUNITY

GROUP

GROUP_OPPORTUNITY

 

I was able to link the first 3 with no issues. It's the GROUP tables i cannot figure out.

 

Any help is greatly appreciated.

 

Thanks,

Tony

 

Platinum Elite Contributor
Posts: 6,668
Country: USA

Re: Link Group Table to Contact Using Crystal Reports

There is a separate table that links contacts to groups. You need to link through that table.I don't recall the table name without doing research but I did set up the link one time for a report that I did.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Contributor
Posts: 23
Country: USA

Re: Link Group Table to Contact Using Crystal Reports

[ Edited ]

That's what I am assuming, but am still having a hard time nailing it down.

I thought I had it figured out by going from CONTACT to GROUP_OPPORTUNITY to GROUP, but I'm guessing I must have my inner/outer joins messed up because I has getting all kinds of whacky report results.

New Member
Posts: 19
Country: USA

Re: Link Group Table to Contact Using Crystal Reports

Just  to help others who found the original question as i did:

 

table group_contact  has contactid & groupid

 

 

A usefull way to explore all the tables is to setup an OleDbConnection and use the following sql:

SELECT * FROM INFORMATION_SCHEMA.TABLES

 

for the db I'm working on it provides the following list.

SYNC_DATABASE
SYNC_DBMAP_INFORMATION
SYNC_DBMAP_INFORMATION_HISTORY
SYNC_DBMAP_SESSION
SYNCSET
SYNCSET_ACCESSOR
SYNC_SUBSCRIPTION
SYNC_LOG_ADD
SYNC_LOG_DELETE
SYNC_LOG_UPDATE
SYNC_LOG_FILE
SYNC_LOG_EXCEPTION
ACT_LOCALSTRING
ACT_TABLES
ACT_COLUMNS
ACT_PRIMARY_KEYS
ACT_FOREIGN_KEYS
ACT_DATABASE_CONFIG
ACTIVITY
COMPANY
COMPANY_ACTIVITY
COMPANY_CONTACT
COMPANY_HISTORY
COMPANY_NOTE
COMPANY_OPPORTUNITY
CONTACT
MY_RECORD_CONTACT
CONTACT_ACTIVITY
CONTACT_CONTACT
CONTACT_HISTORY
CONTACT_NOTE
CONTACT_OPPORTUNITY
GROUP
GROUP_ACTIVITY
GROUP_CONTACT
GROUP_HISTORY
GROUP_NOTE
GROUP_OPPORTUNITY
HISTORY
NOTE
OPPORTUNITY
OPPORTUNITY_ACTIVITY
OPPORTUNITY_HISTORY
OPPORTUNITY_NOTE
OPPORTUNITY_PRODUCTSERVICE
PRODUCT_SERVICE
PRODUCT
PROCESS
STAGE
TEAM
RESOURCE
USER
TEAM_USER
ACCESSOR
SECONDARY_CONTACT
PICKLIST
PICKLIST_ITEM
LOGON_HISTORY
ACTIVITY_TYPE
HISTORY_TYPE