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.