[U2] Report Generation
I have been asked to look into a report generation tool similar to Crystal Reports for multivalued databases. and MS SQL server databases. I've worked with BI Query before are you folks aware of other possible solutions. The user has asked for Ability to schedule queries to run at night Ability to automatically distribute reports. I think saving them in a shared area is good enough. Ability to generate charts as part of the scheduled run. Any ideas are appreciated. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Report Generation
MITS -Original Message- From: Charles_Shaffer charles_shaf...@ntn-bower.com To: u2-users u2-users@listserver.u2ug.org Sent: Thu, Jan 16, 2014 7:47 am Subject: [U2] Report Generation I have been asked to look into a report generation tool similar to Crystal Reports for multivalued databases. and MS SQL server databases. I've worked with BI Query before are you folks aware of other possible solutions. The user has asked for Ability to schedule queries to run at night Ability to automatically distribute reports. I think saving them in a shared area is good enough. Ability to generate charts as part of the scheduled run. Any ideas are appreciated. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Report Generation
Consider mvQuery, CoreVu (from Rocket). I have been dabbling with Kendo UI and ColdFusion. --Bill Consider also an HT -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Thursday, January 16, 2014 10:23 AM To: u2-users@listserver.u2ug.org Subject: [U2] Report Generation I have been asked to look into a report generation tool similar to Crystal Reports for multivalued databases. and MS SQL server databases. I've worked with BI Query before are you folks aware of other possible solutions. The user has asked for Ability to schedule queries to run at night Ability to automatically distribute reports. I think saving them in a shared area is good enough. Ability to generate charts as part of the scheduled run. Any ideas are appreciated. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Report Generation
On 16/01/14 15:23, charles_shaf...@ntn-bower.com wrote: Ability to automatically distribute reports. I think saving them in a shared area is good enough. Dunno. But if you're on Windows, install blat. Then, Windows or linux, you can have the script that runs them also mail them out. Quite possibly from inside U2 using a list stored in the database :-) Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Report Generation
For lightweight reports and dashboards, I use U2 - XML - PHP - JQuery. I've baked this into the Joomla Content Management system so that users on browsers, smart phones, tablets can access U2 data in responsive templates on any device. jQuery is fast and the sorting, filtering happens in the browser so there is no back and forth to the server. It's not a drill-down tool and is not the best choice for massive reports but deployment requires no special licensing and only a browser. With jQuery, we can show the data as grids, charts, and more and with Joomla CMS as the front-end, it's very easy to manage. I'm deploying customer invoices and statements using Joomla CMS with jQuery so that the statement and invoice body is fully filterable, sortable, and cleanly importable to office apps all in the browser. Bruce Decker http://www.bluepinc.com On 1/16/2014 10:28 AM, Bill Brutzman wrote: Consider mvQuery, CoreVu (from Rocket). I have been dabbling with Kendo UI and ColdFusion. --Bill Consider also an HT -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Thursday, January 16, 2014 10:23 AM To: u2-users@listserver.u2ug.org Subject: [U2] Report Generation I have been asked to look into a report generation tool similar to Crystal Reports for multivalued databases. and MS SQL server databases. I've worked with BI Query before are you folks aware of other possible solutions. The user has asked for Ability to schedule queries to run at night Ability to automatically distribute reports. I think saving them in a shared area is good enough. Ability to generate charts as part of the scheduled run. Any ideas are appreciated. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Report Generation
Entrinsik Informer does all of that and more. On 1/16/2014 10:23 AM, charles_shaf...@ntn-bower.com wrote: I have been asked to look into a report generation tool similar to Crystal Reports for multivalued databases. and MS SQL server databases. I've worked with BI Query before are you folks aware of other possible solutions. The user has asked for Ability to schedule queries to run at night Ability to automatically distribute reports. I think saving them in a shared area is good enough. Ability to generate charts as part of the scheduled run. Any ideas are appreciated. Charles Shaffer Senior Analyst NTN-Bower Corporation -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users