Sorry to disturb you guys! I have searched but I could not find a answer yet.
When one builds a reporttable, where that reporttable is created. I need it to make a customized standard report.
I am using DHIS 2.10.
Caveman
Hi again,
sorry the report tables are not materialized in the database, but generated in the application layer.
If you need custom reports I suggest you make queries against the aggregateddatavalue/indicatorvalue tables and join with the appropriate resource tables (they all start with an underscore):
http://dhis2.org/doc/snapshot/en/user/html/ch18s06.html
regards,
Lars
···
On Mon, Jan 7, 2013 at 7:31 AM, Orvalho Augusto orvaquim@gmail.com wrote:
Sorry to disturb you guys! I have searched but I could not find a answer yet.
When one builds a reporttable, where that reporttable is created. I need it to make a customized standard report.
I am using DHIS 2.10.
Caveman
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Thanks!
Is it possible to get indicators already calculated by this way?
Caveman
···
On Jan 7, 2013 10:45 AM, “Lars Helge Øverland” larshelge@gmail.com wrote:
Hi again,
sorry the report tables are not materialized in the database, but generated in the application layer.
If you need custom reports I suggest you make queries against the aggregateddatavalue/indicatorvalue tables and join with the appropriate resource tables (they all start with an underscore):
regards,
Lars
On Mon, Jan 7, 2013 at 7:31 AM, Orvalho Augusto orvaquim@gmail.com wrote:
Sorry to disturb you guys! I have searched but I could not find a answer yet.
When one builds a reporttable, where that reporttable is created. I need it to make a customized standard report.
I am using DHIS 2.10.
Caveman
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Yes you will find it in table aggregatedindicatorvalue .
···
On Mon, Jan 7, 2013 at 10:15 AM, Orvalho Augusto orvaquim@gmail.com wrote:
Thanks!
Is it possible to get indicators already calculated by this way?
Caveman
On Jan 7, 2013 10:45 AM, “Lars Helge Øverland” larshelge@gmail.com wrote:
Hi again,
sorry the report tables are not materialized in the database, but generated in the application layer.
If you need custom reports I suggest you make queries against the aggregateddatavalue/indicatorvalue tables and join with the appropriate resource tables (they all start with an underscore):
regards,
Lars
On Mon, Jan 7, 2013 at 7:31 AM, Orvalho Augusto orvaquim@gmail.com wrote:
Sorry to disturb you guys! I have searched but I could not find a answer yet.
When one builds a reporttable, where that reporttable is created. I need it to make a customized standard report.
I am using DHIS 2.10.
Caveman
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp