Answers.Body: <p>To build a View you would start with a view based on Contacts. Then add Drupal relationship (under Advanced) to add Contact A to the relationship of 'employee/employer'. Then add fields for eg Display Name (use Relationship to make it the organisation), add display Name, add Membership Type etc. May need to tinker with Filters too.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-17T21:08:01.517Z
Answers.LastActivityDate: 2016-04-17T21:08:01.517Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>Personally (others will disagree!) I've always found writing CiviCRM Reports to be a horrible Pain In The MySQL!</p>
  
  <p>There are two really easy ways to get what you want:</p>
  
  <p>1) Make a Custom Profile of type "Search Results" then, on advance search, you will see all of these columns side by side, in whichever order and with ability to sort by any column.</p>
  
  <p>2) (If you are a coder or have access to one) build a custom extension! Extensions that retrieve data and display it are really quick to write - one like this would take less than a day. An expert could bang it out in an afternoon.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-20T15:54:19.533Z
Answers.Text: 1/ Custom Profile does not seem possible : I need 2 different contacts on the same report line : Organization (or Source ?) and Member (Individual) : I see no way to manage that ; 2/ I am not a coder
Answers.UserDisplayName: Jacques-Marie Moranne
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-17T21:08:59.127Z
Answers.Text: if you add 'current employer' field you can get the Org on a profile too
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-17T22:30:01.457Z
Answers.LastActivityDate: 2016-03-17T22:30:01.457Z
Answers.UserDisplayName: JohnFF
Body: <p>I have several Organizations</p>
  
  <p>I need a Report which displays the following columns :
  Organization, Membership Type, Member (first and last name), email, Phone, Status</p>
  
  <p>I would like this Report sorted by the 3 first columns, and/or filtered by Organization.</p>
  
  <p>How can I ?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-03-17T09:38:19.967Z
Comments.Text: What CMS are you using?  If Drupal, then look at Views
Comments.UserDisplayName: Aidan
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-03-18T22:33:53.453Z
Comments.Text: I use Drupal ; I am aware of Views, but am not sure of its conveniance ; I have to get deeper into it. Can you give me some indications ?
Comments.UserDisplayName: Jacques-Marie Moranne
Tags: <civimember><civireport>
Title: How to have a Detailed Membership Report filtered/sorted by pertaining Organization
ThreadText: # How to have a Detailed Membership Report filtered/sorted by pertaining Organization
  
  (Asked by: username_0 on 2016-03-17)
  
  I have several Organizations
  
  I need a Report which displays the following columns :
  Organization, Membership Type, Member (first and last name), email, Phone, Status
  
  I would like this Report sorted by the 3 first columns, and/or filtered by Organization.
  
  How can I ?
  
  **Tags:** civimember, civireport
  
  > **Comments:**
  > **username_1**: What CMS are you using?  If Drupal, then look at Views  
  > **username_0**: I use Drupal ; I am aware of Views, but am not sure of its conveniance ; I have to get deeper into it. Can you give me some indications ?  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2016-04-17. Score: 1
  
  To build a View you would start with a view based on Contacts. Then add Drupal relationship (under Advanced) to add Contact A to the relationship of 'employee/employer'. Then add fields for eg Display Name (use Relationship to make it the organisation), add display Name, add Membership Type etc. May need to tinker with Filters too.
  
  
  ---
  
  ### Answer by username_3 on 2016-03-17. Score: 1
  
  Personally (others will disagree!) I've always found writing CiviCRM Reports to be a horrible Pain In The MySQL!
  
  There are two really easy ways to get what you want:
  
  1) Make a Custom Profile of type "Search Results" then, on advance search, you will see all of these columns side by side, in whichever order and with ability to sort by any column.
  
  2) (If you are a coder or have access to one) build a custom extension! Extensions that retrieve data and display it are really quick to write - one like this would take less than a day. An expert could bang it out in an afternoon.
  
  > **Comments:**
  > **username_0**: 1/ Custom Profile does not seem possible : I need 2 different contacts on the same report line : Organization (or Source ?) and Member (Individual) : I see no way to manage that ; 2/ I am not a coder  
  > **username_2**: if you add 'current employer' field you can get the Org on a profile too  
  
  ---
  
  