CiviCRM Community Forums (archive)

Our organization operates under a membership model but we do have non member contribution pages.  We treat these as memberships even though this might seem backwards.

We are struggling to come up with a report that combines donations and memberships that we can query for 11mos since last give date.  We need this to reach out to expiring memberships, even though they might only be captured as contributions.

The LYBUNT report gives us close to everything we need but it's YTD, not monthly.  The lapsed membership report is fantastic but doesn't include regular donations.  My thought is change LYBUNT to accept a begining and end date filter or change the lapsed membership report to somehow pull donations.

I realize the issue with out current setup but I could use some help in thinking of a creative workaround.