SOURCE: http://www.avidtrader.com/wordpress/wp-content/uploads/2013/01/reports.jpg

Recently I was involved in developing a registration site for SLUG (Sri Lankan University Games) 2013 [1] where we wanted to produce several reports at the end.Thanks to Mr. Samudaya Nanayakkara [2], I came across PHP Report Maker 6 [3], 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
It is possible to create several reports with different fields and filters from the same view. Apart from that it is possible to make a table, view as a report as well.

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.

More info

video tutorial : http://www.youtube.com/watch?v=5xcQrKOv2oo
online demo : http://www.hkvstore.com/phpreportmaker/demo.asp


Reference
[1] http://www.slug2013.moraspirit.com/
[2] http://samudayan.blogspot.com/
[3] http://www.hkvstore.com/phpreportmaker/
0

Add a comment

About Me
About Me
Subscribe
Subscribe
Popular Posts
Popular Posts
  • "The Snare is a poem which evokes positive attitudes within the reader." (1) Which kind of attitudes are evoked? (2) Show them wit...
  • "Island Spell" by Wendy Whatmore vividly describes a beautiful island. The starts her poem saying that she was caught in an island...
  • Try configuring your SLT ADSL connection yourself. Don't WASTE money for SLT . Here are the settings. Type : PPP...
  • To use java tools (javac, java, applet viewer etc.) from anywhere in the dos prompt java should be configured. Suppose that you have already...
  • A late announcement, a little more than 2 years, I moved to Medium. I won't be making any new posts here in this blog. Please refer/foll...
  • SOURCE: http://www.avidtrader.com/wordpress/wp-content/uploads/2013/01/reports.jpg Recently I was involved in developing a registration...
  • Welcome to WSO2 Application Server 6.0.0, the successor of WSO2 Carbon based Application Server. WSO2 Application Server 6.0.0 is a complet...
  • I recently came across this requirement where a  xsd:datetime  in the payload is needed to be converted to a different date time format as ...
  • Dialog GSM offers its latest service,Budget SMS, to both post paid and pre paid customers. With this service you will be able to send D2D SM...
  • Photo Credit : Prima Yogi FAD Singapore 2015 was held on 5th and 6th of December in Singapore and I participated at the event. FAD (F...
Labels
My Links
Loading