Body: <p>I established a custom field (Anonymous) on the contribution object, which works well with the <strong>Contribution Detail</strong> report. I can use it to exclude anonymous contributions from that report, or to include only anonymous contributions. But when I try to use the field to exclude anonymous contributions from the <strong>Top Donors</strong> report, I get a DB error message:
  <a href="https://i.sstatic.net/dGNlZ.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/dGNlZ.png" alt="enter image description here"></a></p>
  
  <p>Background: </p>
  
  <p>We just upgraded to CiviCRM 4.6.6 under Joomla! 3.4.3 (PHP Version 5.4.44 MySQL 5.6.23). </p>
  
  <p>We enter contributions offline, some of which the donor wants to keep anonymous.  I saw a Best Practices post on the CiviCRM community forum where Lobo recommended establishing a custom field on the contribution object for this, and have done so.  I defined it as "searchable" so it shows up on the CiviReports Columns, Sorting, and Filters selection screens. But it seems trying to use it for any type of summary report (Contribution Summary, Top Donors, LYBUNT, etc.) results in the DB error message.</p>
  
  <p>Is there some parameter within the Administrator that I can change to enable custom fields to be used as filters on summary reports?  (The same error occurs if I try to use a different custom field defined on the contact object in a filter for a summary level report.)  I don't know if this is specific to Joomla! installations.  (I'm a newbie and not a techie.)</p>
  
  <p>Thanks for any advice!</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-09-09T16:40:12.847Z
Comments.Text: This happens on the demo server as well -- tested with Contribution Summary report (worked) and Top Donors report (didn't work).
Comments.UserDisplayName: Laryn
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-09-11T00:46:41.283Z
Comments.Text: The behavior you're expecting is the correct behavior.  You're seeing a bug.  If you can replicate it on the demo server with Debugging and Backtrace turned on, you can probably submit a bug report for it.  That said - the core team with their limited resources may not fix this on their own just because you submit it.  You may want to hire someone to patch it and send them the patch - or to submit it to the paid issue queue: https://civicrm.org/paid-issue-queue
Comments.UserDisplayName: Jon G - Megaphone Tech
Tags: <custom-fields><civireport>
Title: Can custom fields be used in Filters for summary level reports?
ThreadText: # Can custom fields be used in Filters for summary level reports?
  
  (Asked by: username_0 on 2015-09-09)
  
  I established a custom field (Anonymous) on the contribution object, which works well with the **Contribution Detail** report. I can use it to exclude anonymous contributions from that report, or to include only anonymous contributions. But when I try to use the field to exclude anonymous contributions from the **Top Donors** report, I get a DB error message:
  [![enter image description here](https://i.sstatic.net/dGNlZ.png)](https://i.sstatic.net/dGNlZ.png)
  
  Background:
  
  We just upgraded to CiviCRM 4.6.6 under Joomla! 3.4.3 (PHP Version 5.4.44 MySQL 5.6.23).
  
  We enter contributions offline, some of which the donor wants to keep anonymous. I saw a Best Practices post on the CiviCRM community forum where Lobo recommended establishing a custom field on the contribution object for this, and have done so. I defined it as "searchable" so it shows up on the CiviReports Columns, Sorting, and Filters selection screens. But it seems trying to use it for any type of summary report (Contribution Summary, Top Donors, LYBUNT, etc.) results in the DB error message.
  
  Is there some parameter within the Administrator that I can change to enable custom fields to be used as filters on summary reports? (The same error occurs if I try to use a different custom field defined on the contact object in a filter for a summary level report.) I don't know if this is specific to Joomla! installations. (I'm a newbie and not a techie.)
  
  Thanks for any advice!
  
  **Tags:** custom-fields, civireport
  
  > **Comments:**
  > **username_1**: This happens on the demo server as well -- tested with Contribution Summary report (worked) and Top Donors report (didn't work).  
  > **username_2**: The behavior you're expecting is the correct behavior.  You're seeing a bug.  If you can replicate it on the demo server with Debugging and Backtrace turned on, you can probably submit a bug report for it.  That said - the core team with their limited resources may not fix this on their own just because you submit it.  You may want to hire someone to patch it and send them the patch - or to submit it to the paid issue queue: https://civicrm.org/paid-issue-queue  
  
  ---
  
  ## 0 answers
  
  