Printable report generation

SMJ wrote:

What is a viable way to generate printable 'reports', in a similar fashion
provided by MS Access?

For example, say I've got a postgresql database of client information
(names, addresses, etc.), and I want to use this information to generate
envelopes for mailouts. As far as my understanding goes, such
functionality is not provided by postgresql itself.

Applixware has a database interface, could be
used to do this sort of stuff -- put DB recs
in documents, spreadsheets, etc.

--
P. Josh Rovero KK1D Oceanographer & Meteorologist
provero@home.com http://members.home.net/provero

On Tue, Aug 14, 2001 at 08:15:50AM +0000, SMJ wrote:

Hi all,

I'm currently in the progress of setting up a databasing system for a
sales company, using a pure Linux / Postgresql solution. I've
traditionally used MS Access 97 for the setup of similar systems, and have
yet to work out one problem -

What is a viable way to generate printable 'reports', in a similar fashion
provided by MS Access?

For example, say I've got a postgresql database of client information
(names, addresses, etc.), and I want to use this information to generate
envelopes for mailouts. As far as my understanding goes, such
functionality is not provided by postgresql itself.

Any help would be appreciated.

Report generation is not supported by postgresql, but there are tools to do
that. Personally I think the easiest way to do it is to have a (perl)script
generate latex, which can be easily transformed into postscript.

- Einar Karttunen

SMJ <meebus@stark.51glen> writes:

Hi all,

I'm currently in the progress of setting up a databasing system for a
sales company, using a pure Linux / Postgresql solution. I've
traditionally used MS Access 97 for the setup of similar systems, and have
yet to work out one problem -

What is a viable way to generate printable 'reports', in a similar fashion
provided by MS Access?

I don't know if there is a ny kind of GUI report generating tool for
Linux/PG. There might be.

For example, say I've got a postgresql database of client information
(names, addresses, etc.), and I want to use this information to generate
envelopes for mailouts. As far as my understanding goes, such
functionality is not provided by postgresql itself.

Yes, Access is a frontend/backend combo (and can actually connect to
multiple brands of backend via ODBC) whereas PG is a pure backend.
Reporting is a frontend function.

Any help would be appreciated.

I'd personally do reporting by writing Perl scripts (generating either
text or HTML), but that might not suit you.

If a Windows box is allowable in the mix, you could set up either
Crystal Reports or Access with the PG ODBC driver and do reports etc
that way.

-Doug
--
Free Dmitry Sklyarov!
http://www.freesklyarov.org/

We will return to our regularly scheduled signature shortly.

I've had a fair amount of success using MS Access via an ODBC connection to
a Postgres backend.

In the past year, I've rolled out 4 larger web apps (university website)
that comprise of a multi-user environment. Each app uses Access for all of
the data entry and reports where necessary.

Depending on the speed of your network, it may be a little slower than
desired, but never-the-less, it gets the job done. I wrote the apps in a
hurry, so I'm probably not optimized very much.

The ODBC driver is available at http://odbc.postrgesql.org/

-----Original Message-----
From: Doug McNaught [SMTP:doug@wireboard.com]
Sent: Monday, August 20, 2001 12:32
To: SMJ
Cc: pgsql-general@postgresql.org
Subject: Re: Printable report generation

SMJ <meebus@stark.51glen> writes:

Hi all,

I'm currently in the progress of setting up a databasing system for a
sales company, using a pure Linux / Postgresql solution. I've
traditionally used MS Access 97 for the setup of similar systems, and

have

yet to work out one problem -

What is a viable way to generate printable 'reports', in a similar

fashion

provided by MS Access?

I don't know if there is a ny kind of GUI report generating tool for
Linux/PG. There might be.

For example, say I've got a postgresql database of client information
(names, addresses, etc.), and I want to use this information to generate
envelopes for mailouts. As far as my understanding goes, such
functionality is not provided by postgresql itself.

Yes, Access is a frontend/backend combo (and can actually connect to
multiple brands of backend via ODBC) whereas PG is a pure backend.
Reporting is a frontend function.

Any help would be appreciated.

I'd personally do reporting by writing Perl scripts (generating either
text or HTML), but that might not suit you.

If a Windows box is allowable in the mix, you could set up either
Crystal Reports or Access with the PG ODBC driver and do reports etc
that way.

-Doug
--
Free Dmitry Sklyarov!
http://www.freesklyarov.org/

We will return to our regularly scheduled signature shortly.

----------------------------------------------------
NetZero Platinum
Sign Up Today - Only $9.95 per month!
http://my.netzero.net/s/signup?r=platinum&amp;refcd=PT97

For example, say I've got a postgresql database of client information
(names, addresses, etc.), and I want to use this information to generate
envelopes for mailouts. As far as my understanding goes, such
functionality is not provided by postgresql itself.

I have the same problem but I need a guide on JDBC serialization. I
would like to put a button on a JSP that will save the result of a query
to local disk as a tab delimited file.

That will permit me to open it in AppleWorks for mailing label printing.

Any pointers greatly appreciated

Cheers

Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html

On Tue, Aug 21, 2001 at 10:25:35AM +0200, Tony Grant wrote:

For example, say I've got a postgresql database of client information
(names, addresses, etc.), and I want to use this information to generate
envelopes for mailouts. As far as my understanding goes, such
functionality is not provided by postgresql itself.

I have the same problem but I need a guide on JDBC serialization. I
would like to put a button on a JSP that will save the result of a query
to local disk as a tab delimited file.

That will permit me to open it in AppleWorks for mailing label printing.

Any pointers greatly appreciated

db=# \h copy
Command: COPY
Description: Copies data between files and tables
Syntax:
COPY [ BINARY ] table [ WITH OIDS ]
FROM { 'filename' | stdin }
[ [USING] DELIMITERS 'delimiter' ]
[ WITH NULL AS 'null string' ]
COPY [ BINARY ] table [ WITH OIDS ]
TO { 'filename' | stdout }
[ [USING] DELIMITERS 'delimiter' ]
[ WITH NULL AS 'null string' ]

db=# copy someTable to '/path/to/file.tsv';

now read tab-separated file "file.tsv" into the program of your
choice.

or use "practical extraction and reporting language" to generate
your reports (perl!)...

--
Khan said that revenge is a dish best served cold. I think
sometimes it's best served hot, chunky, and foaming.
- P.J.Lee ('79-'80)

will@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

Message d'origine <<<<<<<<<<<<<<<<<<

Le 14/08/2001, � 04:15:50 h, SMJ <meebus@stark.51glen> vous a �crit sur le
sujet suivant Printable report generation:

Hi all,

I'm currently in the progress of setting up a databasing system for a
sales company, using a pure Linux / Postgresql solution. I've
traditionally used MS Access 97 for the setup of similar systems, and

have

yet to work out one problem -

What is a viable way to generate printable 'reports', in a similar

fashion

provided by MS Access?

For example, say I've got a postgresql database of client information
(names, addresses, etc.), and I want to use this information to generate
envelopes for mailouts. As far as my understanding goes, such
functionality is not provided by postgresql itself.

Any help would be appreciated.

- Steve Jender

StarOffice 5.2 has also a database interface. Create an ODBC database.
The Pgaccess report module given in the postgresql distribution is not
yet implemented.
- jm malgras

Heck as far as that goes you can use access thru odbc and pull up your
tables and use accesses report generation.
Rob
"SMJ" <meebus@stark.51glen> wrote in message
news:Pine.LNX.4.10.10108141753440.260-100000@stark...