Answers.Body: <p>Can't comment on CiviReports, but I know my way around Drupal Views enough to suggest that as an alternative option since it allows you to specify for each field/column which Location Type to use for the phone, email etc</p>
  
  <p>And to ensure you only see a single row for John even if he has multiple Work Phones it looks like there are two approaches.</p>
  
  <p><a href="https://www.drupal.org/project/views_merge_rows" rel="nofollow">Views Merge Rows</a> module (not tried it) or</p>
  
  <p><a href="https://www.drupal.org/project/views_field_view" rel="nofollow">Views Field View</a> which requires you to create a separate View display for each phone type/location and then insert that as a column, so eg for Home Phone it would give you a list of all the person's home phone in the one cell - but that adds a fair bit of work if you have to do it for many variations of phone/email v home/work etc, ie one view display per combination so the first option might be the better one to try</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-10T21:10:24.120Z
Answers.Text: This could potentially be an option but we occasionally have multiple email addresses or phone numbers in one location type, and when that happens with Views it creates multiple rows for the same contact -- setting the View's `Query Settings` as "Distinct" and "Pure Distinct" doesn't seem to affect it. Do you know of a trick for this case to ensure contacts aren't repeated?
Answers.UserDisplayName: Laryn
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-10T21:29:05.937Z
Answers.Text: you can create a View for the phone and then insert that as a column, so eg for Home Phone it would give you a list of all the person's home phone in the one cell - think it involves the https://www.drupal.org/project/views_field_view module and in the settings specify that it is to match based on eg contact_id, but that adds a fair bit of work if you have to do it for many variations of phone/email v home/work etc, ie one view display per combination
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-10T22:49:30.187Z
Answers.Text: in case you don't get notified of the Edit i made, see above re the Views Merge Rows module which might be simpler for your needs. let us know if you try it and it helps.
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-19T22:30:17.020Z
Answers.Text: Views Merge Rows is the bomb, I was not familiar! Drupal-specific answer but works for me in this case. Thx.
Answers.UserDisplayName: Laryn
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-21T07:28:36.790Z
Answers.Text: cool. thx for reporting back
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-10T18:37:57.513Z
Answers.LastActivityDate: 2016-02-10T22:48:41.763Z
Answers.LastEditDate: 2016-02-10T22:48:41.763Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>Old question but for a CiviCRM only solution, I found that Extended Report has a Report <code>Extended Report - Flexible contact report</code> that does an aggregation of all the phone numbers.</p>
  <p>As of version 5.8, you have to use the following PR to make it work : <a href="https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport/pull/461" rel="nofollow noreferrer">https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport/pull/461</a></p>
  <p>To use this method :</p>
  <ol>
  <li>install <a href="https://civicrm.org/extensions/extended-reports" rel="nofollow noreferrer">Extended Report</a> and patch with the PR</li>
  <li>in Reports -&gt; All Reports, create a <code>New Report</code> and choose <code>Extended Report - Flexible contact report</code></li>
  <li>choose the column <code>Phone</code></li>
  </ol>
  <p>You should have something like that in the phone column for each contact :</p>
  <p><a href="https://i.sstatic.net/X3q1d.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/X3q1d.png" alt="enter image description here" /></a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-12-04T19:49:22.640Z
Answers.Text: good on you for adding a better/newer answer
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-12-04T14:46:59.423Z
Answers.LastActivityDate: 2020-12-09T21:09:17.550Z
Answers.LastEditDate: 2020-12-09T21:09:17.550Z
Answers.UserDisplayName: samuelsov
Body: <p>Is it possible to select a location type for default contact reports, or is it just hard-coded to use the Primary address/email/phone? Also, would it be possible to list a report with multiple email addresses or phone numbers (e.g. a column for Home, Work, etc.)?</p>
  
Tags: <civireport><custom-reports><reports>
Title: Selecting location type or multiple email/phone fields in Reports
ThreadText: # Selecting location type or multiple email/phone fields in Reports
  
  (Asked by: username_0 on 2016-02-10)
  
  Is it possible to select a location type for default contact reports, or is it just hard-coded to use the Primary address/email/phone? Also, would it be possible to list a report with multiple email addresses or phone numbers (e.g. a column for Home, Work, etc.)?
  
  **Tags:** civireport, custom-reports, reports
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2020-12-04. Score: 4 | Accepted answer
  
  Old question but for a CiviCRM only solution, I found that Extended Report has a Report `Extended Report - Flexible contact report` that does an aggregation of all the phone numbers.
  
  As of version 5.8, you have to use the following PR to make it work : <https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport/pull/461>
  
  To use this method :
  
  1. install [Extended Report](https://civicrm.org/extensions/extended-reports) and patch with the PR
  2. in Reports -> All Reports, create a `New Report` and choose `Extended Report - Flexible contact report`
  3. choose the column `Phone`
  
  You should have something like that in the phone column for each contact :
  
  [![enter image description here](https://i.sstatic.net/X3q1d.png)](https://i.sstatic.net/X3q1d.png)
  
  > **Comments:**
  > **username_1**: good on you for adding a better/newer answer  
  
  ---
  
  ### Answer by username_1 on 2016-02-10. Score: 3
  
  Can't comment on CiviReports, but I know my way around Drupal Views enough to suggest that as an alternative option since it allows you to specify for each field/column which Location Type to use for the phone, email etc
  
  And to ensure you only see a single row for John even if he has multiple Work Phones it looks like there are two approaches.
  
  [Views Merge Rows](https://www.drupal.org/project/views_merge_rows) module (not tried it) or
  
  [Views Field View](https://www.drupal.org/project/views_field_view) which requires you to create a separate View display for each phone type/location and then insert that as a column, so eg for Home Phone it would give you a list of all the person's home phone in the one cell - but that adds a fair bit of work if you have to do it for many variations of phone/email v home/work etc, ie one view display per combination so the first option might be the better one to try
  
  > **Comments:**
  > **username_0**: This could potentially be an option but we occasionally have multiple email addresses or phone numbers in one location type, and when that happens with Views it creates multiple rows for the same contact -- setting the View's `Query Settings` as "Distinct" and "Pure Distinct" doesn't seem to affect it. Do you know of a trick for this case to ensure contacts aren't repeated?  
  > **username_1**: you can create a View for the phone and then insert that as a column, so eg for Home Phone it would give you a list of all the person's home phone in the one cell - think it involves the https://www.drupal.org/project/views_field_view module and in the settings specify that it is to match based on eg contact_id, but that adds a fair bit of work if you have to do it for many variations of phone/email v home/work etc, ie one view display per combination  
  > **username_1**: in case you don't get notified of the Edit i made, see above re the Views Merge Rows module which might be simpler for your needs. let us know if you try it and it helps.  
  > **username_0**: Views Merge Rows is the bomb, I was not familiar! Drupal-specific answer but works for me in this case. Thx.  
  > **username_1**: cool. thx for reporting back  
  
  ---
  
  