php reporting tools

Question

I have been developing with PHP for over ten years (since PHP version 3) and have used many different programming languages.

But I have never seen any PHP reporting tools. I am looking for something similar to

Jasper Reports
Crystal Reports
Fast Report
Quick Report
Report Builder

I am not looking for:

FPDF
PHPExcel
TCPDF

There must be a report designer and report library.

Has anyone seen PHP reporting tools comparable to those I mentioned?

@Starx programming language for report creating engine language must be php. there is solution using jasper report with java bridge. but its not php solution. its java solution — sdemirkeser, Mar 10 '12 at 15:39
TCPDF is just great it needs some time to learn but does great results — Ahmed D. Sherif, Oct 09 '12 at 06:19

score 12 · Answer 1 · answered Nov 05 '13 at 03:38

12

You should check out Php Reports http://jdorn.github.io/php-reports/

Pros:

Display reports as HTML tables
Add charts/graphs to accompany reports
Export reports to CSV, XLS, JSON, XML, etc.
Add parameters to reports (e.g. date range)
Find reports by browsing or searching.
Looks really nice.

Cons:

No report designer, reports are just SQL files with comments for meta information
No user management or access control
No email scheduling of reports (coming soon)

I looked into all the existing solutions for PHP before writing the Php Reports framework. Everything out there was ugly, unmaintained, not flexible enough, and/or hard to set up and use.

answered Nov 05 '13 at 03:38

jdorn

153
1
5

No report designer is really a no go for most people – spiritoo Jan 14 '15 at 16:30
I don't think there's support for PostgreSQL, yet. Please confirm. – Susheel Javadi Mar 11 '15 at 09:33
@jdorn hey mate does this php reports supports connection to the Oracle SQL Database? – Luqman Nov 05 '15 at 10:58

score 9 · Answer 2 · edited May 23 '17 at 11:55

9

Well, judging by your example, you are looking for tools to represent the data. So, here are few you might like

Check this question to use Crystal Reports with php.

edited May 23 '17 at 11:55

Community

1
1

answered Mar 10 '12 at 13:04

Starx

77,474
47
185
261

@markus-tharkun, May be he didn't have any reason. – Starx Mar 10 '12 at 13:20
Every downvote has a reason, even if he's a spastic and didn't actually want to downvote ;). – markus Mar 10 '12 at 13:22
@Starx i am looking for engine is only php platform solution. If not i could used jasper report with javabridge. but if i do this user must be install java environment and other thing to run report platform – sdemirkeser Mar 12 '12 at 06:32
@sdemirkeser, Mysql Reports is PHP Platform solution. Haven't you checked my list? – Starx Mar 12 '12 at 06:34
@Starx all looked up all your list before. they are not report engine. i am looking for report engine and editor. If you checked my list such as Jasper Report or Crystal Report you could understand what i need – sdemirkeser Mar 16 '12 at 16:04

score 6 · Answer 3 · answered Dec 16 '13 at 08:09

6

Reportico looks promising. Also it has an extension for Yii making it my favourite.

http://www.reportico.org/site/index.php

answered Dec 16 '13 at 08:09

mccbala

183
1
7

score 2 · Answer 4 · answered Sep 19 '13 at 11:15

2

This project exist for long time. I create all my project using this. http://www.simitgroup.com/?q=PHPJasperXML

answered Sep 19 '13 at 11:15

kstan

21
1

score 1 · Answer 5 · edited May 23 '17 at 12:34

I haven't been a PHP dev for so long :P but I ran into the same issue. So I developed a solution that is comparable with Report Builder. It integrates several technologies (ApacheFOP, XSLT, XSLFO, MS Word, PHP, Doctrine 1.2) but provides a pure PHP API.

Take a look and count with my help if needed. https://github.com/juanmf/sfPlugins/tree/master/reportPlugin

Currently its a symfony plugin, but I'll decouple it.

Its similar to ReportBuilder in that you use Word as designer for report templates, where you must consider the data source structure (XML) to create the data placeholders. Also if you get your data in an array, then you can convert it into XML directly with utils methods. I explain a bit in this similar post: https://stackoverflow.com/questions/5519024/report-engine-solution-for-lamp-application#13042656

score 0 · Answer 6 · edited Oct 04 '15 at 08:01

0

you can integrate PHP with Java and to use JasperReports with iReport as an IDE :).

I've developed a library this is the link https://github.com/FraGoTe/JasperPHPlibrary

Best regards.

edited Oct 04 '15 at 08:01

UnderDog

305
1
4
14

answered Jul 13 '13 at 16:18

Francis Gonzales

486
7
21

php reporting tools

6 Answers6

Linked