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 <[email protected]> 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 > <[email protected]> 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 <[email protected]> >> To: Muhumuza Kananura Rornald <[email protected]> >> Cc: "[email protected]" <[email protected]> >> 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 >> <[email protected]> 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 : [email protected] >> > Unsubscribe : https://launchpad.net/~dhis2-users >> > More help : https://help.launchpad.net/ListHelp >> > >> >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> > _______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
