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) »
  • Discussion (deprecated) »
  • Professional CiviCRM Services (Moderator: Dave Greenberg) »
  • Looking for a Freelancer to Help with Writing SQL for CiviCRM Reporting
Pages: [1]

Author Topic: Looking for a Freelancer to Help with Writing SQL for CiviCRM Reporting  (Read 1351 times)

farmrchrys

  • I post occasionally
  • **
  • Posts: 92
  • Karma: 2
    • Spokane Moves to Amend the Constitution (under development)
  • CiviCRM version: CiviCRM 4.4.6
  • CMS version: Drupal 7.31
  • MySQL version: MySQL 5.5.37
  • PHP version: PHP 5.3.28
Looking for a Freelancer to Help with Writing SQL for CiviCRM Reporting
June 27, 2009, 07:02:04 am
We are a statewide non-profit with about 500 members and a database with about 5000 contacts developing a website using Drupal 6 and CiviCRM 2.2. The goal is to centralize the organization's database in CiviCRM. The organization staff is Windows-based. We are fortunate to have a Microsoft database expert volunteering for us. We need to develop reporting capabilities. The plan is to create MySQL Views for reporting various data (ie conference registrants and their registration particulars, various contribution reports, membership reports, etc.). The views would be opened in MS Access via ODBC and report data formatted by MS Access. While we do have SQL expertise on hand, we don't have the required facility with CiviCRM's database structure. We're looking at developing upwards of 20 reports including a fair amount of custom fields. We're not rich and this would likely be a short-term engagement but it would be for a good cause. Anyone interested in discussing this with me?

Thanks,
Chrys

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Looking for a Freelancer to Help with Writing SQL for CiviCRM Reporting
June 29, 2009, 03:42:08 pm
Chrys - before you embark on this, you should probably review the "CiviReport" functionality that's being released in the next week or so (v2.2.7). This phase will include 14 "report templates" which can be used to generate lots of specific report instances covering Constituent info, Contributions, Memberships and Events. I've been doing some QA on it and the coverage is pretty impressive.

One "hole" based on your brief description is that custom fields are not covered in this phase. However I think the framework should make it pretty easy to fold specific custom fields in for a given report.

http://wiki.civicrm.org/confluence/display/CRM/CiviReport+-+The+Return
Protect your investment in CiviCRM by  becoming a Member!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Professional CiviCRM Services (Moderator: Dave Greenberg) »
  • Looking for a Freelancer to Help with Writing SQL for CiviCRM Reporting

This forum was archived on 2017-11-26.