Answers.Body: <p>ReportPlus (<a href="https://civicrm.org/extensions/reportplus" rel="nofollow noreferrer">https://civicrm.org/extensions/reportplus</a>) is worth looking at.</p>
  
  <p>The included template report for 'Contribution Matrix Plus' definitely has a filter for 'Contribution is Recurring? - Any, Yes, No' already and I suspect some of the other templates will do too. </p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-01-28T10:43:39.557Z
Answers.LastActivityDate: 2020-01-28T10:43:39.557Z
Answers.UserDisplayName: RebeccaTregenna
Answers.Body: <p>Eileen's <a href="https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport" rel="nofollow noreferrer">Extended Reports</a> extension has contribution reports that may help. In the latest version ('master' branch, not yet officially released), Jon added a display field "Recurring Donation?" that can be selected under the 'Columns' tab. At first glance, it doesn't seem to be possible to filter using that option, but you could export all the results and then filter using your favourite spreadsheet software.</p>
  
  <p><a href="https://i.sstatic.net/UrPsK.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/UrPsK.png" alt="Contribution report columns"></a></p>
  
  <p>The Donation Summary report does not have a column/filter available, but looking at <a href="https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport/commit/5f840cd4e54ef91f96729c03865e1c6d9716235c" rel="nofollow noreferrer">Jon's patch here</a>, it should be relatively easy to add?</p>
  
  <p>In other words, a non-recurring contribution has an empty "recurring contribution ID", but it would be great to improve reports in general.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-04-27T22:24:59.063Z
Answers.Text: It is now possible to filter in Extended Reports by choosing Recurring Payments are not null or are null to include only or exclude recurring payments. And I've submitted some code to put this into core.
Answers.UserDisplayName: Lars SG
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-01-27T20:33:09.107Z
Answers.LastActivityDate: 2020-01-27T20:33:09.107Z
Answers.UserDisplayName: bgm
Answers.Body: <p>There are no such report that filters based on if contribution is recurring or not. As said by bgm if you are developer than you can use hook_civicrm_alterReportVar() hook or send a PR to core to add contribution recur filter on contribution report. Since you are using Drupal CMS you can create your own report using Views module. The views integration provide lots of filtering and fields selection and also you can export the results by installing relevant modules.</p>
  
  <p>An example of simple view which displays contribution id having recurring.</p>
  
  <pre><code>$view = new view();
  $view-&gt;name = 'contr';
  $view-&gt;description = '';
  $view-&gt;tag = 'default';
  $view-&gt;base_table = 'civicrm_contribution';
  $view-&gt;human_name = 'contr';
  $view-&gt;core = 7;
  $view-&gt;api_version = '3.0';
  $view-&gt;disabled = FALSE; /* Edit this to true to make a default view disabled initially */
  
  /* Display: Master */
  $handler = $view-&gt;new_display('default', 'Master', 'default');
  $handler-&gt;display-&gt;display_options['title'] = 'contr';
  $handler-&gt;display-&gt;display_options['use_more_always'] = FALSE;
  $handler-&gt;display-&gt;display_options['access']['type'] = 'none';
  $handler-&gt;display-&gt;display_options['cache']['type'] = 'none';
  $handler-&gt;display-&gt;display_options['query']['type'] = 'views_query';
  $handler-&gt;display-&gt;display_options['exposed_form']['type'] = 'basic';
  $handler-&gt;display-&gt;display_options['pager']['type'] = 'full';
  $handler-&gt;display-&gt;display_options['pager']['options']['items_per_page'] = '10';
  $handler-&gt;display-&gt;display_options['style_plugin'] = 'default';
  $handler-&gt;display-&gt;display_options['row_plugin'] = 'fields';
  /* Field: CiviCRM Contributions: Contribution ID */
  $handler-&gt;display-&gt;display_options['fields']['id']['id'] = 'id';
  $handler-&gt;display-&gt;display_options['fields']['id']['table'] = 'civicrm_contribution';
  $handler-&gt;display-&gt;display_options['fields']['id']['field'] = 'id';
  /* Filter criterion: CiviCRM  Recurring Contributions: Recurring Contribution ID */
  $handler-&gt;display-&gt;display_options['filters']['id']['id'] = 'id';
  $handler-&gt;display-&gt;display_options['filters']['id']['table'] = 'civicrm_contribution_recur';
  $handler-&gt;display-&gt;display_options['filters']['id']['field'] = 'id';
  $handler-&gt;display-&gt;display_options['filters']['id']['operator'] = 'not empty';
  
  /* Display: Page */
  $handler = $view-&gt;new_display('page', 'Page', 'page');
  $handler-&gt;display-&gt;display_options['path'] = 'contr';
  $translatables['contr'] = array(
    t('Master'),
    t('contr'),
    t('more'),
    t('Apply'),
    t('Reset'),
    t('Sort by'),
    t('Asc'),
    t('Desc'),
    t('Items per page'),
    t('- All -'),
    t('Offset'),
    t('« first'),
    t('‹ previous'),
    t('next ›'),
    t('last »'),
    t('Contribution ID'),
    t('.'),
    t(','),
    t('Page'),
  );
  </code></pre>
  
  <p>Thanks</p>
  
  <p>Pradeep</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-01-27T23:12:19.923Z
Answers.LastActivityDate: 2020-01-27T23:12:19.923Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>Is there any way to get a report, ideally something like the Contribution Summary report, which allows you to filter by recurring or non-recurring contribution?</p>
  
  <p>It would be quite useful to be able to get a report of all the donors who gave more than $XXX last year, but exclude recurring contributions. There are reports that will show only recurring donations, but I can't seem to find anything in reports that allows me to exclude recurring donations (obviously, this is easily done in contribution search, but that doesn't let me find aggregate contributions over the year).</p>
  
  <p>If this isn't currently possible, is it as simple as looking for donations with an empty or not-empty recurring contribution ID?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-01-27T18:07:03.110Z
