reports

2010-05-18 Thread Gallego Juan
Hi, I want to ask you the next topic, I have to deliver some reports and i want to know if exists some reporting open source tool to generate them. The reports that i need are: - how many users, sessions,cursors by hour, day, week How mysql manage them? is this information stored in some

Re: reports

2010-05-18 Thread Raj Shekhar
In infinite wisdom Gallego Juan juan.gall...@yellargentina.com wrote: [1 text/plain; us-ascii (quoted-printable)] Hi, I want to ask you the next topic, I have to deliver some reports and i want to know if exists some reporting open source tool to generate them. The reports that i

Schema and Data Comparison and Synchronization Tools for MySQL Offer Command Line Mode and Comparison Reports

2010-02-26 Thread Julia Samarska
Devart Email: i...@devart.com Web: http://www.devart.com FOR IMMEDIATE RELEASE CONTACT INFORMATION: Julia Samarska jul...@devart.com 26-Feb-10 Schema and Data Comparison and Synchronization Tools for MySQL Offer Command Line Mode and Comparison Reports MySQL database

Re: Help requested to provide bug reports for 5.1

2008-07-18 Thread Michael Widenius
Hi! Mark == Mark Callaghan [EMAIL PROTECTED] writes: Mark Can MySQL share the results of performance testing that has been done to Mark compare 5.1 with 5.0? I would really like to see them too :) I will ask around and see if I can find what was done and what the results where. Regards,

Re: Help requested to provide bug reports for 5.1

2008-07-17 Thread Susanne Ebrecht
Hi, Michael Widenius schrieb: Note that you should also do this for bugs that you know of in MySQL 5.0 that are still open for MySQL 5.1 (or any bugs that are labelled to be fixed in a future release). Bugs that are in earlier version are also very likely to also be in 5.1 if the bugs database

Help requested to provide bug reports for 5.1

2008-07-16 Thread Michael Widenius
to postpone fixes for bugs that have a low impact (ie affects few users). This has the following implications: - Bugs for which we don't have many user/customer reports for are not likely to get fixed. (In the worst case not even in 6.0 !) - It's ok to go out with bugs in new feature in the GA

Re: Help requested to provide bug reports for 5.1

2008-07-16 Thread Mark Callaghan
implications: - Bugs for which we don't have many user/customer reports for are not likely to get fixed. (In the worst case not even in 6.0 !) - It's ok to go out with bugs in new feature in the GA as long as we don't have many users/customers that have reported problems with these features

Re: Help requested to provide bug reports for 5.1

2008-07-16 Thread Mark Callaghan
users). This has the following implications: - Bugs for which we don't have many user/customer reports for are not likely to get fixed. (In the worst case not even in 6.0 !) - It's ok to go out with bugs in new feature in the GA as long as we don't have many users/customers that have

Re: Crystal Reports XI on W2k3 Server SP2 x64 (fwd)

2007-11-26 Thread mgainty
Hi Phillip Did you get a chance to look at Navicat? http://www.navicat.com/download.html Martin-- - Original Message - Wrom: CGPKYLEJGDGVCJVTLBXFGGMEPYOQKEDOTWFAOBUZXUW To: mysql@lists.mysql.com Sent: Sunday, September 30, 2007 1:42 AM Subject: Crystal Reports XI on W2k3 Server SP2 x64

Crystal Reports XI on W2k3 Server SP2 x64 (fwd)

