Could anyone tell me how to set up a report based on the country of the member (Northern Ireland, Republic of Ireland, England, Wales, Scotland).
Thanks in advance Debs
3 Answers
Welcome to CivICRM SE! You can get a report for the Republic of Ireland using the standard reports and filtering on Country, but CiviCRM doesn't have a field for the countries withing the UK by default. I don't think it would make sense to edit the Country field in the postal address unless you will never have any postal addresses outside the UK/ROI.
You will have to create a custom field for this. Obviously you can enter this manually when you set up the contact. You could populate this automatically from the postcode, but this would require some lookup from postcode to UK country (for example https://www.robertsharp.co.uk/2017/08/09/a-table-that-shows-the-uk-region-for-all-postcode-districts/ has the mapping) so would require some coding. There is a postcode lookup extension https://civicrm.org/extensions/uk-postcode-lookup but I think that's for looking up addresses and won't provide the UK country. Also be aware that postcode isn't the same as administrative area. For example Hay-on-Wye is in Wales, but has an English postcode. Hope that helps.
My client also wanted reports by the 4 'home' countries. So I added them to the 'civicrm_country' table and modified the entries in the 'civicrm state_province table' to point to the correct country. Works well.
answered Jul 10, 2019 at 10:33
Deborah, Welcome to CiviCRM SE. Unfortunately there is no such report to group members based on Country. You may need to add bit of customization by using hook to add ability for grouping members based on country under Sorting tab of the report.
If you are using Drupal CMS than you can build your own report using Views module in table format and group them based on country.
HTH
Pradeep
answered Jul 8, 2019 at 10:55
