<!--/*SC*/DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"/*EC*/-->
<html><head><title></title><style type="text/css"><!--body{padding:1ex;margin:0px;font-family:sans-serif;font-size:small;}a[href]{color:-moz-hyperlinktext !important;text-decoration:-moz-anchor-decoration;}blockquote{margin:0;border-left:2px solid #144fae;padding-left:1em;}blockquote blockquote{border-color:#006312;}blockquote blockquote blockquote{border-color:#540000;}--></style></head><body><div style="font-family: Arial; font-size: medium;" dir="ltr"><div> Sam,</div>
<div> </div>
<div>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.</div>
<div> </div>
<div>Another approach for pure reporting would be to use somthing like Business Objects over ODBC to create the needed reports.</div>
<div> </div>
<div>Using Java, there's BIRT through Eclipse too.</div>
<div> </div>
<div>Hope this helps.</div>
<pre>
Regards,
Mark Schoonover
--
http://www.thetajoin.com - The Drupal Hosting & Performance Company
Email: mark@thetajoin.com :: Voice: 619-928-4473 :: Fax: 619-374-3130
</pre>
<div class="defangedMessage">
<div id="me14342">
<div> </div>
<div>On Wed, 18 Nov 2009 10:55 -0500, "Sam Cohen" <sam@samcohen.com> wrote:</div>
<blockquote type="cite" class="me14342QuoteMessage"><br>
Hi all,<br>
<br>
I have a nonprofit client -- with limited budget -- that has a need to collect a lot of data on their constituents around the country. <br>
<br>
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. <br>
<br>
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. <br>
<br>
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)<br>
<br>
Or if there's a non-drupal solution that anyone knows of, that would be helpful too.<br>
<br>
Thanks,<br>
Sam<br>
<blockquote style="margin: 1.5em 0pt;"></blockquote> </blockquote></div>
</div></div></body></html>