Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2004-03-20
1
Medium Priority
?
262 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 375 total points
ID: 10643421
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

606 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