[OT] Database reporting software

[Andy Todd]

Steve Horsley wrote:
> I have an existing system working on MS Access, and software that 
> regularly logs events into it (and deletes old events after a year).
> 
> Now need to move to real servers, probably Solaris though possibly 
> Linux. Modifying the software to update the database (maybe mySQL or 
> Oracle) contents is easy enough, but how do I produce reports 
> (statistics and summaries) on the database contents?
> 
> I could contemplate web based or application based report generation, 
> but are there easy to use draggy-droppy report designing applications 
> around? Just the names would enable me to look them up.
> 
> I am struggling with OpenOffice.org at the moment, trying to see if it 
> can do what I'm looking for, but it doesn't seem to be able to do GROUP 
> BY and SUM() - simple aggregation stuff.
> 
> All suggestions would be very welcome.
> 
> Steve

The only product I've used is Crystal reports. There is a cost factor 
involved but it is pointy clicky, supports 'proper' SQL like summing and 
group bys and isn't too expensive.

The product page is here : 
http://www.businessobjects.com/products/reporting/crystalreports/default.asp

Regards,
Andy
-- 
--------------------------------------------------------------------------------
 From the desk of Andrew J Todd esq - http://www.halfcooked.com/