Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2004-03-20
1
Medium Priority
?
257 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 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

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…
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
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…
Suggested Courses

688 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