In a windows environment I use Cognose to write reports for MSSQL based databases.

Does anyone have a good PHP solution for pulling and manipulating data in a report format on MySQL?

I am looking for something that I can roll out to specific people on our staff so they can write their own reports and maybe even do some automation like sending a weekly report out via email.

Open Source is always good.

try this out http://hkvstore.com/phpreportmaker/

very cool, thanks