Community
Showing results for 
Search instead for 
Do you mean 
Reply

Report Creation

Copper Contributor
Posts: 57
Country: Canada

Report Creation

It is possible to create a customized report that takes into account certain fields from the Contacts area and also then from the Opportunities area?

 

For example, let me suggest the following areas and fields:

 

Contacts - Contact Name, Address, DOB

Opportunity - Opportunity Total

 

Used Crystal reports in the past however never written a report in Act.  Is there somewhere I can find the listing of fields and associated database to work from as a map?

 

Frank

Platinum Elite Contributor
Posts: 6,651
Country: USA

Re: Report Creation

Yes, you would make it as a contact report with an oppertunity subreport.

 

There is a third party book with comprehensive training information on the ACT! reports, here is the link.

https://www.packtpub.com/sage-act-2011-dashboard-and-report-cookbook/book

 

Full disclusure I wrote the reports chapters of the book.  The report chapters work for all version of the ACT! program since ACT! 2007.

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

Re: Report Creation

Thanks for the prompt information.

 

Last questions:

 

  1. Is it possible to then modify an existing contact report?
  2. Is there a place or online manual that details the structure and associated fields in  Act?


Frank

Platinum Elite Contributor
Posts: 6,651
Country: USA

Re: Report Creation

1. I don't recommend modifying the standard reports because many of then have hidden fields and VB scripting so you would need to reverse engineer the template before starting to modify it.

 

2. There is a data dictionary available that details the table structure. However the table structure of the ACT! database is very complex and the database dictionary document runs to over 200 pages.

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

Re: Report Creation

Can I then sort the report you suggested by an opportunity/service variable?

 

Frank

Copper Contributor
Posts: 57
Country: Canada

Re: Report Creation


Roy_Laudenslage wrote:

1. I don't recommend modifying the standard reports because many of then have hidden fields and VB scripting so you would need to reverse engineer the template before starting to modify it.

 

2. There is a data dictionary available that details the table structure. However the table structure of the ACT! database is very complex and the database dictionary document runs to over 200 pages.



Can I then sort the report you suggested by an opportunity/service variable?

 

Frank

Platinum Elite Contributor
Posts: 6,651
Country: USA

Re: Report Creation

It depends on the report basis. Reports are Contact, Group, Company or Opportunity based.

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

Re: Report Creation

I'm confused.  If I create a opporunties lookup, how can I link and include the contact data so I can use it for a mail merge?

 

Frank

Platinum Elite Contributor
Posts: 6,651
Country: USA

Re: Report Creation

In the opportunity list view select all the opportunities and then right click and to create lookup.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129