Page 1 of 1

mySQL Database Reporting Tools

Posted: Thu Feb 15, 2007 7:12 am
by NotOnUrNelly
Hi All,

I am interested in generating reports directly from the mySQL database that supports my php site. I originally started to generate the web pages with reports in mind, but this method falls short when it reaches the bottom of the page and images a split over two pages in some instances.

Is there a reporting tool that can be linked to mySQL databases that can produce reports when viewed from a web page. Im guessing Crystal reports or something like can be used in these instances.

I am familar with creating reports in Access using grouping and filtering from queries etc. I'm guessing crystal reports or an alternative works on a similar basis.

Any guidance or direction to software available would be great. I may need to plot graphs

Many Thanks
Jamie

Posted: Thu Feb 15, 2007 7:24 am
by feyd
I often use a PDF library to generate my own reports such as ezpdf or fpdf.

Posted: Thu Feb 15, 2007 7:42 am
by NotOnUrNelly
Many Thanks for your reply,

Can this be connected directly to the mySQL database. Im just googling information on this software

Thanks

Posted: Thu Feb 15, 2007 7:50 am
by feyd
It would be run through a script parsed by PHP that is connecting to MySQL.

Posted: Thu Feb 15, 2007 7:56 am
by NotOnUrNelly
Aha, Found some info of fphp, I begin reading this.

Can you generate charts using this?

Thanks

Jamie

Posted: Thu Feb 15, 2007 8:09 am
by feyd
I don't see why not.

Posted: Thu Feb 15, 2007 3:17 pm
by onion2k
If you're really awesome (like me) you can generate charts using GD and embed them in a PDF created with fpdf.

Posted: Thu Feb 15, 2007 4:19 pm
by NotOnUrNelly
I'm not really that hot to be honest,

Can you offer any guidance, also any guidance on fpdf would be great also.

Are there any off the shelf packages I could use?

Many Thanks
Jamie

Posted: Thu Feb 15, 2007 4:51 pm
by feyd
jpgraph has been cited previously.