Re: [otrs] Re: otrs Digest, Vol 44, Issue 18
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 [EMAIL PROTECTED] wrote: 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/ -- ___ 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/
[otrs] 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 ___ 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/
Re: [otrs] Re: otrs Digest, Vol 44, Issue 18
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 [EMAIL PROTECTED] wrote: 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/ -- ___ 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/
RE: [otrs] Re: otrs Digest, Vol 44, Issue 18
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/