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]
