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) »
  • How do I integrate using Crystal Reports into CiviCRM?
Pages: [1]

Author Topic: How do I integrate using Crystal Reports into CiviCRM?  (Read 1981 times)

ryeradio

  • I post frequently
  • ***
  • Posts: 185
  • Karma: 1
  • CiviCRM version: 4.2.1
  • CMS version: Drupal
  • MySQL version: MySQL5
  • PHP version: PHP5
How do I integrate using Crystal Reports into CiviCRM?
February 13, 2012, 08:45:55 am
I would like to be able to use Crystal Reports in CiviCRM, but I am not finding a lot of info on it. I know how to create the report etc, but I am not sure how to link it up with CiviCRM. Anyone have any experience with this?

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: How do I integrate using Crystal Reports into CiviCRM?
February 13, 2012, 09:11:04 am
I would imagine you need to set the MySQL database as a datasource?
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

ryeradio

  • I post frequently
  • ***
  • Posts: 185
  • Karma: 1
  • CiviCRM version: 4.2.1
  • CMS version: Drupal
  • MySQL version: MySQL5
  • PHP version: PHP5
Re: How do I integrate using Crystal Reports into CiviCRM?
February 13, 2012, 10:17:49 am
I can connect to Crystal Reports, I am just wondering after I create the report how do I show a report list in CiviCRM and have a user select and run a report that way.

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: How do I integrate using Crystal Reports into CiviCRM?
February 13, 2012, 10:19:14 am
There are several ways to do this, if you have a URL to the report I would just add the URL either to the Drupal menu or to the CiviCRM menu?
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

ryeradio

  • I post frequently
  • ***
  • Posts: 185
  • Karma: 1
  • CiviCRM version: 4.2.1
  • CMS version: Drupal
  • MySQL version: MySQL5
  • PHP version: PHP5
Re: How do I integrate using Crystal Reports into CiviCRM?
March 08, 2012, 01:23:32 pm
I asked my hosting provider to install Crystal Reports, but he said Crystal cannot be installed on LINUX. Is there a way around this at all? Can Crystal Reports be run on a different server at all and still hook up to CiviCRM data?

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: How do I integrate using Crystal Reports into CiviCRM?
March 09, 2012, 12:16:50 am
I would imagine so, but these are more Crystal Report forum questions then CiviCRM forum questions  ::) I think Crystal Reports can be linked to different types of data sources, and I think MySQL is one. I would imagine you could connect to another server.
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: How do I integrate using Crystal Reports into CiviCRM?
March 09, 2012, 02:42:46 am
Quote from: ryeradio on March 08, 2012, 01:23:32 pm
I asked my hosting provider to install Crystal Reports, but he said Crystal cannot be installed on LINUX. Is there a way around this at all? Can Crystal Reports be run on a different server at all and still hook up to CiviCRM data?

If Crystal Reports can connect to a MySQL datasource remotely (which I'm fairly certain it does) then so long as your host allows remote MySQL connections, then you can do this.

Your host allows such, by the way. ;)
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • How do I integrate using Crystal Reports into CiviCRM?

This forum was archived on 2017-11-26.