Hi all. Just to clarify some points, Actuate is a major company in Enterprise Reporting and Performance Management Applications was the initiator and original code supplier of the BIRT (Business Inteligens and Reporting Tool) project for Eclipse Foundation. Eclipse itself is a major Open Source undertaking to produce an open source extensible development platform and application framework. Since it is heavily financed by some big firm the development and releases are on schedule like the Callisto release this June.
http://www.eclipse.org/org/press-release/20060626callisto.php So BIRT is a bona fide open source software. (Actuate announced latelly though that they will integrate BIRT into their next generation product line.) I have to agree with Reinier that the question here is Tomcat or no Tomcat. Using Appache and Tocat on one server can be a problem. But BIRT is a well developed product with very good backup both in development and maintenance. As you all know PHP can call Java classes so BIRT can be called from PHP directly, but this involves some coding into Eclipse sever and this creates problem at updates etc. We experimented both but the Tomcat way seemed the easier. Rp >Hello all, > >All "third party" reporting tools having following requirements: >-> Should be a tool that should connect more than one data sources >-> Should not only report in tables, there should be diagramms, bars etc. >-> Havin an own API to cover own requirements (add own features) > >There was an article in an computer literature here in Germany, in the IX >July are following systems are listened: > >Open source: >ACURATE BIRD/BIRT -> www.actuate.com/birt (Developer: Acurate/Eqlipse) > -> OS: Windows / Linux > >Reporting tools without any informatins about licencing or costs (But might >have, I´m sure about that): >ACURATE 8 -> www.actuate.com > -> Windows, Solaris, AIX, HP/UX, Linux >REPORT BUILDER -> www.guptaworldwide.com > -> OS: Windows / Linux >SAS ENTERPRISE BUSINESS INELLIGENCE SERVER -> www.sas.de > -> OS: for the server: Linux 32Bit/Itanum, AIX, HP-UX, >Itanium/PA-RISC, OpenVMS, OS/390... >CRYSTAL REPORTS -> www.businessobjects.de > -> OS: Windows 2000 and newer (no linux) >COGNOS 8 BUSINESS INTELLIGENCE -> www.cognos.com > -> Windows, HP-UX, AIX, Solaris, Linux >LIST&LABEL -> www.combit.com > -> Windows (95,98+,ME,NT4,2000,2003,XP) >QUICKVIEW -> www.quicktech.de > -> Windows 32 Bit and Itanium >MICROSTRATEGY 8 -> www.microstrategy.de > -> Windows 32Bit, AIX, Solaris, HP-UX, RedHat Linux >WEBFOCUS -> www.infromationsbuilder.de > -> MVS, iSeries, Unix, Linux, Windows > >All in all, most of these people who should make reports don´t have an linux >system as workstation. There could be now two strategies: Implement on the >server an reporting module or an third-party product what makes reports to >the client´s browser, or installing an reporting tool on the windows client >what connect the servers database and building reports. > >But all these products having no idea about medical reports. These are >standardized products and must be also customized that it can be fit. So >there is now the question if it is so an worse idea that there are common >medical reports what covers the requirement of an hospital should be >developed as a module. > >Robert > > > > > > > >>-----Ursprüngliche Nachricht----- >>Von: [EMAIL PROTECTED] >>[mailto:[EMAIL PROTECTED] Im >>Auftrag von Ruzicska Péter >>Gesendet: Mittwoch, 28. Juni 2006 09:05 >>An: care2002-developers@lists.sourceforge.net >>Betreff: Re: [Care2002-developers] Summary Report Feature ! >> >>Hi everibody, >>For the integration of BIRT with PHP see the manual here >>http://www.eclipse.org/birt/phoenix/deploy/usingPHP.php >> >>Peter >> >> >> >>>Hi, >>> >>>It's great that there is discussion started about reporting tool. >>> >>>There should be many solution that would fit to care2x. As a >>> >>> >>guideline >> >> >>>I would recommend to search for one with gpl-compatible license and >>>compatible with php 4/5. This way it can be integrated in the user >>>interface in care2x as new module or part of the existing modules. >>> >>>About Eclipse-BIRT: isn't this plugins that extends the Eclipse >>>platform? These means that if somebody needs the reports it have to >>>start this Eclipse-extended application. I see the reporting >>> >>> >>tool not >> >> >>>as a separate application, but as part of the current care2x user >>>interface. But nevertheless, whatever you decide will be better than >>>the current situation. >>> >>>About the question who should do this: I see there are many >>> >>> >>interested >> >> >>>people. I recommend that you proceed discussing this, come >>> >>> >>to a common >> >> >>>understanding and idea for solution and then organise yourselves to >>>implement this. You can use the care2x wiki to log your progress and >>>discussions for this feature. >>> >>>Greetings >>>Kaloyan >>> >>>On Thu, 2006-06-22 at 16:22 +0300, Reinier Battenberg wrote: >>> >>> >>> >>> >>>>Great, when will you be finished? :-)) >>>> >>>>no kidding, good suggestion. Are there more people who know >>>> >>>> >>a platform >> >> >>>>and who have experience with it? >>>> >>>>Are there people who are willing to see if they could build >>>> >>>> >>an alpha >> >> >>>>version for care2x using any of the proposed platforms? >>>> >>>>rgds, >>>>reinier >>>> >>>>Ruzicska Péter wrote: >>>> >>>> >>>> >>>> >>>>>Hi Everybody, >>>>>I agree Care2x needs a reporting tool so please check on >>>>> >>>>> >>the Eclipse >> >> >>>>>foundation BIRT tool http://www.eclipse.org/birt/phoenix/ >>>>> >>>>> >>. We have >> >> >>>>>hand on experience with it and found it to be just exactly >>>>> >>>>> >>what they >> >> >>>>>say it is. BIRT is an open source, Eclipse-based reporting system >>>>>that integrates with your application to produce >>>>> >>>>> >>compelling reports >> >> >>>>>for both web and PDF. >>>>>I can highly recommend it and it is easy to integrate. >>>>>Peter Ruzicska >>>>>[EMAIL PROTECTED] írta: >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>>>Hi Everybody, >>>>>> >>>>>>The easy-to-use reportin tool is one of the most important things >>>>>>that is missing in Care2x. We are also making the routine >>>>>> >>>>>> >>reports, >> >> >>>>>>and also hope that DHIS will be integrated to Care2x as >>>>>> >>>>>> >>an advanced >> >> >>>>>>analysing and reporting tool. >>>>>>But the ideal would be to have a flexible userfriendly >>>>>> >>>>>> >>module within >> >> >>>>>>the main branch for this task. I hope software developers >>>>>> >>>>>> >>would find >> >> >>>>>>an open source solution for this. The Italina Olympic >>>>>> >>>>>> >>committee has >> >> >>>>>>a reporting tool which is quite flexible, could it be >>>>>> >>>>>> >>used as a base to further develop. >> >> >>>>>>Mauri Niemi >>>>>> >>>>>>On 21 Jun 2006 at 18:28, Reinier Battenberg wrote: >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>>>Hi, >>>>>>> >>>>>>>I think everybody who installs care2x sooner or later will need >>>>>>>some sort of reporting. Yet, there is no reporting mechanism in >>>>>>>care2x. Everybody is programmatically building his or her own >>>>>>>reports, probably some reports are or will be almost the same. >>>>>>>(raise your finger if you have Registrations per Month reports) >>>>>>> >>>>>>>Now, if there would be one reporting engine in (or >>>>>>> >>>>>>> >>besides) care2x >> >> >>>>>>>which would be able to generate reports. What would the >>>>>>> >>>>>>> >>requirements of such a piece of software be? >> >> >>>>>>>Just to start that thread off, some ideas: >>>>>>> >>>>>>>- It should be able to generate reports in different >>>>>>> >>>>>>> >>formats: html, >> >> >>>>>>>pdf, xml, csv, tab delimited >>>>>>>- It should be templatable, so you can re-use the formatting in >>>>>>>different reports >>>>>>>- It should be able to produce 'Lists', but also Charts >>>>>>>- It should be able to handle the following entities by default, >>>>>>>but be extensible for future or custom >>>>>>>modules: >>>>>>>- Patient >>>>>>>- Departments >>>>>>>- Appointments >>>>>>>- Admission >>>>>>>- Requests >>>>>>>- Doctors >>>>>>>- Nurses >>>>>>>- Wards >>>>>>>- OP Rooms >>>>>>>- Laboratory/Blood Bank >>>>>>>- Tests >>>>>>>- Pharmacy >>>>>>>- Pharmacy Product >>>>>>>- Medical Depot >>>>>>>- Medical Depot Product >>>>>>> >>>>>>>- Of these entities the relation to other entities should be >>>>>>>requestable where applicable (Pharmacy Products per Department, >>>>>>>Appointment per Patient, Nurses per Doctor etc) >>>>>>> >>>>>>>- All reports should be 'filterable' on all information >>>>>>> >>>>>>> >>available >> >> >>>>>>>in the Entities. (A report about Admissions per Month for the >>>>>>>Oncology Department for 2004) >>>>>>> >>>>>>>- It should be a non-programmers task to define new Reports. >>>>>>>- It should be a non-programmers task to run Reports. >>>>>>>- The Reporting Engine only creates reports for day to >>>>>>> >>>>>>> >>day data. If >> >> >>>>>>>you want to do real agregation of data, you would need >>>>>>> >>>>>>> >>to use DHIS. >> >> >>>>>>>My question: what else should care2x report generator be able to >>>>>>>do? (or should not) >>>>>>> >>>>>>> >>>>>>>rgds, >>>>>>> >>>>>>>Reinier Battenberg >>>>>>> >>>>>>>PS >>>>>>>Next question: how do we manage these requirements as a >>>>>>> >>>>>>> >>care2x group? >> >> >>>>>>>Next question: who builds this, even though everyone will use it? >>>>>>>Next question: can we use JasperReports to generate the reports? >>>>>>>And then build a nice module around it? (somebody has >>>>>>> >>>>>>> >>done such a >> >> >>>>>>>thing for SugarCRM. It seems like a pragmatic idea >>>>>>>http://www.sugarforge.org/projects/zuckerreports ) >>>>>>> >>>>>>> >>>>>>>[EMAIL PROTECTED] wrote: >>>>>>> Dear kyaw, >>>>>>> >>>>>>> I work for a brazilian public hospital situated in >>>>>>> >>>>>>> >>Petrópolis - RJ. >> >> >>>>>>> We are studying care2x to see if this software will >>>>>>> >>>>>>> >>fit our needs. >> >> >>>>>>> It is possible that we will need reports also, so if >>>>>>> >>>>>>> >>it will not be a >> >> >>>>>>> problem for you, as soon as you have your reports >>>>>>> >>>>>>> >>ready, please send them >> >> >>>>>>> to me. I am open to share with you also what you maybe need. >>>>>>> >>>>>>> Thank you >>>>>>> >>>>>>> Guilherme Rheingantz Vasconcellos >>>>>>> >>>>>>> >>>>>>> >>>>>>> Dear all, >>>>>>> >>>>>>> The care2x system was start using on Sri lanka, since >>>>>>> >>>>>>> >>last april 2006. >> >> >>>>>>> Currently, one hospital is using and we are >>>>>>> >>>>>>> >>introducing to another and >> >> >>>>>>> another hospitals. >>>>>>> >>>>>>> The hospital "Medical Record Officer", request >>>>>>> >>>>>>> >>several reports. So, I am >> >> >>>>>>> planning to develop summary reports for OPD, as well >>>>>>> >>>>>>> >>as Ward patients. >> >> >>>>>>> >>>>>>> So, what will you recommend? >>>>>>> >>>>>>> >>>>>>> >>>>>>> Best regards to Care2x Members, >>>>>>> kko!@ >>>>>>> _______________________________________________ >>>>>>> Care2002-developers mailing list >>>>>>> Care2002-developers@lists.sourceforge.net >>>>>>> >>>>>>> >>>>>>> >>https://lists.sourceforge.net/lists/listinfo/care2002-developers >> >> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Care2002-developers mailing list >>>>>>> Care2002-developers@lists.sourceforge.net >>>>>>> >>>>>>> >>>>>>> >>https://lists.sourceforge.net/lists/listinfo/care2002-developers >> >> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>All the advantages of Linux Managed Hosting--Without the >>>>> >>>>> >>Cost and Risk! >> >> >>>>>Fully trained technicians. The highest number of Red Hat >>>>>certifications in the hosting industry. Fanatical Support. >>>>> >>>>> >>Click to >> >> >>>>>learn more >>>>>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=2487 >>>>> >>>>> >29&dat=121 > > >>>>>642 _______________________________________________ >>>>>Care2002-developers mailing list >>>>>Care2002-developers@lists.sourceforge.net >>>>>https://lists.sourceforge.net/lists/listinfo/care2002-developers >>>>> >>>>> >>>>> >>>>> >>>>> >>>>Using Tomcat but need to do more? Need to support web >>>> >>>> >>services, security? >> >> >>>>Get stuff done quickly with pre-integrated technology to >>>> >>>> >>make your job >> >> >>>>easier Download IBM WebSphere Application Server v.1.0.1 based on >>>>Apache Geronimo >>>>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=26305 >>>> >>>> >>7&dat=1216 >> >> >>>>42 _______________________________________________ >>>>Care2002-developers mailing list >>>>Care2002-developers@lists.sourceforge.net >>>>https://lists.sourceforge.net/lists/listinfo/care2002-developers >>>> >>>> >>>> >>>> >>>Using Tomcat but need to do more? Need to support web >>> >>> >>services, security? >> >> >>>Get stuff done quickly with pre-integrated technology to >>> >>> >>make your job >> >> >>>easier Download IBM WebSphere Application Server v.1.0.1 based on >>>Apache Geronimo >>>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057 >>> >>> >>&dat=12164 >> >> >>>2 _______________________________________________ >>>Care2002-developers mailing list >>>Care2002-developers@lists.sourceforge.net >>>https://lists.sourceforge.net/lists/listinfo/care2002-developers >>> >>> >>> >>> >>> >> >>Using Tomcat but need to do more? Need to support web >>services, security? >>Get stuff done quickly with pre-integrated technology to make >>your job easier Download IBM WebSphere Application Server >>v.1.0.1 based on Apache Geronimo >>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&; >> >> >dat=121642 > > >>_______________________________________________ >>Care2002-developers mailing list >>Care2002-developers@lists.sourceforge.net >>https://lists.sourceforge.net/lists/listinfo/care2002-developers >> >> >> > > >Using Tomcat but need to do more? Need to support web services, security? >Get stuff done quickly with pre-integrated technology to make your job easier >Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo >http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 >_______________________________________________ >Care2002-developers mailing list >Care2002-developers@lists.sourceforge.net >https://lists.sourceforge.net/lists/listinfo/care2002-developers > > > Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
