Re: reporting tools

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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Thomas Kellerer
Sent: Thursday, August 23, 2007 10:07 AM
To: pgsql-general(at)postgresql(dot)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