Dynamic PHP/HTML reports

[fnbcprog]

I am writing a fairly complicated application in typical LAMP architecture. The program also utilizes AJAX throughout with the SAJAX package.

What I was wondering is if anyone had any suggestions as to reporting in the application. I think there are basically two options.

1. Write a PHP script for every single report.
2. Write a sub-application to work with MySQL and report dynamically without a separate script for each report.

Any ideas or suggestions are very appreciated!!!

Thanks,

Brian