Crystal Reports or other graphing tools?

[Anon]

I need to create charts and graphs of data from a MySQL db. I was going to try using charts made within PHP, but has anyone used Crystal Reports to sit between their DB and their web pages?
What is the better option of these two methods? PHP charts would be free, but take time to develop, so how much work would it be in PHP, do tools already exist to make Pie/Bar charts, etc, and what do other people do?

Many thanks.

[Anon]

Crystal works good, is easy to learn, and will save you some time if you use it a lot. If all you need are a few graphs you might also get by with a spreadsheet.

[Anon]

Right, thanks.
I have found out some more about Crystal Reports - looks like it's Windows only, but it might be possible to set up scheduled actions that will get it to refresh web pages based on the db content.
The thing I like about PHP is it's live and dynamic, but if we can set Crystal Reports to update web charts without manual intervention then that is probably good enough.
My other option is something like jpgraph (www.aditus.nu) to create my own the long way.
Thanks again.