Hi,
Is anybody using Jaspr reports for OTRS reporting? Jasper reports is an open source, Java based reporting toolset: http://jasperforge.org/sf/projects/jasperreports
I've heard of it... frankly, though, for reporting, and many simple apps, nothing beats CFML for productivity. I use the BlueDragon server for simple stuff like this.
But ColdFusion is payware, or is ther a free version you use? It would be nice to have a completely free stack.
The very useful feature would be that people can start contributing reports for other people to use,
A report repository would be awesome... but not everyone will want to use Jasper. So in addition to the product specific definition, Documenting the report/schema SQL used would be useful to post, too. That would permit easy migration to other reporting tools, and actually represents most of the development effort!
I completely agree, I'm guessing you are reading your mail bottom up (if sorted new to old :). You will see another mail from me asking people for their Real-Smart-SQL-Queries-For-Reports(tm). So if you have any, please share them :) I would be perfectly fine with documenting smart report queries and provide the Ireports implementation of them. If we build a nice set they could maybe go on the website (or I can host them somewhere).
Mike Morris
Bas (who now sees you read the digest, not the individual mails :)