Database Reports Without Programming?

[janeinpa]

I am a web designer, working with an e-commerce site. For the first time I think I've managed to to use OsCommerce to get PayPal IPN to pass information to our mySQL database on the host server. I'm not a programmer, so here's my question:

Is there software available that will let me generate reports from the database without programming? Nothing fancy. My client would like to see her monthly sales, for example, or which customers are buying a certain product, etc. Can these reports be output in html so she can see them in a browser? I hope you can help me with this. Thank you.

[jpf]

Short answer:

Crystal Reports (Windows Based)

I use this on MySQL databases just fine for creating simple lookup to VERY complex reports. Programing not required!! However not free.

I use Crystal Report Advanced & Crystal Enterprise ver 9.2&10 with WEB reporting. Using Windows based MySQL 2.5.0 driver works best.