Open source PHP reporting tool [closed]

Question

I am developing web based application, i need php reporting lib/class to make the job easy. I need PDF/Excel format. The report based on related db tables(member bills, member info) Is there any advanced open source solution ?

Thanks

Antiquity

@Fellow_StackOverflow, Please do not close questions related to software tools. Refer 3rd point in stackoverflow.com/faq! – Contractile

Answer 1

There are tons of reporting libraries, most of which create Xml or Csv. You would have to give more data about what kind of reporting you need for a recommendation. I haven't used PHPExcel yet, but it is the first attempt I have seen to actually create Excel documents rather than creating CSV's that will load in Excel. PDF creation is built into PHP with the PDF functions, and is fairly easy to do.

[UPDATE]

PHPExcel is archived now you can use PhpSpreadsheet instead.

Impetigo

PHPExcel is a great library which works as advertised. It does require php5.2.x with mbstrings, xmlwriter and zip extensions installed. It can read and output excel 97(xls) and excel 2007 files(xlsx). It can even use excels formulas to calculate a value. – Radiotelegraphy

PHPExcel is DEAD - github.com/PHPOffice/PHPExcel/blob/1.8/README.md – Ogdoad

Answer 2

A newer library that looks very promising is PHP Reports by jdorn on github.

This is unrelated to the older library by the same name hosted on Sourceforge.

Bess

This is nice library to use for mySQL reporting. – Automaton

@lolcode, I have been trying to get this up and running with my AppGini Application but i have hit a deadend. Would you please help me out. Av been using this AppGini Community Forum and Php Reports . The issue is getting the reports / list of reports to display on my Application. – Indiraindirect

Answer 3

A bit late, but you might want to check out RLib - works with PHP and MySQL and creates multiple different types - PDF, CSV, HTML etc.

http://rlib.sicompos.com/

Aurelia

Answer 4

Unfortunately I don't know of a decent reporting class in PHP.

Do you need a full reporting suite, or do you just need to be able to export data to the pdf and Excel file formats?

If you only need to create these kind of pages, the simplest solution would be to display the data you require and add CutePdf software which installs itself as a printer. Then you can print to pdf from the browser.

If you need to create pdf files on the server side, there is a pdf creation library in the Zend Framework. ZendFramework-1.8.1\library\Zend\Pdf

Spitfire

Answer 5

I recommend giving this PHP reporting library a try:

https://github.com/webuccinoco/sre-community

You can also download it via the following composer command:

composer create-project webuccinoco/sre-community

Wuhu