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) »
  • Creating a combined report
Pages: [1]

Author Topic: Creating a combined report  (Read 659 times)

pederb

  • I’m new here
  • *
  • Posts: 27
  • Karma: 0
  • CiviCRM version: 4.3.5
  • CMS version: Drupal 7.22
  • MySQL version: MySql 5.1
  • PHP version: 5.3
Creating a combined report
June 24, 2012, 11:47:26 am
How do I make a report that joins Contributions and Grants?

Members from local clubs are donating and the clubs are receiving grants.
Both Contributions and Grants have custom fields so we can assign each record to a specific club.
I need to make a monthly balance report that shows all donations and grants for each club.

I know how to make SQL joins/unions etc. but haven't made any reports in CiviCRM yet...

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 a combined report
June 24, 2012, 06:22:38 pm

Check:

http://book.civicrm.org/developer/the-extensions-framework/reports
http://alastaira.wordpress.com/2011/03/17/civicrm-creating-a-custom-report/

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 CiviReport (Moderator: Dave Greenberg) »
  • Creating a combined report

This forum was archived on 2017-11-26.