mySQL Database Reporting Tools

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
NotOnUrNelly
Forum Commoner
Posts: 61
Joined: Wed Mar 24, 2004 4:45 pm

mySQL Database Reporting Tools

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

I often use a PDF library to generate my own reports such as ezpdf or fpdf.
NotOnUrNelly
Forum Commoner
Posts: 61
Joined: Wed Mar 24, 2004 4:45 pm

Post by NotOnUrNelly »

Many Thanks for your reply,

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

Thanks
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

It would be run through a script parsed by PHP that is connecting to MySQL.
NotOnUrNelly
Forum Commoner
Posts: 61
Joined: Wed Mar 24, 2004 4:45 pm

Post by NotOnUrNelly »

Aha, Found some info of fphp, I begin reading this.

Can you generate charts using this?

Thanks

Jamie
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

I don't see why not.
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Post by onion2k »

If you're really awesome (like me) you can generate charts using GD and embed them in a PDF created with fpdf.
NotOnUrNelly
Forum Commoner
Posts: 61
Joined: Wed Mar 24, 2004 4:45 pm

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

jpgraph has been cited previously.
Post Reply