Body: <p>When I try to create a Report with all contributions and include <strong>Contribution Note</strong> column (see picture), then the Report returns <em>only</em> those Contributions that contain Contribution Note. Or, conversely, the Report does not include contributions whose Contribution Note is empty/null.</p>
  <p>In the Filters tab I leave the Contribution Note setting empty.</p>
  <p><a href="https://i.sstatic.net/wZK7k.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/wZK7k.png" alt="enter image description here" /></a></p>
  <p>Furthermore, if I ask to return only contributions where Contribution Note is null, the Report does not return any (although many such contributions exist).</p>
  <p><a href="https://i.sstatic.net/WuOa3.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/WuOa3.png" alt="enter image description here" /></a></p>
  <p>This way the Contribution Note settings works very different from Contribution Source setting. Namely, if Contribution Source column is checked, but there Contribution does not have any Contribution Source, the Contribution is still included in the Report.</p>
  <p>What is the problem here? How can I include all contributions and display Contribution Note (if there is one) and not display Contribution Note (if it is empty)?</p>
  <p>CiviCRM 5.68.1. for Drupal 7</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-03-28T22:19:51.263Z
Comments.Text: How about using SearchKit rather than the report? Then this would be under your control
Comments.UserDisplayName: Andy Clark
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2024-04-03T14:34:33.203Z
Comments.Text: @AndyClark I would be glad to. However, Reports has a functionality that SearchKit does not, namely, Reports can send CSV to email (which is then further automated). 
  
  How can I achieve something similar with SearchKit?
Comments.UserDisplayName: Aivars
Tags: <civireport><contributions>
Title: A bug with Contribution Note in CiviCRM reports? Can I fix it?
ThreadText: # A bug with Contribution Note in CiviCRM reports? Can I fix it?
  
  (Asked by: username_0 on 2024-03-28)
  
  When I try to create a Report with all contributions and include **Contribution Note** column (see picture), then the Report returns *only* those Contributions that contain Contribution Note. Or, conversely, the Report does not include contributions whose Contribution Note is empty/null.
  
  In the Filters tab I leave the Contribution Note setting empty.
  
  [![enter image description here](https://i.sstatic.net/wZK7k.png)](https://i.sstatic.net/wZK7k.png)
  
  Furthermore, if I ask to return only contributions where Contribution Note is null, the Report does not return any (although many such contributions exist).
  
  [![enter image description here](https://i.sstatic.net/WuOa3.png)](https://i.sstatic.net/WuOa3.png)
  
  This way the Contribution Note settings works very different from Contribution Source setting. Namely, if Contribution Source column is checked, but there Contribution does not have any Contribution Source, the Contribution is still included in the Report.
  
  What is the problem here? How can I include all contributions and display Contribution Note (if there is one) and not display Contribution Note (if it is empty)?
  
  CiviCRM 5.68.1. for Drupal 7
  
  **Tags:** civireport, contributions
  
  > **Comments:**
  > **username_1**: How about using SearchKit rather than the report? Then this would be under your control  
  > **username_0**: @username_1 I would be glad to. However, Reports has a functionality that SearchKit does not, namely, Reports can send CSV to email (which is then further automated).   How can I achieve something similar with SearchKit?  
  
  ---
  
  ## 0 answers
  
  