Community
Showing results for 
Search instead for 
Do you mean 
Reply

Report on Activity exposed to OLEDB ?

Copper Contributor
Posts: 84
Country: Singapore

Report on Activity exposed to OLEDB ?

Hi all,

 

few month ago ,

 

I am using ACT 2008 (10) Premium , i understand that this version is not able to use Qlik View to access meeting activity. Can some one tell me the latest version it is allow me to access ? some one reply me as below :-

 

Unfortunately you cannot report on Activities as these are not exposed in the ACT! OLEDB Reporting Provider 1.0.

 

May i know that the latest version is possible , can some one confirm with me pls.

 

Paul

Silver Contributor
Posts: 1,813
Country: USA

Re: Report on Activity exposed to OLEDB ?

Yes, this was added in version 12 and 12 (2010 and 2011) your would use the OLDDB report provider #2 for this.

Test Drive Act! and Quickbooks over Citrix http://GoTryAct.com

Jon Klubnik| ActTrainer.com
(866)710 4228

ACT! Certified Consultant / ACT! Premier Trainer / ACT! Hosting Provider

Employee
Posts: 1,163
Country: USA

Re: Report on Activity exposed to OLEDB ?

The OLEDB 2.0 Reporting Provider wasn't available until v12 (2010).

Matthew Wood
Act! SDK Support
Community Moderator
Copper Contributor
Posts: 84
Country: Singapore

Re: Report on Activity exposed to OLEDB ?

Hi all, Thank you very much. One more last question is ver 12 it is already release ? Paul
Platinum Elite Contributor
Posts: 6,663
Country: USA

Re: Report on Activity exposed to OLEDB ?

Yes.

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

Re: Report on Activity exposed to OLEDB ?

Hi All,

 

I have manage to make use of OLEDB2 to access 2011 ACT database , I try and fail to get activity report , does any one here able to provide this services ? what i need to access act database activity information and opportunity information. ( i have ver 2008 , which i manage to get all opportunity information , but i am not able to get activity information which activity link to company and contact ) , in case some one know , pls reply me , so that i like to enage you for service. or pls email me at paulyeo@tdstech.com , thank. paul 

 

below is the example what i need :-

 

VRP_CONTACT_OPPORTUNITY:


SQL SELECT

//*******CONTACT OPPORTUNITY *******************    "CONTACT OPPORTUNITY CONTACTID" as ID1, **********************

    // VAR.

    "CONTACT OPPORTUNITY CONTACTID" as ID10,
    "CONTACT OPPORTUNITY CONTACTID" as ID100,

    "CONTACT OPPORTUNITY CONTACTID",
    "CONTACT OPPORTUNITY OPPORTUNITYID" AS ID99,
    "CONTACT OPPORTUNITY OPPORTUNITYID" AS ID999,
    "CONTACT OPPORTUNITY OPPORTUNITYID" AS ID9999,

    "CONTACT OPPORTUNITY OPPORTUNITYID",

    "OPPORTUNITY Actual Close Date",
    "OPPORTUNITY Competitor",
    "OPPORTUNITY Create Date",
    "OPPORTUNITY Days Open",
    "OPPORTUNITY Details",
    "OPPORTUNITY Edit Date",
    "OPPORTUNITY Estimate Project Complete Date",
    "OPPORTUNITY Estimated Close Date",
    "OPPORTUNITY Last Edited By",
    "OPPORTUNITY Open Date",
    "OPPORTUNITY Opportunity Field 4",
    "OPPORTUNITY Opportunity Field 5",
    "OPPORTUNITY Opportunity Field 6",
    "OPPORTUNITY Opportunity Field 7",
    "OPPORTUNITY Opportunity Field 8",
    "OPPORTUNITY Opportunity Name",
    "OPPORTUNITY OPPORTUNITYID",
    "OPPORTUNITY Private Opportunity",
    "OPPORTUNITY Probability of Close",
    "OPPORTUNITY PROCESS Active Process",
    "OPPORTUNITY PROCESS Created On",
    "OPPORTUNITY PROCESS Edited On",
    "OPPORTUNITY PROCESS Process",
    "OPPORTUNITY PROCESS Process Description",
    "OPPORTUNITY Product Subtotal",
    "OPPORTUNITY Project Stage 3",
    "OPPORTUNITY Project start date",
    "OPPORTUNITY Reason",
    "OPPORTUNITY Record Creator",
    "OPPORTUNITY Record Manager",
    "OPPORTUNITY Referred By",
    "OPPORTUNITY STAGE Created On",
    "OPPORTUNITY STAGE Edited On",
    "OPPORTUNITY STAGE Stage",
    "OPPORTUNITY STAGE Stage Description",
    "OPPORTUNITY STAGE Step",
    "OPPORTUNITY STAGEID",
    "OPPORTUNITY Status",
    "OPPORTUNITY Total",
    "OPPORTUNITY Weighted Total",
    "PROCESS PROCESSID",
    "STAGE PROCESSID",
    "STAGE STAGEID"
FROM "Master_TDS_2008".dbo."VRP_CONTACT_OPPORTUNITY";
//where year([OPPORTUNITY Edit Date]) = '2009';;