# Problems with Report tables **URL:** \ **Category:** Support - Assistance technique\ **Created:** [1 June 2012 11:03 UTC](https://community.dhis2.org/t/problems-with-report-tables/1217 "2012-06-01T11:03:34Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![jose](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/jose/32/28386_2.png) [@jose](https://community.dhis2.org/u/jose)\ **Post date:** [1 June 2012 11:03 UTC](https://community.dhis2.org/t/problems-with-report-tables/1217/1 "2012-06-01T11:03:34Z")
Hi all, I have a problem with totals using the report tables. In the picture DataEntry.jpg you can see a dataset with different DataElements and two categories combined between them. The dataset corresponds to the Organization Unit CS Pacu and the period time is the first week of 2012. When i try to make a report table of the same information, i get a report without totals (as you can see in the picture Report.jpg). The organization unit and the period time are the same. So any idea about why is it going wrong? I am using the 2.7 version. Thank you very much! ![image](https://dhis2.b-cdn.net/images/transparent.png) ![image](https://dhis2.b-cdn.net/images/transparent.png) ---
**Author:** ![olatitle](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/olatitle/32/45144_2.png) [@olatitle](https://community.dhis2.org/u/olatitle)\ **Post date:** [1 June 2012 12:16 UTC](https://community.dhis2.org/t/problems-with-report-tables/1217/2 "2012-06-01T12:16:17Z")
Hi Jose, Most likely there are no weekly values in your datamart (where all the reports fetch data from). Weekly periods are not selected by default in the datamart scheduler. Go to Maintenance-\>Data Administration-\>Scheduling and tick “Weekly” in the Aggregation period types section. Also make sure to start the scheduler. The datamart will then export at midnight (server time). Ola > **···** > > * * * > > * * * > > Ola Hodne Titlestad (Mr) > HISP > Department of Informatics > University of Oslo > > Mobile: +47 48069736 > Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. [Googlemaps link](http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway) > > On 1 June 2012 13:03, Jose Garcia Muñoz [josemp10@gmail.com](mailto:josemp10@gmail.com) wrote: > > > Hi all, > > > > I have a problem with totals using the report tables. In the picture DataEntry.jpg you can see a dataset with different DataElements and two categories combined between them. The dataset corresponds to the Organization Unit CS Pacu and the period time is the first week of 2012. When i try to make a report table of the same information, i get a report without totals (as you can see in the picture Report.jpg). The organization unit and the period time are the same. So any idea about why is it going wrong? I am using the 2.7 version. > > > > Thank you very much! > > > > * * * > > > > Mailing list: [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users) > > > > Post to : [dhis2-users@lists.launchpad.net](mailto:dhis2-users@lists.launchpad.net) > > > > Unsubscribe : [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users) > > > > More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp) ---
**Author:** ![jose](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/jose/32/28386_2.png) [@jose](https://community.dhis2.org/u/jose)\ **Post date:** [1 June 2012 12:43 UTC](https://community.dhis2.org/t/problems-with-report-tables/1217/3 "2012-06-01T12:43:05Z")
Yes, I didn’t run the Data Mart 🙂 and now it works! Thanks Ola, Jason. One more thing: It seems that the period could not be weekly right? As it doesn’t appear in the Data Mart, and the same with the Scheduling task (no weekly checkbox appear). Thanks. > **···** > > On Fri, Jun 1, 2012 at 2:16 PM, Ola Hodne Titlestad [olati@ifi.uio.no](mailto:olati@ifi.uio.no) wrote: > > > Hi Jose, > > > Most likely there are no weekly values in your datamart (where all the reports fetch data from). > > > > > > Weekly periods are not selected by default in the datamart scheduler. > > > > > > Go to Maintenance-\>Data Administration-\>Scheduling and tick “Weekly” in the Aggregation period types section. > > > Also make sure to start the scheduler. The datamart will then export at midnight (server time). > > > > > > Ola > > > * * * > > > > > > > > > * * * > > > > Ola Hodne Titlestad (Mr) > > HISP > > Department of Informatics > > University of Oslo > > > > Mobile: +47 48069736 > > Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. [Googlemaps link](http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway) > > > > On 1 June 2012 13:03, Jose Garcia Muñoz [josemp10@gmail.com](mailto:josemp10@gmail.com) wrote: > > > > Hi all, > > > > > > I have a problem with totals using the report tables. In the picture DataEntry.jpg you can see a dataset with different DataElements and two categories combined between them. The dataset corresponds to the Organization Unit CS Pacu and the period time is the first week of 2012. When i try to make a report table of the same information, i get a report without totals (as you can see in the picture Report.jpg). The organization unit and the period time are the same. So any idea about why is it going wrong? I am using the 2.7 version. > > > > > > Thank you very much! > > > > * * * > > > > > > Mailing list: [https://launchpad.net/~dhis2-users](https://launchpad.net/%7Edhis2-users) > > > > > > Post to : [dhis2-users@lists.launchpad.net](mailto:dhis2-users@lists.launchpad.net) > > > > > > Unsubscribe : [https://launchpad.net/~dhis2-users](https://launchpad.net/%7Edhis2-users) > > > > > > More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp) > > > ---
**Author:** ![jason](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/jason/32/32739_2.png) [@jason](https://community.dhis2.org/u/jason)\ **Post date:** [1 June 2012 16:40 UTC](https://community.dhis2.org/t/problems-with-report-tables/1217/4 "2012-06-01T16:40:26Z")
I think weekly periods are in the latest 2.8 version but not 2.7. Regards, Jason > **···** > > – > > Sent from my mobile > > On Jun 1, 2012 2:51 PM, “Jose Garcia Muñoz” [josemp10@gmail.com](mailto:josemp10@gmail.com) wrote: > > > Yes, I didn’t run the Data Mart 🙂 and now it works! Thanks Ola, Jason. > > > > One more thing: It seems that the period could not be weekly right? As it doesn’t appear in the Data Mart, and the same with the Scheduling task (no weekly checkbox appear). > > > > Thanks. > > > > On Fri, Jun 1, 2012 at 2:16 PM, Ola Hodne Titlestad [olati@ifi.uio.no](mailto:olati@ifi.uio.no) wrote: > > > > > Hi Jose, > > > > Most likely there are no weekly values in your datamart (where all the reports fetch data from). > > > > > > > > Weekly periods are not selected by default in the datamart scheduler. > > > > > > > > Go to Maintenance-\>Data Administration-\>Scheduling and tick “Weekly” in the Aggregation period types section. > > > > Also make sure to start the scheduler. The datamart will then export at midnight (server time). > > > > > > > > Ola > > > > * * * > > > > > > > > > > > > * * * > > > > > > Ola Hodne Titlestad (Mr) > > > HISP > > > Department of Informatics > > > University of Oslo > > > > > > Mobile: +47 48069736 > > > Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. [Googlemaps link](http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=Vetlandsvn.+95B,+0685+Oslo,+Norway) > > > > > > On 1 June 2012 13:03, Jose Garcia Muñoz [josemp10@gmail.com](mailto:josemp10@gmail.com) wrote: > > > > > Hi all, > > > > > > > > I have a problem with totals using the report tables. In the picture DataEntry.jpg you can see a dataset with different DataElements and two categories combined between them. The dataset corresponds to the Organization Unit CS Pacu and the period time is the first week of 2012. When i try to make a report table of the same information, i get a report without totals (as you can see in the picture Report.jpg). The organization unit and the period time are the same. So any idea about why is it going wrong? I am using the 2.7 version. > > > > > > > > Thank you very much! > > > > > * * * > > > > > > > > Mailing list: [https://launchpad.net/~dhis2-users](https://launchpad.net/%7Edhis2-users) > > > > > > > > Post to : [dhis2-users@lists.launchpad.net](mailto:dhis2-users@lists.launchpad.net) > > > > > > > > Unsubscribe : [https://launchpad.net/~dhis2-users](https://launchpad.net/%7Edhis2-users) > > > > > > > > More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp) > > > > > > > * * * > > > > Mailing list: [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users) > > > > Post to : [dhis2-users@lists.launchpad.net](mailto:dhis2-users@lists.launchpad.net) > > > > Unsubscribe : [https://launchpad.net/~dhis2-users](https://launchpad.net/~dhis2-users) > > > > More help : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp) ---
**Author:** ![Lars](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/lars/32/34166_2.png) [@Lars](https://community.dhis2.org/u/Lars)\ **Post date:** [3 June 2012 15:33 UTC](https://community.dhis2.org/t/problems-with-report-tables/1217/5 "2012-06-03T15:33:46Z")
Yes weeks are in latest 2.8 stable, download from here: > **[Resources - DHIS2](https://dhis2.org/resources/)** > > Get started with DHIS2 or update your implementation with these helpful learning, training, and discussion resources Lars > **···** > > On Fri, Jun 1, 2012 at 6:40 PM, Jason Pickering \ wrote: > > > I think weekly periods are in the latest 2.8 version but not 2.7. > > > > Regards, > > Jason > > > > -- > > Sent from my mobile > > > > On Jun 1, 2012 2:51 PM, "Jose Garcia Muñoz" \ wrote: > > > > > Yes, I didn't run the Data Mart 🙂 and now it works! Thanks Ola, Jason. > > > > > > One more thing: It seems that the period could not be weekly right? As it > > > doesn't appear in the Data Mart, and the same with the Scheduling task (no > > > weekly checkbox appear). > > > > > > Thanks. > > > > > > On Fri, Jun 1, 2012 at 2:16 PM, Ola Hodne Titlestad \ \>\> wrote: > > > > > > > Hi Jose, > > > > > > > > Most likely there are no weekly values in your datamart (where all the > > > > reports fetch data from). > > > > > > > > Weekly periods are not selected by default in the datamart scheduler. > > > > > > > > Go to Maintenance-\>Data Administration-\>Scheduling and tick "Weekly" in > > > > the Aggregation period types section. > > > > Also make sure to start the scheduler. The datamart will then export at > > > > midnight (server time). > > > > > > > > Ola > > > > -------- > > > > > > > > ---------------------------------- > > > > Ola Hodne Titlestad (Mr) > > > > HISP > > > > Department of Informatics > > > > University of Oslo > > > > > > > > Mobile: +47 48069736 > > > > Home address: Vetlandsvn. 95B, 0685 Oslo, Norway. Googlemaps link > > > > > > > > On 1 June 2012 13:03, Jose Garcia Muñoz \ wrote: > > > > > > > > > Hi all, > > > > > > > > > > I have a problem with totals using the report tables. In the picture > > > > > DataEntry.jpg you can see a dataset with different DataElements and two > > > > > categories combined between them. The dataset corresponds to the > > > > > Organization Unit CS Pacu and the period time is the first week of 2012. > > > > > When i try to make a report table of the same information, i get a report > > > > > without totals (as you can see in the picture Report.jpg). The organization > > > > > unit and the period time are the same. So any idea about why is it going > > > > > wrong? I am using the 2.7 version. > > > > > > > > > > Thank you very much! > > > > > > > > > > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ > > > > > Mailing list: [DHIS 2 Users in Launchpad](https://launchpad.net/~dhis2-users) > > > > > Post to : dhis2-users@lists.launchpad.net > > > > > Unsubscribe : [DHIS 2 Users in Launchpad](https://launchpad.net/~dhis2-users) > > > > > More help : [ListHelp - Launchpad Help](https://help.launchpad.net/ListHelp) > > > > > > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ > > > Mailing list: [DHIS 2 Users in Launchpad](https://launchpad.net/~dhis2-users) > > > Post to : dhis2-users@lists.launchpad.net > > > Unsubscribe : [DHIS 2 Users in Launchpad](https://launchpad.net/~dhis2-users) > > > More help : [ListHelp - Launchpad Help](https://help.launchpad.net/ListHelp) > > > > \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ > > Mailing list: [DHIS 2 Users in Launchpad](https://launchpad.net/~dhis2-users) > > Post to : dhis2-users@lists.launchpad.net > > Unsubscribe : [DHIS 2 Users in Launchpad](https://launchpad.net/~dhis2-users) > > More help : [ListHelp - Launchpad Help](https://help.launchpad.net/ListHelp)