Hello Guys,

Could any of you recommend a free reporting tool for MySQL server databases? I would like to create a simple report for a database that contains one table with three fields. I googled' a few but they seem way to complex for what i am trying to achieve.

Please advise

Thanks!

This article should help: http://www.databasejournal.com/featu...ing-tools.html

A search for "mysql reports" will turn up much more.

Thank you for the link. I was actually looking for a recommendation; hoping someone here might now of tool to get the job done. Thanks! Downloaded and installed Navi but it crashes after start up. Thanks.

Well, can you tell us what you're trying to achieve?? Since we don't know, it's hard to guess. What kind of report are you wanting? What's your goal?

MySQL reporting could mean you want statistics on the MySQL system itself, or a report on the user-entered data into a table/tables ON the MySQL server. And what KIND of report? Excel/CSV? Graph? Presented via web, email?? How often is this report going to be run? Kind of an open ended question....

You could use the mysql command line and use the "--into-outfile" directive, fields separated by ",", enclosed by """, and type in your query, and get a CSV file from the data, suitable for import into Excel, where you can graph/sort yourself.

Provide details and we may be able to help.

Okay. MYSQL database contains a table with four fields ('ID', 'Name', 'Date' and 'Taken'). Every time a certain action occurs in my system, a shell script inserts data into those fields. I would like to use a tool such as 'Crystal Reports' but that I can install on my Raspberry pi or other linux system to connect to MYSQL database and create a report based on that table's data that would look like:

ID Name Date Taken
1 John 20160101 yes
1 John 20160102 no

Please advise

Thank you

Fairly simple time series in a mysql database?

Then why not use rrdtool? or even graphite?

try http://community.jaspersoft.com/proj...eport-designer

Thank you both for your responses. I found a good way of accomplish what I needed. Downloaded LibreBase, installed MySQL base plugin, connected to database and created simple report.

Attached Thumbnails

 

Good job, and well done!
Glad to have helped.

Thank you!