09-18-2013 11:13 AM
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
09-18-2013 01:47 PM
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.
09-19-2013 07:32 AM
Thanks for the prompt information.
Last questions:
Frank
09-19-2013 09:16 AM
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.
09-19-2013 04:49 PM
Can I then sort the report you suggested by an opportunity/service variable?
Frank
09-19-2013 04:50 PM
@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
09-19-2013 05:14 PM
It depends on the report basis. Reports are Contact, Group, Company or Opportunity based.
09-19-2013 06:20 PM
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
09-19-2013 09:29 PM
In the opportunity list view select all the opportunities and then right click and to create lookup.