Community
Showing results for 
Search instead for 
Do you mean 
Reply

Refining Contact Sub-report to Omit Specific Contacts

New Member
Posts: 10
Country: United States

Refining Contact Sub-report to Omit Specific Contacts

I have a report that containing a sub-report iterating over each contact linked with the parent company. However, this also includes contacts alternatively linked to the company through the Group/Companies > Companies and Divisions Tab.

 

Is there anyway I can omit these contact records from my subreport?

 

All suggestions are welcome. Thanks.

New Member
Posts: 10
Country: United States

Re: Refining Contact Sub-report to Omit Specific Contacts

Perhaps I should provide an example:

 

Company A has three contacts, known as Contact 1, Contact 2 and Contact 3.

 

Company B has one contact, known as Contact 4.

 

Contact 4 is also linked to Company A.

 

If I run a report on Company A, which has a sub-report iterating over contacts belonging to Company A, I only want the records for Contact's 1 through 3.

 

You have my thanks in advance!

New Member
Posts: 10
Country: United States

Re: Refining Contact Sub-report to Omit Specific Contacts

Ok.

 

Can I solve this problem with the built in features of the Report Designer, should I write a VBA script or is this impossible?

Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: Refining Contact Sub-report to Omit Specific Contacts

There's nothing available to the ACT! reports that would differentiate between the contact so what you want can't be done.

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