dhis2-devs team mailing list archive

[Ola Hodne Titlestad <olatitle@xxxxxxxxx>]

Hi Thuy,

When you say reports, which module are you referring to? There are many ways
to set up reports in DHIS2, and my first thought is that it should be
possible to generate all your reports from the same database, and that
splitting up into 2 databases sounds like al lot of extra work for you guys
(maintenance, import/export etc.).

Using report tables as your data source for your reports you should be able
to generate more or less anything you want, you can e.g combine orgunits
from any level. You should then be able to use report tables (with report
parameters) in any of the report modules whether it is Jasper, BIRT, Excel
or some other local variant you are using.

You say, some orguits from district level and some orhgunits from ward
level, does that mean not all districts in one province and not all wards,
or all districts and some wards of a particular type maybe?

If you create one report table per province you can select exactly the
orgunits you want from district and ward level, and then not select orgunit
as report parameter (all orgunits in the report are fixed). This will work,
but since you have 84 (?) provinces this easily becomes very messy.

So the problem relates to making these reports generic and reusable for all
your provinces, for any orgunit at level 2. I assume that the orgunits you
want to display at ward level are of a special type, like a health center
more than just the normal ward (phoung/xa). Is that right? If you have
assigned a common orgunit group for all these ward level units that you want
to see in the report then it should be possible to modify the report tables
to generically list all these units even for a province report.

My point is that if the report logic is something like this:

For any selected orgunit at level 2 (this is your report parameter) populate
a report table with ALL children (districts) and the grandchildren (ward
level) of orgunit type X.

That should be doable to add to report tables I think.

I would rather try to improve the report table functionality than splitting
up into two databases just to solve a report problem.

Does this make sense?

Ola
------------


2009/12/17 Thuy Nguyen <thuy.hispvietnam@xxxxxxxxx>

> Dear all,
> Recently Vietnam team has been working on the reports of Vietnam and design
> them in DHIS2. And we see that there is a problem.
> The levels in Vietnam are set as below:
> Ward => District=> Province=>MOH
> There are 3 levels of reports.
> 1st : Ward level reports, these reports are entered by ward level user.
> These reports display the data values of ward level.
> 2nd: District level reports, these reports display data values of list of
> wards level.
> 3rd: Province reports, these reports display data values from some of org
> units at district level and some org unit at ward level to submit to MOH.
> So when the user from province level generate report, the report can't
> reach the data values from ward but it's calculated and display only in the
> district level.
>
> But as I know DHIS only support for display data values of the next 1 lower
> level when we generate in any org unit level. So we are going to separate
> the data base to twice.
> 1st database is for national level which includes only reports from
> province level..
> and the 2nd one is for province level which includes only reports of ward
> and district level.
> In this way, the users from province level may generate report from the 2nd
> database, and then import to the 1st database for submit report to MOH.
>
> Currently we only know this solution. And we don't know if it is right and
> good solution. If you have any suggestion, or any experience about this
> problem, please share and consult to us. We really need your ideas.
>
> Looking forward to your responses.
> Thanks and Regards,
> --
> --
> Thuy
> HISP Vietnam
> +84902079126
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> More help   : https://help.launchpad.net/ListHelp
>
>