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) »
  • reports with Crystal - how to get data
Pages: [1]

Author Topic: reports with Crystal - how to get data  (Read 3176 times)

julianbrelsford

  • I’m new here
  • *
  • Posts: 28
  • Karma: 2
reports with Crystal - how to get data
April 22, 2009, 09:08:50 am
I'm trying to learn how to change the Crystal Reports that I've made for Raiser's Edge work with CiviCRM. I have "Crystal Reports for Blackbaud" version 8.5

In Raiser's Edge the basic approach is you export an MDB file and run your report off of that, but this approach has to be changed for CiviCRM. For one thing, I think I read that CiviCRM's built in Export feature doesn't export Relationships yet (our reports use relationship info very heavily). I know that one of the ways Crystal reports can work is to send SQL requests to the database, but I'm not sure if that's a good way to go...

Any of you reports experts know what to do?

--------
oh, and if it would be easier to use BIRT instead I'm willing to try that.

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: reports with Crystal - how to get data
April 22, 2009, 09:13:00 am
I am not familiar with Crystal report, but can't you directly access CiviCRM database (MySQL) and generate reports. Have you searched in Crystal Reports doc or Google for "connecting to MySQL databases" or something like that.

Kurund
« Last Edit: April 22, 2009, 04:25:51 pm by Dave Greenberg »
Found this reply helpful? Support CiviCRM

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: reports with Crystal - how to get data
April 23, 2009, 12:48:12 am
I have played a bit with Crystal Reports (not a lot!) and I'd imagine there is a possibility to link directly to the MySQL database. That is probably the best way forward. You will probably have some possibilties with 'connections' to different types of databases, and MySQL should be one of them.

Good luck!
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • reports with Crystal - how to get data

This forum was archived on 2017-11-26.