← Back to team overview

dhis2-users team mailing list archive

Re: DHIS Annual Report

 

OK sorry thought a data entrant worked only within a specific org
unit. Jasons suggestion will work. You can create such an SQL report
under Data administration - SQL View. Create new, give it a name (like
"User reporting"), paste the SQL, save,  generate it by clicking on
the green icon, then view it by clicking on the blue icon.



SELECT storedby, COUNT(*) FROM completedatasetregistration
WHERE date  >= '2011-10-01' and date <='2012-09-30'
GROUP BY storedby;


On Tue, Sep 11, 2012 at 3:18 PM, Jason Pickering
<jason.p.pickering@xxxxxxxxx> wrote:
> There is no way to get this directly. You would need to look in the
> completedatasetregistration table.
>
> However, if you have multiple people who might submit the data for a
> particular orgunit, you would not be able to distinguish who completed the
> information the first time, versus the last time. The only thing this table
> will show you will be the last person who "completed" the data.
>
> I think
>
> SELECT storedby, COUNT(*) FROM completedatasetregistration
> WHERE date  >= '2011-10-01' and date <='2012-09-30'
> GROUP BY storedby;
>
>
> might give you what you need however.
>
> Regards,
> Jason
>
>
>
>
> On Tue, Sep 11, 2012 at 6:37 PM, Muhumuza Kananura Rornald
> <mk.rornald@xxxxxxxxx> wrote:
>>
>> Dear Lars;
>> Thanks for the support.
>> I have data entrants who are paid according the number of forms (Data
>> sets) entered. Is there any way how I can access the number of forms
>> submitted by each individual.
>>
>> I will be grateful for the feedback.
>>
>> Regards
>> Muhumuza Kananura Rornald
>> Management Information System Officer
>> THETA Uganda
>> Tel: +256776301718
>>
>>
>> ________________________________
>> From: Lars Helge Øverland <larshelge@xxxxxxxxx>
>> To: Muhumuza Kananura Rornald <mk.rornald@xxxxxxxxx>
>> Cc: "dhis2-users@xxxxxxxxxxxxxxxxxxx" <dhis2-users@xxxxxxxxxxxxxxxxxxx>
>> Sent: Tuesday, September 11, 2012 2:12 PM
>> Subject: Re: [Dhis2-users] DHIS Annual Report
>>
>> Hello Muhumuza,
>>
>> at the moment we only support aggregated reports for the financial
>> year which starts in July. We can implement support for this in the
>> next version which is 2.10.
>>
>> The work-around is to create a "report table" (reports module) where
>> you include the four quarters which comprise your financial year. You
>> then generate this report and export to Excel where you can summarize
>> those four quarters into the financial year.
>>
>> regards,
>>
>> Lars
>>
>> On Mon, Sep 10, 2012 at 2:10 PM, Muhumuza Kananura Rornald
>> <mk.rornald@xxxxxxxxx> wrote:
>> > Dear;
>> >
>> > Dear DHIS2 Users;
>> > I am using DHIS2 in managing community health data in our organization
>> > (CDC
>> > funded). I am now supposed to produce an annual report for which the
>> > financial year ends in September 31. How can I go about it.
>> >
>> > Regards
>> >
>> > Muhumuza Kananura Rornald
>> > Management Information System Officer
>> > THETA Uganda
>> > tel: 0776301718
>> >
>> > _______________________________________________
>> > Mailing list: https://launchpad.net/~dhis2-users
>> > Post to    : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> > Unsubscribe : https://launchpad.net/~dhis2-users
>> > More help  : https://help.launchpad.net/ListHelp
>> >
>>
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>


References