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 CiviReport (Moderator: Dave Greenberg) »
  • Transactions Disappear from Report if both are active and of same type
Pages: [1]

Author Topic: Transactions Disappear from Report if both are active and of same type  (Read 810 times)

jobewan

  • I post occasionally
  • **
  • Posts: 79
  • Karma: 0
Transactions Disappear from Report if both are active and of same type
December 08, 2010, 12:29:18 pm
Hello:

I have an interesting effect taking place when running a Membership Detail report: member records with renewing memberships that are active at the same time (overlapping from one year to the next) are missing the earlier of the two active memberships on the report output.

If I change the membership type of either record so that the two active membership records are not of the same type, they both show up on the report output.

Anyone heard of such a thing?

-Joe

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Transactions Disappear from Report if both are active and of same type
December 08, 2010, 12:37:54 pm
Isn't that by design? You're not really supposed to have 2 membership records for the same type of membership for the same contacts that 'connect' - the earlier membership is supposed to be extended when they renew
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

jobewan

  • I post occasionally
  • **
  • Posts: 79
  • Karma: 0
Re: Transactions Disappear from Report if both are active and of same type
December 09, 2010, 08:00:31 am
Ah . . . that is one school of thought, and the school in which I suspect my version of CiviCRM got it's learnin. <wink!>

Our memberships are annual -only-, no matter how long someone has been a member in toto, so there will [hopefully] always be some overlap at the beginning/end of the calendar year.

The other question/comment would be: what business would CiviReport have ignoring a membership entry, for any reason whatsoever?  If there was an error in the form (pun) of duplicate memberships at any given time, wouldn't one want to run a report to find out?  The effect here is that the system is actively hiding the 'problem', if it is indeed set up to do so, and this is not an unintended outcome.

So basically, I need CiviReport to simply do that: report.

Any ideers?

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Transactions Disappear from Report if both are active and of same type
December 09, 2010, 10:53:30 am
You can use drupal devel module to see what query is running & then see why it is being excluded
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • Transactions Disappear from Report if both are active and of same type

This forum was archived on 2017-11-26.