Answers.Body: <p>I was able to add this to the bottom of the alterDisplay in the Recur.php file to change the Campaign Id to the Campaign Title.
  <a href="https://i.sstatic.net/fk6dB.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/fk6dB.png" alt="enter image description here"></a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-01-06T02:55:32.480Z
Answers.Text: Maybe I should submit this change to CiviCRM core? I think it would be beneficial to others
Answers.UserDisplayName: Scott Pulver
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-01-07T11:35:03.683Z
Answers.Text: Have you looked into ReportPlus yet? I'm sure that would allow you to specify, for example financial type and campaign and then filter for only recurring ones.
Answers.UserDisplayName: RebeccaTregenna
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-01-06T02:48:42.333Z
Answers.LastActivityDate: 2020-01-06T02:48:42.333Z
Answers.UserDisplayName: Scott Pulver
Body: <p>I'm trying to find a way to get a report on all the Recurring Contributions and what campaign they are attached too. Has anyone else done this? The Recurring Contributions report can give me the donations but there is no Campaign column.
  <a href="https://i.sstatic.net/Xt2z4.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/Xt2z4.png" alt="d"></a>
  Thanks</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-01-05T23:59:30.013Z
Comments.Text: So I was able to get the Campaign Id by changing the Recur.php file but I could only add campign_id. I would say I need to somehow do a join with the civicrm_campaign table to get the campaign title. Does anyone know the best way to do that?
Comments.UserDisplayName: Scott Pulver
Tags: <civicontribute><civireport><reports>
Title: CiviCRM Recurring Contributions Report with Campaign
ThreadText: # CiviCRM Recurring Contributions Report with Campaign
  
  (Asked by: username_0 on 2020-01-05)
  
  I'm trying to find a way to get a report on all the Recurring Contributions and what campaign they are attached too. Has anyone else done this? The Recurring Contributions report can give me the donations but there is no Campaign column.
  [![d](https://i.sstatic.net/Xt2z4.png)](https://i.sstatic.net/Xt2z4.png)
  Thanks
  
  **Tags:** civicontribute, civireport, reports
  
  > **Comments:**
  > **username_0**: So I was able to get the Campaign Id by changing the Recur.php file but I could only add campign_id. I would say I need to somehow do a join with the civicrm_campaign table to get the campaign title. Does anyone know the best way to do that?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2020-01-06. Score: 1
  
  I was able to add this to the bottom of the alterDisplay in the Recur.php file to change the Campaign Id to the Campaign Title.
  [![enter image description here](https://i.sstatic.net/fk6dB.png)](https://i.sstatic.net/fk6dB.png)
  
  > **Comments:**
  > **username_0**: Maybe I should submit this change to CiviCRM core? I think it would be beneficial to others  
  > **username_1**: Have you looked into ReportPlus yet? I'm sure that would allow you to specify, for example financial type and campaign and then filter for only recurring ones.  
  
  ---
  
  