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.
How to create reports in PHP Application
Moderator: General Moderators
-
anupkeskar
- Forum Newbie
- Posts: 1
- Joined: Wed Feb 17, 2010 7:12 am
Re: How to create reports in PHP Application
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
Moved thread.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
Re: How to create reports in PHP Application
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.
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.