List:General Discussion« Previous MessageNext Message »
From:Jeff Date:September 22 2005 5:55pm
Subject:RE: Web-based reporting tool?
View as plain text  
> -----Original Message-----
> From: Warrick Wilson [mailto:warrickw@stripped] 
> Sent: Thursday, September 22, 2005 12:09
> To: mysql@stripped
> Subject: Web-based reporting tool?
> This seems to be a common question, but answers aren't that common...
> What are people using as a web-based reporting tool? I'd like 
> to add a 
> user-facing interface to allow users to run pre-defined 
> reports (in which 
> they may need to enter data, like "Start Date" and "End 
> Date") against their 
> data.
> I've done a bunch of Google searching, and there's always 
> Crystal Reports. 
> That is cost-prohibitive currently, though I was discussing 
> this with them. 
> However, there are issues where we may want to split our 
> current database 
> server into a larger number of servers, and then the license 
> issues crop up 
> again.
> What else is good and reliable? I'm looking at QLR Manager, 
> looked at Agata, 
> downloaded a number of other programs to find out they are 
> intended for 
> running on the desktop (as opposed to being a web-based app). 
> I'm not overly 
> concerned with language, either, although the database server 
> is currently a 
> Windows box. I'm using PHP for some stuff, but could run 
> Java, etc. if 
> needed for the right software.
> Thanks. 

If they're pre defined reports that just require date ranges or simple
arguments then why not simply build a php website that 
Has a these reports on them.  You can use simple forms to collect the
criteria from the user and then generate the report.
I use this extensively in my company for distributing information.  No
licensing to worry about and and exporting the reports to a 
Spreadsheet with a "download" button is fairly easy as well.

Web-based reporting tool?Warrick Wilson22 Sep
  • RE: Web-based reporting tool?Jeff22 Sep
  • RE: Web-based reporting tool?Wiebe de Jong22 Sep
RE: Web-based reporting tool?andy.lawton25 Sep