Re: otrs Digest, Vol 44, Issue 18
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.
I just created my first (useless) report,
If you're looking for useless reports, I've got 'em by the truckload :-)
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,
Now I need to start looking at the otrs schema and build some real useful reports
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! Mike Morris The Music Place 1617 Willowhurst Avenue San Jose, CA 95125 (408) 445-ARTS (2787) ------------------------------------ Your Free Quote: A government big enough to give you everything you want is also big enough to take everything you have. - Gerald Ford ------------------------------------
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 :)
I do some querying to the mysql db using sunshine reports (eclipse plugin)
to get my formatting. Sunshinereports is like a sexy front end for
jasperReports.
Ireports sounds good to me for RDL's :)
-Andy
PS - I didn't think anyone used cold fusion anymore ;). Oh wait, what am I
saying, I'm still using Mod_perl.
On 3/8/07 2:29 PM, "Bas Rijniersce"
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 :) _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? => http://www.otrs.com/
--
Hi,
I do some querying to the mysql db using sunshine reports (eclipse plugin) to get my formatting. Sunshinereports is like a sexy front end for jasperReports.
Ireports sounds good to me for RDL's :)
RDL?? :-) Would you be willing to share your SQL queries as well?
-Andy
After preparing some of my queries, I actually started seeing if there was
any updated eclipse tools and I think I found one that looks really nice and
very portable - its called BIRT (http://www.eclipse.org/birt/phoenix/)
I'm quickly picking up on it!
On 3/8/07 3:06 PM, "Bas Rijniersce"
Hi,
I do some querying to the mysql db using sunshine reports (eclipse plugin) to get my formatting. Sunshinereports is like a sexy front end for jasperReports.
Ireports sounds good to me for RDL's :)
RDL?? :-)
Would you be willing to share your SQL queries as well?
-Andy
OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? => http://www.otrs.com/
--
Hi,
After preparing some of my queries, I actually started seeing if there was any updated eclipse tools and I think I found one that looks really nice and very portable - its called BIRT (http://www.eclipse.org/birt/phoenix/)
I'm quickly picking up on it!
Looking at the tutorial it's similar to iReports, not a surprise since they use the same underlying library. Again, the best thing would be to share queries so that people can build on those using their own tool. Bas
participants (3)
-
Andy Lubel -
Bas Rijniersce -
Mike Morris