Solved

How do I connect the activity table and the history table in ACT under crystal reports

Posted on 2011-03-17
4
656 Views
Last Modified: 2012-05-11
Using ACT! version 12, I can see the activity table and the history table. I have determined that a 'history' record from the history tab contains data from both of these.

I am using the OLE/DB Provider v 2.0 from Act in Crystal Reports to report on this information, but am unable to find the joining field/table which connects activity to history.

Can anyone tell me where the relationship is defined. Thanks

Iain
0
Comment
Question by:PCIIain
  • 2
4 Comments
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 35157334
They don't correct directly. Both connect to 1 or more contacts/companies/groups
0
 
LVL 13

Author Comment

by:PCIIain
ID: 35157447
So when they clear an ACTIVITY (and it is therefore flagged as cleared) a copy of this record is put in the HISTORY table?
0
 
LVL 30

Assisted Solution

by:Mike Lazarus
Mike Lazarus earned 50 total points
ID: 35157485
Well, it's not an exact copy.... the user can change items when saving the history
0
 
LVL 7

Accepted Solution

by:
50cal earned 450 total points
ID: 35157502
As far as I know there is no link table between Activities and History. When you complete an Activity it creates a history item but it does not retain a link between the two, you can demonstrate this by un-clearing and re-clearing an activity - it will not update the history entry but create a new one.

There are link tables between
Contacts <-> History
Contacts <-> Activities.

50cal.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Crystal 2013 - Using Can Grow adds spaces in text 9 60
Crystal Reports - Trim Data 7 48
Crystal Reports 7 VB6  'Feature Not Enabled' Error 10 20
free Crystal Report viewer 4 18
As owner of GL Computing, I have worked with CRM products since 1984 and with Act! since 1987.  GL Computing provides training and technical support to Act! Consultants, resellers and add-on developers around the world. One of the problems we not…
Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question