dhis2-devs team mailing list archive

[Trí Trần Thanh <tranthanhtri84@xxxxxxxxx>]

- Yes, i know birt can do that, but we have many problem when using birt for
report. It useful for us but so difficult with normal use. We ready use birt
for child heath report in Hồ Chí Minh, but now we must change to orther way.

- We don't have strong server, that why we can't use birt. I see when
generate report, server lost many memory for birt, after some time we must
restart tomcat service. We have about 20 user using at same time.

Tran Thanh Tri
HISP Viet Nam
+84903670967


2009/4/3 Lars Helge Øverland <larshelge@xxxxxxxxx>

>
>
> 2009/4/3 Trí Trần Thanh <tranthanhtri84@xxxxxxxxx>
>
>> Thanks.
>>
>> Really , we are developing Report module in DHIS2.0 for Vietnam.
>> 1. We will design excel template file.
>> 2. We will define report with some property and list of report item and
>> link to exceltemplate file
>>    Report Item have some property : row, column (position of cell in excel
>> template file), expression [1023.4]+[103.5]ect...,
>> 3. After have 2 thing, we will generate report by
>>      - get datavalue from database by expression
>>     - put this data into excel file by row-column position
>>
>> 4. With this way we can get data from excel file and insert into
>> database(because we have position  (row-column) of dataelement in excel file
>> by ReportItem
>>
>>
>>  Now we can get data form database and put it into excel file and user can
>> get it and view by Excel 2003. But now we want to find the way for view this
>> excel file on webpage directly.
>>
>
> This idea is actually not so bad Tri:) Just want to make you aware that you
> can create BIRT reports and use the built-in export to Excel there, I would
> have explored that option first.
>
> I don't think there is a way to present excel sheets on a web page
> directly. My best guess would be to use JExcelApi and export to HTML, if
> possible. Still, Firefox is able to display Excel sheets inside the browser
> in a separate window. If you provide links for opening the Excel sheets and
> instruct users to open them inside the browser I would believe that this is
> more than good enough...
>
>
> Lars
>
>