reporting tools

-----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

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

I looked at BIRT - it is part of Eclipse. It is pretty new and I found the documentation to be pretty limited. Also, it has few output options. These factors caused me to decide against it. Settled on JasperReports and like it a lot. It integrated easily with my Java (Eclipse RCP) GUI. Creating reports isn't any harder than Crystal Reports. In my GUI, I use an xml file for a report list, so I can add, edit, and delete reports easily without altering program code.

Michael Schmidt
----- Original Message -----
From: Reid Thompson<mailto:Reid.Thompson@ateb.com>
To: Geoffrey<mailto:lists@serioustechnology.com>
Cc: pgsql-general@postgresql.org<mailto:pgsql-general@postgresql.org>
Sent: Thursday, August 23, 2007 7:35 AM
Subject: Re: [GENERAL] reporting tools

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

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 driver provided 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

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...

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