Body: <p>We have webform which we captured organization name, contact name and case assigned to manager(One of the contact type). We need to get all details in single report got contact and case details, but not able to get organisation name. can anyone help us how to select the organization name in custom php file, also we have created new template for this. </p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-25T15:25:37.747Z
Comments.Text: How is the organization name tied to the contact?  Is it an employer relationship?  Have you looked at the Extended Reports extension to see if it handles this?
Comments.UserDisplayName: Jon G - Megaphone Tech
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-25T19:26:20.703Z
Comments.Text: are you looking for the field 'organisation' or 'current employer'?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-26T09:40:28.500Z
Comments.Text: Relationship created as individual(contact) to Organization
Comments.UserDisplayName: kanchana
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-26T09:41:57.433Z
Comments.Text: Also i need to get contact with another relationship [Advisor of/Enquired by] in the same report
Comments.UserDisplayName: kanchana
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-26T09:45:05.097Z
Comments.Text: i have selected civicrm_contact_sort_name with  one relationship, how to get the another contact name which is captured in webform
Comments.UserDisplayName: kanchana
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-26T10:25:40.193Z
Comments.Text: In the webform we have captured the 4 different types of contact with case and contact relationship build.. How to take these four in the same report
Comments.UserDisplayName: kanchana
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-26T21:16:59.080Z
Comments.Text: I would build a Drupal View
Comments.UserDisplayName: petednz - fuzion
Tags: <relationships><reports>
Title: Report Customization
ThreadText: # Report Customization
  
  (Asked by: username_0 on 2019-07-25)
  
  We have webform which we captured organization name, contact name and case assigned to manager(One of the contact type). We need to get all details in single report got contact and case details, but not able to get organisation name. can anyone help us how to select the organization name in custom php file, also we have created new template for this.
  
  **Tags:** relationships, reports
  
  > **Comments:**
  > **username_1**: How is the organization name tied to the contact?  Is it an employer relationship?  Have you looked at the Extended Reports extension to see if it handles this?  
  > **username_2**: are you looking for the field 'organisation' or 'current employer'?  
  > **username_0**: Relationship created as individual(contact) to Organization  
  > **username_0**: Also i need to get contact with another relationship [Advisor of/Enquired by] in the same report  
  > **username_0**: i have selected civicrm_contact_sort_name with  one relationship, how to get the another contact name which is captured in webform  
  > **username_0**: In the webform we have captured the 4 different types of contact with case and contact relationship build.. How to take these four in the same report  
  > **username_2**: I would build a Drupal View  
  
  ---
  
  ## 0 answers
  
  