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 8)

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.