Обсуждение: reporting tools

We are looking for a reporting tool that will enable users to generate
their own reports.  Something like Crystal Reports.

Anyone using something like this with Postgresql?

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Geoffrey wrote:
> We are looking for a reporting tool that will enable users to generate
> their own reports.  Something like Crystal Reports.
>
> Anyone using something like this with Postgresql?
>

Why not Crystal Reports?

Joshua D. Drake

- --

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/
            UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGzMDnATb/zqfZUUQRAnFVAJ9DJuRS9fC9lxYLprFjJDksZooa0QCfTact
hyg0jWPxREKbcYMblS/0fp4=
=Z38E
-----END PGP SIGNATURE-----

Joshua D. Drake wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Geoffrey wrote:
>> We are looking for a reporting tool that will enable users to generate
>> their own reports.  Something like Crystal Reports.
>>
>> Anyone using something like this with Postgresql?
>>
>
> Why not Crystal Reports?

My bad.

We are looking for an open source reporting tool that will enable users
to generate their own reports.  Something like Crystal Reports. ;)

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin

On 8/22/07, Joshua D. Drake <jd@commandprompt.com> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Geoffrey wrote:
> > We are looking for a reporting tool that will enable users to generate
> > their own reports.  Something like Crystal Reports.
> >
> > Anyone using something like this with Postgresql?
> >
>
> Why not Crystal Reports?

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.

On Aug 22, 2007, at 7:21 PM, Geoffrey wrote:

> We are looking for an open source reporting tool that will enable
> users to generate their own reports.  Something like Crystal
> Reports. ;)

I was looking at a couple the other day: iReport (part of Jasper),
OpenRPT, and DataVision (http://datavision.sourceforge.net/). The
DataVision page has some links to other report writers. Hopefully
you'll do better than I did -- I also wanted something that works on
OS X. All of the above meet that criteria by using Java or GTK, but
the user interfaces are hard to take if you want a typical Mac
application.



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

John DeSoi wrote:
>
> On Aug 22, 2007, at 7:21 PM, Geoffrey wrote:
>
>> We are looking for an open source reporting tool that will enable
>> users to generate their own reports.  Something like Crystal Reports. ;)
>
> I was looking at a couple the other day: iReport (part of Jasper),
> OpenRPT, and DataVision (http://datavision.sourceforge.net/). The
> DataVision page has some links to other report writers. Hopefully you'll
> do better than I did -- I also wanted something that works on OS X. All
> of the above meet that criteria by using Java or GTK, but the user
> interfaces are hard to take if you want a typical Mac application.

MS Access?

Joshua D. Drake

>
>
>
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org/
>


- --

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/
            UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGzN5PATb/zqfZUUQRAgm0AKCCqXpYK0lj4nO6wgF/N4aiLqfHVwCglB1U
mdN7zbzfOZ6/9SKE3xcLi/M=
=LCrl
-----END PGP SIGNATURE-----

On 23/08/07, Scott Marlowe <scott.marlowe@gmail.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?

On Thu, 2007-08-23 at 16:42 +0800, Phoenix Kiula wrote:
> On 23/08/07, Scott Marlowe <scott.marlowe@gmail.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?
>

my 2 cents.. I've tried to install and play with pentaho like more than
a couple of times and failed each time. There was just some java errors
which I didn't comprehend and this is from it's all-in-one package.

Phoenix Kiula wrote on 23.08.2007 10:42:
> On 23/08/07, Scott Marlowe <scott.marlowe@gmail.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

Joshua D. Drake wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> John DeSoi wrote:
>> On Aug 22, 2007, at 7:21 PM, Geoffrey wrote:
>>
>>> We are looking for an open source reporting tool that will enable
>>> users to generate their own reports.  Something like Crystal Reports. ;)
>> I was looking at a couple the other day: iReport (part of Jasper),
>> OpenRPT, and DataVision (http://datavision.sourceforge.net/). The
>> DataVision page has some links to other report writers. Hopefully you'll
>> do better than I did -- I also wanted something that works on OS X. All
>> of the above meet that criteria by using Java or GTK, but the user
>> interfaces are hard to take if you want a typical Mac application.
>
> MS Access?

Gag, cough, choke....

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin

Thanks for the various responses, I'll check them out and post my
research results and our decision.

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin

On Thu, 2007-08-23 at 06:20 -0400, Geoffrey wrote:
> Joshua D. Drake wrote:
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> > John DeSoi wrote:
> >> On Aug 22, 2007, at 7:21 PM, Geoffrey wrote:
> >>
> >>> We are looking for an open source reporting tool that will enable
> >>> users to generate their own reports.  Something like Crystal Reports. ;)
> >> I was looking at a couple the other day: iReport (part of Jasper),
> >> OpenRPT, and DataVision (http://datavision.sourceforge.net/). The
> >> DataVision page has some links to other report writers. Hopefully you'll
> >> do better than I did -- I also wanted something that works on OS X. All
> >> of the above meet that criteria by using Java or GTK, but the user
> >> interfaces are hard to take if you want a typical Mac application.
> >
> > MS Access?
>
> Gag, cough, choke....

Ah, no, sorry.
Gag and cough only run on an Amiga, and choke went EOL with MSDOS 6.2

;-)

