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.
Thanks
-
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?– Scott PulverCommented Jan 5, 2020 at 23:59
Add a comment
|
1 Answer
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.
-
Maybe I should submit this change to CiviCRM core? I think it would be beneficial to others Commented Jan 6, 2020 at 2:55
-
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. Commented Jan 7, 2020 at 11:35