Solved

Need recommendations on a server based (GUI) Reporting Engine for MySQL

Posted on 2004-03-20
1
252 Views
Last Modified: 2012-05-04
I own and help run a number of small businesses that have reporting needs that exceed our IT resources.

Most of our business is conducted through our websites.  We're using a leased, dedicated server in a LAMP (Linux, Apache, MySQL, Perl/PHP) environment.
 
Currently, instead of having our programmers design an endless number of customized reports, I'm running  a variety of macros overnight on my local machine that distribute reports via email.  I have an ODBC connection to various MySQL databases and have designed the queries and reports in MS Access.
 
As our reporting needs continue to grow, we're very interested in a program that would allow non-technical owners and employees to create reports on the fly using a GUI drop and drag interface (that contained the same type of features as Access including "sum", "count" etc.)  The product would also need to allow non-technical people (or maybe half-technical people such as myself) to create the queries underlying the reports without having to know all the proper sql query syntax.
 
Looking for suggestions/recommendations.
0
Comment
Question by:RBielecki
1 Comment
 
LVL 9

Accepted Solution

by:
gtkfreak earned 125 total points
Comment Utility
Check out datavision on Sourceforge. Works with Java.

Also check out RLIB at http://rlib.sicompos.com/

Also, check out the one below Agata Reports.
http://www.agata.org.br/us/index.php
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost every time LOAD DATA INFILE comes to the rescue. Here we will try to understand some of the very common scenarios for loading data …
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now