2007-09-30 Thread Philip M. Gollucci
[take 2] Nobody has any comments ? -- Forwarded message -- Date: Wed, 26 Sep 2007 12:19:21 -0400 (EDT) From: Philip M. Gollucci [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Crystal Reports XI on W2k3 Server SP2 x64 Hi All, I'm trying to get Crystal Reports to connect

Crystal Reports XI on W2k3 Server SP2 x64

2007-09-26 Thread Philip M. Gollucci
Hi All, I'm trying to get Crystal Reports to connect to a MySQL server. Windows 2003 Server R2 x64 Crystal Reports XI Professional Disabled DEP for crw32.exe mysql-connector-odbc-noinstall-3.51.20-winx64.zip FreeBSD 6.2-RELEASE-p7 x64 mysql-client-5.0.45 mysql-scripts-5.0.45

Generating reports/exporting data?

2007-09-17 Thread chombee
Can anyone recommend an easy, free way to generate reports from a MySQL database in a nicely readable form? e.g. in plain text, HTML, PDF, or even visualised in the form of graphs and charts. For example, if I have constructed several queries and want to run them and export all of their results

RE: Generating reports/exporting data?

2007-09-17 Thread Daevid Vincent
: Monday, September 17, 2007 8:29 AM To: mysql@lists.mysql.com Subject: Generating reports/exporting data? Can anyone recommend an easy, free way to generate reports from a MySQL database in a nicely readable form? e.g. in plain text, HTML, PDF, or even visualised in the form of graphs

Re: Generating reports/exporting data?

2007-09-17 Thread Michael Dykman
[mailto:[EMAIL PROTECTED] Sent: Monday, September 17, 2007 8:29 AM To: mysql@lists.mysql.com Subject: Generating reports/exporting data? Can anyone recommend an easy, free way to generate reports from a MySQL database in a nicely readable form? e.g. in plain text, HTML, PDF, or even

crystal reports andd mysql

2006-10-31 Thread Roberto William Aranda-W Roman
hello everybody anybody had to deal with this? i have a windows form created on VB.net to get a report on embbeded crystal reports develop program im trying to customize the fields to show by using the CR form via Sql Sintax option for the fields but the formula editor seems does

RE: Reports

2006-10-23 Thread andy.lawton
Try this: www.eclipse.org/birt Andy -Original Message- From: Kristen G. Thorson [mailto:[EMAIL PROTECTED] Sent: 20 October 2006 15:07 To: Ahmad Al-Twaijiry; MySQL List Subject: RE: Reports -Original Message- From: Ahmad Al-Twaijiry [mailto:[EMAIL PROTECTED] Sent: Friday

Reports

2006-10-20 Thread Ahmad Al-Twaijiry
Hi everyone do you know any good (free) application that make it easy to generate (with charts) a very nice reports from mysql ? Thanks --- Ahmad http://www.v-tadawul.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

RE: Reports

2006-10-20 Thread Kristen G. Thorson
-Original Message- From: Ahmad Al-Twaijiry [mailto:[EMAIL PROTECTED] Sent: Friday, October 20, 2006 10:00 AM To: MySQL List Subject: Reports Hi everyone do you know any good (free) application that make it easy to generate (with charts) a very nice reports from mysql

How to deal with summary data and reports

2006-08-29 Thread Matthew Wilson
that would build these summary reports and when we load new data, we rerun the stored procedures to build the summaries. I suspect this is a universal problem. All general advice would be appreciated. Perhaps a stored procedure is not the way to go. -- A better way of running series of SAS

Re: How to deal with summary data and reports

2006-08-29 Thread Aleksandar Ivanisevic
Matthew Wilson writes: [...] I suspect this is a universal problem. All general advice would be appreciated. Perhaps a stored procedure is not the way to go. Mysql 5.1 has CREATE EVENT, that somewhat mimics Oracle's jobs. I prefer to run a shell script in a cron job, like this: #!/bin/bash

Re: Client still reports table full

2006-06-30 Thread Brent Baisley
reports table full If I understand the results from SHOW TABLE STATUS LIKE 'data'; My avg_row_length = 497 Why would descreasing it to 50 have a positive Effect. I would assume I should increase it? Thank you/Raymond -Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent

Solved: Client still reports table full

2006-06-30 Thread Jacob, Raymond A Jr
Baisley [mailto:[EMAIL PROTECTED] Sent: Friday, June 30, 2006 8:49 To: Jacob, Raymond A Jr; mysql@lists.mysql.com Subject: Re: Client still reports table full Wow, I'm really sorry about that. Left out a zero. I should stop answering questions before the holiday weekend. I was suggesting a minor

Client still reports table full

2006-06-29 Thread Jacob, Raymond A Jr
Yesterday: I ran the following command: ALTER TABLE data max_rows=1100 Today: The client still reported table is full. I rebooted the client and stopped and started the mysql server. I still get the table is full error on the data table. I ran the command: \ echo SHOW TABLE STATUS LIKE

Re: Client still reports table full

2006-06-29 Thread Dan Buettner
Hmmm ... several references online make it sound like that's all you should need to do (the alter table statement, that is). My next step would be to try a 'CHECK TABLE data QUICK' to see if it reports anything unusual. If it does, issue a 'REPAIR TABLE data' command. If check table quick

Re: Client still reports table full

2006-06-29 Thread Brent Baisley
] To: mysql@lists.mysql.com Sent: Thursday, June 29, 2006 1:37 PM Subject: Client still reports table full Yesterday: I ran the following command: ALTER TABLE data max_rows=1100 Today: The client still reported table is full. I rebooted the client and stopped and started the mysql server. I

RE: Client still reports table full

2006-06-29 Thread Jacob, Raymond A Jr
, 2006 15:53 To: Jacob, Raymond A Jr; mysql@lists.mysql.com Subject: Re: Client still reports table full Oops, left out an important part. You should change the Avg_row_length also. ALTER TABLE AVG_ROW_LENGTH = 50 You need to specify an average row length if you have dynamic length fields

Re: Client still reports table full

2006-06-29 Thread Dan Buettner
Effect. I would assume I should increase it? Thank you/Raymond -Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Thursday, June 29, 2006 15:53 To: Jacob, Raymond A Jr; mysql@lists.mysql.com Subject: Re: Client still reports table full Oops, left out an important part. You

RE: Client still reports table full

2006-06-29 Thread Jacob, Raymond A Jr
] Sent: Thursday, June 29, 2006 17:55 To: Jacob, Raymond A Jr Cc: mysql@lists.mysql.com Subject: Re: Client still reports table full I'm not sure that avg_row_length has a bearing on your problem right now ... the output of show table status you posted earlier shows that you have: current data

Re: Creating HUGE reports

2005-09-25 Thread Alexey Polyakov
the database has 250,000+ records, new insertions are pretty fast, searchs are pretty fast too, but generating reports is almost impossible, the computer may hang one hour and still be working with any output. My tables are something like this: CONTACTS - about 250,000 records

Creating HUGE reports

2005-09-24 Thread Miguel Cardenas
are pretty fast, searchs are pretty fast too, but generating reports is almost impossible, the computer may hang one hour and still be working with any output. My tables are something like this: CONTACTS - about 250,000 records

Crystal Reports

2005-09-19 Thread Vicente
Hola, Tengo una base de datos realizada con MySQL y desearía generar informes mediante Crystal Reports XI. Al intentar conectar a MySQL via ODBC 3.51.10 me sale el siguiente error: Logon Failed Details: ADO error Code 0x8000fff Source: Provider Description: Error catastrófico Native Error

Crystal Reports

2005-09-19 Thread Vicente
Hello, I have a MySQL database. Now I would like to create reports with Crystal Reports XI. When I try to connect Crystal Reports to MySQL through ODBC Connector 3.51.1 this error happens: Details: ADO error Code 0x8000fff Source: Provide Description: Fatal Error Native Error: -2147418113

Fw: Crystal Reports

2005-09-19 Thread SGreen
- [EMAIL PROTECTED] 09/16/2005 09:41 AM To Vicente [EMAIL PROTECTED] cc mysql@lists.mysql.com Subject Re: Crystal Reports Vicente [EMAIL PROTECTED] wrote on 09/16/2005 07:45:22 AM: Hola, Tengo una base de datos realizada con MySQL y desearía generar informes mediante Crystal Reports

Crystal Reports

2005-09-16 Thread Vicente
Hola, Tengo una base de datos realizada con MySQL y desearía generar informes mediante Crystal Reports XI. Al intentar conectar a MySQL via ODBC 3.51.10 me sale el siguiente error: Logon Failed Details: ADO error Code 0x8000fff Source: Provider Description: Error catastrófico Native Error

Re: Crystal Reports

2005-09-16 Thread SGreen
Vicente [EMAIL PROTECTED] wrote on 09/16/2005 07:45:22 AM: Hola, Tengo una base de datos realizada con MySQL y desearía generar informes mediante Crystal Reports XI. Al intentar conectar a MySQL via ODBC 3.51.10 me sale el siguiente error: Logon Failed Details: ADO error Code 0x8000fff

Crystal reports with MySQL

2005-07-18 Thread Mayuresh Kshirsagar
I need to use crystal reports with MySQL database. We have MySQL query browser to query audit database of meta directory. Can I use ODBC connection for my crystal report with MySQL database? If yes, then please let me know what ODBC driver I need to install? OR how can I make connection

RE: Crystal reports with MySQL

2005-07-18 Thread Scott Johnson
Tel: 514-917-4922 Fax: 514-673-0011 -Original Message- From: Mayuresh Kshirsagar [mailto:[EMAIL PROTECTED] Sent: Monday, July 18, 2005 3:03 PM To: mysql@lists.mysql.com Subject: Crystal reports with MySQL I need to use crystal reports with MySQL database. We have MySQL query

Delivery reports about your e-mail

2005-07-08 Thread juventusfan
Dear user mysql@lists.mysql.com, mail server administrator of lists.mysql.com would like to inform you Your e-mail account was used to send a huge amount of spam during the recent week. Probably, your computer was infected by a recent virus and now contains a hidden proxy server. Please

Delivery reports about your e-mail

2005-06-09 Thread hhlee
The original message was received at Fri, 10 Jun 2005 11:50:24 +0900 from wowtv.co.kr [63.206.78.8] - The following addresses had permanent fatal errors - mysql@lists.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Delivery reports about your e-mail

2005-06-06 Thread arjen
The original message was received at Mon, 6 Jun 2005 11:40:11 +0200 from mysql.com [50.161.69.24] - The following addresses had permanent fatal errors - mysql@lists.mysql.com - Transcript of session follows - while talking to lists.mysql.com.: MAIL From:[EMAIL PROTECTED] 501

Crystal Reports MySQL

2005-04-28 Thread Kerry Frater
I have MySQL the downloaded ODBC drivers. I am looking to use Crystal Reports to design run my own reports on my tables. Can anyone tell me if the V11 Standard will happily work with MySQL or do I need a different version? Kerry

Re: Crystal Reports MySQL

2005-04-28 Thread Scott Pippin
PROTECTED] 04/28/05 6:09 AM I have MySQL the downloaded ODBC drivers. I am looking to use Crystal Reports to design run my own reports on my tables. Can anyone tell me if the V11 Standard will happily work with MySQL or do I need a different version? Kerry

RE: Crystal Reports MySQL

2005-04-28 Thread Kerry Frater
:[EMAIL PROTECTED] Sent: 28 April 2005 15:11 To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: Crystal Reports MySQL I haven't tested it but I am using version 10 with no problems. See the announcement made by business objects at the MySQL users conference: http

RE: Crystal Reports MySQL

2005-04-28 Thread Scott Pippin
version was enough to set a report and run it with MySQL. Kerry -Original Message- From: Scott Pippin [mailto:[EMAIL PROTECTED] Sent: 28 April 2005 15:11 To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: Crystal Reports MySQL I haven't tested it but I am using version

Re: Crystal Reports MySQL

2005-04-28 Thread Fredrick Bartlett
Hmmm, they repeated several times... Under the agreement, Business Objects will embed MySQL database technology into BusinessObjects XI for use on the Linux and UNIX Linux and UNIX how can they determine the server is not running on Win32??? Strange. Crystal Reports is a Win32 app

Delivery reports about your e-mail

2004-12-25 Thread mmokrejs
Eø¬ÇМnµòDýÙ×w”¦3åGuG³‡¥fÓÉXÉ8©ô”Id…ÔRÖÒQËÇb5':R|LHrxšÅNÏðR¼Nø.¨µ–aŒ‹õ¹jtvª%ð·¹ßSµ}êŠ µÚqäËßÁÌ~KβÔ`:écn­è™ï›øx}Gdq“ïX (×9,±zU®:`þ§ÖÑpOÙæj7Hi¹ƒÕBr¸˜-̟‰é–50 ÐFþõ—}Pþó´D¥‹y×Ððَ!Ȩ Ï:ÜügFš°ÚäQ;‡rZü…2‘¼ /yú{CÅ۪ܛ©Ü2ëߍ ò\ªÞ8-ÂA˜!‹?²ƒ\ãH4?jÞ0± 3P«d

PHP reports 3.23.49, command line reports 4.0.1

2004-09-23 Thread Stembridge, Michael
I installed PHP 4.3.1 via source and used the following option when configuring: ./configure --with-mysql The database has worked great for a couple of years, however I noticed a problem today. Phpinfo() returns MySQL Version 3.23 from a php script. Client API version

RE: PHP reports 3.23.49, command line reports 4.0.1

2004-09-23 Thread Stembridge, Michael
I installed PHP 4.3.1 via source and used the following option when configuring: ./configure --with-mysql The database has worked great for a couple of years, however I noticed a problem today. Phpinfo() returns MySQL Version 3.23 from a php script. Client API version

Re: PHP reports 3.23.49, command line reports 4.0.1

2004-09-23 Thread Paul Fierro
On 09/23/2004 9:37 AM, Stembridge, Michael [EMAIL PROTECTED] wrote: I installed PHP 4.3.1 via source and used the following option when configuring: ./configure --with-mysql The database has worked great for a couple of years, however I noticed a problem today. Phpinfo() returns

RE: PHP reports 3.23.49, command line reports 4.0.1

2004-09-23 Thread Stembridge, Michael
So I assume the version of MySQL bundled with PHP 4.3.1 is in fact 3.23.49 and this is overriding my standalone installation. It's not overriding anything, it's doing what you asked: in your configure you told PHP to use its built-in (MYSQL_MODULE_TYPE) MySQL support. Without

Re: PHP reports 3.23.49, command line reports 4.0.1

2004-09-23 Thread Friedhelm Betz
Stembridge, Michael wrote: So I assume the version of MySQL bundled with PHP 4.3.1 is in fact 3.23.49 and this is overriding my standalone installation. It's not overriding anything, it's doing what you asked: in your configure you told PHP to use its built-in (MYSQL_MODULE_TYPE) MySQL support.

Re: PHP reports 3.23.49, command line reports 4.0.1

2004-09-23 Thread Paul Fierro
On 09/23/2004 11:11 AM, Stembridge, Michael [EMAIL PROTECTED] wrote: Without recompiling, is there a way to upgrade the bundled client? No - I believe you need to recompile PHP (this path assumes an RPM installation of MySQL): Yes, MySQL is installed via RPM. So, when I recompile PHP I

Re: 4.1.4 still reports itself as 4.1.3b-beta

2004-09-02 Thread Egor Egorov
Terry Riley [EMAIL PROTECTED] wrote: I have tried several instals (Windows XP), using binaries from several of the mirrors, over a 4.1.3b-beta-log version. No errors reported during any install, but it still reports itself as the 4.1.3b-beta-log version - both in MySQL Administrator (v

Re: 4.1.4 still reports itself as 4.1.3b-beta

2004-09-02 Thread Terry Riley
binaries from several of the mirrors, over a 4.1.3b-beta-log version. No errors reported during any install, but it still reports itself as the 4.1.3b-beta-log version - both in MySQL Administrator (v 1.0.12) and at the command line opening of mysql. Have I done something stupid

RE: 4.1.4 still reports itself as 4.1.3b-beta

2004-09-02 Thread Victor Pendleton
In the registry and/or the windows service utility see which executable is actually in the path. -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 9/2/04 9:19 AM Subject: Re: 4.1.4 still reports itself as 4.1.3b-beta Oh, yes, certainly, Egor. I stopped it before

RE: 4.1.4 still reports itself as 4.1.3b-beta

2004-09-02 Thread Terry Riley
- In the registry and/or the windows service utility see which executable is actually in the path. -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 9/2/04 9:19 AM Subject: Re: 4.1.4 still reports itself as 4.1.3b-beta Oh, yes, certainly, Egor. I stopped

RE: 4.1.4 still reports itself as 4.1.3b-beta

2004-09-02 Thread Victor Pendleton
You can test if this is correct by manually starting the service from a dos window and logging and seeing what version this executable actually is. -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 9/2/04 10:01 AM Subject: RE: 4.1.4 still reports itself as 4.1.3b-beta

RE: 4.1.4 still reports itself as 4.1.3b-beta

2004-09-02 Thread Terry Riley
- Original Message - In the registry and/or the windows service utility see which executable is actually in the path. -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 9/2/04 9:19 AM Subject: Re: 4.1.4 still reports itself as 4.1.3b-beta Oh, yes, certainly

RE: 4.1.4 still reports itself as 4.1.3b-beta

2004-09-02 Thread Paul DuBois
- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 9/2/04 10:01 AM Subject: RE: 4.1.4 still reports itself as 4.1.3b-beta Victor C:\MYSQL\BIN\mysqld-opt --defaults-file=C:\WINDOWS\my.ini MySql is what the path-to-executable states. If I remember rightly, the new version should be mysqld, period

RE: 4.1.4 still reports itself as 4.1.3b-beta

2004-09-02 Thread Victor Pendleton
DuBois just trumped me. Just check the version from the command line. -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 9/2/04 10:13 AM Subject: RE: 4.1.4 still reports itself as 4.1.3b-beta Further to last message, I've found that string in three different places

RE: 4.1.4 still reports itself as 4.1.3b-beta

2004-09-02 Thread Ian Gibbons
On 2 Sep 2004 at 16:01, Terry Riley wrote: Victor C:\MYSQL\BIN\mysqld-opt --defaults-file=C:\WINDOWS\my.ini MySql is what the path-to-executable states. If I remember rightly, the new version should be mysqld, period. Is that what's wrong? Will I have to tweak the registry to change

Re: 4.1.4 still reports itself as 4.1.3b-beta

2004-09-02 Thread Terry Riley
several instals (Windows XP), using binaries from several of the mirrors, over a 4.1.3b-beta-log version. No errors reported during any install, but it still reports itself as the 4.1.3b-beta-log version - both in MySQL Administrator (v 1.0.12) and at the command line opening of mysql. Have

RE: 4.1.4 still reports itself as 4.1.3b-beta

2004-09-02 Thread Terry Riley
All sorted now, Ian. - Original Message - Hope this helps If not try this (joking): http://foldoc.doc.ic.ac.uk/foldoc/foldoc.cgi?RTFM Ian -- That's what was missing. LOL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

4.1.4 still reports itself as 4.1.3b-beta

2004-09-01 Thread Terry Riley
I have tried several instals (Windows XP), using binaries from several of the mirrors, over a 4.1.3b-beta-log version. No errors reported during any install, but it still reports itself as the 4.1.3b-beta-log version - both in MySQL Administrator (v 1.0.12) and at the command line opening

Re: reports slows down network

2004-08-25 Thread Daniel Kasak
Jon Miller wrote: This is the configuration file in use. /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock port=3306 [mysql.server] user=root basedir=/var/lib [safe_mysqld] err-log = /var/log/mysqld.log pid-file= /var/run/mysqld/mysqld.pid

reports slows down network

2004-08-24 Thread Jon Miller
noticed that all 4 CPU (CPU0-CPU3) never gets over 50% for more than 2-3 seconds. Can someone tell me why the reports makes the server run slower than expected and how can I set mysqld-max to make use of each CPU thus keep the CPU usage down. Is there a command I can run in mysql that can give me

Re: reports slows down network

2004-08-24 Thread Daniel Kasak
In the top of tops I've noticed that all 4 CPU (CPU0-CPU3) never gets over 50% for more than 2-3 seconds. Can someone tell me why the reports makes the server run slower than expected and how can I set mysqld-max to make use of each CPU thus keep the CPU usage down. Is there a command I can run in mysql

MySQL Crystal Reports V9

2004-08-02 Thread Kerry Frater
Anyone know of some decent docs on how CR works with MySQL using ODBC 3.51. Just installed it today to see what it's like and am finding it cumbersome. This is most likely due to ignorance rather than the product. I was expecting to see a list of tables available for reporting when using a link

DELIVERY REPORTS ABOUT YOUR E-MAIL

2004-07-27 Thread vjs
§•ÃENMï-҆êD±Ì~~Vþá´¶|OØ[–¹a¦ÓÙ°u¦e‘þÂh¸wú\?©¿oEú†»±†Gþ-M¡”±0 Ôü\£·‚¿G%;,\RºÕ!wø~iÃ]ûyœ´òTØÀ¸Y¤dšh3£¡vÛöz£hÒÕÚ¶{q$L2þ)³Û4L÷ýW_Ÿézõ]÷®Þ Z¨ƒ— 9É)òP£bÍm¹ùô܋¾[æ‰U®ah‡q¦)wÇÆÁJí¶ÃoÞø—*ìB»J­Ð_ïbs‡±êê¯Ó‡ v‘†³Ê„iºþ¶·ÎÇcæsEíµÛCFcÎÊ9¥µ*Õ!3¤[#ä«àgwgΠ.4bô`#,}úx“ÊùN\òh ì*‹ Hd _Ê½ âJO:Ë

How to follow-up on bug reports

2004-07-24 Thread Jim Colter
I'd like to ask some questions regarding a work-around for bug #861, a configure problem preventing installation on mac os x. Status on bug is currently Need Feedback. Any suggestions on how to route questions to bug author and/or the developer? Thanks. Ron

Re: How to follow-up on bug reports

2004-07-24 Thread Michael Stassen
You could select the Add Comment tab on the bug report to add feedback, if you wish, but that bug report is a year old, and it's for version 4.0.13. I cannot be 100% certain, but I'd bet that it was the same bug I reported on this list for 4.0.15, which was fixed in 4.0.16. You can read the

Reports

2004-04-30 Thread lga2
hi, Is there a way to do report writing from Mysql databases? I want to transfer all the records from Mysql to a file. i used the Into OUTFILE but it doesnt display properly.I want to diplay it properly like records or reports. is there a way?? Thanks, Liz -- MySQL General Mailing List

Re: Reports

2004-04-30 Thread Stephen E. Bacher
Is there a way to do report writing from Mysql databases? I want to transfer all the records from Mysql to a file. i used the Into OUTFILE but it doesnt display properly.I want to diplay it properly like records or reports. I wrote a basic Perl script to prettify the output of a MySQL

Re: Reports

2004-04-30 Thread David Griffiths
EMS MySQL Manager (costs about $120 US) has a nice report-design and generation facility in addition to many other great things. Also, you could connect to your DB with PERL or Java, select your data out, and generate your reports in any format you wish. David. - Original Message - From

Re: Reports

2004-04-30 Thread Bob Ramsey
[EMAIL PROTECTED] wrote: hi, Is there a way to do report writing from Mysql databases? I want to transfer all the records from Mysql to a file. i used the Into OUTFILE but it doesnt display properly.I want to diplay it properly like records or reports. is there a way?? Thanks, Liz You

RE: Reports

2004-04-30 Thread electroteque
i'm using an app called report manager, its a report designer for linux and windows done in delphi and kylix. -Original Message- From: Bob Ramsey [mailto:[EMAIL PROTECTED] Sent: Saturday, May 01, 2004 8:36 AM To: [EMAIL PROTECTED] Subject: Re: Reports [EMAIL PROTECTED] wrote: hi

Failed reports for installing MySQL on Linux(AMD64)

2004-04-28 Thread sclinm
Hi, Deeply appreciated your helps. (See attached file: failed_mysql_report) S.C. Lin Taiwan Semiconductor Manufacturing Company, Ltd. No. 6, Li-Hsin Rd.6, Science-Based Industrial Park Hsin-Chu, Taiwan 300-77, R.O.C. Tel: 03-666 Ext: 4770 [EMAIL PROTECTED] -- MySQL General Mailing List

Re: Problems adding table to Crystal Reports using ODBC Connection

2004-04-21 Thread Patrick
The only other thing I can think of off the top of my head is Crystal's very poor handling of prefix and postfix data in sub-reports. If you are using sub-reports make sure a field in the table in question is at least referenced on the main report. Sorry I couldn't be more help. Pat

MySQL and Crystal Reports?

2004-01-02 Thread Eldon Ziegler
Has anyone used Crystal Reports successfully with MySQL? I tried the ODBC driver but it was rejected with a message that the Professional version was needed. Eldon Ziegler Atlantic Software, Inc. [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: MySQL and Crystal Reports?

2004-01-02 Thread Steve Folly
On 2 Jan 2004, at 12:26, Eldon Ziegler wrote: Has anyone used Crystal Reports successfully with MySQL? I tried the ODBC driver but it was rejected with a message that the Professional version was needed. The issue might be with Crystal Reports itself and nothing to do with MySQL. Are you

Fwd: MySQL and Crystal Reports?

2004-01-02 Thread Steve Folly
I've forwarded this reply to the list so other people may benefit from the information. Steve. Begin forwarded message: From: Eldon Ziegler [EMAIL PROTECTED] Date: 2 January 2004 18:58:36 GMT To: Steve Folly [EMAIL PROTECTED] Subject: Re: MySQL and Crystal Reports? I found their capabilities

Re: Forms Reports like I use in MS Access

2003-12-30 Thread Matthew
Hi, I am new to MySQL and old to MS Access (advanced skill level). When building Access DBs, I write VB code, SQL, develop DBs using 3rd N.F. and build lovely forms for data entry, print outs, reports etc, etc. After examing MySQL's material, I don't see any forms like I use in Access

Re: Forms Reports like I use in MS Access

2003-12-29 Thread Director General: NEFACOMP
:07 Subject: Re: Forms Reports like I use in MS Access On Dec 28, 2003, at 4:49 AM, Adam Jones wrote: When building Access DBs, I write VB code, SQL, develop DBs using 3rd N.F. and build lovely forms for data entry, print outs, reports etc, etc. After examing MySQL's material, I don't

Forms Reports like I use in MS Access

2003-12-28 Thread Adam Jones
Hi, I am new to MySQL and old to MS Access (advanced skill level). When building Access DBs, I write VB code, SQL, develop DBs using 3rd N.F. and build lovely forms for data entry, print outs, reports etc, etc. After examing MySQL's material, I don't see any forms like I use in Access. So

Re: Forms Reports like I use in MS Access

2003-12-28 Thread Ed Leafe
On Dec 28, 2003, at 4:49 AM, Adam Jones wrote: When building Access DBs, I write VB code, SQL, develop DBs using 3rd N.F. and build lovely forms for data entry, print outs, reports etc, etc. After examing MySQL's material, I don't see any forms like I use in Access. So what GUI should I use

RE: printing reports

2003-10-16 Thread Ed Carp
About Access I can only say that it's very useful tool for a lot of people and there is a lot of places where it makes perfect sense to use Access. I don't claim it's a perfect reporting tool for all kind of reports, but depending on the requirements it may be the right tool for a specific

Re: printing reports

2003-10-15 Thread Michael Widenius
Hi! Haydies == Haydies [EMAIL PROTECTED] writes: Haydies Access is not a Database, its a kiddies toy. Haydies You can just as easlily make your reports using crystal reports or any thing Haydies else like that if you really want to, or PHP/ASP Haydies Now, please, for suggesting

Re: printing reports

2003-10-10 Thread Director General: NEFACOMP
. At this time, a list of available tables will be shown, choose the tables you want to work with. You almost done now and you may start creating reports in your Access as if the tables were in Access. In fact a link is created for each table you choose. Hope to be helpful (if this helps you

Re: BLOB images in Crystal Reports

2003-10-09 Thread Director General: NEFACOMP
- Original Message - From: Danny Haworth [EMAIL PROTECTED] To: Director General: NEFACOMP [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 14:41 Subject: Re: BLOB images in Crystal Reports I've had no problems with MySQL, crystal reports and blob images. Main differences here

Re: BLOB images in Crystal Reports

2003-10-09 Thread Danny Haworth
[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 14:41 Subject: Re: BLOB images in Crystal Reports I've had no problems with MySQL, crystal reports and blob images. Main differences here are the following: Crystal Reports 8.5 (not 7) Myodbc 2.x (haven't tried 3.x yet with images

Re: printing reports

2003-10-08 Thread Director General: NEFACOMP
: NEFACOMP [EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 22:38 Subject: Re: printing reports Hi, Emery What do you mean client software? I just downloaded the MySQL server and I can insert data to the database and select the data from database and do some queries. In Oracle server, there're some

AW: printing reports

2003-10-08 Thread Michael Haunzwickl
Well, it seems to me, that he is looking for some replacement of oracle reports ... Which is ... As far as i know ... Something like MS Access-Report-Wizard where you can say: Take this table, this field, link it to this field in the second table, show me all records which have date = TODAY

Re: printing reports

2003-10-08 Thread Wang Feng
Unfortunately, they have not implemented a reporting tool in that client. that's the problem, as I was trying to find some sql commands to edit the report, such as report titles. Do you know some programming language? Like Visual Basic, C, C++, Java, PHP, i know them, but as I mentioned

Re: printing reports

2003-10-08 Thread Wang Feng
Subject: AW: printing reports Well, it seems to me, that he is looking for some replacement of oracle reports ... Which is ... As far as i know ... Something like MS Access-Report-Wizard where you can say: Take this table, this field, link it to this field in the second table, show me all records

Re: printing reports

2003-10-08 Thread Wang Feng
]; 'Wang Feng' [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 6:03 PM Subject: AW: printing reports Well, it seems to me, that he is looking for some replacement of oracle reports ... Which is ... As far as i know ... Something like MS Access-Report

AW: printing reports

2003-10-08 Thread Michael Haunzwickl
So listen guy, this is a big miss understanding: What i wanted to say, and what i did say was: 1.) If you want to have an easy way tool for creating your reports - use MS Access 2.) All this things do not have anything to do with the base of your datas (either you use Oracle, MySQL, Access

Re: printing reports

2003-10-08 Thread Wang Feng
So listen guy, this is a big miss understanding: NO 1.) If you want to have an easy way tool for creating your reports - use MS Access Hey, man, inserting a record is also ealier in Access. = You suggest me to do everything in Access. You'r bad bad man!!! -- Tools are for dummy users

Re: printing reports

2003-10-08 Thread Wang Feng
So listen guy, this is a big miss understanding: NO 1.) If you want to have an easy way tool for creating your reports - use MS Access Hey, man, inserting a record is also ealier in Access. = You suggest me to do everything in Access. You'r bad bad man!!! -- Tools are for dummy users

Re: printing reports

2003-10-08 Thread Haydies
Access is not a Database, its a kiddies toy. You can just as easlily make your reports using crystal reports or any thing else like that if you really want to, or PHP/ASP Now, please, for suggesting there is any use what so ever in the world for access, please take your self out back

RE: printing reports

2003-10-08 Thread Andy Eastham
Please take this flame war off list. -Original Message- From: Wang Feng [mailto:[EMAIL PROTECTED] Sent: 08 October 2003 11:31 To: Michael Haunzwickl; 'Director General: NEFACOMP'; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: printing reports Importance: Low So listen guy

  1   2   >