Answers.Body: <p>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.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-07-10T10:33:37.880Z
Answers.LastActivityDate: 2019-07-10T10:33:37.880Z
Answers.UserDisplayName: Andy Clark
Answers.Body: <p>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.</p>
  
  <p>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 <a href="https://www.robertsharp.co.uk/2017/08/09/a-table-that-shows-the-uk-region-for-all-postcode-districts/" rel="nofollow noreferrer">https://www.robertsharp.co.uk/2017/08/09/a-table-that-shows-the-uk-region-for-all-postcode-districts/</a> has the mapping) so would require some coding. There is a postcode lookup extension <a href="https://civicrm.org/extensions/uk-postcode-lookup" rel="nofollow noreferrer">https://civicrm.org/extensions/uk-postcode-lookup</a> 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.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-07-08T12:30:07.893Z
Answers.LastActivityDate: 2019-07-08T12:30:07.893Z
Answers.UserDisplayName: Mick Kahn
Answers.Body: <p>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. </p>
  
  <p>If you are using Drupal CMS than you can build your own report using <a href="https://docs.civicrm.org/sysadmin/en/latest/integration/drupal/views/" rel="nofollow noreferrer">Views</a> module in table format and group them based on country. </p>
  
  <p>HTH</p>
  
  <p>Pradeep</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-07-08T10:55:22.590Z
Answers.LastActivityDate: 2019-07-08T10:55:22.590Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>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).</p>
  
  <p>Thanks in advance
  Debs</p>
  
Tags: <civireport>
Title: Report based on country
ThreadText: # Report based on country
  
  (Asked by: username_0 on 2019-07-08)
  
  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
  
  **Tags:** civireport
  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_1 on 2019-07-10. Score: 2
  
  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.
  
  
  ---
  
  ### Answer by username_2 on 2019-07-08. Score: 2
  
  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.
  
  
  ---
  
  ### Answer by username_3 on 2019-07-08. Score: 1
  
  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](https://docs.civicrm.org/sysadmin/en/latest/integration/drupal/views/) module in table format and group them based on country.
  
  HTH
  
  Pradeep
  
  
  ---
  
  