Reporting tool

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
PHPaolo
Forum Newbie
Posts: 11
Joined: Mon Aug 31, 2009 10:21 am

Reporting tool

Post 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
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Re: Reporting tool

Post by John Cartwright »

What kind of reports?
PHPaolo
Forum Newbie
Posts: 11
Joined: Mon Aug 31, 2009 10:21 am

Re: Reporting tool

Post by PHPaolo »

Basically some simple analysis report (like revenue/month), invoices and items labels.
User avatar
lord_webby
Forum Commoner
Posts: 44
Joined: Wed Aug 19, 2009 9:01 am

Re: Reporting tool

Post 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?
PHPaolo
Forum Newbie
Posts: 11
Joined: Mon Aug 31, 2009 10:21 am

Re: Reporting tool

Post 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
User avatar
lord_webby
Forum Commoner
Posts: 44
Joined: Wed Aug 19, 2009 9:01 am

Re: Reporting tool

Post by lord_webby »

I don't know about anything specific for mysql but FPDFis a library that allows you to create custom pdf files.
PHPaolo
Forum Newbie
Posts: 11
Joined: Mon Aug 31, 2009 10:21 am

Re: Reporting tool

Post by PHPaolo »

WARNING: the DB is SQL SERVER and NOT mySQL ^_^
User avatar
lord_webby
Forum Commoner
Posts: 44
Joined: Wed Aug 19, 2009 9:01 am

Re: Reporting tool

Post 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.
PHPaolo
Forum Newbie
Posts: 11
Joined: Mon Aug 31, 2009 10:21 am

Re: Reporting tool

Post by PHPaolo »

I wanted just avoid misunderstandings ^^ not being rude. :)
User avatar
lord_webby
Forum Commoner
Posts: 44
Joined: Wed Aug 19, 2009 9:01 am

Re: Reporting tool

Post 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.
PHPaolo
Forum Newbie
Posts: 11
Joined: Mon Aug 31, 2009 10:21 am

Re: Reporting tool

Post by PHPaolo »

I will check it in the evening (at my GMT ^_^). I'll let you know
PHPaolo
Forum Newbie
Posts: 11
Joined: Mon Aug 31, 2009 10:21 am

Re: Reporting tool

Post by PHPaolo »

ok, probably FPDF will do the trick.
Great!
Thank U

Paolo
User avatar
lord_webby
Forum Commoner
Posts: 44
Joined: Wed Aug 19, 2009 9:01 am

Re: Reporting tool

Post 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.
Post Reply