RE: Web-based reporting tool? (UNCLASSIFIED)

[Michael Mr NISO/Lockheed Martin Kidwell]

Classification:  UNCLASSIFIED 
Caveats: NONE

 
Well this is probably getting off topic, but I didn't start it ;). And I
know there's a lot of expertise on the list...

So, one of the items mentioned by Warrick dealt with 

 snip [ pre-defined reports (in which they may need to enter data, like
"Start Date" and "End
 Date") against their data.] end snip

We use php for this functionality, but it's kind of klugey (sp?) -- the user
has 6 pull down menus to deal with ( month, date, year, for both the start
and end dates).

Anybody know of a sexier way to implement this functionality?

Michael Kidwell


-----Original Message-----
From: Jeff [mailto:jsmforum@stripped] 
Sent: Thursday, September 22, 2005 1:56 PM
To: mysql@stripped
Subject: RE: Web-based reporting tool?

> -----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.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
Classification:  UNCLASSIFIED 
Caveats: NONE