Our treasurer has asked for a report to show the payment history for each contact, even if that contact has never paid anything.
'Contribution Aggregate by Relationship' report is perfect, we select all the relevant years and it presents the data beautifully but the problem is that it's only showing contacts who have made a contribution in one of the years selected. We need it to show a line of data for each member, regardless if they have paid or not.
'Contribution and Membership Detail' report also has the information needed albiet in a different format, but again, it only shows contacts who have made a contribution.
If there is a built-in report for the data we need, apologies, I'm struggling to find it. Does anyone know if any of the civi extensions might do this?
Thanks for your time!