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) »
  • Add the membership status in CiviEvent and CiviContributions reports
Pages: [1]

Author Topic: Add the membership status in CiviEvent and CiviContributions reports  (Read 1125 times)

Tchiot Galopin

  • I’m new here
  • *
  • Posts: 13
  • Karma: 0
  • CiviCRM version: 4.1.2
  • CMS version: Drupal 7.12
  • MySQL version: 5.1.44
  • PHP version: 5.3.3.7
Add the membership status in CiviEvent and CiviContributions reports
March 25, 2011, 08:02:51 am
Hello,

As indicated in the title, I have to add in most of my reports (list of participants of an event, list of donors, etc..) the option to display a column with the membership status.

The idea is simple, when we contact people for a fundraising or when we receive them to a meeting, we must be able to offer them to renew their membership at the same time ..

Is it possible to get this information in the table civicrn_membership? If yes, how? ...

Thank you in advance for your help ...
« Last Edit: March 25, 2011, 08:07:42 am by Tchiot Galopin »

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: Add the membership status in CiviEvent and CiviContributions reports
March 25, 2011, 11:31:39 am

Here are instructions on how to modify a CiviReport:

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

A blog from a community member describing it in other words:

http://alastaira.wordpress.com/2011/03/17/civicrm-creating-a-custom-report/

Hope this will help you get started

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

Tchiot Galopin

  • I’m new here
  • *
  • Posts: 13
  • Karma: 0
  • CiviCRM version: 4.1.2
  • CMS version: Drupal 7.12
  • MySQL version: 5.1.44
  • PHP version: 5.3.3.7
Re: Add the membership status in CiviEvent and CiviContributions reports
March 31, 2011, 08:49:04 am
Thank you for your quick response.

I found a solution to add membership columns in the Sybunt report. I'll try first to add it into events report (cause I'd like to be sure of the procedure) and, next, i'll share the solution on this forum.

Tchiot Galopin

  • I’m new here
  • *
  • Posts: 13
  • Karma: 0
  • CiviCRM version: 4.1.2
  • CMS version: Drupal 7.12
  • MySQL version: 5.1.44
  • PHP version: 5.3.3.7
Add the membership status in SYBUNT (CiviContrib) reports
April 01, 2011, 06:39:27 am
If displaying status of membership in other reports (Contrib, Event, etc.) is interesting someone...
Please find first for SYBUNT report (cf. attachement)
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • Add the membership status in CiviEvent and CiviContributions reports

This forum was archived on 2017-11-26.