Re : reporting tools

Hi,

For my projet (J2EE application), I have been using Jasper and iReport.
That works quite well although so far we have not done stuff really complicated.

I am hoping that the "Power" end users will be able to write the reports themselves. "Power" users because although iReports is wysiwyg tool, it's not so easy that everybody can use it.
For that, we will need to provide them with a data source so they can play around and see results while designing the reports.

In the J2EE code, Jasper will use a JAVA list (populated from a PG 8.x database) as the data source.
iReport can easily use a CSV file (exporting the Java list to CSV is easy too) and that's convenient for the user. However when there's master -detail report (i.e. a report and sub-reports) like with invoices (master table) and invoices_lines (details table) : that becomes more complicated.
So far, we haven't found an easily solution (we have not searched much though).

Here is my experience, in a few words : works quite well, setting up and running needs a couple of days, not so easy to use by end users. Once used to it and set up, it will give great results within a few minutes.

Have fun,
L(at)u
The Computing Froggy

----- Message d'origine ----
De : Thomas Kellerer <spam_eater(at)gmx(dot)net>
À : pgsql-general(at)postgresql(dot)org
Envoyé le : Jeudi, 23 Août 2007, 11h16mn 46s
Objet : Re: [GENERAL] reporting tools

Phoenix Kiula wrote on 23.08.2007 10:42:
> On 23/08/07, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
>> Yeah, I'm not the biggest fan of CR, but it's worked with PostgreSQL
>> for quite some time now. We had it hitting a pg7.2 db back in the
>> day, when hip kids road around in rag top roadsters and wore tshirts
>> with cigarettes rolled in their sleeves.
>>
>> Also, look at Pentaho. It's open source and pretty good.
>
>
>
> Thanks. Pentaho looks good. But are there any alternatives that don't
> require me to spend days installing the whole Java shebang?

If you don't need a server-based solution, you might want to look at iReport
designer.

Although it is also Java based it only needs a runtime environment on the client
(not sure if that qualifies for "whole shebang" for you as well):

http://www.jasperforge.org/sf/projects/ireport

Thomas

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

_____________________________________________________________________________
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail