Community
Showing results for 
Search instead for 
Do you mean 
Reply

Sorting in Reports

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

Sorting in Reports

I have edited the History Summary report to include fields for city, county and phone number. When I generate the report it automatically sorts alphabetically by contact name but I want to sort by county then by company and then by contact. How do I do this?? When I use the define sections feature it will only give me the first contact in any county. I'm using 2009 v11

Accepted Solutions
Solution
Accepted by topic author Delndi
‎09-25-2015 03:20 AM
Copper Contributor
Posts: 11
Country: United Kingdom

Re: Sorting in Reports

Thanks Darren.

As I said in my question I have already tried this one but it only gives you the first contact in any county. Mike Lazarus of GL computing suggested another link at http://tinyurl.com/8ks2x6 which says to change the order at the bottom to "none" and the report comes out in the same sort order as the look up so you can define criteria in the original look up

View solution in original post


All Replies
Copper Super Contributor
Posts: 56
Country: Australia

Re: Sorting in Reports

Try this article in the ACT! Knowledge Base

 

How to Change the Sort Order in an Existing Report - http://tinyurl.com/9szu83 

 


Darren Flood
ACT! Certified Consultant
Evolution Marketing;
ACT! Software
& CRM Consultants - Australia
Solution
Accepted by topic author Delndi
‎09-25-2015 03:20 AM
Copper Contributor
Posts: 11
Country: United Kingdom

Re: Sorting in Reports

Thanks Darren.

As I said in my question I have already tried this one but it only gives you the first contact in any county. Mike Lazarus of GL computing suggested another link at http://tinyurl.com/8ks2x6 which says to change the order at the bottom to "none" and the report comes out in the same sort order as the look up so you can define criteria in the original look up