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:[EMAIL PROTECTED] Sent: Thursday, September 22, 2005 1:56 PM To: mysql@lists.mysql.com Subject: RE: Web-based reporting tool? > -----Original Message----- > From: Warrick Wilson [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 22, 2005 12:09 > To: mysql@lists.mysql.com > 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/[EMAIL PROTECTED] Classification: UNCLASSIFIED Caveats: NONE -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]