views:

5526

answers:

4

Hi All

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

A: 

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

Jon Winstanley
+1  A: 

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.

Kris Erickson
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.
txyoji
A: 

I Think PHP Report Maker is ther best php Reporting Tool's but it is not free or open source.

Nayan Paul
+1  A: 

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/

Jim Nickel