Page 1 of 1
Reporting tool
Posted: Mon Aug 31, 2009 10:23 am
by PHPaolo
Hi! I'm (VERY) new to php and I'm having a little problem...
For a client of mine I've installed a web application in PHP based on a SQL Server 2005 Database.
Now I need a (possibly free) application/class to run and print some static reports.
No particular requirement except that I have to run the reports from a PHP page.
Any advice?
Thanks in advance
Paolo
Re: Reporting tool
Posted: Mon Aug 31, 2009 11:24 am
by John Cartwright
What kind of reports?
Re: Reporting tool
Posted: Tue Sep 01, 2009 2:41 am
by PHPaolo
Basically some simple analysis report (like revenue/month), invoices and items labels.
Re: Reporting tool
Posted: Tue Sep 01, 2009 3:29 am
by lord_webby
You're probably going to need to code those yourself to get exactly what you want. I'm guessing your database isn't set up for a particular web app?
Re: Reporting tool
Posted: Tue Sep 01, 2009 3:51 am
by PHPaolo
The DB is custom made for my web application and I have total control over it.
I know that I have to write the reports code, but I'm searching something to write the PDFs (for example) based on my queries (like I was used to do with ASP and Crystal Report)
Paolo
Re: Reporting tool
Posted: Tue Sep 01, 2009 3:54 am
by lord_webby
I don't know about anything specific for mysql but
FPDFis a library that allows you to create custom pdf files.
Re: Reporting tool
Posted: Tue Sep 01, 2009 4:24 am
by PHPaolo
WARNING: the DB is SQL SERVER and NOT mySQL ^_^
Re: Reporting tool
Posted: Tue Sep 01, 2009 4:29 am
by lord_webby
Sorry, my fault, let me correct that:
I don't know about anything specific for sql but FPDFis a library that allows you to create custom pdf files.
Re: Reporting tool
Posted: Tue Sep 01, 2009 4:43 am
by PHPaolo
I wanted just avoid misunderstandings ^^ not being rude.

Re: Reporting tool
Posted: Tue Sep 01, 2009 5:06 am
by lord_webby
No worries. Did you check out FDPF? I used it in one of my
recent sites for generating forms - you can design a pdf and then use it as a template and overlay your data on top.
Re: Reporting tool
Posted: Tue Sep 01, 2009 5:11 am
by PHPaolo
I will check it in the evening (at my GMT ^_^). I'll let you know
Re: Reporting tool
Posted: Tue Sep 01, 2009 8:33 am
by PHPaolo
ok, probably FPDF will do the trick.
Great!
Thank U
Paolo
Re: Reporting tool
Posted: Tue Sep 01, 2009 8:35 am
by lord_webby
No Problem. Thought I'd also mention: There's a class called FPDI somewhere which lets you create uneditable PDFs if you need the functionality.