Community
Showing results for 
Search instead for 
Do you mean 
Reply

Problem - Report returns same Contact History for all contacts with same name

Accepted Solution Solved
Copper Contributor
Posts: 11
Country: United States
Accepted Solution

Problem - Report returns same Contact History for all contacts with same name

Part of a report that I put together in the basic report editor includes a subreport to return Contact History date, result and details.  If I have two contacts with the same name, it always returns the contact history of the same single contact (ie Contact #1, #2 and #3 all report Contact #1's history).  The fields in the [main] report still work properly, being specific for each contact.

 

I did a database maintenance procedure (check, repair, rebuilt everything, reindex) but it did not fix the problem.  Does anyone have any suggestions?

 

Thanks 


Accepted Solutions
Solution
Accepted by topic author chad
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,668
Country: USA

Re: Problem - Report returns same Contact History for all contacts with same name

That's your problem, use Contact ID.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129

View solution in original post


All Replies
Platinum Elite Contributor
Posts: 6,668
Country: USA

Re: Problem - Report returns same Contact History for all contacts with same name

What is your linking field for the subreport?
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Contributor
Posts: 11
Country: United States

Re: Problem - Report returns same Contact History for all contacts with same name

I'm using Contact to link to the subreport.

Solution
Accepted by topic author chad
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,668
Country: USA

Re: Problem - Report returns same Contact History for all contacts with same name

That's your problem, use Contact ID.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Contributor
Posts: 11
Country: United States

Re: Problem - Report returns same Contact History for all contacts with same name

Ah, works like a charm.  Thanks Roy.