[consulting] a clients needs good reporting software to use with Drupal -- any suggestions?

[Mark Schoonover]

 Sam,

There are a couple of approaches to this project. Both Postgres &
MySQL support ODBC drivers for Windows access to Drupal
databases. I'm guessing that your client is using/wants to use
Excel for their reports. Excel can connect to the Drupal database
via the ODBC driver.

Another approach for pure reporting would be to use somthing like
Business Objects over ODBC to create the needed reports.

Using Java, there's BIRT through Eclipse too.

Hope this helps.
Regards,
Mark Schoonover

--
http://www.thetajoin.com - The Drupal Hosting & Performance Company
Email: mark at thetajoin.com :: Voice: 619-928-4473 :: Fax: 619-374-3130



On Wed, 18 Nov 2009 10:55 -0500, "Sam Cohen" <sam at samcohen.com>
wrote:

  Hi all,
  I have a nonprofit client -- with limited budget -- that has a
  need to collect a lot of data on their constituents around the
  country.
  Drupal is perfect for collecting this data, but here's the
  catch.  They need the ability to generate reports based on
  this data, such as graphic representations, things Views
  doesn't do.
  I told them they'd be able to export a spreadsheet and then
  run reports, but they want the ability to run reports and
  crunch numbers right form the site.
  Have any of you run into this or have any suggestions?  I'm
  wondering if there might be some third party options that I
  may be able to integrate.  Or perhaps some sort of software
  that I can install on the server that can read right from the
  database (of course, I'd have to teach it CCK logic)
  Or if there's a non-drupal solution that anyone knows of, that
  would be helpful too.
  Thanks,
  Sam
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/consulting/attachments/20091118/12390bce/attachment.html