MySQL open source reporting services

When you say "reporting service" I suppose you mean "report programming and generating system." Is that right?

• Jasper - http://community.jaspersoft.com/

• BIRT - http://www.eclipse.org/birt/phoenix/

• Crystal Reports, if you can deal with an non-open-source system.

These all work fine with MySQL.

Unfortunately all these reporting systems are engaged in some ridiculous spin where they're telling themselves they are "business intelligence solutions" rather than report programming schemes. So, you'll do some digging through the marketing BS to find out solutions to simple problems like "how do I list sales of microbrew beer by zip code" or whatever you want to report about.

For MySQL reporting you could try one of the following. Unfortunately none of them are open source.

• Smart report maker

• MySQL Pivot table generator - recommended if you want to create analytical & summary reports

• Navicat - very powerful