Compuit1
asked on
How to create report from MySQL
Hello - New area for me. I have a database running on a Centos (Linux) system using MySQL Workbench V 5.2.47.
What I wish to achieve is have a shortcut on the MySQL system's desktop that when launched it will prompt you to enter your search or query detail, say name, job and date range. When the OK button is clicked a report is generated on the screen showing the relevant data.
If the entry and report screens could be made pretty it it will be great. What tools are required for this please and any help would be well received?
What I wish to achieve is have a shortcut on the MySQL system's desktop that when launched it will prompt you to enter your search or query detail, say name, job and date range. When the OK button is clicked a report is generated on the screen showing the relevant data.
If the entry and report screens could be made pretty it it will be great. What tools are required for this please and any help would be well received?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
How could I achieve this from say a shortcut on the desktop instead of logging into MySQL and running the search tool? Can a few lines of code do it? If so could someone point me to an example please?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you want to connect to the MySQL server from Windows client and you don't want to install any tools then you can use Excel:
http://office.microsoft.com/en-ca/excel-help/connect-to-a-mysql-database-HA104019820.aspx
http://office.microsoft.com/en-ca/excel-help/connect-to-a-mysql-database-HA104019820.aspx
Excel is a great suggestion but unless we know exactly how your wanting to display and interact with the data these suggestions are futile.
"Excel is a great suggestion but unless we know exactly how your wanting to display and interact with the data these suggestions are futile."
:o) You mean "great but useless". Thanks. I could say about the same about your comment though, no offense intended.
Anyway, that's up to the asker to decide what' useless and what's not, isn't it?
:o) You mean "great but useless". Thanks. I could say about the same about your comment though, no offense intended.
Anyway, that's up to the asker to decide what' useless and what's not, isn't it?
No that's not what I'm saying at all. I was giving credit to your suggestion :)
However, I am making the point though that it still may not be suitable for what the OP wants to do. I could list "thousands" of ways to interface with a database but they're only useful if the asker can use it in their project. If we just keep throwing ideas with no feedback then it's just confusing. From their point of view they may have to test and research each idea we give them so could also end up a waste of time. So yes it is up to the asker to decide what's useless and what's not.
As for my comments above, hardly useless as I'm also questioning the asker as to their intentions with the data not just saying "use this".
However, I am making the point though that it still may not be suitable for what the OP wants to do. I could list "thousands" of ways to interface with a database but they're only useful if the asker can use it in their project. If we just keep throwing ideas with no feedback then it's just confusing. From their point of view they may have to test and research each idea we give them so could also end up a waste of time. So yes it is up to the asker to decide what's useless and what's not.
As for my comments above, hardly useless as I'm also questioning the asker as to their intentions with the data not just saying "use this".
Agreed, but one way of solving problems here IS to make suggestions and in many cases the asker will pick whichever suits him better without the need to study the whole history and the future of the problem. :o)
Cheers!
Cheers!
I agree! :)
This is in no way aimed at you but I think what's generally missing here at EE is helping the asker find the best solution. I see so may suggestions without probing the asker to find out what the asker is trying to achieve. You just caught a bit of my rant, that's all ;) The futile comment is aimed at all the suggestions, not just yours ;)
This is in no way aimed at you but I think what's generally missing here at EE is helping the asker find the best solution. I see so may suggestions without probing the asker to find out what the asker is trying to achieve. You just caught a bit of my rant, that's all ;) The futile comment is aimed at all the suggestions, not just yours ;)
ASKER
Hello thanks for the feedback - just quickly the time frame in which I needed help has passed but in the end I was thinking of DataVision and Crystal reports. We were in a rush to get something in place and due to time constraints I found and put together some SQL queries for the user and saved them as snippets in the user's MySQL Workbench console. Now this met the immediate requirement to quickly query and retrieve result on the screen for given search criteria albeit not the best. Then there is a feature to saving the report data to disk in My Workbench which worked as well for their needs.
Now I will look at what has been given as a solution and allocate according but just at the moment I do not have time.... "I will be back".
Now I will look at what has been given as a solution and allocate according but just at the moment I do not have time.... "I will be back".
Thanks for posting back. Given your are considering Crystal reports, I'd like to make another recommendation on a business intelligence (BI) tool that it's far easier to use. Qlikview, check it out. www.qlikview.com
FYI - Crystal only runs in Windows. There is a way to run a viewer in Linux but the report has to be developed and I believe saved with data on a Windows machine
mlmcc
mlmcc
ASKER
Hello - Thank you... Yes the solution would be either jasper or pentaho. I also like Datavision and believe it will be fit for purpose. The solution needed to be opensource based and reporting a key criteria. Qlikview really good but appears to be Windows based.
Thanks again, I spread the points.
Thanks again, I spread the points.
Thanks for the points. The server version of Qlikview is windows based but overkill for a lot of us. I've been able to get away with just the client version for my users.
Qlikview seems to be free only for individual use.
Would that cover several users in the same company using company data?
Would that cover several users in the same company using company data?
The free version has too many restrictions to be useful.
The paid client version works much like excel in that it can connect to virtually any data source (via odbc) and can be saved as a file .qvw that other users can access and open
The paid client version works much like excel in that it can connect to virtually any data source (via odbc) and can be saved as a file .qvw that other users can access and open
Any comment/experience about Talend Studio
http://www.talend.com/products/talend-open-studio ?
http://www.talend.com/products/talend-open-studio ?
ASKER
Using the search tools that come with phpMyAdmin I can pull the query data .... How do i put that query into a script that will prompt for a date or name etc if run / launched. Sorry have little knowledge on this topic...
sample-data.png