Solved

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

Posted on 2011-03-17
4
651 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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

A lot of users new to ACT!, especially those who don't get the benefit of a consultant, seem confused between when to share on a network and when to sync ... or, in fact, how to do either. So I thought I would attempt to explain the various options …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

705 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now