Comments.Text: Are you on drupal or wordpress?
Comments.UserDisplayName: Pradeep Nayak
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-01-27T22:58:12.420Z
Comments.Text: We're on Drupal
Comments.UserDisplayName: Lars SG
Tags: <civicontribute><civireport><contributions><recurring-contributions><reports>
Title: How to generate a report excluding recurring contributions?
ThreadText: # How to generate a report excluding recurring contributions?
  
  (Asked by: username_0 on 2020-01-27)
  
  Is there any way to get a report, ideally something like the Contribution Summary report, which allows you to filter by recurring or non-recurring contribution?
  
  It would be quite useful to be able to get a report of all the donors who gave more than $XXX last year, but exclude recurring contributions. There are reports that will show only recurring donations, but I can't seem to find anything in reports that allows me to exclude recurring donations (obviously, this is easily done in contribution search, but that doesn't let me find aggregate contributions over the year).
  
  If this isn't currently possible, is it as simple as looking for donations with an empty or not-empty recurring contribution ID?
  
  **Tags:** civicontribute, civireport, contributions, recurring-contributions, reports
  
  > **Comments:**
  > **username_1**: Are you on drupal or wordpress?  
  > **username_0**: We're on Drupal  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_2 on 2020-01-28. Score: 4
  
  ReportPlus (<https://civicrm.org/extensions/reportplus>) is worth looking at.
  
  The included template report for 'Contribution Matrix Plus' definitely has a filter for 'Contribution is Recurring? - Any, Yes, No' already and I suspect some of the other templates will do too.
  
  
  ---
  
  ### Answer by username_3 on 2020-01-27. Score: 3
  
  Eileen's [Extended Reports](https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport) extension has contribution reports that may help. In the latest version ('master' branch, not yet officially released), Jon added a display field "Recurring Donation?" that can be selected under the 'Columns' tab. At first glance, it doesn't seem to be possible to filter using that option, but you could export all the results and then filter using your favourite spreadsheet software.
  
  [![Contribution report columns](https://i.sstatic.net/UrPsK.png)](https://i.sstatic.net/UrPsK.png)
  
  The Donation Summary report does not have a column/filter available, but looking at [Jon's patch here](https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport/commit/5f840cd4e54ef91f96729c03865e1c6d9716235c), it should be relatively easy to add?
  
  In other words, a non-recurring contribution has an empty "recurring contribution ID", but it would be great to improve reports in general.
  
  > **Comments:**
  > **username_0**: It is now possible to filter in Extended Reports by choosing Recurring Payments are not null or are null to include only or exclude recurring payments. And I've submitted some code to put this into core.  
  
  ---
  
  ### Answer by username_1 on 2020-01-27. Score: 2
  
  There are no such report that filters based on if contribution is recurring or not. As said by username_3 if you are developer than you can use hook_civicrm_alterReportVar() hook or send a PR to core to add contribution recur filter on contribution report. Since you are using Drupal CMS you can create your own report using Views module. The views integration provide lots of filtering and fields selection and also you can export the results by installing relevant modules.
  An example of simple view which displays contribution id having recurring.
  $view = new view();
  $view->name = 'contr';
  $view->description = '';
  $view->tag = 'default';
  $view->base_table = 'civicrm_contribution';
  $view->human_name = 'contr';
  $view->core = 7;
  $view->api_version = '3.0';
  $view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
  
  /* Display: Master */
  $handler = $view->new_display('default', 'Master', 'default');
  $handler->display->display_options['title'] = 'contr';
  $handler->display->display_options['use_more_always'] = FALSE;
  $handler->display->display_options['access']['type'] = 'none';
  $handler->display->display_options['cache']['type'] = 'none';
  $handler->display->display_options['query']['type'] = 'views_query';
  $handler->display->display_options['exposed_form']['type'] = 'basic';
  $handler->display->display_options['pager']['type'] = 'full';
  $handler->display->display_options['pager']['options']['items_per_page'] = '10';
  $handler->display->display_options['style_plugin'] = 'default';
  $handler->display->display_options['row_plugin'] = 'fields';
  /* Field: CiviCRM Contributions: Contribution ID */
  $handler->display->display_options['fields']['id']['id'] = 'id';
  $handler->display->display_options['fields']['id']['table'] = 'civicrm_contribution';
  $handler->display->display_options['fields']['id']['field'] = 'id';
  /* Filter criterion: CiviCRM  Recurring Contributions: Recurring Contribution ID */
  $handler->display->display_options['filters']['id']['id'] = 'id';
  $handler->display->display_options['filters']['id']['table'] = 'civicrm_contribution_recur';
  $handler->display->display_options['filters']['id']['field'] = 'id';
  $handler->display->display_options['filters']['id']['operator'] = 'not empty';
  
  /* Display: Page */
  $handler = $view->new_display('page', 'Page', 'page');
  $handler->display->display_options['path'] = 'contr';
  $translatables['contr'] = array(
    t('Master'),
    t('contr'),
    t('more'),
    t('Apply'),
    t('Reset'),
    t('Sort by'),
    t('Asc'),
    t('Desc'),
    t('Items per page'),
    t('- All -'),
    t('Offset'),
    t('« first'),
    t('‹ previous'),
    t('next ›'),
    t('last »'),
    t('Contribution ID'),
    t('.'),
    t(','),
    t('Page'),
  );
  
  Thanks
  Pradeep
  
  
  ---
  
  