Answers.Body: <p>This appears to be a regression in CiviCRM 4.6.32.  (It doesn't appear to affect CiviCRM 4.7.28.)</p>
  
  <p>I have recreated this on the <a href="http://d46.demo.civicrm.org/civicrm/report/instance/3?reset=1" rel="nofollow noreferrer">sandbox site</a>.</p>
  
  <p>I have raised this as a bug in the CiviCRM issue queue:</p>
  
  <p><a href="https://issues.civicrm.org/jira/browse/CRM-21333" rel="nofollow noreferrer">Custom fields of type select not displaying in Activity Report</a></p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>It was subsequently raised as a bug by Martin Castle:</p>
  
  <p><a href="https://issues.civicrm.org/jira/browse/CRM-21402" rel="nofollow noreferrer">Custom data fails to pull through to reports</a> </p>
  
  <p>And a fix has been released by VangelisP:</p>
  
  <p><a href="https://github.com/civicrm/civicrm-core/pull/11262" rel="nofollow noreferrer">Resolves regression issue with non-dynamic custom fields</a></p>
  
  <p>This will hopefully be included in a future release of CiviCRM 4.6</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-11-03T01:23:52.127Z
Answers.Text: I see the same issue after upgrading Drupal installation to 4.6.32, just installed 4.6.33 and the issue remains. I have two custom fields in the same report, the radio type appears normally but the check box type does not show the field value that is stored in the database.
Answers.UserDisplayName: Keith Webb
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-19T11:03:45.453Z
Answers.LastActivityDate: 2017-11-17T18:26:49.700Z
Answers.LastEditDate: 2017-11-17T18:26:49.700Z
Answers.UserDisplayName: William Mortada
Answers.Body: <p>Just updated to 4.6.36 and the bug has been resolved! Thank you</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-03-18T12:08:19.050Z
Answers.LastActivityDate: 2018-03-18T12:08:19.050Z
Answers.UserDisplayName: Keith Webb
Answers.Body: <p>Did you check the <code>in_selector</code> column in the <code>civicrm_custom_field</code> table? I seem to recollect I had to set those to 1 but I am not sure...</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-20T12:39:36.737Z
Answers.Text: Thanks Eric, I don't actually have access to the database for this site but I've managed to recreate the issue on the sandbox site so I don't think it is about any specific database settings.
Answers.UserDisplayName: William Mortada
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-19T11:05:24.883Z
Answers.LastActivityDate: 2017-10-19T11:05:24.883Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>A site I'm working on has recently been upgraded to version 4.6.32.  Since this upgrade the client is no longer able to see data from some of the custom fields in the Activity Report.  </p>
  
  <p>Custom fields of type 'text' display fine, but fields of type 'select' are blank even though there is data stored in this field.</p>
  
  <p>The site is running CiviCRM 4.6.32 on Drupal 7.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-11-21T15:22:00.653Z
Comments.Text: The patch noted below did not work for my issue. I'm still digging around to find the culprit, as mentioned it only check box, radio displays without issue.
Comments.UserDisplayName: Keith Webb
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-11-21T16:08:55.670Z
Comments.Text: Thanks for the update Keith. Let us know what you discover.
Comments.UserDisplayName: William Mortada
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-02-28T16:02:38.370Z
Comments.Text: The patch didn't work for me. The if statement in the patch is never true because $value always contains a square character at either end. And they don't exist in $cf_values['value'] (at least not for my data).
Comments.UserDisplayName: Michael Chaplin
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-03-18T12:07:29.123Z
Comments.Text: Just updated to 4.6.36 and the bug has been resolved!  Thank you
Comments.UserDisplayName: Keith Webb
Tags: <custom-fields><civireport><activities><4.6>
Title: Custom fields of type select not displaying in Activity Report
ThreadText: # Custom fields of type select not displaying in Activity Report
  
  (Asked by: username_0 on 2017-10-19)
  
  A site I'm working on has recently been upgraded to version 4.6.32. Since this upgrade the client is no longer able to see data from some of the custom fields in the Activity Report.
  
  Custom fields of type 'text' display fine, but fields of type 'select' are blank even though there is data stored in this field.
  
  The site is running CiviCRM 4.6.32 on Drupal 7.
  
  **Tags:** custom-fields, civireport, activities, 4.6
  
  > **Comments:**
  > **username_1**: The patch noted below did not work for my issue. I'm still digging around to find the culprit, as mentioned it only check box, radio displays without issue.  
  > **username_0**: Thanks for the update username_1. Let us know what you discover.  
  > **username_2**: The patch didn't work for me. The if statement in the patch is never true because $value always contains a square character at either end. And they don't exist in $cf_values['value'] (at least not for my data).  
  > **username_1**: Just updated to 4.6.36 and the bug has been resolved!  Thank you  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_0 on 2017-10-19. Score: 2 | Accepted answer
  
  This appears to be a regression in CiviCRM 4.6.32. (It doesn't appear to affect CiviCRM 4.7.28.)
  
  I have recreated this on the [sandbox site](http://d46.demo.civicrm.org/civicrm/report/instance/3?reset=1).
  
  I have raised this as a bug in the CiviCRM issue queue:
  
  [Custom fields of type select not displaying in Activity Report](https://issues.civicrm.org/jira/browse/CRM-21333)
  
  **UPDATE**
  
  It was subsequently raised as a bug by Martin Castle:
  
  [Custom data fails to pull through to reports](https://issues.civicrm.org/jira/browse/CRM-21402)
  
  And a fix has been released by VangelisP:
  
  [Resolves regression issue with non-dynamic custom fields](https://github.com/civicrm/civicrm-core/pull/11262)
  
  This will hopefully be included in a future release of CiviCRM 4.6
  
  > **Comments:**
  > **username_1**: I see the same issue after upgrading Drupal installation to 4.6.32, just installed 4.6.33 and the issue remains. I have two custom fields in the same report, the radio type appears normally but the check box type does not show the field value that is stored in the database.  
  
  ---
  
  ### Answer by username_1 on 2018-03-18. Score: 1
  
  Just updated to 4.6.36 and the bug has been resolved! Thank you
  
  
  ---
  
  ### Answer by username_3 on 2017-10-19. Score: 0
  
  Did you check the `in_selector` column in the `civicrm_custom_field` table? I seem to recollect I had to set those to 1 but I am not sure...
  
  > **Comments:**
  > **username_0**: Thanks Eric, I don't actually have access to the database for this site but I've managed to recreate the issue on the sandbox site so I don't think it is about any specific database settings.  
  
  ---
  
  