Answers.Body: <p>There was <a href="https://github.com/civicrm/civicrm-core/pull/20752" rel="nofollow noreferrer">https://github.com/civicrm/civicrm-core/pull/20752</a> but I don't think it fully fixed it everywhere, so the short answer is it might require some code. But maybe the fix and discussion there will give some pointers.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-10-08T01:12:31.763Z
Answers.LastActivityDate: 2021-10-08T01:12:31.763Z
Answers.UserDisplayName: Demerit
Body: <p>I have a custom field, &quot;Location&quot; with 10 values. There are a variable number of Mentors at each location. I'm trying to get a report that, for each location, has Location as section heading, following by the number of Mentors at that location and then a list of those Mentors.</p>
  <p>If I do not choose the Location as a column in the report, my first section heading is Location: 1 (16).</p>
  <p>If I select Location as a column, I get Location: Miami (). Plus I have a column repeating the value &quot;Miami&quot; which is not useful.</p>
  <p>The section heading I want is: Location: Miami (16)</p>
  <p>Is there a simple way to accomplish this or does it require code?</p>
  
Tags: <reports><custom-reports>
Title: contact report with custom field as section heading
ThreadText: # contact report with custom field as section heading
  
  (Asked by: username_0 on 2021-10-08)
  
  I have a custom field, "Location" with 10 values. There are a variable number of Mentors at each location. I'm trying to get a report that, for each location, has Location as section heading, following by the number of Mentors at that location and then a list of those Mentors.
  
  If I do not choose the Location as a column in the report, my first section heading is Location: 1 (16).
  
  If I select Location as a column, I get Location: Miami (). Plus I have a column repeating the value "Miami" which is not useful.
  
  The section heading I want is: Location: Miami (16)
  
  Is there a simple way to accomplish this or does it require code?
  
  **Tags:** reports, custom-reports
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2021-10-08. Score: 0
  
  There was <https://github.com/civicrm/civicrm-core/pull/20752> but I don't think it fully fixed it everywhere, so the short answer is it might require some code. But maybe the fix and discussion there will give some pointers.
  
  
  ---
  
  