Solved

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

Posted on 2004-03-20
1
255 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

734 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