On Wed, 2007-08-22 at 18:57 -0400, Geoffrey wrote:
> We are looking for a reporting tool that will enable users to generate
> their own reports.  Something like Crystal Reports.
>
> Anyone using something like this with Postgresql?
>

agata, datavision, jasper reports, birt, openRPT -- google shows
numerous results

On 8/23/2007 5:16 AM Thomas Kellerer wrote:
> Phoenix Kiula wrote on 23.08.2007 10:42:
>> On 23/08/07, Scott Marlowe <scott.marlowe@gmail.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):

This is specifically why we released OpenRPT as open source - it's very lightweight, no Java required.
http://sf.net/projects/openrpt

Cheers,
Ned


--
Ned Lilly
President and CEO
xTuple
119 West York Street
Norfolk, VA 23510
tel. 757.461.3022 x101
email: ned@xtuple.com
www.xtuple.com

Ned Lilly wrote on 23.08.2007 15:44:
> This is specifically why we released OpenRPT as open source - it's very
> lightweight, no Java required.  http://sf.net/projects/openrpt

I am a Java developer and thus I have no problems in using Java based tools.
Especially because I ususally only have a JDBC driver for the databases I use
around (especially with Oracle this is *very* nice, because it does not require
a full client install, only a single .jar file)

But OpenRPT looks quite nice, I'll have a look at it as well. I guess I need to
install the whole ODBC "shebang" for that, right :)


Thomas

On 8/23/2007 10:07 AM Thomas Kellerer wrote:
> Ned Lilly wrote on 23.08.2007 15:44:
>> This is specifically why we released OpenRPT as open source - it's
>> very lightweight, no Java required.  http://sf.net/projects/openrpt
>
> I am a Java developer and thus I have no problems in using Java based
> tools. Especially because I ususally only have a JDBC driver for the
> databases I use around (especially with Oracle this is *very* nice,
> because it does not require a full client install, only a single .jar file)
>
> But OpenRPT looks quite nice, I'll have a look at it as well. I guess I
> need to install the whole ODBC "shebang" for that, right :)

Heh.  Actually, no, there's a native Postgres connection as well.  And you can compile it with any other native db
driverprovided by Qt (but why on earth would anyone want to use any other db ;-) 

Cheers,
Ned


--
Ned Lilly
President and CEO
xTuple
119 West York Street
Norfolk, VA 23510
tel. 757.461.3022 x101
email: ned@xtuple.com
www.xtuple.com

If query development is an important part of what you need to do,
consider dbQwikEdit.  It's not open or free.  But you can get a minimal
config for free (I think) and it's pretty cheap copnsidering what it can
do.

