Report Tool
Is there any MySQL reporting tool that is open source and doesn't require programming knowledge? I need a front end for MySQL that will allow a user to input a couple parameters and will produce a report, including graphs. I haven't been able to find an adequate open source solution for this.
View Complete Forum Thread with Replies
Related Forum Messages:
Report Creator
I am now using Open Office to connect to the MySQL thru ODBC. So that I can retrieve some data from MySQL and generate report in open office. I have already installed MyODBC and unixODBC. A file called odbc.ini created as below: [MySQL-test] Description = MySQL database test Driver = MySQL Server = localhost Database = test Port = 3306 When I tried to test this ODBC connection using isql MySQL-test test, an error occured: [IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified [ISQL]ERROR: Could not SQLConnect
View Replies !
Mysqladmin 1.4 Report
when i try to create a report in mysqladmin 1.4 it a message box displays "the server must be connected" Under the enviroment tab the myODBC box has "not found Driver 3.51 not found I am using xampp can you tell me what i'm doing wrong?
View Replies !
Report Writer
couldn't really find a spot to put this, but basically I need a MySQL report writer. I have been using SQuirrel, but it isn't properly representing BLOB and DOUBLE values, looks like the values come out the other end as hexadecimal. Rather than spend time sortign it out I'm just gong to move to another report writer. It is unfortunate as I have really enjoyed using SQuirrel.
View Replies !
Report Generation
I have the MySQL server and the Query Browser up and working but I don't see anything about generating reports and I can't find anything on reports in the online documentation. What do MySQL users use for generating customized reports? Is there some GUI tool from MySQL or do people use other products like Crystal Reports?
View Replies !
Weekly Report
I am creating weekly reports for a application that I have. I'm using the Date column ( YYYY-MM-DD) for my mysql database. Is there a query that brings up totals for Monday through Sunday for the month of April/June etc??
View Replies !
Select For A Report
I have a table with this fields : ID (integer) Date (datetime) Name (char) I want select count of items that add in each month of year For example a report like this : 2 Items add to database in january of 2006 9 Items add to database in march of 2006 3 Items add to database in january of 2007 (I can change the numbric month to it names with PHP)
View Replies !
Client Side Report
i hav a few reports that generate at server side i would like to copy the tables needed for the report to client's temp file, and perform the calculation and filtering there. may i know is this way possible? for 1 table, there's .frm, .myd and .myi files, which files should i copy? and how should the connection string looks like when connecting to client's own temp file?
View Replies !
Generate Report Using Group By
I have few invoices which have due_date as one of its field. Now I want to generate a report like the following CName --------0-30 -------- 31 - 60 --------61 - 90 -------- over 90 abc --------$45 -------- $34 -------- NO -------- No Xyz --------No -------- $78 -------- $76 -------- No bcd -------- $897 -------- $456 -------- No --------No Totals: ---- --- --- --- Where those days are overdue period (today - due date). I want to retrieve the whole in one (max 2 not a buch in a loop) queries.
View Replies !
Parameters In SP When Calling A Report
Set up the connection to the DB in Crystal using MyODBC. I used the Database expert to call my Stored Procedure which has one Parameter and the code is real simple going like this: call SuccessLetter (AppNo) From the wizard i can see and place all the fields from the SP onto the report as long as i hard code an application number into my parameter. But as soon as i change it to a variable (as above) i get the following error from Crystal: Unknown Fields AppNo in order clause MySQL ODBC 3.51 error 42S21 On the VB code side i used Success.SetParameterValue("AppNo", GeneralFunctions.ApplicationNo) to set up the parameter and this does get passed thru so the error is comming from the database expert - almost as if it dont recognise that my stored procedure has a parameter. Which it does and it does work if i use the SP outside of Crystal. I know the SP is working fine cause i have written another SP and then called SuccessLetter with the new SP using a parameter and the results are perfecr.
View Replies !
INSERT IGNORE - Get A Report?
I'm creating a shopping cart-esq type system with a primary key on two fields. My app builds an insert query that can insert many rows at once. When the user tries to add something already in their cart (not allowed by the primary key structure) the IGNORE statement allows the query to go ahead, and the other rows to be inserted. My question therefore is: Can I get a response from MySQL as to whether or not the IGNORE statement affected the query ? i.e would there have been a duplicate row ? Ideally I could even get info about WHICH row would have caused a conflict, but I'd be surprised if I could get this info.
View Replies !
Report Query Load
Is there a way in PHP to have the MYSQL report the load that is placing on the mysql server. I am trying to optimize some queries and I was hoping the server could give me some feedback so I know if I'm going in the right direction.
View Replies !
Structure Of Database To Prepare Report
I'm attempting to create a database which will take information from one (perhaps two) tables and utilize that information to return queries to a report designed in Excel. The general idea I have is this: The "primary" or "source" table is easy. This is a trial balance (account number as a primary key, description, amount). I'll need table(s) to denote which account numbers belong to which page/line on the report. I'm not sure how many pages the report will be, but let's say my Excel workbook would have 50 sheets. My question is this: What would you recommend for a table structure. The way I see it, I could have a single table listing each page and each line on each page (each identified by a unique id), then have another table listing each account and each page/line id. The other option I see is to have a separate table for each "page," but I'm not sure I see a benefit in this. My first instinct is to use the first method I mentioned.
View Replies !
Crystal Report, MySql, And Images
I am creating a report using Crystal Report and I want to upload an image coming from the mysql database to the crystal report. Can I upload the image to crystal report without actually storing the image in the database?
View Replies !
Multiple Count Queries -> One Report
I'm getting a bunch of data out of a database in the form of a lot of COUNT statements eg: SELECT COUNT (*) AS "Value1" FROM tablename WHERE x=1; SELECT COUNT (*) AS "Value2" FROM tablename WHERE y=5; etc ... there are about 30 queries. I'm using PHPmyAdmin to do this. Currently I have to put each statement in separately: If I put the whole load of them, PHPadmin only displays the last value. I don't need a great deal of detail, but if someone can suggest a way I can accomplish this so I run one multi-line query and get all my values at once that would be great. Perhaps there is a better tool than phpMyadmin? Or maybe I should be looking at VIEWs or STORED PROCEDURES? If you can paint the broad outlines, I can fill in the gaps.
View Replies !
How To Show Records In A Report View
my table contains the following columns : news_date (date) news (tinytext) i need a query which would display the table records in the following way: 09-11-06 the news item------------- --------------------------- --------------------------- 10-11-06 the news item------------- ------------------------- ------------------------- thats is each record should be displayed as seperate and not in a tabular view.
View Replies !
Report Of Query Execution Times
Does mysql have a tool to record and report a list of all queries executed and how long it took to execute each query? If not can anyone suggest a tool I can use to do this? I've heard of mysql query profiler but does it capture queries from all sessions?
View Replies !
Crystal Report Connection Problems
ODBC ERROR:[MySQL][ODBC 3.51 Driver][MySQL-5.0.27 community-nt] You have an error in your SQL syntax: check the manual that corresponds to your MySQL server version for the right syntax to use neer 'ahmsys','tenants' limit 0 at line 1. While trying to connect to this tabel (tenants) I get this error, however I'm able to connect to the next tabel (teansactions) in the database (ahmsys). What is this... limit 0 at line 1.
View Replies !
How Make Stock Card Report
i want the query can show stock card report like : Item Code QtyIn QtyOut Final Date A-001 2/3/2008 10 5 5 <------------ line 1 4/3/2008 2 0 7 <------------ line 2 10/3/2008 20 2 25 <------------ line 3 15/3/2008 4 0 29 <------------ line 4 item code,date,qtyin and qtyout are my fields in databse, but "Final" are operation result from 10 - 5 = 5, 5 (final line 1) + 2 + 0 = 7, 7 (final line 2) + 20 + 2 = 25, 25 (final line 3) + 4 + 0 = 29
View Replies !
How To Report Changes In Rows Before And After Multiple Transactions
I am trying to uncover what a specific tool is doing to my database. What is your favorite way to compare database contents before and after an operation? I would like to know what rows were modified in which tables. Hopefully, such a tool or method could report the "before" and "after" states of affected rows only, where applicable. I don't expect there to be any changes to any table structures. I am using a LAMP setup, if it matters. I am hoping for an open-source solution.
View Replies !
Viewing Error In Crystal Report
i am trying to make a report using crysatl report in c#.net for mysql database. 1. when i use a dsn (odbc) the error occurs when the form containing the viewer is loaded 'could not load rowset'. however i checked the connection and it worked fine 2. i tried again using the project data sets when building the crystal report but this time i could not log on when the form containing the viewer was openend
View Replies !
Scribe Report Generator For MySQL And Other RDBMS
We are looking for beta-testers for our new product - Scribe Report Generator. At this moment, Scribe supports 6 relational databases, including Oracle, MS SQL Server 2000, and Sybase. Very briefly: Scribe is written in Java, is based on visual programming and can be extended by adding user-written Java classes; it comes with the API library to let other Java-based apps run Scribe reports programmatically. The details are on our website: www.gestalt.com/Scribe (temporary location). User: guest Password: star We offer a free license to everyone who provides us with a feedback on bugs, inconsistencies, or constructive criticism that helps us refine Scribe.
View Replies !
Stored Procedure For Creating Daily Report
how i can create a stored procedure that do the select into the OUTFILE for a day or two from the time of excution. the aim is to generate a report to the shared folder say /home/reports/ The created file should have the unixtime to identify itself
View Replies !
Report Writing Query Problem (joins Again...)
Hola database type folks, I have been trying to get this right for sometime but now must admit defeat I have 3 tables artists -> holds details on the artists card_gallery -> hold details of card available related to artists via artist_name scart -> shopping basket related to card_gallery via card_image_id I am writing a reporting facility that allows the administrator to view all the artists in a table along with their number of cards online and cards sold figures. Currently I have something like select card_gallery.artist_name as cg_an, count(card_gallery.artist_name) as cg_ca, count(scart.card_image_id) as s_ci, from card_gallery left join scart on card_gallery.card_gallery_id=scart.card_image_id group by card_gallery.artist_name but that doesnt give the correct number of cards sold. Cards sold are registered in the scart table by setting the processed field to 1 Ideally I would like to be able to view all the artists on one table with the number of cards online and the number sold even if it's 0
View Replies !
Adding User Defined Date Range For Report
Hello I have a very simple query that list customer info within a date range. I would like to have a interactive form that would allow the customer to choose between two dates and query the DB for information between the two dates entered. it is coded like (WHERE `date_purchased` > '2005-08-01 00:00:00' AND `date_purchased` < '2005-09-01 00:00:00') below is the code but I need help or guidence on how to get the customer input into the query instead of the hard coded area that is there now....
View Replies !
ERD Tool?
I need a good ERD tool for reverse engineering a few databases. It must be able to properly reverse engineer the foreign keys and create the entity relationships for InnoDB tables. (The fabforce product does not, for example, or at least I can't figure out how to make it do so) Free is preferable, but commerical/licensed products are okay too.
View Replies !
Graphical Tool
I'm building my first MySQL database and come into trooble when trying to create constraint integrity. I'm trying to get it work by hand (notepad) but thing that it would be better to create the tables using a graphical tool, but I can't find any for MySQL.Please help by giving me URL's for graphical tools (if possible free) that manage constraint integrity.
View Replies !
Looking For Encryption Tool
I have a prospect that needs to collect sensitive personal data via the web for mortgage applications. A certificate & SSL seems to protect the data from the browser to the server, but I need some way to encrypt the data for storage in mysql and (possibly) into a flat file for retrieval by the prospect. I have not been able to find a simple solution for this compatible with BSD and Apache.
View Replies !
Php Admin Tool
I recently upgraded from phpmyadmin 2.5.0 to 2.6.3-pl1. I cannot find the functionality to 'load text files into tables'.
View Replies !
Migration Tool Kit
I'm new to MySQL and cannot get a connection to my database at my ISP. My ISP is lowesthosting.com they use an Apache Server. I've tried to connect using the dns # 207.44.216.56. I've also tried using my FTP address and I cannot get a connection. I get a message in the details that it will not recognize my password. I know I'm doing something wrong but can't figure out what?
View Replies !
Migration Tool
I'm new to using the Migration Tool and don't know where to look for help, so I posted here rather than the Migration Tool forum. What I am trying to do is get data from a high-traffic Oracle server over to a local MySQL so I can dissect and analyze the data with large amounts of data (with temporary query space too big for MS Access). In the migration tool is there a way to do the following: On the Oracle Server: - Select ACCOUNT_ID, CALL_DATE, CALL_TIME, CALL_RESULT from DATA_REPOSITORY.ACCOUNT_CALLS where CALL_DATE >= TO_DATE('07/01/2007','MM/DD/YYYY') and CALL_DATE <= TO_DATE('07/31/2007','MM/DD/YYYY') On the MySQL Server I want to migrate it into a local schema/table called LOCAL_PROD.CALLS_200707. The major things that I want to do here is only select the 4 fields I need out of the data repository, and I only want to do a month at a time since there is usually ~27 million records per month with data going back all the way to 2005 and I want it split up for faster querying and right now I don't care for anything before the last couple of months. Is this possible using the Migration Tool? I can connect to the Oracle DB and local MySQL fine. However, when I try to mess with the SQL statements under the Advanced options and Apply Changes, it looks like everything is going fine. However, the WHERE statement will go away during the Bulk Transfer and the process will still try to take the entire contents of DATA_REPOSITORY.ACCOUNT_CALLS and create a DATA_REPOSITORY schema on the local server and try to put the entire contents in a table of the same name. I'm open to other suggestions if the Migration Tool is not made for that kind of functionality.
View Replies !
GUI Admin Tool
I am looking for GUI tool throught which I can: Connect Remote MySQL servers Execute query in GUI tool View Records Modify Record directly by selecting and editing row. Delete tables View tables Almost, similar like what TOAD offers for Oracle. Which is suitable/best GUI tool for MySQL Admin activities.
View Replies !
MySQL GUI Tool
I just downloaded mysql but i would like to use a tool that would let me create/drop/alter tables , delete, add files etc. Which tool do you think is the BEST one for this?
View Replies !
Stand Alone SQL Tool?
i have been using SQLyog 2.5.1 for my sql administration during development. i went back onto their site to see if there were any updates and realised that they were on 3.5 and you had to register the software! (2.5.1 was freeware).
View Replies !
Database Design Tool
Is there a good (free) database design tool for windows and MySQL? I have been using DBDesigner but it seems to ignore foreign key constraints when I generate an SQL create script.
View Replies !
Tool To Produce A Shema
Is there a tool that can compare db1 with db2 and just output the SQL to make db1 look like db2?Would appreciate if that was possible in phpmyadmin either directly or with an extension if those exist.
View Replies !
MySQL Monitoring Tool
I have an application thats running 24/7 but every night its loosing connection to the database. When I restart the app in the morning it works fine again. I want to monitor the DB and the server for 24 hours to see what is causing the application to loose connection at night. The provider of the app said that the DB could be tying up too many resources and its loosing connectivity.
View Replies !
MySQL GUI Client Tool
I am looking for a gui-based open source client tool for mysql. Does anybody have any suggestion besides those listed in the first few posts in the beginning of the forum?
View Replies !
MySQL Migration Tool
how trustworthy and capable is the Migration Tool? If it says everything went smoothly does it mean that everything went smoothly? Just a little example, Access stores dates on the background in US format although it displays it to me normally in EU/Dutch format (day-month-year). This I could easily check to see if it migrated things well because I'm aware of this issue with Access. But are there any pitfalls I should look out for with this migration tool? Not sure if others have experience with it.
View Replies !
Problem With MysqlAdministrator' Tool
when I first time to login database via 'mysqlAdministrotr' with user 'root', it does not work. Then when I close it, the error message comes out like this 'Exception EAccessviolation in module libmysqladmin.dll at 000013d8 access violation at address 00AC13D8 in module 'libmysqladmin.dll'. Read'.
View Replies !
MySQL Diag Tool For XP
I have MySQL v5 installed on my XP PC. MySQL is used by another program on the same PC. Currently this other program, which I create scripts with in its' native scripting language and run within the program, is coming back with an error that says Error: Table is Read Only. I have used the MySQL GUI admin tool to look at the database that this program uses to see if I can see anything wrong, but it all looks OK. Is there a tool I can use to try and write/access the tables within this programs MySQL database so I can try and identify the offending table and maybe fix the problem.
View Replies !
Error After 30s Of Loading Via ETL Tool
Exception in component tMysqlBulkExec_4 com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Last packet sent to the server was 30074 ms ago. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:532) at com.mysql.jdbc.Util.handleNewInstance(Util.java:353) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2720) at com.mysql.jdbc.MysqlIO.sendFileToServer(MysqlIO.java:2798) at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:2033) at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1421) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1772) at com.mysql.jdbc.Connection.execSQL(Connection.java:2430) at com.mysql.jdbc.Connection.execSQL(Connection.java:2359) at com.mysql.jdbc.Statement.execute(Statement.java:719) at datastrata.load_0_2.load.tMysqlBulkExec_4Process(load.java:1801) at datastrata.load_0_2.load.tFileExist_3Process(load.java:1735) at datastrata.load_0_2.load.tFileExist_1Process(load.java:1573) at datastrata.load_0_2.load.tFileList_1Process(load.java:4491) at datastrata.load_0_2.load.runJobInTOS(load.java:5722) at datastrata.load_0_2.load.main(load.java:5616) Caused by: java.net.SocketException: Broken pipe at java.net.SocketOutputStream.socketWrite0(Native Method) at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109) at java.net.SocketOutputStream.write(SocketOutputStream.java:153) at java.io.BufferedOutputStream.write(BufferedOutputStream.java:122) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2703) ... 13 more
View Replies !
A Tool That Can Compare Db Difference
I have a dev. database, and the real db. In the dev db I testing/developing all new things. I wanna ask that have the MYSQL some tool that can compare two databases (structures) to say what is the different. If it is not exists possible solution if I make two sql dump, and make a "diff" on it. But I wanna automatize it.
View Replies !
Code Coverage Tool
I am working on MySQL as well Oracle database. But I did not find any code coverage tool for mysql. In oracle, we use DBMS_PROFILER to get the code coverage. Is any similar tool available in MySQL or not?
View Replies !
|
TRACKER
