dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

See this discussion for details

How to handle NULL values in report tables?

http://groups.google.co.in/group/dhis-users/t/1896d5a6e44d3a00?hl=en-GB

I think it was on the dhis-users list.

Ola, your point is understood. If you see the SQL code and BIRT report
that I sent along with that discussion, I basically used a custom
aggregation routine to persist NULL values during aggregation, so that
they appear as blanks in the report.

Lars, with the system settings you mention, would the same result be
possible with the DHIS aggregation engine (with the addition of the
COUNT operator that I use in this example).


Best regards,
Jason



On Sat, Sep 26, 2009 at 9:12 AM, Jason Pickering
<jason.p.pickering@xxxxxxxxx> wrote:
>
> I am very sure about this and have discussed with Jan separately that blank values are reported/displayed as 0 on maps.
>
> I will see if I can dig out the discussion.
>
> On Sat, Sep 26, 2009 at 8:28 AM, Knut Staring <knutst@xxxxxxxxx> wrote:
>>
>> Are you sure, Jason? I must admit I dont recall the details of that discussion, but actually saving zeros when people dont enter anything renders DHIS 2 useless for Tom's purposes. There should perhaps be a setting so one could choose how blanks will be handled.
>> Knut
>>
>> On Sat, Sep 26, 2009 at 8:09 AM, Jason Pickering <jason.p.pickering@xxxxxxxxx> wrote:
>>>
>>> Hi Tom,
>>>
>>> We have had some long rambling discussions on this one as well, so you might want to have a look at the archives.
>>>
>>> Blank values are not only displayed as 0 in the report, they are stored in the database as 0.
>>>
>>> Regards,
>>> Jason
>>>
>>>
>>>
>>> On Fri, Sep 25, 2009 at 5:40 PM, Tom <hiattt@xxxxxxx> wrote:
>>>>
>>>> This is using the Dataelements report
>>>>
>>>> --
>>>> Blanks are displayed as 0 in report
>>>> https://bugs.launchpad.net/bugs/436692
>>>> You received this bug notification because you are a member of DHIS 2
>>>> developers, which is subscribed to DHIS.
>>>>
>>>> Status in DHIS 2 - District Health Information Software: New
>>>>
>>>> Bug description:
>>>> Blank values are converted to 0s in the report.
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>
>>
>>
>> --
>> Cheers,
>> Knut Staring
>