It uses ODBC and can read any DB that ODBC points to (Oracle, MySQL,
Postgres, SQLServer, etc...).  You can enter your queries in by hand
(being the sql savy people we are, that's what we'd do).  But there is
also a GUI that users can run that'll hand-hold them through building
SQL using graphics.  Pretty neat.  This feature allows users to run
"ad-hoc".

THe output is just tabular.  But you can export to lots of different
formats.

Just a thought.

http://www.dbqwikedit.com/

-dave

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Thomas Kellerer
Sent: Thursday, August 23, 2007 10:07 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] reporting tools

Ned Lilly wrote on 23.08.2007 15:44:
> This is specifically why we released OpenRPT as open source - it's
very
> lightweight, no Java required.  http://sf.net/projects/openrpt

I am a Java developer and thus I have no problems in using Java based
tools.
Especially because I ususally only have a JDBC driver for the databases
I use
around (especially with Oracle this is *very* nice, because it does not
require
a full client install, only a single .jar file)

But OpenRPT looks quite nice, I'll have a look at it as well. I guess I
need to
install the whole ODBC "shebang" for that, right :)


Thomas


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Use

www.fyireporting.com

Open source, uses excellent PostgreSQL npgsql drivers.
Use standard RDL format

Andrus.



"Geoffrey" <lists@serioustechnology.com> kirjutas s�numis
news:46CCBF59.2090806@serioustechnology.com...
> We are looking for a reporting tool that will enable users to generate
> their own reports.  Something like Crystal Reports.
>
> Anyone using something like this with Postgresql?
>
> --
> Until later, Geoffrey
>
> Those who would give up essential Liberty, to purchase a little
> temporary Safety, deserve neither Liberty nor Safety.
>  - Benjamin Franklin
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>

Andrus wrote:
> Use
>
> www.fyireporting.com
>
> Open source, uses excellent PostgreSQL npgsql drivers.
> Use standard RDL format

I guess I should have noted that we will need to run this on Linux clients.

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin

> I guess I should have noted that we will need to run this on Linux
> clients.

Geoffrey,

You can run FYIReporting engine in Linux using MONO ( www.go-mono.com )

Andrus.

Andrus wrote:
>> I guess I should have noted that we will need to run this on Linux
>> clients.
>
> Geoffrey,
>
> You can run FYIReporting engine in Linux using MONO ( www.go-mono.com )

Thanks, we're looking for something that will run natively on Linux.

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin

Geoffrey <lists@serioustechnology.com> wrote:
>
> Andrus wrote:
> >> I guess I should have noted that we will need to run this on Linux
> >> clients.
> >
> > Geoffrey,
> >
> > You can run FYIReporting engine in Linux using MONO ( www.go-mono.com )
>
> Thanks, we're looking for something that will run natively on Linux.

I read this, almost deleted it, read it again ...

Just in case there's confusion, MONO + FYIReporting _is_ native on Linux.

At least, as much so as Java on Linux is.

--
Bill Moran
http://www.potentialtech.com

Bill Moran wrote:
> Geoffrey <lists@serioustechnology.com> wrote:
>> Andrus wrote:
>>>> I guess I should have noted that we will need to run this on Linux
>>>> clients.
>>> Geoffrey,
>>>
>>> You can run FYIReporting engine in Linux using MONO ( www.go-mono.com )
>> Thanks, we're looking for something that will run natively on Linux.
>
> I read this, almost deleted it, read it again ...
>
> Just in case there's confusion, MONO + FYIReporting _is_ native on Linux.
>
> At least, as much so as Java on Linux is.

We are not interested in using any Microsoft technologies, or
technologies based on Microsoft technologies.

It's a philosophical position.

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin

On 10/14/2007 6:41 PM Geoffrey wrote:
> Bill Moran wrote:
>> Geoffrey <lists@serioustechnology.com> wrote:
>>> Andrus wrote:
>>>>> I guess I should have noted that we will need to run this on Linux
>>>>> clients.
>>>> Geoffrey,
>>>>
>>>> You can run FYIReporting engine in Linux using MONO ( www.go-mono.com )
>>> Thanks, we're looking for something that will run natively on Linux.
>>
>> I read this, almost deleted it, read it again ...
>>
>> Just in case there's confusion, MONO + FYIReporting _is_ native on Linux.
>>
>> At least, as much so as Java on Linux is.
>
> We are not interested in using any Microsoft technologies, or
> technologies based on Microsoft technologies.
>
> It's a philosophical position.


