Reporting tool
Moderator: General Moderators
Reporting tool
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
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
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
Re: Reporting tool
What kind of reports?
Re: Reporting tool
Basically some simple analysis report (like revenue/month), invoices and items labels.
- lord_webby
- Forum Commoner
- Posts: 44
- Joined: Wed Aug 19, 2009 9:01 am
Re: Reporting tool
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
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
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
- lord_webby
- Forum Commoner
- Posts: 44
- Joined: Wed Aug 19, 2009 9:01 am
Re: Reporting tool
I don't know about anything specific for mysql but FPDFis a library that allows you to create custom pdf files.
Re: Reporting tool
WARNING: the DB is SQL SERVER and NOT mySQL ^_^
- lord_webby
- Forum Commoner
- Posts: 44
- Joined: Wed Aug 19, 2009 9:01 am
Re: Reporting tool
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.
I don't know about anything specific for sql but FPDFis a library that allows you to create custom pdf files.
Re: Reporting tool
I wanted just avoid misunderstandings ^^ not being rude. 
- lord_webby
- Forum Commoner
- Posts: 44
- Joined: Wed Aug 19, 2009 9:01 am
Re: Reporting tool
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
I will check it in the evening (at my GMT ^_^). I'll let you know
Re: Reporting tool
ok, probably FPDF will do the trick.
Great!
Thank U
Paolo
Great!
Thank U
Paolo
- lord_webby
- Forum Commoner
- Posts: 44
- Joined: Wed Aug 19, 2009 9:01 am
Re: Reporting tool
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.