08-05-2010 01:48 AM - edited 08-05-2010 05:33 AM
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.
08-05-2010 09:40 AM
You mean something like this? See atttachment.