Shankar Unni wrote: > > [EMAIL PROTECTED] writes: > > > I am wondering how most users generate reports from mysql that they > > can print on a laser printer (e.g. invoices)? [...] I guess some people > > user something like Crystal Reports via ODBC, but I wonder what most > > people do??? > > Use Crystal Reports :-)? Depends on (a) how professional you need the > reports to be, and (b) how much you can afford.. > > But more seriously, you *could* create a layout for "tbl" (part of GNU > "groff", available for all POSIX platforms and even NT via the cygwin port), > and generate output using that template: > > .TS H > page-header specs > .TH > other header specs. > header lines > body lines <<<-- generate this using MySQL > .TE > > And then run all this through "tbl" followed by "groff". Haven't tried this > myself in this particular combination, but having used tbl in the past, I > don't see any major conceptual problems with it. It's free, but needs some > elbow grease to get it to work.. > > A "tbl" reference is at > http://www.primate.wisc.edu/software/troffcvt/tbl.html. This question strikes a chord with me also. I started looking to see if there is any Perl modules/Bundles/Packages for generating postscript reports. What I have found is fairly primative. Does anybody have any suggestions?? -- Alvin Starr || voice: (416)585-9971 Interlink Connectivity || fax: (416)585-9974 [EMAIL PROTECTED] || --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
