×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Suggestions on MySQL Web Based Reporting Tools

Suggestions on MySQL Web Based Reporting Tools

Suggestions on MySQL Web Based Reporting Tools

(OP)
Hello All

I am leading a project to develop a web database using MySQL on Linux / Apache. For reporting, we would like to do it through an HTML page and give the user parameters to run the report. I would like to avoind hard coding the reports, if possible. I reviewed Crystal Reports, and they have a web reporting system, but it runs on NT.  Any suggestions would be greatly appreciated!

Thanks

Dave

RE: Suggestions on MySQL Web Based Reporting Tools

All of our web database reports are run through custom apps with PHP (which plays very well with MySQL).  You can write HTML forms where a user can enter in what parameters they wish to see.  A PHP script could then use those parameters to query the database .... compile the information ... and generate reports in HTML back to the users browser.  If you compile PHP with the GD library you can even create some nifty dynamic graphs to impress the suite and ties.  

http://www.php.net

I have use Crystal Reports for a lot of my MS SQL database reporting, and have been able to do everything (plus a whole lot more) in PHP that I could in CR.  

RE: Suggestions on MySQL Web Based Reporting Tools

If you need better control over layout for printing,  you could use the PHP extension for creating PDF documents. You could even have the server display the PDF document locally, but send the same PDF file to a printer on the server or on the network. See www.php.net/pdf.

Or... it wouldn't surprise me if there are some tools out there which can take XML data and turn it into a nicely formatted printed document. Then you can just output your report values embedded in whatever XML tags and properties the tool specifies. Right off the bat I can tell you that IE5+ has some very interesting capabilities to render XML with fine control over print kerning and layout.

Or, for the ultimate in nut-and-bolts method, you could read the specs for any of the open layout methods such as TEX (good for printing form Unix) or RTF (formats nicely in most wordprocessors such as Word, WprdPerfect, etc...). These formats are simply other markup languages, so you are just dealing with text to output from PHP.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close