Solved

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

Posted on 2004-03-20
1
254 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
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

713 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