Answers.Body: <p>If you're using CiviCRM 4.6, there's now a CiviCRM report template that uses the recurring contribution table as a base and gives you access to a bunch of those related fields.</p>
  
  <p>I've got a custom extension here: <a href="https://github.com/adixon/ca.civicrm.contributionrecur" rel="nofollow">https://github.com/adixon/ca.civicrm.contributionrecur</a>
  which backports that report to earlier CiviCRM versions, and also adds a few more fields.</p>
  
  <p>I notice in your picture you are actually trying to export records, presumably to generate a report in a separate piece of software. You can do something similar from any (CiviCRM) report, i.e. it has a csv download option, and the ability to select which fields to show.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-10T14:18:04.790Z
Answers.LastActivityDate: 2016-02-10T14:18:04.790Z
Answers.UserDisplayName: Alan Dixon
Answers.Body: <p>You can get the recurring units and recurring interval from civicrm_contribution_recur table (looking at it in phpMyAdmin is likely easiest, or you can examine the code's xml schema definition at <a href="https://github.com/civicrm/civicrm-core/blob/master/xml/schema/Contribute/ContributionRecur.xml#L61" rel="nofollow">https://github.com/civicrm/civicrm-core/blob/master/xml/schema/Contribute/ContributionRecur.xml#L61</a> and <a href="https://github.com/civicrm/civicrm-core/blob/master/xml/schema/Contribute/ContributionRecur.xml#L78" rel="nofollow">https://github.com/civicrm/civicrm-core/blob/master/xml/schema/Contribute/ContributionRecur.xml#L78</a>. </p>
  
  <p>I'm not sure what you mean by 'Offer installments' but if it is the installments paid so far, then you can retrieve all of the records in civicrm_contribution table where civicrm_contribution.contribution_recur_id = civicrm_contribution_recur.id (<a href="https://github.com/civicrm/civicrm-core/blob/master/xml/schema/Contribute/Contribution.xml#L345" rel="nofollow">https://github.com/civicrm/civicrm-core/blob/master/xml/schema/Contribute/Contribution.xml#L345</a>).</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-02T16:38:12.970Z
Answers.LastActivityDate: 2015-12-02T16:38:12.970Z
Answers.UserDisplayName: Joe Murray
Body: <p>I want recurring related fields on the custom report, but there is only one field available as per the civicrm i.e. <strong>Recurring contribution ID</strong>.</p>
  
  <p>The fields that I was looking for are <strong>Recurring Units</strong>, <strong>Recurring Intervals</strong>, <strong>Offer Installments</strong>. I am quite unsure if there is some configuration available on civicrm with which we can achieve this. Also please help if there is any API hooks that I can use it to make this happen.</p>
  
  <p><a href="https://i.sstatic.net/Jc4w0.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/Jc4w0.png" alt="enter image description here"></a></p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-11-30T07:03:01.983Z
Comments.Text: Recurring contributions are stored as a seperate entity/SQL-table. The only link to the contribution entity/SQL-table is recurring contribution ID.
Comments.UserDisplayName: Flying
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-11-30T07:13:26.023Z
Comments.Text: @Flying thank you for the informations, is there any hooks or api that can be used to extend this form and add extra recurring fields ?
Comments.UserDisplayName: shrish
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-11-30T07:14:20.030Z
Comments.Text: Probably, but that is out of my reach...:-)
Comments.UserDisplayName: Flying
Tags: <civireport><contributions><recurring-contributions>
Title: How can we have recurring related fields on custom report?
ThreadText: # How can we have recurring related fields on custom report?
  
  (Asked by: username_0 on 2015-11-30)
  
  I want recurring related fields on the custom report, but there is only one field available as per the civicrm i.e. **Recurring contribution ID**.
  
  The fields that I was looking for are **Recurring Units**, **Recurring Intervals**, **Offer Installments**. I am quite unsure if there is some configuration available on civicrm with which we can achieve this. Also please help if there is any API hooks that I can use it to make this happen.
  
  [![enter image description here](https://i.sstatic.net/Jc4w0.png)](https://i.sstatic.net/Jc4w0.png)
  
  **Tags:** civireport, contributions, recurring-contributions
  
  > **Comments:**
  > **username_1**: Recurring contributions are stored as a seperate entity/SQL-table. The only link to the contribution entity/SQL-table is recurring contribution ID.  
  > **username_0**: @username_1 thank you for the informations, is there any hooks or api that can be used to extend this form and add extra recurring fields ?  
  > **username_1**: Probably, but that is out of my reach...:-)  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2016-02-10. Score: 2
  
  If you're using CiviCRM 4.6, there's now a CiviCRM report template that uses the recurring contribution table as a base and gives you access to a bunch of those related fields.
  
  I've got a custom extension here: <https://github.com/adixon/ca.civicrm.contributionrecur>
  which backports that report to earlier CiviCRM versions, and also adds a few more fields.
  
  I notice in your picture you are actually trying to export records, presumably to generate a report in a separate piece of software. You can do something similar from any (CiviCRM) report, i.e. it has a csv download option, and the ability to select which fields to show.
  
  
  ---
  
  ### Answer by username_3 on 2015-12-02. Score: 0
  
  You can get the recurring units and recurring interval from civicrm\_contribution\_recur table (looking at it in phpMyAdmin is likely easiest, or you can examine the code's xml schema definition at <https://github.com/civicrm/civicrm-core/blob/master/xml/schema/Contribute/ContributionRecur.xml#L61> and <https://github.com/civicrm/civicrm-core/blob/master/xml/schema/Contribute/ContributionRecur.xml#L78>.
  
  I'm not sure what you mean by 'Offer installments' but if it is the installments paid so far, then you can retrieve all of the records in civicrm\_contribution table where civicrm\_contribution.contribution\_recur\_id = civicrm\_contribution\_recur.id (<https://github.com/civicrm/civicrm-core/blob/master/xml/schema/Contribute/Contribution.xml#L345>).
  
  
  ---
  
  