Body: <p>i am confusing how to show all relationship in the exported report, there's a example below.</p>
  
  <p>Company A have 3 representatives in the relationship field.</p>
  
  <p>and using following method to export.</p>
  
  <p>find membership -> select Company A -> export members -> Select fields for export (Field Mapping).</p>
  
  <p>The exported report show 1 representative of comapny A only. Any advance or solution ?</p>
  
  <p>i have tried multiple columns on Using Field Mapping during "Select fields for export" phase. it doesn't work.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-02-01T20:32:36.107Z
Comments.Text: have you had a look at using the Relationships Report to export?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-02-02T02:18:27.490Z
Comments.Text: Hi petednz, thanks for your reply! Relationships Report show the name of contact A & B and their relationship only. any report can show all the relationship with the name, id, mail...those contact  information ? Thanks.
Comments.UserDisplayName: ttapp
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-02-02T19:53:40.433Z
Comments.Text: sorry but i didn't quite understand your comment. If you are saying 'no that report doesn't help as it doesn't include Custom fields' - you may want to add that requirement in your Subject. 2 other thoughts. Why not do a Search to find the people who are Employed, then export. perhaps that would give you what you need? If you are on Drupal then Views is the other option. If any of this is useful i will convert to an Answer
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-02-03T02:31:38.297Z
Comments.Text: My goal is that any report contain contacts information with their all relationship? so that the Relationships Report is not my purpose. Thanks.
Comments.UserDisplayName: ttapp
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-02-03T06:31:14.447Z
Comments.Text: Why not do a Search to find the people who are Employed (rather than the employers), then export. perhaps that would give you what you need? since each Employee will only have one Employer (hopefully)
Comments.UserDisplayName: petednz - fuzion
Tags: <export>
Title: How to export multiple relationships of contact
ThreadText: # How to export multiple relationships of contact
  
  (Asked by: username_0 on 2017-02-01)
  
  i am confusing how to show all relationship in the exported report, there's a example below.
  
  Company A have 3 representatives in the relationship field.
  
  and using following method to export.
  
  find membership -> select Company A -> export members -> Select fields for export (Field Mapping).
  
  The exported report show 1 representative of comapny A only. Any advance or solution ?
  
  i have tried multiple columns on Using Field Mapping during "Select fields for export" phase. it doesn't work.
  
  **Tags:** export
  
  > **Comments:**
  > **username_1**: have you had a look at using the Relationships Report to export?  
  > **username_0**: Hi username_1, thanks for your reply! Relationships Report show the name of contact A & B and their relationship only. any report can show all the relationship with the name, id, mail...those contact  information ? Thanks.  
  > **username_1**: sorry but i didn't quite understand your comment. If you are saying 'no that report doesn't help as it doesn't include Custom fields' - you may want to add that requirement in your Subject. 2 other thoughts. Why not do a Search to find the people who are Employed, then export. perhaps that would give you what you need? If you are on Drupal then Views is the other option. If any of this is useful i will convert to an Answer  
  > **username_0**: My goal is that any report contain contacts information with their all relationship? so that the Relationships Report is not my purpose. Thanks.  
  > **username_1**: Why not do a Search to find the people who are Employed (rather than the employers), then export. perhaps that would give you what you need? since each Employee will only have one Employer (hopefully)  
  
  ---
  
  ## 0 answers
  
  