Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Tuned Listener
Phoerster
Posts: 40
Country: USA
Message 1 of 6 (837 Views)

Create a Contact Report

I want to create a report that will show me how many contacts of a certain ID/Status that reside in each state...i/e a report that groups contacts by state and counts them for me.

 

 

Please use plain text.
Platinum Elite Contributor
Roy_Laudenslage
Posts: 5,739
Country: United States
Message 2 of 6 (794 Views)

Re: Create a Contact Report

That can be done but it would require some VB script programming to accumulate the numbers you want.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Tech Benders
royel@techbenders.com
Please use plain text.
Silver Contributor
jonmklub
Posts: 1,722
Country: USA
Message 3 of 6 (791 Views)

Re: Create a Contact Report

There are two easy ways to do this.1) export your contact list along with state, id status/ to excel using export to excel in the contact list, then try grouping in excel.

 

The second way would be crystal reports. This is a failry simple report there that most consultants can do pretty quickly.

Jon Klubnik| ActTrainer.com
(866)710 4228

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


Act v17 Virtual Roadshow Webinars: acttrainer.com/texas-act-road-show/
Monday, November 3, 2014 at 9am CEN
Tuesday, November 4, 2014 at 1...


Please use plain text.
Platinum Elite Contributor
Roy_Laudenslage
Posts: 5,739
Country: United States
Message 4 of 6 (787 Views)

Re: Create a Contact Report

The scripting to create the report in ACT! is very simple and I've done it several times.  Frankly Crystal reports would be overkill.  

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Tech Benders
royel@techbenders.com
Please use plain text.
Tuned Listener
Phoerster
Posts: 40
Country: USA
Message 5 of 6 (770 Views)

Re: Create a Contact Report

So what is the script?  Where do I put it in the report template?

 

Please use plain text.
Platinum Elite Contributor
Roy_Laudenslage
Posts: 5,739
Country: United States
Message 6 of 6 (756 Views)

Re: Create a Contact Report

The script would be specific to the database information. It would be one or more simple If - Then statements. As to placement, that would be specific to the report structure.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Tech Benders
royel@techbenders.com
Please use plain text.