Answers.Body: <p>People build reports based on their clients requirement and if they think this is going to help others in the community they contribute code either in the form of sending PR to core or release as an extension publicly. </p>
  
  <p>I think (but not confident) <a href="https://civicrm.org/extensions/extended-reports" rel="nofollow noreferrer">Extended reports extension</a> does provides some additional filtering and reports, its worth trying if it meets your need. Else you can use <a href="https://docs.civicrm.org/dev/en/latest/hooks/hook_civicrm_alterReportVar/" rel="nofollow noreferrer">alterReportVar</a> hook to add filter to reports.</p>
  
  <p>Hope i answered your question!</p>
  
  <p>Pradeep</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-09-21T02:39:10.183Z
Answers.Text: Thanks Pradeep -- the Extended reports extension didn't seem to address that from what I could tell, and I'm trying to keep the project I'm working on as stock as possible, so I just added a custom field to handle it and made that searchable, and that seemed to do the trick. I appreciate the information both about the extension and the alterReportVar bit -- I may look into that in the future. Thanks again.
Answers.UserDisplayName: Matt Woodward
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-09-20T20:35:36.073Z
Answers.LastActivityDate: 2018-09-20T20:35:36.073Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>Before I add a custom field to handle this, I thought I'd make sure I'm not missing something.</p>
  
  <p>When I go to Contact Reports -> Constituent Summary, it appears you can include and filter on all the "Do not" privacy settings EXCEPT "Do not trade."</p>
  
  <p>Is there a way to add the ability to filter on "Do not trade?" Any idea why that one in particular is left out?</p>
  
  <p>Thanks.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-02-17T14:11:35.410Z
Comments.Text: Hi Matt. Did you manage to achieve this in your report? Would you mind sharing how you have done it please? I am in a similar situation.... thanks
Comments.UserDisplayName: Tapash
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-02-21T14:58:53.117Z
Comments.Text: Hi Tapash -- I wound up adding a custom field and making that searchable. I have since migrated to Salesforce so I didn't dig deeper into how to do this with the native CiviCRM functionality.
Comments.UserDisplayName: Matt Woodward
Tags: <contacts><reports><privacy>
Title: Filter Constituents on "Do not trade?"
ThreadText: # Filter Constituents on "Do not trade?"
  
  (Asked by: username_0 on 2018-09-20)
  
  Before I add a custom field to handle this, I thought I'd make sure I'm not missing something.
  
  When I go to Contact Reports -> Constituent Summary, it appears you can include and filter on all the "Do not" privacy settings EXCEPT "Do not trade."
  
  Is there a way to add the ability to filter on "Do not trade?" Any idea why that one in particular is left out?
  
  Thanks.
  
  **Tags:** contacts, reports, privacy
  
  > **Comments:**
  > **username_1**: Hi username_0. Did you manage to achieve this in your report? Would you mind sharing how you have done it please? I am in a similar situation.... thanks  
  > **username_0**: Hi username_1 -- I wound up adding a custom field and making that searchable. I have since migrated to Salesforce so I didn't dig deeper into how to do this with the native CiviCRM functionality.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2018-09-20. Score: 3 | Accepted answer
  
  People build reports based on their clients requirement and if they think this is going to help others in the community they contribute code either in the form of sending PR to core or release as an extension publicly.
  
  I think (but not confident) [Extended reports extension](https://civicrm.org/extensions/extended-reports) does provides some additional filtering and reports, its worth trying if it meets your need. Else you can use [alterReportVar](https://docs.civicrm.org/dev/en/latest/hooks/hook_civicrm_alterReportVar/) hook to add filter to reports.
  
  Hope i answered your question!
  
  username_2
  
  > **Comments:**
  > **username_0**: Thanks username_2 -- the Extended reports extension didn't seem to address that from what I could tell, and I'm trying to keep the project I'm working on as stock as possible, so I just added a custom field to handle it and made that searchable, and that seemed to do the trick. I appreciate the information both about the extension and the alterReportVar bit -- I may look into that in the future. Thanks again.  
  
  ---
  
  