9 messages in com.mysql.lists.mysqlRe: Dynamically Generating Printed Re...
FromSent OnAttachments
Martin12 Sep 2000 03:53 
Bill Hess12 Sep 2000 04:54 
Ed Carp12 Sep 2000 07:43 
Jan Dvorak12 Sep 2000 08:01 
James Treworgy12 Sep 2000 09:00 
Jim Carey12 Sep 2000 14:26 
James Treworgy12 Sep 2000 18:28 
Martin Cameron13 Sep 2000 02:23 
Martin Cameron13 Sep 2000 02:27 
Subject:Re: Dynamically Generating Printed Reports from MySQL
From:Martin Cameron (came@cameron.co.nz)
Date:09/13/2000 02:23:03 AM
List:com.mysql.lists.mysql

There were two principal reasons why we didn't use the "PHP/Web Browser" route: 1. We wanted to have a setup where there was no human intervention - ie had
to be able to be done unattended 2. Printing from a web browser meant being only able to print one report at
atime and often came with a header from the browser. Hence the need for a script that could be run as a cron job.

Regards Martin Cameron

Jan Dvorak wrote:

Ed Carp wrote:

Martin (came@cameron.co.nz) writes:

Some time ago, a discussion took place on whether it was possible to generate
reprots directly from MySQL to a printer. I watched closely for a answer, but did not seem to get
one that was satisfactory.

It would also be possible to generate the report in HTML (using Escapade or
PHP), then print it from a browser.

Or generate TeX in Escapade or PHP or Perl or Python and make the DVI and a PostScript output.

Ed Carp, N7EKG er@pobox.com 940/367-2744 cell phone http://www.pobox.com/~erc ercp@khijol.org - text pager

Jan