Recently I was involved in developing a registration site for SLUG (Sri Lankan University Games) 2013  where we wanted to produce several reports at the end.Thanks to Mr. Samudaya Nanayakkara , I came across PHP Report Maker 6 , a php dynamic web report generator with data sources MySQL, PostgreSQL, Microsoft Access, Microsoft SQL Server and Oracle for the moment. In my case it was with MySQL.
The basic steps would be,
- Connect to the database
- Create a view
- Create a report
PHP Report Maker supports extended filters, which comes in handy in filtering report data. The filters can be configured simply to result in a complex functionality.
Stuff that didn't work in localhost
I created several extended filters for the reports and I configured them to have 'SELECT-ONE' type, that is the drop down. But in the browser, the drop down was not fed with the distinct values of the relevant field, is was left with only 'Please select'. The issue was not there when I moved the files to the server :-)
Moving reports to the server, pay attention
There are views created in the database server in the process of creating the reports. They need to be formed in the server, a mysql dump and restore would do.
Next is the database info in the server. If they differ from those in your localhost, modify them. They can be found in ewrcfg6.php in phprptinc in your report out put directory.
In my case all the table names were in lower case in the mysql dump of views where as in the saver they were in camel case. Grep and sed can be used to replace them accordingly.
video tutorial : http://www.youtube.com/watch?v=5xcQrKOv2oo
online demo : http://www.hkvstore.com/phpreportmaker/demo.asp