Answers.Body: <p>I've investigated this myself, but haven't had to do it yet.  Broadly, you would use the <code>GROUP_CONCAT</code> MySQL function.  You can see examples of this being used on <a href="https://github.com/civicrm/civicrm-core/blob/master/CRM/Report/Form/Contribute/OrganizationSummary.php#L178" rel="nofollow noreferrer">core contribution reports</a> for displaying multiple credit card types for contributions paid in multiple installments with different cards.</p>
  
  <p>I also have a fork of the <a href="https://github.com/MegaphoneJon/com.jlacey.salutations/blob/no-addressee/salutations.php#L429" rel="nofollow noreferrer">salutations</a> extension that provides a UI for exporting multiple-record custom groups as part of an export.  Instead of putting all the data in a single cell, I break the data out into multiple columns, but all on the same row.</p>
  
  <p>You could also use the <a href="https://civicrm.org/extensions/sql-tasks-extension-configurable-recurring-tasks" rel="nofollow noreferrer">SQL Tasks extension</a> to generate the report using pure SQL, if you need a quicker solution and can trade off some configurability.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-05-20T22:43:33.207Z
Answers.LastActivityDate: 2020-05-20T22:43:33.207Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>We woud like a simple contact report which, rather than showing a single row for each custom field (with repeating contact name on each row), shows a single row for the contact and shows all the repeating custom data in a single cell.</p>
  
  <p>Could anyone share a simple reporting template example that does this?</p>
  
Tags: <civireport>
Title: How can I show multiple repeating custom field values in a single cell on a report?
ThreadText: # How can I show multiple repeating custom field values in a single cell on a report?
  
  (Asked by: username_0 on 2020-05-20)
  
  We woud like a simple contact report which, rather than showing a single row for each custom field (with repeating contact name on each row), shows a single row for the contact and shows all the repeating custom data in a single cell.
  
  Could anyone share a simple reporting template example that does this?
  
  **Tags:** civireport
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2020-05-20. Score: 1
  
  I've investigated this myself, but haven't had to do it yet. Broadly, you would use the `GROUP_CONCAT` MySQL function. You can see examples of this being used on [core contribution reports](https://github.com/civicrm/civicrm-core/blob/master/CRM/Report/Form/Contribute/OrganizationSummary.php#L178) for displaying multiple credit card types for contributions paid in multiple installments with different cards.
  
  I also have a fork of the [salutations](https://github.com/MegaphoneJon/com.jlacey.salutations/blob/no-addressee/salutations.php#L429) extension that provides a UI for exporting multiple-record custom groups as part of an export. Instead of putting all the data in a single cell, I break the data out into multiple columns, but all on the same row.
  
  You could also use the [SQL Tasks extension](https://civicrm.org/extensions/sql-tasks-extension-configurable-recurring-tasks) to generate the report using pure SQL, if you need a quicker solution and can trade off some configurability.
  
  
  ---
  
  