CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Find contributions by membership type
Pages: [1]

Author Topic: Find contributions by membership type  (Read 1319 times)

timfluhr

  • I post occasionally
  • **
  • Posts: 51
  • Karma: 0
Find contributions by membership type
November 03, 2010, 10:19:50 am
Hello.

I'm trying to query civicrm for contributions by membership type.  We have about 6 different membership types and I need to do a breakdown of how much contributions came from each type over the course of a period of time.  Is there a way to do this using reports or the search functionality?  Are there other ways of doing this?

Thanks.

-tim

Susanh

  • I’m new here
  • *
  • Posts: 21
  • Karma: 2
    • Sierra Club Canada
Re: Find contributions by membership type
November 04, 2010, 01:10:06 pm
How about a search builder query where "membership type= 1" (or 2 or 3 depending) and "contribution receive date IN time period"

Susan

Martin.Schwenke

  • I post occasionally
  • **
  • Posts: 35
  • Karma: 0
  • CiviCRM version: 4.1.x
  • CMS version: Drupal 6.x
  • MySQL version: 5.1.x
  • PHP version: 5.3.x
Re: Find contributions by membership type
November 07, 2010, 04:33:22 pm
Quote from: Susanh on November 04, 2010, 01:10:06 pm
How about a search builder query where "membership type= 1" (or 2 or 3 depending) [...]

Is it just me, or is this function currently broken in CiviCRM 3.2.4?  It doesn't matter what value I enter for membership status, I always get all contacts (or all those selected by the other search criteria).

I am able to reproduce this on the sandbox too...

Should I open a bug?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Find contributions by membership type
November 07, 2010, 05:21:47 pm

Can you investigate and please provide a patch to fix the issue

Search Builder is not being actively maintained / supported, so kinda important that the community help out with patches and improvements

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

timfluhr

  • I post occasionally
  • **
  • Posts: 51
  • Karma: 0
Re: Find contributions by membership type
November 09, 2010, 02:53:23 pm
Quote from: Susanh on November 04, 2010, 01:10:06 pm
How about a search builder query where "membership type= 1" (or 2 or 3 depending) and "contribution receive date IN time period"

Susan

I've done this and it gets me a list of those with memberships who have contributed after a certain date, but I still need to be able find out the total amount contributed in a time period by a membership type.

Any thoughts?

thanks.

-tim

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Find contributions by membership type
November 09, 2010, 04:06:53 pm
can you make a smart group from the membership types and use civireport to crunch the numbers via the Contribution Report by just selecting the relevant Group?
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

timfluhr

  • I post occasionally
  • **
  • Posts: 51
  • Karma: 0
Re: Find contributions by membership type
November 10, 2010, 08:50:54 am
Thanks peterd.  That's a great idea!

Martin.Schwenke

  • I post occasionally
  • **
  • Posts: 35
  • Karma: 0
  • CiviCRM version: 4.1.x
  • CMS version: Drupal 6.x
  • MySQL version: 5.1.x
  • PHP version: 5.3.x
Re: Find contributions by membership type
November 22, 2010, 08:08:48 pm
Quote from: Donald Lobo on November 07, 2010, 05:21:47 pm
Can you investigate and please provide a patch to fix the issue

Sorry, I spent quite a bit of time trying to understand how recent changes might have broken it...  but couldn't get to the bottom of it.    :(

Oh, and the problem I was seeing was with membership status rather than membership type.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Find contributions by membership type

This forum was archived on 2017-11-26.