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.