Re: reports? from MySQL (oops, on a Mac)
Date |Wed, 29 Aug 2001 00:24:25 -0400 From |[EMAIL PROTECTED] Hello! i'd like to ask... if any of you are familar with (File Maker Pro, most recent versions)... how does one go about using MySQL to create a printable report? e.g., where you select the fields you wanted in the report and then create a layout and page setup for the report, (then print it)? G Thanks again. G (Mac OS 9 or X) I use for it Siag office - look to http://siag.nu/ For example look to this screenshot http://siag.nu/siag/mysql.png ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.com - 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
Re: reports? from MySQL (oops, on a Mac)
i untarred the siag app (very cool, hope it'll work) and dropped in my home dir. then i ran ./configure, make and make install... i got: checking host system type... configure: error: can not guess host type; you must specify one configure: error: ./configure failed for XawM [ichi:~/apps/siag-3.4.9] ichi% make make all-recursive Making all in XawM make[2]: *** No rule to make target `all'. Stop. make[1]: *** [all-recursive] Error 1 make: *** [all-recursive-am] Error 2 [ichi:~/apps/siag-3.4.9] ichi% make install Making install in XawM make[1]: Nothing to be done for `install'. Making install in siod Making install in docs make[3]: Nothing to be done for `install-exec-am'. make install-man1 /bin/sh ../../mkinstalldirs /usr/local/man/man1 mkdir /usr/local/man mkdir /usr/local/man/man1 make[4]: *** [install-man1] Error 1 make[3]: *** [install-man] Error 2 make[2]: *** [install-am] Error 2 make[1]: *** [install-recursive] Error 1 make: *** [install-recursive] Error 1 the readme says: Usually `configure' can figure that out, but if it prints a message saying it can not guess the host type, give it the `--host=TYPE' option. TYPE can either be a short name for the system type, such as `sun4', or a canonical name with three fields: CPU-COMPANY-SYSTEM dumb question: what do i put for macintosh G4/450 OS X? TIA At 11:26 AM +0500 8/29/01, Grigory Bakunov wrote: Date |Wed, 29 Aug 2001 00:24:25 -0400 From |[EMAIL PROTECTED] Hello! i'd like to ask... if any of you are familar with (File Maker Pro, most recent versions)... how does one go about using MySQL to create a printable report? e.g., where you select the fields you wanted in the report and then create a layout and page setup for the report, (then print it)? G Thanks again. G (Mac OS 9 or X) I use for it Siag office - look to http://siag.nu/ For example look to this screenshot http://siag.nu/siag/mysql.png ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.com - 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
Re: reports? from MySQL (oops, on a Mac)
Date |Wed, 29 Aug 2001 03:15:50 -0400 From |[EMAIL PROTECTED] Hello! G dumb question: what do i put for macintosh G4/450 OS X? I all case you need 3 things - X Window, gcc, Mysql. I use Siag on OS/2, MS Windows and all Unixes - so it's will work with MacOS X. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.com - 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
Re: reports? from MySQL (oops, on a Mac)
so, does this mean: siag works in Mac OS X, but in X Windows, i.e., XonX? and, do i then have to use MySQL for X Windows (XFree86) system also or can i use the same MySQL i have for/on OS X itself? thank you. At 12:22 PM +0500 8/29/01, Grigory Bakunov wrote: Date |Wed, 29 Aug 2001 03:15:50 -0400 From |[EMAIL PROTECTED] Hello! G dumb question: what do i put for macintosh G4/450 OS X? I all case you need 3 things - X Window, gcc, Mysql. I use Siag on OS/2, MS Windows and all Unixes - so it's will work with MacOS X. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.com - 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
Re: reports? from MySQL (oops, on a Mac)
Date |Wed, 29 Aug 2001 03:33:45 -0400 From |[EMAIL PROTECTED] Hello! G so, does this mean: G siag works in Mac OS X, but in X Windows, i.e., XonX? yes. G and, do i then have to use MySQL for X Windows (XFree86) system also G or can i use the same MySQL i have for/on OS X itself? you can use your standart mysql. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.com - 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
reports? from MySQL
hello. with a lot of help from many of you and some very nice folks, i have been able to build some example/experiment/'mess around' type of dbs. yay. i'd like to ask... if any of you are familar with (File Maker Pro, most recent versions)... how does one go about using MySQL to create a printable report? e.g., where you select the fields you wanted in the report and then create a layout and page setup for the report, (then print it)? ALL 'directional' aids are welcome... books, websites, tips, personal knowledge. EXAMPLES are super. Thanks in Advance. TR - 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
Re: reports? from MySQL
linking tables via MyODBC + MS Access works great for me. dpk - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 28, 2001 12:06 AM Subject: reports? from MySQL hello. with a lot of help from many of you and some very nice folks, i have been able to build some example/experiment/'mess around' type of dbs. yay. i'd like to ask... if any of you are familar with (File Maker Pro, most recent versions)... how does one go about using MySQL to create a printable report? e.g., where you select the fields you wanted in the report and then create a layout and page setup for the report, (then print it)? ALL 'directional' aids are welcome... books, websites, tips, personal knowledge. EXAMPLES are super. Thanks in Advance. TR - 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 - 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
Re: reports? from MySQL
If you're accessing via Windows, you can use MyODBC and a reporting package such as Crystal Reports or Quick Reports or just about any ODBC-compliant reporting package. You should also be able to link MS Access to your MySQL database... For simple reports where you just want to print some data, you can use a tool like urSQL (http://www.urbanresearch.com/ursql) and MyODBC to build your query and then export the results. Results can be exported to HTML, Text, Excel, etc... - Original Message - i'd like to ask... if any of you are familar with (File Maker Pro, most recent versions)... how does one go about using MySQL to create a printable report? e.g., where you select the fields you wanted in the report and then create a layout and page setup for the report, (then print it)? - 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
reports? from MySQL (oops, on a Mac)
i'd like to ask... if any of you are familar with (File Maker Pro, most recent versions)... how does one go about using MySQL to create a printable report? e.g., where you select the fields you wanted in the report and then create a layout and page setup for the report, (then print it)? Thanks again. (Mac OS 9 or X) - 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
Re: Best way to generate laser-printed reports from mysql
I am wondering how most users generate reports from mysql that they can print on a laser printer (e.g. invoices)? HTML is fine if the report is only 1 page long. I guess some people user something like Crystal Reports via ODBC, but I wonder what most people do??? I use StarOffice. Adam -- Adam Stein @ Xerox Corporation Email: [EMAIL PROTECTED] Disclaimer: All views expressed here have been proved to be my own. [http://www.csh.rit.edu/~adam/] - 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
RE: Best way to generate laser-printed reports from mysql
[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]
Re: Best way to generate laser-printed reports from mysql
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