I'm currently diving into using Pentaho to achieve what you are looking for.<div>Might look an overkill but after a bit of learning turns out to be a great solution.</div><div><br></div><div><br><br><div class="gmail_quote">
On Wed, Nov 18, 2009 at 6:06 PM, <span dir="ltr"><<a href="mailto:consulting-request@drupal.org">consulting-request@drupal.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Send consulting mailing list submissions to<br>
<a href="mailto:consulting@drupal.org">consulting@drupal.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://lists.drupal.org/mailman/listinfo/consulting" target="_blank">http://lists.drupal.org/mailman/listinfo/consulting</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:consulting-request@drupal.org">consulting-request@drupal.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:consulting-owner@drupal.org">consulting-owner@drupal.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of consulting digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. a clients needs good reporting software to use with Drupal --<br>
any suggestions? (Sam Cohen)<br>
2. Re: a clients needs good reporting software to use with<br>
Drupal -- any suggestions? (Vivek Khurana)<br>
3. Re: a clients needs good reporting software to use with<br>
Drupal -- any suggestions? (Adam Gregory)<br>
4. Re: a clients needs good reporting software to use with<br>
Drupal -- any suggestions? (Mark Schoonover)<br>
5. Re: a clients needs good reporting software to use with<br>
Drupal -- any suggestions? (Sam Cohen)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Wed, 18 Nov 2009 10:55:21 -0500<br>
From: Sam Cohen <<a href="mailto:sam@samcohen.com">sam@samcohen.com</a>><br>
Subject: [consulting] a clients needs good reporting software to use<br>
with Drupal -- any suggestions?<br>
To: "A list for Drupal consultants and Drupal service/hosting<br>
providers" <<a href="mailto:consulting@drupal.org">consulting@drupal.org</a>><br>
Message-ID:<br>
<<a href="mailto:a0b404fa0911180755w5015ca2bp1f133da719b818a3@mail.gmail.com">a0b404fa0911180755w5015ca2bp1f133da719b818a3@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="iso-8859-1"<br>
<br>
Hi all,<br>
<br>
I have a nonprofit client -- with limited budget -- that has a need to<br>
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<br>
the ability to generate reports based on this data, such as graphic<br>
representations, things Views doesn't do.<br>
<br>
I told them they'd be able to export a spreadsheet and then run reports, but<br>
they want the ability to run reports and crunch numbers right form the site.<br>
<br>
<br>
Have any of you run into this or have any suggestions? I'm wondering if<br>
there might be some third party options that I may be able to integrate. Or<br>
perhaps some sort of software that I can install on the server that can read<br>
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<br>
helpful too.<br>
<br>
Thanks,<br>
Sam<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <a href="http://lists.drupal.org/pipermail/consulting/attachments/20091118/aad01ade/attachment-0001.html" target="_blank">http://lists.drupal.org/pipermail/consulting/attachments/20091118/aad01ade/attachment-0001.html</a><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Wed, 18 Nov 2009 22:09:17 +0530<br>
From: Vivek Khurana <<a href="mailto:hiddenharmony@gmail.com">hiddenharmony@gmail.com</a>><br>
Subject: Re: [consulting] a clients needs good reporting software to<br>
use with Drupal -- any suggestions?<br>
To: "A list for Drupal consultants and Drupal service/hosting<br>
providers" <<a href="mailto:consulting@drupal.org">consulting@drupal.org</a>><br>
Message-ID:<br>
<<a href="mailto:91bea30d0911180839x19d16449uda068d41e282be5d@mail.gmail.com">91bea30d0911180839x19d16449uda068d41e282be5d@mail.gmail.com</a>><br>
Content-Type: text/plain; charset=ISO-8859-1<br>
<br>
On Wed, Nov 18, 2009 at 9:25 PM, Sam Cohen <<a href="mailto:sam@samcohen.com">sam@samcohen.com</a>> wrote:<br>
><br>
> Hi all,<br>
><br>
> Or if there's a non-drupal solution that anyone knows of, that would be<br>
> helpful too.<br>
<br>
<br>
I recently built a reporting solution for the client using drupal and<br>
jasper. We had clearly defined reports so we used iReports to design<br>
the reports and generate a jrxml file. This jrxml file is used to<br>
generate the reports every weekend via a cron job. I used ant based<br>
scripts to run Jasper server and generate the reports in pdf.<br>
<br>
regards<br>
Vivek<br>
<br>
--<br>
The hidden harmony is better than the obvious!!<br>
<br>
<br>
------------------------------<br>
<br>
Message: 3<br>
Date: Wed, 18 Nov 2009 11:43:50 -0500<br>
From: Adam Gregory <<a href="mailto:arcaneadam@gmail.com">arcaneadam@gmail.com</a>><br>
Subject: Re: [consulting] a clients needs good reporting software to<br>
use with Drupal -- any suggestions?<br>
To: "A list for Drupal consultants and Drupal service/hosting<br>
providers" <<a href="mailto:consulting@drupal.org">consulting@drupal.org</a>><br>
Message-ID:<br>
<<a href="mailto:1855f6860911180843k377ac0a8ucef73422a2bf3791@mail.gmail.com">1855f6860911180843k377ac0a8ucef73422a2bf3791@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="iso-8859-1"<br>
<br>
CiviCRM. Period. It is hefty and has a slight learning curve, but it is<br>
simply a top notch CRM designed with Non-profits in mind. <a href="Http://civicrm.org" target="_blank">Http://civicrm.org</a><br>
<br>
-----<br>
Adam A. Gregory<br>
Blog: AdamAGregory.com<br>
Twitter: <a href="http://twitter.com/adamgregory" target="_blank">twitter.com/adamgregory</a><br>
Skype: aagregory2<br>
Cell: 706.761.7375<br>
<br>
<br>
On Wed, Nov 18, 2009 at 10:55 AM, Sam Cohen <<a href="mailto:sam@samcohen.com">sam@samcohen.com</a>> wrote:<br>
<br>
><br>
> Hi all,<br>
><br>
> I have a nonprofit client -- with limited budget -- that has a need to<br>
> 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<br>
> need the ability to generate reports based on this data, such as graphic<br>
> representations, things Views doesn't do.<br>
><br>
> I told them they'd be able to export a spreadsheet and then run reports,<br>
> but they want the ability to run reports and crunch numbers right form the<br>
> site.<br>
><br>
> Have any of you run into this or have any suggestions? I'm wondering if<br>
> there might be some third party options that I may be able to integrate. Or<br>
> perhaps some sort of software that I can install on the server that can read<br>
> 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<br>
> helpful too.<br>
><br>
> Thanks,<br>
> Sam<br>
><br>
><br>
> _______________________________________________<br>
> consulting mailing list<br>
> <a href="mailto:consulting@drupal.org">consulting@drupal.org</a><br>
> <a href="http://lists.drupal.org/mailman/listinfo/consulting" target="_blank">http://lists.drupal.org/mailman/listinfo/consulting</a><br>
><br>
><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <a href="http://lists.drupal.org/pipermail/consulting/attachments/20091118/73888471/attachment-0001.html" target="_blank">http://lists.drupal.org/pipermail/consulting/attachments/20091118/73888471/attachment-0001.html</a><br>
<br>
------------------------------<br>
<br>
Message: 4<br>
Date: Wed, 18 Nov 2009 08:45:06 -0800<br>
From: "Mark Schoonover" <<a href="mailto:mark@thetajoin.com">mark@thetajoin.com</a>><br>
Subject: Re: [consulting] a clients needs good reporting software to<br>
use with Drupal -- any suggestions?<br>
To: "A list for Drupal consultants and Drupal service/hosting<br>
providers" <<a href="mailto:consulting@drupal.org">consulting@drupal.org</a>>, "A list for Drupal consultants and<br>
Drupal service/hosting providers" <<a href="mailto:consulting@drupal.org">consulting@drupal.org</a>><br>
Message-ID: <<a href="mailto:1258562706.20706.1345876341@webmail.messagingengine.com">1258562706.20706.1345876341@webmail.messagingengine.com</a>><br>
Content-Type: text/plain; charset="us-ascii"<br>
<br>
Sam,<br>
<br>
There are a couple of approaches to this project. Both Postgres &<br>
MySQL support ODBC drivers for Windows access to Drupal<br>
databases. I'm guessing that your client is using/wants to use<br>
Excel for their reports. Excel can connect to the Drupal database<br>
via the ODBC driver.<br>
<br>
Another approach for pure reporting would be to use somthing like<br>
Business Objects over ODBC to create the needed reports.<br>
<br>
Using Java, there's BIRT through Eclipse too.<br>
<br>
Hope this helps.<br>
Regards,<br>
Mark Schoonover<br>
<br>
--<br>
<a href="http://www.thetajoin.com" target="_blank">http://www.thetajoin.com</a> - The Drupal Hosting & Performance Company<br>
Email: <a href="mailto:mark@thetajoin.com">mark@thetajoin.com</a> :: Voice: 619-928-4473 :: Fax: 619-374-3130<br>
<br>
<br>
<br>
On Wed, 18 Nov 2009 10:55 -0500, "Sam Cohen" <<a href="mailto:sam@samcohen.com">sam@samcohen.com</a>><br>
wrote:<br>
<br>
Hi all,<br>
I have a nonprofit client -- with limited budget -- that has a<br>
need to collect a lot of data on their constituents around the<br>
country.<br>
Drupal is perfect for collecting this data, but here's the<br>
catch. They need the ability to generate reports based on<br>
this data, such as graphic representations, things Views<br>
doesn't do.<br>
I told them they'd be able to export a spreadsheet and then<br>
run reports, but they want the ability to run reports and<br>
crunch numbers right form the site.<br>
Have any of you run into this or have any suggestions? I'm<br>
wondering if there might be some third party options that I<br>
may be able to integrate. Or perhaps some sort of software<br>
that I can install on the server that can read right from the<br>
database (of course, I'd have to teach it CCK logic)<br>
Or if there's a non-drupal solution that anyone knows of, that<br>
would be helpful too.<br>
Thanks,<br>
Sam<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <a href="http://lists.drupal.org/pipermail/consulting/attachments/20091118/12390bce/attachment-0001.html" target="_blank">http://lists.drupal.org/pipermail/consulting/attachments/20091118/12390bce/attachment-0001.html</a><br>
<br>
------------------------------<br>
<br>
Message: 5<br>
Date: Wed, 18 Nov 2009 12:05:52 -0500<br>
From: Sam Cohen <<a href="mailto:sam@samcohen.com">sam@samcohen.com</a>><br>
Subject: Re: [consulting] a clients needs good reporting software to<br>
use with Drupal -- any suggestions?<br>
To: "A list for Drupal consultants and Drupal service/hosting<br>
providers" <<a href="mailto:consulting@drupal.org">consulting@drupal.org</a>><br>
Message-ID:<br>
<<a href="mailto:a0b404fa0911180905i1cce0897r9cdf28989becbbb0@mail.gmail.com">a0b404fa0911180905i1cce0897r9cdf28989becbbb0@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="iso-8859-1"<br>
<br>
Having used CiviCRM fairly extensively, I was going to reply that they have<br>
minimal reporting capability, but I decided to check out their site first<br>
and to my surprise there's now CiviReport <a href="http://civicrm.org/civireport" target="_blank">http://civicrm.org/civireport</a> ,<br>
which I assume is part of the new 3.0 release. (or somehow I missed it in<br>
2.0)<br>
<br>
That may be exactly what I'm looking for. CiviCRM really is a pretty<br>
amazing project. My only problem with it, as a consultant, is the enormous<br>
learning curve there is for clients and the amount of training I need to<br>
build in.<br>
<br>
Sam<br>
<br>
On Wed, Nov 18, 2009 at 11:43 AM, Adam Gregory <<a href="mailto:arcaneadam@gmail.com">arcaneadam@gmail.com</a>> wrote:<br>
<br>
> CiviCRM. Period. It is hefty and has a slight learning curve, but it is<br>
> simply a top notch CRM designed with Non-profits in mind.<br>
> <a href="Http://civicrm.org" target="_blank">Http://civicrm.org</a><br>
><br>
> -----<br>
> Adam A. Gregory<br>
> Blog: AdamAGregory.com<br>
> Twitter: <a href="http://twitter.com/adamgregory" target="_blank">twitter.com/adamgregory</a><br>
> Skype: aagregory2<br>
> Cell: 706.761.7375<br>
><br>
><br>
> On Wed, Nov 18, 2009 at 10:55 AM, Sam Cohen <<a href="mailto:sam@samcohen.com">sam@samcohen.com</a>> wrote:<br>
><br>
>><br>
>> Hi all,<br>
>><br>
>> I have a nonprofit client -- with limited budget -- that has a need to<br>
>> 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<br>
>> need the ability to generate reports based on this data, such as graphic<br>
>> representations, things Views doesn't do.<br>
>><br>
>> I told them they'd be able to export a spreadsheet and then run reports,<br>
>> but they want the ability to run reports and crunch numbers right form the<br>
>> site.<br>
>><br>
>> Have any of you run into this or have any suggestions? I'm wondering if<br>
>> there might be some third party options that I may be able to integrate. Or<br>
>> perhaps some sort of software that I can install on the server that can read<br>
>> 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<br>
>> helpful too.<br>
>><br>
>> Thanks,<br>
>> Sam<br>
>><br>
>><br>
>> _______________________________________________<br>
>> consulting mailing list<br>
>> <a href="mailto:consulting@drupal.org">consulting@drupal.org</a><br>
>> <a href="http://lists.drupal.org/mailman/listinfo/consulting" target="_blank">http://lists.drupal.org/mailman/listinfo/consulting</a><br>
>><br>
>><br>
><br>
> _______________________________________________<br>
> consulting mailing list<br>
> <a href="mailto:consulting@drupal.org">consulting@drupal.org</a><br>
> <a href="http://lists.drupal.org/mailman/listinfo/consulting" target="_blank">http://lists.drupal.org/mailman/listinfo/consulting</a><br>
><br>
><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <a href="http://lists.drupal.org/pipermail/consulting/attachments/20091118/05c4ebda/attachment.html" target="_blank">http://lists.drupal.org/pipermail/consulting/attachments/20091118/05c4ebda/attachment.html</a><br>
<br>
------------------------------<br>
<br>
_______________________________________________<br>
consulting mailing list<br>
<a href="mailto:consulting@drupal.org">consulting@drupal.org</a><br>
<a href="http://lists.drupal.org/mailman/listinfo/consulting" target="_blank">http://lists.drupal.org/mailman/listinfo/consulting</a><br>
<br>
<br>
End of consulting Digest, Vol 46, Issue 11<br>
******************************************<br>
</blockquote></div><br><br clear="all"><br>-- <br>Paolo Teodorani<br><br>Twin snc di Teodorani Paolo & C.<br>via Dante di Nanni, 29<br>47822 Santarcangelo di R. (RN)<br><br>Tel. +39 3358089645<br>email.: <a href="mailto:teodorani@gmail.com">teodorani@gmail.com</a> - <a href="mailto:info@twinlogix.com">info@twinlogix.com</a><br>
<a href="http://www.twinlogix.com">http://www.twinlogix.com</a> (finally a good looking website !)<br>
</div>