[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. -- Shankar Unni [EMAIL PROTECTED]
