Page 1 of 1
How to create reports in PHP Application
Posted: Wed Feb 17, 2010 7:16 am
by anupkeskar
I have developed a Material Request Web application using PHP And MySQL.
Now i want to create various reports, Stock, In, Out Etc.
Is there any tool or method through which i can create web based reports to my application?
Please Help.
Thanks And Regards,
-Anup.
Re: How to create reports in PHP Application
Posted: Wed Feb 17, 2010 8:40 am
by emmbec
Take a look at Jasper Reports if you don't need to have the reports embedded into the website, or use OpenFlash Charts to create your reports, they are really nice

Re: How to create reports in PHP Application
Posted: Wed Feb 17, 2010 4:00 pm
by pickle
Moved thread.
Re: How to create reports in PHP Application
Posted: Wed Feb 17, 2010 7:40 pm
by josh
http://dev.mysql.com/doc/refman/5.0/en/ ... tions.html RTFM (not that you didn't, I just like saying that!). Pay particular attention to the functions on this page though

like SUM and COUNT and MAX, MIN, AVG.
Also I wrote a tool that deals with the problem of having to SUM *billions* of rows. It uses an algorithm to make that a little faster.
http://code.google.com/p/socks/
I would recommend just learning the mysql functions to start with. If you are looking to deal with scaling issues I would look into the stuff I am researching.