A Free PHP Report Creator

Have you looked into Jasper Reports? While the actual tool is written in Java, it is a very powerful tool that should provide most anything you need from a MySQL (or most any DB available on Linux - it uses the JDBC interface) reporting tool ... it's available both in Open Source as well as commercially supported versions ... plus lots of docs, samples and even books are available ...

I  choose to develop my own reporting view using  HTML based CSS styles + Custom libraries for generating CSV, XLS, PDF  ... You can try this way for your own reports.

Also, you could check out these reporting tools

1)  BIRT - http://eclipse.org/birt/phoenix/deploy/usingPHP.php
http://www.theserverside.com/news/1363642/Intergrating-BIRT-with-PHP

I have used this for JSP/JAVA application.

2) Jasper reports
http://www.simit.com.my/?q=node/14

I have used this for JSP/JAVA application.

I don't know Jasper, but if you make a Google search for "php mysql report generator" you will get many good results including some that are open-sourced.

This answer might be useful.
http://stackoverflow.com/questions/747103/something-like-crystal-reports-for-php

And I believe that Crystal Reports has a COM interface, so you might be able to use that, too.