Answers.Body: <p>I think <a href="https://civicrm.org/extensions/extended-reports" rel="nofollow noreferrer">Extended report extension</a> does provide Line item financial type filtering but not sure if they filter only recurring contribution. There are of Contribution reports with additional filter/fields available that are not present in core reports. You may need to add filter to show only recurring contribution using <a href="https://docs.civicrm.org/dev/en/latest/hooks/hook_civicrm_alterReportVar/" rel="nofollow noreferrer">hook_civicrm_alterReportVar</a> hook.</p>
  
  <p>(Even Bookkeeping Transactions Report does filter financial type using line item FT.)</p>
  
  <p>HTH</p>
  
  <p>Pradeep</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-06-27T14:29:17.180Z
Answers.LastActivityDate: 2018-06-27T14:29:17.180Z
Answers.UserDisplayName: Pradeep Nayak
Answers.Body: <p>I do not think there is a standard report that shows the line item financial type, but I might be mistaken.
  You can query the table <code>civicrm_line_item</code> if you have some kind of BI tool?</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-06-27T14:15:32.787Z
Answers.LastActivityDate: 2018-06-27T14:15:32.787Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>I am looking for a report that lists recurring contributions by Line item financial type. I have tried the Find Contribution report, the Advanced Search, the contribution report Recurring Contributions... They all only query the Contribution table Financial Type. I need to query the Line Item financial type.</p>
  
Tags: <recurring-contributions>
Title: Recurring contribution report by LineItem financial type
ThreadText: # Recurring contribution report by LineItem financial type
  
  (Asked by: username_0 on 2018-06-27)
  
  I am looking for a report that lists recurring contributions by Line item financial type. I have tried the Find Contribution report, the Advanced Search, the contribution report Recurring Contributions... They all only query the Contribution table Financial Type. I need to query the Line Item financial type.
  
  **Tags:** recurring-contributions
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2018-06-27. Score: 0
  
  I think [Extended report extension](https://civicrm.org/extensions/extended-reports) does provide Line item financial type filtering but not sure if they filter only recurring contribution. There are of Contribution reports with additional filter/fields available that are not present in core reports. You may need to add filter to show only recurring contribution using [hook\_civicrm\_alterReportVar](https://docs.civicrm.org/dev/en/latest/hooks/hook_civicrm_alterReportVar/) hook.
  
  (Even Bookkeeping Transactions Report does filter financial type using line item FT.)
  
  HTH
  
  username_1
  
  
  ---
  
  ### Answer by username_2 on 2018-06-27. Score: 0
  
  I do not think there is a standard report that shows the line item financial type, but I might be mistaken.
  You can query the table `civicrm_line_item` if you have some kind of BI tool?
  
  
  ---
  
  