Hi, I cannot say about the programs that are best to generate the reports. But from the users point of view we need different type of tools. For us there should be some regular fixed reports. These are often different in different hospitals. For that puprose there is need for a report generator, which would be used by those who implement Care2x and support the hospital. These background tools can be also more complex as long as they can generate simple frontend for people who can only browse.
We also need some reports where enduser has some filters and play little bit with available data. In the Italian Olympic Commitee version they have inone report filter for time, department and doctor. There could be age, sex, service items, supplies items etc filters. Here we need a good report generator which the support people can use to make a simple self explanatory front end. On the third level we need a more advance reporting tool, which could be used by well trained endusers. That tools should analyze the database in manay ways. We have thought that for this purpose DHIS would be the best one and therefore we hope co-operaton between DHIS and Care2x developes will become closer. For those who do not know DHIS: it has been developed during the last 10 years in multinational co-operation. It is free and open source. Recently they have migrated to opens source programming tools as well. Mauri Niemi On 23 Jun 2006 at 22:31, Reinier Battenberg wrote: > > Hi, > > Your remark about extra application servers is very valid indeed. Most > hospitals (especially in > developing countries, or in developed M$ based environments) will not have > the capacity to learn > yet another technology. > > The phpreports project is definitly simpler than the other two candidates. In > a sense that is an > advantage, but the lack of PDF output and a visual report designer (with > which non-programmers > can design nicely formatted reports) might make it too simple. > > or am i mistaking here? > > rgds, > > Reinier > > Mr. Kyaw Kyaw Oo wrote: > Dear all, > > Search keyword or condition: date_reg >= '2006-05-20 00:00:00' AND > date_reg <= '2006- > 05-20 23:59:59' > > I found 403 relevant data! > Please click the right one. Showing 1 to 20. > > =============================================================== > Our hospital server is busy with the patient registration for days and > years. > I mean, I don't want to give another work load to install another web > server or application > server. Sometimes, we need to restart the server because of slow > response. I believe that > we shouldn't introduce another web server or application server on > care2x. The installation > process can also be more complicated. > > And care2x system was used some third party modules, that are outdated > and we need to > upgrade our core system modules. i.e adodb, mysql 5, php 5 etc. Because > some php > reporting projects are using PHP 5. > > And our reporting module should be built in with the existing system. > Browse between > modules to get the specific results and print that result. > > I mean, we should generate the page to display before we are decided to > print on pdf or > export to other format. > > I found some project that works with xml,php 5, and hoping it can fulfil > our needs. But we > need to check more on that project. > > http://phpreports.sourceforge.net/index.html > > Please check that link and suggest. Can we upgrade care2x to php 5 ? > > Best regards, > kyaw kyaw oo > Sri lanka > ==================================================================== > > On 6/23/06, Reinier Battenberg < [EMAIL PROTECTED]> wrote: > Hi Kaloyan, > > Cool huh, this mailinglist is really swinging currently. Let's see where > this is heading! > > Eclipse-Birt needs a Tomcat application server, but then it's 100% > webbased. From > looking a bit at the JasperReports option, this can use the java-php > bridge, and then > does not need a seperate appserver. (it does need a Java Runtime > installed) > > BIRT looks really cool though, but JasperReports is definitly a mature > product that is > used in a lot of projects. > > Do the advantages of BIRT (i think its a bit more advanced and we seem to > have > someone with experience on this list) outweight the disadvantage of > telling our > hospitals to run Tomcat to do reporting? > > reinier > > > > > > Kaloyan Raev wrote: > 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=248729&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 > > > > > 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 > > > -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.9.5/376 - Release Date: 26.6.2006 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
