Thread: 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
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
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.
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
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&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... > 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 > >