Re: [GENERAL] Printable report generation
Heck as far as that goes you can use access thru odbc and pull up your tables and use accesses report generation. Rob "SMJ" <[EMAIL PROTECTED]> wrote in message Pine.LNX.4.10.10108141753440.260-10@stark">news:Pine.LNX.4.10.10108141753440.260-10@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 > > ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] Printable report generation
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) [EMAIL PROTECTED] http://sourceforge.net/projects/newbiedoc -- we need your brain! http://www.dontUthink.com/ -- your brain needs us! ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] Printable report generation
> > 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 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]