Skip to main content
2 of 2
replaced http://civicrm.stackexchange.com/ with https://civicrm.stackexchange.com/

How to write custom report SQL

I'm not asking for the actual solution, but more a pointer to references examples for the structure so I can move forward.

CiviCRM 4.7 or WordPress - I need to create a report that I think will be achieved by custom coding only.

My original request was here Custom Report By Relationship

Essentially I have a a 'street rep (individual)' that has a relationship with a 'household ( a physical address)' that makes 'contributions' and a 'household' has a relationship with an 'individual' as head of household.

So want to build a street collection report structured

Street Rep (page break) --- Street Name (sub section ) --- door number, head of household name, last years contribution (line)

Although the requirement is relatively simple it has a level of complexity that my unfamiliarity with Civi structures is making it tough for me.

I really appreciate any pointers or help.

Alan Fuller
  • 431
  • 2
  • 10