Body: <p>I've created a relationship report through the Extended Reports extension but have run into a challenging situation.  I want the report to show detailed information (in this case, the name of the leading office) rather than the ID number stored in the table.  Is there a way to make this happen without creating custom code?  We're using 5.16.4.  Thanks.</p>
  
  <p><a href="https://i.sstatic.net/5jdLb.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/5jdLb.jpg" alt="enter image description here"></a></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-12-02T18:32:11.057Z
Comments.Text: In case you don't get a quick answer, worth mentioning what CMS you are using as some reports are easier to build with CMS tools, eg Views for Drupal.
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-12-02T21:52:15.267Z
Comments.Text: Good point.  I should have mentioned that we are currently using Drupal 7.
Comments.UserDisplayName: J. Rolfs
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-12-02T22:45:46.190Z
Comments.Text: if you are using Drupal then i would build this with Views myself
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-12-02T22:50:49.433Z
Comments.Text: Ok.  We'll look into that option.  Thanks.
Comments.UserDisplayName: J. Rolfs
Tags: <extension><civireport>
Title: Lookup Field in Extended Reports
ThreadText: # Lookup Field in Extended Reports
  
  (Asked by: username_0 on 2019-12-02)
  
  I've created a relationship report through the Extended Reports extension but have run into a challenging situation. I want the report to show detailed information (in this case, the name of the leading office) rather than the ID number stored in the table. Is there a way to make this happen without creating custom code? We're using 5.16.4. Thanks.
  
  [![enter image description here](https://i.sstatic.net/5jdLb.jpg)](https://i.sstatic.net/5jdLb.jpg)
  
  **Tags:** extension, civireport
  
  > **Comments:**
  > **username_1**: In case you don't get a quick answer, worth mentioning what CMS you are using as some reports are easier to build with CMS tools, eg Views for Drupal.  
  > **username_0**: Good point.  I should have mentioned that we are currently using Drupal 7.  
  > **username_1**: if you are using Drupal then i would build this with Views myself  
  > **username_0**: Ok.  We'll look into that option.  Thanks.  
  
  ---
  
  ## 0 answers
  
  