Geoffrey, have you looked at OpenRPT?

http://sourceforge.net/projects/openrpt

Ned Lilly wrote:
> On 10/14/2007 6:41 PM Geoffrey wrote:
>> Bill Moran wrote:
>>> Geoffrey <lists@serioustechnology.com> wrote:
>>>> Andrus wrote:
>>>>>> I guess I should have noted that we will need to run this on Linux
>>>>>> clients.
>>>>> Geoffrey,
>>>>>
>>>>> You can run FYIReporting engine in Linux using MONO (
>>>>> www.go-mono.com )
>>>> Thanks, we're looking for something that will run natively on Linux.
>>>
>>> I read this, almost deleted it, read it again ...
>>>
>>> Just in case there's confusion, MONO + FYIReporting _is_ native on
>>> Linux.
>>>
>>> At least, as much so as Java on Linux is.
>>
>> We are not interested in using any Microsoft technologies, or
>> technologies based on Microsoft technologies.
>>
>> It's a philosophical position.
>
>
> Geoffrey, have you looked at OpenRPT?
>
> http://sourceforge.net/projects/openrpt

Yes, and it is looking like the app we will be going with.  Thanks.


--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin

On Mon, 2007-10-15 at 23:59 -0400, Robert James wrote:
> Can you clarify the need / value added for reporting tool, over just
> running queries and packaging the output in HTML (with a little CSS
> for styling, you can get near PDF quality).  This can be done in SQL
> and a tad of PHP (or Ruby).
>

Not all users w/ have like to see pre-prepared queries. Some will have
extra requirements eg: slice the data etc. So, in these circumstances,
drill down is very important.

>

Robert James wrote:
> Can you clarify the need / value added for reporting tool, over just running
> queries and packaging the output in HTML (with a little CSS for styling, you
> can get near PDF quality).  This can be done in SQL and a tad of PHP (or
> Ruby).

Looking at having someone generate reports which a gui that requires no
more then sql knowledge.

>
> On 10/15/07, Geoffrey <lists@serioustechnology.com> wrote:
>> Ned Lilly wrote:
>>> On 10/14/2007 6:41 PM Geoffrey wrote:
>>>> Bill Moran wrote:
>>>>> Geoffrey <lists@serioustechnology.com> wrote:
>>>>>> Andrus wrote:
>>>>>>>> I guess I should have noted that we will need to run this on Linux
>>>>>>>> clients.
>>>>>>> Geoffrey,
>>>>>>>
>>>>>>> You can run FYIReporting engine in Linux using MONO (
>>>>>>> www.go-mono.com )
>>>>>> Thanks, we're looking for something that will run natively on Linux.
>>>>> I read this, almost deleted it, read it again ...
>>>>>
>>>>> Just in case there's confusion, MONO + FYIReporting _is_ native on
>>>>> Linux.
>>>>>
>>>>> At least, as much so as Java on Linux is.
>>>> We are not interested in using any Microsoft technologies, or
>>>> technologies based on Microsoft technologies.
>>>>
>>>> It's a philosophical position.
>>>
>>> Geoffrey, have you looked at OpenRPT?
>>>
>>> http://sourceforge.net/projects/openrpt
>> Yes, and it is looking like the app we will be going with.  Thanks.
>>
>>
>> --
>> Until later, Geoffrey
>>
>> Those who would give up essential Liberty, to purchase a little
>> temporary Safety, deserve neither Liberty nor Safety.
>>   - Benjamin Franklin
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 9: In versions below 8.0, the planner will ignore your desire to
>>        choose an index scan if your joining column's datatypes do not
>>        match
>>
>


--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin