List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:September 17 2007 7:46pm
Subject:Re: Generating reports/exporting data?
View as plain text  
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 <daevid@stripped> 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:chombee@stripped]
> > Sent: Monday, September 17, 2007 8:29 AM
> > To: mysql@stripped
> > 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/mysql?unsub=1
> >
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


-- 
 - michael dykman
 - mdykman@stripped

 - All models are wrong.  Some models are useful.
Thread
Generating reports/exporting data?chombee17 Sep
  • RE: Generating reports/exporting data?Daevid Vincent17 Sep
    • Re: Generating reports/exporting data?Michael Dykman17 Sep