Re: PostgreSQL / Reporting tool

Howdy:

I'm running PostgreSQL 7.1.3 on RedHat Linux 7.2 rev 10.

Curious to find out if anyone is using a (any) tool
to connect to the database and generate detailed level
reports.

For example, a minor part of the department is still
using MS Access a la ODBC to do some reporting. A few
others are thinking about getting rid of any Microsoft
related product (yea!) but still need to find another
solution. One possible solution is using Crystal Report
Writer (www.seagate.com).

Although I try to use Perl to do some not-too-complicated
reporting, having to learn a new language is something that
the department is not in favor of.

Any suggestions are appreciated. Thanks!

-X

On Tuesday 09 Jul 2002 2:20 pm, Johnson, Shaunn wrote:
> Curious to find out if anyone is using a (any) tool
> to connect to the database and generate detailed level
> reports.
>
> For example, a minor part of the department is still
> using MS Access a la ODBC to do some reporting. A few
> others are thinking about getting rid of any Microsoft
> related product (yea!) but still need to find another
> solution. One possible solution is using Crystal Report
> Writer (www.seagate.com).

I use Access for reports on PCs - if people like it, leave them alone. Crystal
can be a real PITA although I think it's got the lion's share of reporting on
PCs.

> Although I try to use Perl to do some not-too-complicated
> reporting, having to learn a new language is something that
> the department is not in favor of.

There are various XML and similar projects out there that will produce a
report as postscript/pdf - AFAIK none of them offer the graphical template
building that Crystal/MS-Access do.

- Richard Huxton

No way to get your msaccess report tool ?

-----Message d'origine-----
De : pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org]De la part de Richard Huxton
Envoyé : mercredi 10 juillet 2002 11:09
À : Johnson, Shaunn; pgsql-general(at)postgresql(dot)org
Objet : Re: [GENERAL] PostgreSQL / Reporting tool

On Tuesday 09 Jul 2002 2:20 pm, Johnson, Shaunn wrote:
> Curious to find out if anyone is using a (any) tool
> to connect to the database and generate detailed level
> reports.
>
> For example, a minor part of the department is still
> using MS Access a la ODBC to do some reporting. A few
> others are thinking about getting rid of any Microsoft
> related product (yea!) but still need to find another
> solution. One possible solution is using Crystal Report
> Writer (www.seagate.com).

I use Access for reports on PCs - if people like it, leave them alone.
Crystal
can be a real PITA although I think it's got the lion's share of reporting
on
PCs.

> Although I try to use Perl to do some not-too-complicated
> reporting, having to learn a new language is something that
> the department is not in favor of.

There are various XML and similar projects out there that will produce a
report as postscript/pdf - AFAIK none of them offer the graphical template
building that Crystal/MS-Access do.

- Richard Huxton

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly

On Fri, 12 Jul 2002, philip johnson wrote:

> There are various XML and similar projects out there that will produce a
> report as postscript/pdf - AFAIK none of them offer the graphical template
> building that Crystal/MS-Access do.

Look at "http://datavision.sourceforge.net/". I have installed it and
played with it a bit but then had to move on to other projects before I
could plumb its depths. I was fairly impressed with it.

Rod
--
"Open Source Software - Sometimes you get more than you paid for..."