Hi Mr Kyaw Kyaw Oo,
in another FOSS project that I am using, the most popular way of making
reports is using the following tools:
- To design reports, they use Ireport (http://ireport.sourceforge.net)
- IReport produces definition files for reports. This means:
formatting, SQL, Database Connection, and fields to filter on. (where
doctor_ID = XXX, and everytime the report is run, you have to provide
the Doctor_ID)
- The JasperReports engine (http://jasperreports.sourceforge.net/).
This engine generates the reports based on the IReport definition and
the data from care2x/sugarcrm
- A custom module for sugarcrm/care2x with which the IReport files are
managed and with which you can run reports directly from
sugarcrm/care2x
Only the last module should be written. Once that module is there,
community members could start designing IReports and share them amongst
eachother. This is not a programmers job anymore, even business users
could get a go at this!
This approach seems very reasonable to me. Are there more ideas as to
how to approach this? And are there any volunteers who would like to
implement or sponsor this implementation?
rgds,
Reinier
Mr. Kyaw Kyaw Oo wrote:
Let's choose one and let's decide which one we will use. I
checked some reporting project and I found some Java based and they are
quite good. And I found some PHP and it for PHP5. I think it is not a
right solution for care2x environment.
Then, I decided to use the existing infrastructure and it is quite
handy to use such as pdf-php module. Even it is not intended for
end-user, it should be quite easy for developers. What OSS project will
you be recommend ? Now, I am currently coding some basic module in
existing infrastructure.
Mr. kyaw kyaw oo
Sri Lanka
=================================================================
On 6/22/06,
[EMAIL PROTECTED] <[EMAIL PROTECTED]>
wrote:
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
>
>
>
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.9.2/370 - Release Date: 20.6.2006
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
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
|
