Jasper does have a commercial offering, but it is still an open source
project.. (readers of this list may be familiar with the arrangement)
I'm not sure what license they are using these days (used to be GPL)
but the web site is a little counter-intuitive.
- michael
On 9/17/07, Daevid Vincent [EMAIL PROTECTED] wrote:
It's not free in that you have to buy the product, but it is free in
that you make ONE report and get multiple export modules that you don't have
to write yourself. That alone is awesome!
http://www.jaspersoft.com
:)
-Original Message-
From: chombee [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 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 to a file. Or I have a query that runs
over one row of a table by specifying a specific primary key value in
the query and I want to run it on each row of the table by
incrementing
the primary key and then compute totals and averages on the
results. In
general I want to be able to run lots of queries, do simple
calculations
on their results, and display all these results alongside
each other in
one file.
I'm aware that the mysql client can run in batch mode and has HTML and
XML output options, but this is a little too simple for what I want.
Currently I'm using Python's MySQLdb module and rolling my
own scripts,
but I was hoping there would be something a little faster. I started
writing Python scripts to take user input from the keyboard
and pass it
to mysql, but then I discovered mysqlimport which was much quicker, so
I'm hoping something similar exists for outputting reports.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
- michael dykman
- [EMAIL PROTECTED]
- All models are wrong. Some models are useful.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]