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) »
  • Creating report for member renewal history
Pages: [1]

Author Topic: Creating report for member renewal history  (Read 869 times)

nseltzer

  • I’m new here
  • *
  • Posts: 7
  • Karma: 1
Creating report for member renewal history
September 10, 2010, 02:57:05 pm
Our organization would like to generate a periodic list of those members who have renewed at a higher or lower dollar amount.  The LYBUNT and SYBUNT reports give you people who have not renewed at all, but we are also interested in identifying members who renew at different dollar amounts than a past membership.  This does not appear to be an existing report.  Has anyone done this and can you walk us through setting it up?

Thanks for any help.

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: Creating report for member renewal history
September 10, 2010, 05:37:55 pm

might want to modify the SYBUNT queries, here's a primer:

http://wiki.civicrm.org/confluence/display/CRMDOC32/CiviReport+structure+and+customization

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
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Creating report for member renewal history

This forum was archived on 2017-11-26.