Community
Showing results for 
Search instead for 
Do you mean 
Reply

Summary Reports

Tuned Listener
Posts: 5
Country: UK

Summary Reports

[ Edited ]

I am trying to create a report that counts how many contacts we have from each country and the idea is the final report will go something like:

 

Australia - 100

Belgium - 30

Cyprus - 150

Denmark - 200

Finland - 90

 

and carry on in alphabetical order with the total number of each next to it. I have created the fields I want [C:COUNTRY] and COUNT([C:CONTACT]) however when i run the preview i end up with several blank pages, big gaps in between countries and some countries are on the report several times even though the spelling is identical.

 

Can anyone suggest where I am going wrong? I've looked through the forum and help topics it would seem i'm doing everything I should be yet it's still going wrong.

 

Thanks

  

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Summary Reports

You mean something like this? See atttachment.

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