Providing another source table for reports

Hi all,

I’m trying to build the reports without using the Report Tables tools.

When i add new report on dhis it gives a chance to provide another data source different from the report tables (" If selecting no report table, the user is responsible for providing the data source table. ").

I just don’t know how to tell DHSI that I want to use another data source.
Any help on how to accomplish this?

Thanks in advance

···


Cintia Marisa

Hi Cintia,

···

From: Cintia Marisa cintia.banze@gmail.com
To: dhis2-devs@lists.launchpad.net
Sent: Wednesday, May 13, 2009 9:22:14 AM
Subject: [Dhis2-devs] Providing another source table for reports

Hi all,

I’m trying to build the reports without using the Report Tables tools.

When i add new report on dhis it gives a chance to provide another data source different from the report tables (" If selecting no report table, the user is responsible for providing the data source table. ").

I just don’t know how to tell DHSI that I want to use another data source.
Any help on how to accomplish this?

Thanks in advance


Cintia Marisa

You can use BIRT to include your dataset. Simply create dataset under outline->DataSet. Simply choose “SQL select query” and make you sql statement on next screen, like “select * from yourtable where …”

murod

Hi,

When using standard reports (BIRT reports in DHIS 2) the only limitation is that you need to use the DHIS 2 database as your source, but within that database you can create BIRT datasets based on any table or view as you like. This is simply because DHIS replaces the database connection string in the BIRT design file when you upload the report. This is done to make sure that the data source is available.

Still, I’m wondering why you do not want to use report tables? Report tables are generic and very flexible and can provide routine data sources for your reports that are automatically updated to e.g. the latest month, the last quarter, acculmulative values so far this year and more.You can also specify exactly which data elements or indicators to use. Furthermore, report tables also allow for report paremeters where you can specify which orgunit to show data for, or all children below a selected orgunit, and also which month to use, so that you can reuse your design for many purposes. Report tables are small and automatically generated datamarts that you can use out of the box while other data sources most liley will need some kind of manual update like an export to datamart or similar.

You can read more about report tables here:
https://answers.launchpad.net/dhis2/+question/61455
https://answers.launchpad.net/dhis2/+faq/370

What kind of report are you designing and what made you choose not to use report tables?

best regards,
Ola Hodne Titlestad
HISP
University of Oslo

···

On Wed, May 13, 2009 at 10:40 AM, Murodullo Latifov murodlatifov@yahoo.com wrote:

Hi Cintia,


From: Cintia Marisa cintia.banze@gmail.com
To: dhis2-devs@lists.launchpad.net

Sent: Wednesday, May 13, 2009 9:22:14 AM
Subject: [Dhis2-devs] Providing another source table for reports

Hi all,

I’m trying to build the reports without using the Report Tables tools.

When i add new report on dhis it gives a chance to provide another data source different from the report tables (" If selecting no report table, the user is responsible for providing the data source table. ").

I just don’t know how to tell DHSI that I want to use another data source.
Any help on how to accomplish this?

Thanks in advance


Cintia Marisa

You can use BIRT to include your dataset. Simply create dataset under outline->DataSet. Simply choose “SQL select query” and make you sql statement on next screen, like “select * from yourtable where …”

murod


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

HI Cintia,

I reply to the list so that we can share this discussion with the rest of the community.
The report table concept has been developed in an evolutionary way based on various requirements from different countries. We are happy to further extend it to meet your needs in Mozambique. I am not sure I understand your problems of periods, and not sure what you mean by “doesn’t seem to keep the keys to link the data elements, periods and organization units”.

If you like you could provide us more info on this, and if possible a screenshot of your report, and we could try to modify report tables functionality to meet your needs.

best regards,
Ola Hodne Titlestad

HISP
University of Oslo

···

On Wed, May 13, 2009 at 12:40 PM, Cintia Marisa cintia.banze@gmail.com wrote:

Hi, thanks for the help.

I’ve already read the articles you sent to me.

I’ll try again, then I’ll give you guys a feedback.

I choose not use report table, mostly because of the periods. The problem Orvalho is having( we are having) with periods, make it difficult for us to create report tables.

It, takes a long time for the table to be created, and it doesn’t seem to keep the keys to link the data elements, periods and organization units as I need.

In the reports I’m making i need to have cross tabulated data with org units, data elements and periods.

I know report tables are mean to make my work easier, but i can’t get them to provide the data the way I need.

Thanks for the support.

On Wed, May 13, 2009 at 11:21 AM, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Hi,

When using standard reports (BIRT reports in DHIS 2) the only limitation is that you need to use the DHIS 2 database as your source, but within that database you can create BIRT datasets based on any table or view as you like. This is simply because DHIS replaces the database connection string in the BIRT design file when you upload the report. This is done to make sure that the data source is available.

Still, I’m wondering why you do not want to use report tables? Report tables are generic and very flexible and can provide routine data sources for your reports that are automatically updated to e.g. the latest month, the last quarter, acculmulative values so far this year and more.You can also specify exactly which data elements or indicators to use. Furthermore, report tables also allow for report paremeters where you can specify which orgunit to show data for, or all children below a selected orgunit, and also which month to use, so that you can reuse your design for many purposes. Report tables are small and automatically generated datamarts that you can use out of the box while other data sources most liley will need some kind of manual update like an export to datamart or similar.

You can read more about report tables here:
https://answers.launchpad.net/dhis2/+question/61455
https://answers.launchpad.net/dhis2/+faq/370

What kind of report are you designing and what made you choose not to use report tables?

best regards,
Ola Hodne Titlestad
HISP
University of Oslo

On Wed, May 13, 2009 at 10:40 AM, Murodullo Latifov murodlatifov@yahoo.com wrote:

Hi Cintia,


From: Cintia Marisa cintia.banze@gmail.com
To: dhis2-devs@lists.launchpad.net

Sent: Wednesday, May 13, 2009 9:22:14 AM
Subject: [Dhis2-devs] Providing another source table for reports

Hi all,

I’m trying to build the reports without using the Report Tables tools.

When i add new report on dhis it gives a chance to provide another data source different from the report tables (" If selecting no report table, the user is responsible for providing the data source table. ").

I just don’t know how to tell DHSI that I want to use another data source.
Any help on how to accomplish this?

Thanks in advance


Cintia Marisa

You can use BIRT to include your dataset. Simply create dataset under outline->DataSet. Simply choose “SQL select query” and make you sql statement on next screen, like “select * from yourtable where …”

murod


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


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


Cintia Marisa

Hi,

In attachment one of the reports I need to build, maybe it will help you guys to understand what i need.

I used the query below to get the data that i needed.

C03preview.pdf (16.4 KB)

···

=============================================================

select a.periodid, a.sourceid, b.week, b.YR , b.startdate, b.enddate, c.name,
sum(if(dataelementid=691,a.value,0)) as A1,
sum(if(dataelementid=692,a.value,0)) as A2,
sum(if(dataelementid=693,a.value,0)) as A3,

sum(if(dataelementid=694,a.value,0)) as A4,
sum(if(dataelementid=695,a.value,0)) as A5,
sum(if(dataelementid=696,a.value,0)) as A6,
sum(if(dataelementid=697,a.value,0)) as A7,
sum(if(dataelementid=698,a.value,0)) as A8,

sum(if(dataelementid=699,a.value,0)) as A9,
sum(if(dataelementid=700,a.value,0)) as A10,
sum(if(dataelementid=730,a.value,0)) as A11,
sum(if(dataelementid=727,a.value,0)) as A12,
sum(if(dataelementid=728,a.value,0)) as A13,

sum(if(dataelementid=729,a.value,0)) as A14,
sum(if(dataelementid=705,a.value,0)) as A15,
sum(if(dataelementid=706,a.value,0)) as A16,
sum(if(dataelementid=707,a.value,0)) as A17,
sum(if(dataelementid=708,a.value,0)) as A18,

sum(if(dataelementid=709,a.value,0)) as A19,
sum(if(dataelementid=710,a.value,0)) as A20,
sum(if(dataelementid=711,a.value,0)) as A21,
sum(if(dataelementid=712,a.value,0)) as A22,
sum(if(dataelementid=713,a.value,0)) as A23,

sum(if(dataelementid=714,a.value,0)) as A24,
sum(if(dataelementid=715,a.value,0)) as A25,
sum(if(dataelementid=716,a.value,0)) as A26,
sum(if(dataelementid=717,a.value,0)) as A27,
sum(if(dataelementid=718,a.value,0)) as A28,

sum(if(dataelementid=721,a.value,0)) as A29,
sum(if(dataelementid=722,a.value,0)) as A30,
sum(if(dataelementid=731,a.value,0)) as A31,
sum(if(dataelementid=725,a.value,0)) as A32,
sum(if(dataelementid=726,a.value,0)) as A33,

sum(if(dataelementid=732,a.value,0)) as A34
from dhis2_exp.datavalue a
inner join modbas2dhis.period b on a.periodid = b.periodid
– inner join dhis2_exp.organisationunit c on a.sourceid = c.organisationunitid

   where periodtypeid=7

group by a.periodid, a.sourceid

=============================================================

regards

On Wed, May 13, 2009 at 12:50 PM, Ola Hodne Titlestad olati@ifi.uio.no wrote:

HI Cintia,

I reply to the list so that we can share this discussion with the rest of the community.

The report table concept has been developed in an evolutionary way based on various requirements from different countries. We are happy to further extend it to meet your needs in Mozambique. I am not sure I understand your problems of periods, and not sure what you mean by “doesn’t seem to keep the keys to link the data elements, periods and organization units”.

If you like you could provide us more info on this, and if possible a screenshot of your report, and we could try to modify report tables functionality to meet your needs.

best regards,

Ola Hodne Titlestad

HISP
University of Oslo

On Wed, May 13, 2009 at 12:40 PM, Cintia Marisa cintia.banze@gmail.com wrote:

Hi, thanks for the help.

I’ve already read the articles you sent to me.

I’ll try again, then I’ll give you guys a feedback.

I choose not use report table, mostly because of the periods. The problem Orvalho is having( we are having) with periods, make it difficult for us to create report tables.

It, takes a long time for the table to be created, and it doesn’t seem to keep the keys to link the data elements, periods and organization units as I need.

In the reports I’m making i need to have cross tabulated data with org units, data elements and periods.

I know report tables are mean to make my work easier, but i can’t get them to provide the data the way I need.

Thanks for the support.

On Wed, May 13, 2009 at 11:21 AM, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Hi,

When using standard reports (BIRT reports in DHIS 2) the only limitation is that you need to use the DHIS 2 database as your source, but within that database you can create BIRT datasets based on any table or view as you like. This is simply because DHIS replaces the database connection string in the BIRT design file when you upload the report. This is done to make sure that the data source is available.

Still, I’m wondering why you do not want to use report tables? Report tables are generic and very flexible and can provide routine data sources for your reports that are automatically updated to e.g. the latest month, the last quarter, acculmulative values so far this year and more.You can also specify exactly which data elements or indicators to use. Furthermore, report tables also allow for report paremeters where you can specify which orgunit to show data for, or all children below a selected orgunit, and also which month to use, so that you can reuse your design for many purposes. Report tables are small and automatically generated datamarts that you can use out of the box while other data sources most liley will need some kind of manual update like an export to datamart or similar.

You can read more about report tables here:
https://answers.launchpad.net/dhis2/+question/61455
https://answers.launchpad.net/dhis2/+faq/370

What kind of report are you designing and what made you choose not to use report tables?

best regards,
Ola Hodne Titlestad
HISP
University of Oslo

On Wed, May 13, 2009 at 10:40 AM, Murodullo Latifov murodlatifov@yahoo.com wrote:

Hi Cintia,


From: Cintia Marisa cintia.banze@gmail.com
To: dhis2-devs@lists.launchpad.net

Sent: Wednesday, May 13, 2009 9:22:14 AM
Subject: [Dhis2-devs] Providing another source table for reports

Hi all,

I’m trying to build the reports without using the Report Tables tools.

When i add new report on dhis it gives a chance to provide another data source different from the report tables (" If selecting no report table, the user is responsible for providing the data source table. ").

I just don’t know how to tell DHSI that I want to use another data source.
Any help on how to accomplish this?

Thanks in advance


Cintia Marisa

You can use BIRT to include your dataset. Simply create dataset under outline->DataSet. Simply choose “SQL select query” and make you sql statement on next screen, like “select * from yourtable where …”

murod


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


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


Cintia Marisa


Cintia Marisa

I am working with Cintia on this.

So the question is:
How can we use DHIS interfance to send the period and orgunit to BIRT? And the BIRT build a report for us.

Forgive me if am being non sense or missing to study the appropriate docs.

Thanks
Caveman

Cintia Marisa wrote:

···

Hi,

In attachment one of the reports I need to build, maybe it will help you guys to understand what i need.

I used the query below to get the data that i needed.

=============================================================

select a.periodid, a.sourceid, b.week, b.YR , b.startdate, b.enddate, c.name <http://c.name>,
sum(if(dataelementid=691,a.value,0)) as A1,
sum(if(dataelementid=692,a.value,0)) as A2,
sum(if(dataelementid=693,a.value,0)) as A3,
sum(if(dataelementid=694,a.value,0)) as A4,
sum(if(dataelementid=695,a.value,0)) as A5,
sum(if(dataelementid=696,a.value,0)) as A6,
sum(if(dataelementid=697,a.value,0)) as A7,
sum(if(dataelementid=698,a.value,0)) as A8,
sum(if(dataelementid=699,a.value,0)) as A9,
sum(if(dataelementid=700,a.value,0)) as A10,
sum(if(dataelementid=730,a.value,0)) as A11,
sum(if(dataelementid=727,a.value,0)) as A12,
sum(if(dataelementid=728,a.value,0)) as A13,
sum(if(dataelementid=729,a.value,0)) as A14,
sum(if(dataelementid=705,a.value,0)) as A15,
sum(if(dataelementid=706,a.value,0)) as A16,
sum(if(dataelementid=707,a.value,0)) as A17,
sum(if(dataelementid=708,a.value,0)) as A18,
sum(if(dataelementid=709,a.value,0)) as A19,
sum(if(dataelementid=710,a.value,0)) as A20,
sum(if(dataelementid=711,a.value,0)) as A21,
sum(if(dataelementid=712,a.value,0)) as A22,
sum(if(dataelementid=713,a.value,0)) as A23,
sum(if(dataelementid=714,a.value,0)) as A24,
sum(if(dataelementid=715,a.value,0)) as A25,
sum(if(dataelementid=716,a.value,0)) as A26,
sum(if(dataelementid=717,a.value,0)) as A27,
sum(if(dataelementid=718,a.value,0)) as A28,
sum(if(dataelementid=721,a.value,0)) as A29,
sum(if(dataelementid=722,a.value,0)) as A30,
sum(if(dataelementid=731,a.value,0)) as A31,
sum(if(dataelementid=725,a.value,0)) as A32,
sum(if(dataelementid=726,a.value,0)) as A33,
sum(if(dataelementid=732,a.value,0)) as A34
from dhis2_exp.datavalue a
       inner join modbas2dhis.period b on a.periodid = b.periodid
    -- inner join dhis2_exp.organisationunit c on a.sourceid = c.organisationunitid
       where periodtypeid=7
group by a.periodid, a.sourceid

=============================================================

regards

On Wed, May 13, 2009 at 12:50 PM, Ola Hodne Titlestad <olati@ifi.uio.no > <mailto:olati@ifi.uio.no>> wrote:

    HI Cintia,

    I reply to the list so that we can share this discussion with the
    rest of the community.
    The report table concept has been developed in an evolutionary way
    based on various requirements from different countries. We are happy
    to further extend it to meet your needs in Mozambique. I am not sure
    I understand your problems of periods, and not sure what you mean by
    "doesn't seem to keep the keys to link the data elements, periods
    and organization units".

    If you like you could provide us more info on this, and if possible
    a screenshot of your report, and we could try to modify report
    tables functionality to meet your needs.

    best regards,
    Ola Hodne Titlestad
    HISP
    University of Oslo

    On Wed, May 13, 2009 at 12:40 PM, Cintia Marisa > <cintia.banze@gmail.com <mailto:cintia.banze@gmail.com>> wrote:

        Hi, thanks for the help.

        I've already read the articles you sent to me.

        I'll try again, then I'll give you guys a feedback.

        I choose not use report table, mostly because of the periods.
        The problem Orvalho is having( we are having) with periods,
        make it difficult for us to create report tables.

        It, takes a long time for the table to be created, and it
        doesn't seem to keep the keys to link the data elements, periods
        and organization units as I need.

        In the reports I'm making i need to have cross tabulated data
        with org units, data elements and periods.

        I know report tables are mean to make my work easier, but i
        can't get them to provide the data the way I need.

        Thanks for the support.

        On Wed, May 13, 2009 at 11:21 AM, Ola Hodne Titlestad > <olati@ifi.uio.no <mailto:olati@ifi.uio.no>> wrote:

            Hi,

            When using standard reports (BIRT reports in DHIS 2) the
            only limitation is that you need to use the DHIS 2 database
            as your source, but within that database you can create BIRT
            datasets based on any table or view as you like. This is
            simply because DHIS replaces the database connection string
            in the BIRT design file when you upload the report. This is
            done to make sure that the data source is available.

            Still, I'm wondering why you do not want to use report
            tables? Report tables are generic and very flexible and can
            provide routine data sources for your reports that are
            automatically updated to e.g. the latest month, the last
            quarter, acculmulative values so far this year and more.You
            can also specify exactly which data elements or indicators
            to use. Furthermore, report tables also allow for report
            paremeters where you can specify which orgunit to show data
            for, or all children below a selected orgunit, and also
            which month to use, so that you can reuse your design for
            many purposes. Report tables are small and automatically
            generated datamarts that you can use out of the box while
            other data sources most liley will need some kind of manual
            update like an export to datamart or similar.

            You can read more about report tables here:
            https://answers.launchpad.net/dhis2/+question/61455
            https://answers.launchpad.net/dhis2/+faq/370

            What kind of report are you designing and what made you
            choose not to use report tables?

            best regards,
            Ola Hodne Titlestad
            HISP
            University of Oslo

            On Wed, May 13, 2009 at 10:40 AM, Murodullo Latifov > <murodlatifov@yahoo.com <mailto:murodlatifov@yahoo.com>> wrote:

                Hi Cintia,

                ------------------------------------------------------------------------
                *From:* Cintia Marisa <cintia.banze@gmail.com
                <mailto:cintia.banze@gmail.com>>
                *To:* dhis2-devs@lists.launchpad.net
                <mailto:dhis2-devs@lists.launchpad.net>
                *Sent:* Wednesday, May 13, 2009 9:22:14 AM
                *Subject:* [Dhis2-devs] Providing another source table
                for reports

                Hi all,

                I'm trying to build the reports without using the Report
                Tables tools.

                When i add new report on dhis it gives a chance to
                provide another data source different from the report
                tables (" If selecting no report table, the user is
                responsible for providing the data source table. ").

                I just don't know how to tell DHSI that I want to use
                another data source.
                Any help on how to accomplish this?

                Thanks in advance

                -- Cintia Marisa

                You can use BIRT to include your dataset. Simply create
                dataset under outline->DataSet. Simply choose "SQL
                select query" and make you sql statement on next screen,
                like "select * from yourtable where ..."

                murod

                _______________________________________________
                Mailing list: https://launchpad.net/~dhis2-devs
                <https://launchpad.net/~dhis2-devs>
                Post to : dhis2-devs@lists.launchpad.net
                <mailto:dhis2-devs@lists.launchpad.net>
                Unsubscribe : https://launchpad.net/~dhis2-devs
                <https://launchpad.net/~dhis2-devs>
                More help : https://help.launchpad.net/ListHelp

            _______________________________________________
            Mailing list: https://launchpad.net/~dhis2-devs
            <https://launchpad.net/~dhis2-devs>
            Post to : dhis2-devs@lists.launchpad.net
            <mailto:dhis2-devs@lists.launchpad.net>
            Unsubscribe : https://launchpad.net/~dhis2-devs
            <https://launchpad.net/~dhis2-devs>
            More help : https://help.launchpad.net/ListHelp

        -- Cintia Marisa

--
Cintia Marisa

------------------------------------------------------------------------

_______________________________________________
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

Hi Caveman,

In order to have BIRT do selection you need to add parameters in BIRT design. For this you have to do the following:

In outline view of BIRT there is "Report Parameters" option, create your parameters here first. You can select combobox and use another Data Set to get data, like Period.
See attached sample report with two parameters, one is typed other is dynamic from database.

regards,
murod

sample_params.rptdesign (20.4 KB)

sample_params.rptconfig (1.3 KB)

···

----- Original Message ----
From: Orvalho Joaquim Augusto <orvaquim@gmail.com>
To: Ola Hodne Titlestad <olati@ifi.uio.no>
Cc: DHIS 2 developers <dhis2-devs@lists.launchpad.net>
Sent: Wednesday, May 13, 2009 5:43:38 PM
Subject: Re: [Dhis2-devs] Providing another source table for reports

I am working with Cintia on this.

So the question is:
How can we use DHIS interfance to send the period and orgunit to BIRT? And the BIRT build a report for us.

Forgive me if am being non sense or missing to study the appropriate docs.

Thanks
Caveman

Cintia Marisa wrote:

Hi,

In attachment one of the reports I need to build, maybe it will help you guys to understand what i need.

I used the query below to get the data that i needed.

=============================================================

select a.periodid, a.sourceid, b.week, b.YR , b.startdate, b.enddate, c.name <http://c.name>,
sum(if(dataelementid=691,a.value,0)) as A1,
sum(if(dataelementid=692,a.value,0)) as A2,
sum(if(dataelementid=693,a.value,0)) as A3,
sum(if(dataelementid=694,a.value,0)) as A4,
sum(if(dataelementid=695,a.value,0)) as A5,
sum(if(dataelementid=696,a.value,0)) as A6,
sum(if(dataelementid=697,a.value,0)) as A7,
sum(if(dataelementid=698,a.value,0)) as A8,
sum(if(dataelementid=699,a.value,0)) as A9,
sum(if(dataelementid=700,a.value,0)) as A10,
sum(if(dataelementid=730,a.value,0)) as A11,
sum(if(dataelementid=727,a.value,0)) as A12,
sum(if(dataelementid=728,a.value,0)) as A13,
sum(if(dataelementid=729,a.value,0)) as A14,
sum(if(dataelementid=705,a.value,0)) as A15,
sum(if(dataelementid=706,a.value,0)) as A16,
sum(if(dataelementid=707,a.value,0)) as A17,
sum(if(dataelementid=708,a.value,0)) as A18,
sum(if(dataelementid=709,a.value,0)) as A19,
sum(if(dataelementid=710,a.value,0)) as A20,
sum(if(dataelementid=711,a.value,0)) as A21,
sum(if(dataelementid=712,a.value,0)) as A22,
sum(if(dataelementid=713,a.value,0)) as A23,
sum(if(dataelementid=714,a.value,0)) as A24,
sum(if(dataelementid=715,a.value,0)) as A25,
sum(if(dataelementid=716,a.value,0)) as A26,
sum(if(dataelementid=717,a.value,0)) as A27,
sum(if(dataelementid=718,a.value,0)) as A28,
sum(if(dataelementid=721,a.value,0)) as A29,
sum(if(dataelementid=722,a.value,0)) as A30,
sum(if(dataelementid=731,a.value,0)) as A31,
sum(if(dataelementid=725,a.value,0)) as A32,
sum(if(dataelementid=726,a.value,0)) as A33,
sum(if(dataelementid=732,a.value,0)) as A34
from dhis2_exp.datavalue a
       inner join modbas2dhis.period b on a.periodid = b.periodid
    -- inner join dhis2_exp.organisationunit c on a.sourceid = c.organisationunitid
       where periodtypeid=7
group by a.periodid, a.sourceid

=============================================================

regards

On Wed, May 13, 2009 at 12:50 PM, Ola Hodne Titlestad <olati@ifi.uio.no <mailto:olati@ifi.uio.no>> wrote:

    HI Cintia,

    I reply to the list so that we can share this discussion with the
    rest of the community.
    The report table concept has been developed in an evolutionary way
    based on various requirements from different countries. We are happy
    to further extend it to meet your needs in Mozambique. I am not sure
    I understand your problems of periods, and not sure what you mean by
    "doesn't seem to keep the keys to link the data elements, periods
    and organization units".

    If you like you could provide us more info on this, and if possible
    a screenshot of your report, and we could try to modify report
    tables functionality to meet your needs.

    best regards,
    Ola Hodne Titlestad
    HISP
    University of Oslo

    On Wed, May 13, 2009 at 12:40 PM, Cintia Marisa > <cintia.banze@gmail.com <mailto:cintia.banze@gmail.com>> wrote:

        Hi, thanks for the help.

        I've already read the articles you sent to me.

        I'll try again, then I'll give you guys a feedback.

        I choose not use report table, mostly because of the periods.
        The problem Orvalho is having( we are having) with periods,
        make it difficult for us to create report tables.

        It, takes a long time for the table to be created, and it
        doesn't seem to keep the keys to link the data elements, periods
        and organization units as I need.

        In the reports I'm making i need to have cross tabulated data
        with org units, data elements and periods.

        I know report tables are mean to make my work easier, but i
        can't get them to provide the data the way I need.

        Thanks for the support.

        On Wed, May 13, 2009 at 11:21 AM, Ola Hodne Titlestad > <olati@ifi.uio.no <mailto:olati@ifi.uio.no>> wrote:

            Hi,

            When using standard reports (BIRT reports in DHIS 2) the
            only limitation is that you need to use the DHIS 2 database
            as your source, but within that database you can create BIRT
            datasets based on any table or view as you like. This is
            simply because DHIS replaces the database connection string
            in the BIRT design file when you upload the report. This is
            done to make sure that the data source is available.

            Still, I'm wondering why you do not want to use report
            tables? Report tables are generic and very flexible and can
            provide routine data sources for your reports that are
            automatically updated to e.g. the latest month, the last
            quarter, acculmulative values so far this year and more.You
            can also specify exactly which data elements or indicators
            to use. Furthermore, report tables also allow for report
            paremeters where you can specify which orgunit to show data
            for, or all children below a selected orgunit, and also
            which month to use, so that you can reuse your design for
            many purposes. Report tables are small and automatically
            generated datamarts that you can use out of the box while
            other data sources most liley will need some kind of manual
            update like an export to datamart or similar.

            You can read more about report tables here:
           https://answers.launchpad.net/dhis2/+question/61455
           https://answers.launchpad.net/dhis2/+faq/370

            What kind of report are you designing and what made you
            choose not to use report tables?

            best regards,
            Ola Hodne Titlestad
            HISP
            University of Oslo

            On Wed, May 13, 2009 at 10:40 AM, Murodullo Latifov > <murodlatifov@yahoo.com <mailto:murodlatifov@yahoo.com>> wrote:

                Hi Cintia,

                ------------------------------------------------------------------------
                *From:* Cintia Marisa <cintia.banze@gmail.com
                <mailto:cintia.banze@gmail.com>>
                *To:* dhis2-devs@lists.launchpad.net
                <mailto:dhis2-devs@lists.launchpad.net>
                *Sent:* Wednesday, May 13, 2009 9:22:14 AM
                *Subject:* [Dhis2-devs] Providing another source table
                for reports

                Hi all,

                I'm trying to build the reports without using the Report
                Tables tools.

                When i add new report on dhis it gives a chance to
                provide another data source different from the report
                tables (" If selecting no report table, the user is
                responsible for providing the data source table. ").

                I just don't know how to tell DHSI that I want to use
                another data source.
                Any help on how to accomplish this?

                Thanks in advance

                -- Cintia Marisa

                You can use BIRT to include your dataset. Simply create
                dataset under outline->DataSet. Simply choose "SQL
                select query" and make you sql statement on next screen,
                like "select * from yourtable where ..."

                murod

                _______________________________________________
                Mailing list: https://launchpad.net/~dhis2-devs
                <https://launchpad.net/~dhis2-devs>
                Post to : dhis2-devs@lists.launchpad.net
                <mailto:dhis2-devs@lists.launchpad.net>
                Unsubscribe : https://launchpad.net/~dhis2-devs
                <https://launchpad.net/~dhis2-devs>
                More help : https://help.launchpad.net/ListHelp

            _______________________________________________
            Mailing list: https://launchpad.net/~dhis2-devs
            <https://launchpad.net/~dhis2-devs>
            Post to : dhis2-devs@lists.launchpad.net
            <mailto:dhis2-devs@lists.launchpad.net>
            Unsubscribe : https://launchpad.net/~dhis2-devs
            <https://launchpad.net/~dhis2-devs>
            More help : https://help.launchpad.net/ListHelp

        -- Cintia Marisa

-- Cintia Marisa

------------------------------------------------------------------------

_______________________________________________
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

_______________________________________________
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

Hi,

The main challenge with designing such a report in BIRT is that you need to know which data element the values belong to as the design is not a straight forward table where you could list the data elements row by row.

Normally I would not recommend BIRT at all for this report, but rather design a custom data entry form for this and then use the dataset report option to view the report. That would also give you the possibility of entering data using the same form. Simply set up a dataset with the data elements you need and then design the form using the built in editor in DHIS2.

If you want to use BIRT the easiest way would be to select exactly the data elements you need and then crosstab them so that the columns names would correspond to data element names. It is not very intuitive for a new report designer to use the codes A1-34 as you do with your query and data element shortnames as columns would be much easier. In report tables you can do this by selecting data elements as one of the cross-tabbed dimensions and then select the data elements you need. Since this is a weekly bulletin/report we need to add a reporting week parameter as well as a new relative period called reporting week. That can be done. For now you could test to do the same report by using a static period (one given week) and orgunit with parameter in repor table and then use this table in BIRT.

best regards,
Ola Hodne Titlestad
HISP
University of Oslo

···

On Wed, May 13, 2009 at 4:39 PM, Cintia Marisa cintia.banze@gmail.com wrote:

Hi,

In attachment one of the reports I need to build, maybe it will help you guys to understand what i need.

I used the query below to get the data that i needed.

=============================================================

select a.periodid, a.sourceid, b.week, b.YR , b.startdate, b.enddate, c.name,
sum(if(dataelementid=691,a.value,0)) as A1,
sum(if(dataelementid=692,a.value,0)) as A2,

sum(if(dataelementid=693,a.value,0)) as A3,

sum(if(dataelementid=694,a.value,0)) as A4,
sum(if(dataelementid=695,a.value,0)) as A5,
sum(if(dataelementid=696,a.value,0)) as A6,
sum(if(dataelementid=697,a.value,0)) as A7,
sum(if(dataelementid=698,a.value,0)) as A8,

sum(if(dataelementid=699,a.value,0)) as A9,
sum(if(dataelementid=700,a.value,0)) as A10,
sum(if(dataelementid=730,a.value,0)) as A11,
sum(if(dataelementid=727,a.value,0)) as A12,
sum(if(dataelementid=728,a.value,0)) as A13,

sum(if(dataelementid=729,a.value,0)) as A14,
sum(if(dataelementid=705,a.value,0)) as A15,
sum(if(dataelementid=706,a.value,0)) as A16,
sum(if(dataelementid=707,a.value,0)) as A17,
sum(if(dataelementid=708,a.value,0)) as A18,

sum(if(dataelementid=709,a.value,0)) as A19,
sum(if(dataelementid=710,a.value,0)) as A20,
sum(if(dataelementid=711,a.value,0)) as A21,
sum(if(dataelementid=712,a.value,0)) as A22,
sum(if(dataelementid=713,a.value,0)) as A23,

sum(if(dataelementid=714,a.value,0)) as A24,
sum(if(dataelementid=715,a.value,0)) as A25,
sum(if(dataelementid=716,a.value,0)) as A26,
sum(if(dataelementid=717,a.value,0)) as A27,
sum(if(dataelementid=718,a.value,0)) as A28,

sum(if(dataelementid=721,a.value,0)) as A29,
sum(if(dataelementid=722,a.value,0)) as A30,
sum(if(dataelementid=731,a.value,0)) as A31,
sum(if(dataelementid=725,a.value,0)) as A32,
sum(if(dataelementid=726,a.value,0)) as A33,

sum(if(dataelementid=732,a.value,0)) as A34
from dhis2_exp.datavalue a
inner join modbas2dhis.period b on a.periodid = b.periodid
– inner join dhis2_exp.organisationunit c on a.sourceid = c.organisationunitid

   where periodtypeid=7

group by a.periodid, a.sourceid

=============================================================

regards

On Wed, May 13, 2009 at 12:50 PM, Ola Hodne Titlestad olati@ifi.uio.no wrote:

HI Cintia,

I reply to the list so that we can share this discussion with the rest of the community.

The report table concept has been developed in an evolutionary way based on various requirements from different countries. We are happy to further extend it to meet your needs in Mozambique. I am not sure I understand your problems of periods, and not sure what you mean by “doesn’t seem to keep the keys to link the data elements, periods and organization units”.

If you like you could provide us more info on this, and if possible a screenshot of your report, and we could try to modify report tables functionality to meet your needs.

best regards,

Ola Hodne Titlestad

HISP
University of Oslo

On Wed, May 13, 2009 at 12:40 PM, Cintia Marisa cintia.banze@gmail.com wrote:

Hi, thanks for the help.

I’ve already read the articles you sent to me.

I’ll try again, then I’ll give you guys a feedback.

I choose not use report table, mostly because of the periods. The problem Orvalho is having( we are having) with periods, make it difficult for us to create report tables.

It, takes a long time for the table to be created, and it doesn’t seem to keep the keys to link the data elements, periods and organization units as I need.

In the reports I’m making i need to have cross tabulated data with org units, data elements and periods.

I know report tables are mean to make my work easier, but i can’t get them to provide the data the way I need.

Thanks for the support.

On Wed, May 13, 2009 at 11:21 AM, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Hi,

When using standard reports (BIRT reports in DHIS 2) the only limitation is that you need to use the DHIS 2 database as your source, but within that database you can create BIRT datasets based on any table or view as you like. This is simply because DHIS replaces the database connection string in the BIRT design file when you upload the report. This is done to make sure that the data source is available.

Still, I’m wondering why you do not want to use report tables? Report tables are generic and very flexible and can provide routine data sources for your reports that are automatically updated to e.g. the latest month, the last quarter, acculmulative values so far this year and more.You can also specify exactly which data elements or indicators to use. Furthermore, report tables also allow for report paremeters where you can specify which orgunit to show data for, or all children below a selected orgunit, and also which month to use, so that you can reuse your design for many purposes. Report tables are small and automatically generated datamarts that you can use out of the box while other data sources most liley will need some kind of manual update like an export to datamart or similar.

You can read more about report tables here:
https://answers.launchpad.net/dhis2/+question/61455
https://answers.launchpad.net/dhis2/+faq/370

What kind of report are you designing and what made you choose not to use report tables?

best regards,
Ola Hodne Titlestad
HISP
University of Oslo

On Wed, May 13, 2009 at 10:40 AM, Murodullo Latifov murodlatifov@yahoo.com wrote:

Hi Cintia,


From: Cintia Marisa cintia.banze@gmail.com
To: dhis2-devs@lists.launchpad.net

Sent: Wednesday, May 13, 2009 9:22:14 AM
Subject: [Dhis2-devs] Providing another source table for reports

Hi all,

I’m trying to build the reports without using the Report Tables tools.

When i add new report on dhis it gives a chance to provide another data source different from the report tables (" If selecting no report table, the user is responsible for providing the data source table. ").

I just don’t know how to tell DHSI that I want to use another data source.
Any help on how to accomplish this?

Thanks in advance


Cintia Marisa

You can use BIRT to include your dataset. Simply create dataset under outline->DataSet. Simply choose “SQL select query” and make you sql statement on next screen, like “select * from yourtable where …”

murod


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


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


Cintia Marisa


Cintia Marisa

Hi,

Ola Hodne Titlestad wrote:

Hi,

The main challenge with designing such a report in BIRT is that you need to know which data element the values belong to as the design is not a straight forward table where you could list the data elements row by row.

Yes you are right but that exercise has been done in order to move data from the actual non dhis system.

Normally I would not recommend BIRT at all for this report, but rather design a custom data entry form for this and then use the dataset report option to view the report. That would also give you the possibility of entering data using the same form. Simply set up a dataset with the data elements you need and then design the form using the built in editor in DHIS2.

Fine.

If you want to use BIRT the easiest way would be to select exactly the data elements you need and then crosstab them so that the columns names would correspond to data element names. It is not very intuitive for a new report designer to use the codes A1-34 as you do with your query and data element shortnames as columns would be much easier. In report tables you can do this by selecting data elements as one of the cross-tabbed dimensions and then select the data elements you need. Since this is a weekly bulletin/report we need to add a reporting week parameter as well as a new relative period called reporting week. That can be done. For now you could test to do the same report by using a static period (one given week) and orgunit with parameter in repor table and then use this table in BIRT.

The A1-34 are not an accident invetion. The actual System uses that. So we are keeping that way. The actual system is the source for data until the migration ends. We want use DHIS. So we will not do another entering application.

Yeah, we need week as entering parameter. We gonna test the ideias from Murodullo. We will come here to tell what happend on the lab explosion :slight_smile:

I do not know other way to say Thanks for your support so I say Thanks a lot
Caveman

···

best regards,
Ola Hodne Titlestad
HISP
University of Oslo

On Wed, May 13, 2009 at 4:39 PM, Cintia Marisa <cintia.banze@gmail.com > <mailto:cintia.banze@gmail.com>> wrote:

    Hi,

    In attachment one of the reports I need to build, maybe it will help
    you guys to understand what i need.

    I used the query below to get the data that i needed.

    =============================================================

    select a.periodid, a.sourceid, b.week, b.YR , b.startdate,
    b.enddate, c.name <http://c.name>,
     sum(if(dataelementid=691,a.value,0)) as A1,
     sum(if(dataelementid=692,a.value,0)) as A2,
     sum(if(dataelementid=693,a.value,0)) as A3,
     sum(if(dataelementid=694,a.value,0)) as A4,
     sum(if(dataelementid=695,a.value,0)) as A5,
     sum(if(dataelementid=696,a.value,0)) as A6,
     sum(if(dataelementid=697,a.value,0)) as A7,
     sum(if(dataelementid=698,a.value,0)) as A8,
     sum(if(dataelementid=699,a.value,0)) as A9,
     sum(if(dataelementid=700,a.value,0)) as A10,
     sum(if(dataelementid=730,a.value,0)) as A11,
     sum(if(dataelementid=727,a.value,0)) as A12,
     sum(if(dataelementid=728,a.value,0)) as A13,
     sum(if(dataelementid=729,a.value,0)) as A14,
     sum(if(dataelementid=705,a.value,0)) as A15,
     sum(if(dataelementid=706,a.value,0)) as A16,
     sum(if(dataelementid=707,a.value,0)) as A17,
     sum(if(dataelementid=708,a.value,0)) as A18,
     sum(if(dataelementid=709,a.value,0)) as A19,
     sum(if(dataelementid=710,a.value,0)) as A20,
     sum(if(dataelementid=711,a.value,0)) as A21,
     sum(if(dataelementid=712,a.value,0)) as A22,
     sum(if(dataelementid=713,a.value,0)) as A23,
     sum(if(dataelementid=714,a.value,0)) as A24,
     sum(if(dataelementid=715,a.value,0)) as A25,
     sum(if(dataelementid=716,a.value,0)) as A26,
     sum(if(dataelementid=717,a.value,0)) as A27,
     sum(if(dataelementid=718,a.value,0)) as A28,
     sum(if(dataelementid=721,a.value,0)) as A29,
     sum(if(dataelementid=722,a.value,0)) as A30,
     sum(if(dataelementid=731,a.value,0)) as A31,
     sum(if(dataelementid=725,a.value,0)) as A32,
     sum(if(dataelementid=726,a.value,0)) as A33,
     sum(if(dataelementid=732,a.value,0)) as A34
     from dhis2_exp.datavalue a
           inner join modbas2dhis.period b on a.periodid = b.periodid
        -- inner join dhis2_exp.organisationunit c on a.sourceid =
    c.organisationunitid
           where periodtypeid=7
     group by a.periodid, a.sourceid

    =============================================================

    regards

    On Wed, May 13, 2009 at 12:50 PM, Ola Hodne Titlestad > <olati@ifi.uio.no <mailto:olati@ifi.uio.no>> wrote:

        HI Cintia,

        I reply to the list so that we can share this discussion with
        the rest of the community.
        The report table concept has been developed in an evolutionary
        way based on various requirements from different countries. We
        are happy to further extend it to meet your needs in Mozambique.
        I am not sure I understand your problems of periods, and not
        sure what you mean by "doesn't seem to keep the keys to link the
        data elements, periods and organization units".

        If you like you could provide us more info on this, and if
        possible a screenshot of your report, and we could try to modify
        report tables functionality to meet your needs.

        best regards,
        Ola Hodne Titlestad
        HISP
        University of Oslo

        On Wed, May 13, 2009 at 12:40 PM, Cintia Marisa > <cintia.banze@gmail.com <mailto:cintia.banze@gmail.com>> wrote:

            Hi, thanks for the help.

            I've already read the articles you sent to me.

            I'll try again, then I'll give you guys a feedback.

            I choose not use report table, mostly because of the
            periods. The problem Orvalho is having( we are having) with periods, make it difficult for us to create report tables.

            It, takes a long time for the table to be created, and it
            doesn't seem to keep the keys to link the data elements,
            periods and organization units as I need.

            In the reports I'm making i need to have cross tabulated
            data with org units, data elements and periods.

            I know report tables are mean to make my work easier, but i
            can't get them to provide the data the way I need.

            Thanks for the support.

            On Wed, May 13, 2009 at 11:21 AM, Ola Hodne Titlestad > <olati@ifi.uio.no <mailto:olati@ifi.uio.no>> wrote:

                Hi,

                When using standard reports (BIRT reports in DHIS 2) the
                only limitation is that you need to use the DHIS 2
                database as your source, but within that database you
                can create BIRT datasets based on any table or view as
                you like. This is simply because DHIS replaces the
                database connection string in the BIRT design file when
                you upload the report. This is done to make sure that
                the data source is available.

                Still, I'm wondering why you do not want to use report
                tables? Report tables are generic and very flexible and
                can provide routine data sources for your reports that
                are automatically updated to e.g. the latest month, the
                last quarter, acculmulative values so far this year and
                more.You can also specify exactly which data elements or
                indicators to use. Furthermore, report tables also allow
                for report paremeters where you can specify which
                orgunit to show data for, or all children below a
                selected orgunit, and also which month to use, so that
                you can reuse your design for many purposes. Report
                tables are small and automatically generated datamarts
                that you can use out of the box while other data sources
                most liley will need some kind of manual update like an
                export to datamart or similar.

                You can read more about report tables here:
                https://answers.launchpad.net/dhis2/+question/61455
                https://answers.launchpad.net/dhis2/+faq/370

                What kind of report are you designing and what made you
                choose not to use report tables?

                best regards,
                Ola Hodne Titlestad
                HISP
                University of Oslo

                On Wed, May 13, 2009 at 10:40 AM, Murodullo Latifov > <murodlatifov@yahoo.com <mailto:murodlatifov@yahoo.com>> > wrote:

                    Hi Cintia,

                    ------------------------------------------------------------------------
                    *From:* Cintia Marisa <cintia.banze@gmail.com
                    <mailto:cintia.banze@gmail.com>>
                    *To:* dhis2-devs@lists.launchpad.net
                    <mailto:dhis2-devs@lists.launchpad.net>
                    *Sent:* Wednesday, May 13, 2009 9:22:14 AM
                    *Subject:* [Dhis2-devs] Providing another source
                    table for reports

                    Hi all,

                    I'm trying to build the reports without using the
                    Report Tables tools.

                    When i add new report on dhis it gives a chance to
                    provide another data source different from the
                    report tables (" If selecting no report table, the
                    user is responsible for providing the data source
                    table. ").

                    I just don't know how to tell DHSI that I want to
                    use another data source.
                    Any help on how to accomplish this?

                    Thanks in advance

                    -- Cintia Marisa

                    You can use BIRT to include your dataset. Simply
                    create dataset under outline->DataSet. Simply choose
                    "SQL select query" and make you sql statement on
                    next screen, like "select * from yourtable where ..."

                    murod

                    _______________________________________________
                    Mailing list: https://launchpad.net/~dhis2-devs
                    <https://launchpad.net/~dhis2-devs>
                    Post to : dhis2-devs@lists.launchpad.net
                    <mailto:dhis2-devs@lists.launchpad.net>
                    Unsubscribe : https://launchpad.net/~dhis2-devs
                    <https://launchpad.net/~dhis2-devs>
                    More help : https://help.launchpad.net/ListHelp

                _______________________________________________
                Mailing list: https://launchpad.net/~dhis2-devs
                <https://launchpad.net/~dhis2-devs>
                Post to : dhis2-devs@lists.launchpad.net
                <mailto:dhis2-devs@lists.launchpad.net>
                Unsubscribe : https://launchpad.net/~dhis2-devs
                <https://launchpad.net/~dhis2-devs>
                More help : https://help.launchpad.net/ListHelp

            -- Cintia Marisa

    -- Cintia Marisa

------------------------------------------------------------------------

_______________________________________________
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

Hi all,
1st
Thank u guys for the help.

2nd
Murod,

Thanks for the samples you sent, they were helpful.

But still, even with the samples you sent to me, when I try to upload and view the report in DHIS I get “no report design available” error.

Here’s the log:

···

====================================================

  • INFO 09:06:38,359 All startup routines done (DefaultStartupRoutineExecutor.java [Thread-1])

  • INFO 09:38:51,875 Upload file name: sample_params.rptdesign, content type: application/octet-stream (AddReportAction.java [http-8080-1])

  • INFO 09:38:51,875 New file: C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\birt-viewer\sample_params.rptdesign (AddReportAction.java [http-8080-1])

  • INFO 09:38:51,890 Report connection URL: jdbc:mysql://localhost/dhis2_exp?useUnicode=true&characterEncoding=UTF-8 (AddReportAction.java [http-8080-1])

org.eclipse.birt.report.exception.ViewerException: There is no report design object available.
at org.eclipse.birt.report.context.ViewerAttributeBean.__init(ViewerAttributeBean.java:233)
at org.eclipse.birt.report.context.BaseAttributeBean.init(BaseAttributeBean.java:233)

at org.eclipse.birt.report.context.ViewerAttributeBean.<init>(ViewerAttributeBean.java:116)
at org.eclipse.birt.report.context.BirtContext.__init(BirtContext.java:44)
at org.eclipse.birt.report.context.BaseContext.<init>(BaseContext.java:69)

at org.eclipse.birt.report.context.BirtContext.<init>(BirtContext.java:30)
at org.eclipse.birt.report.servlet.ViewerServlet.__getContext(ViewerServlet.java:150)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doGet(BirtSoapMessageDispatcherServlet.java:151)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)

====================================================

The error disappears if I upLoad the design without choose in BIRT a data source. But by doing that i got no data displayed.

On Wed, May 13, 2009 at 10:17 PM, Orvalho Joaquim Augusto orvaquim@gmail.com wrote:

Hi,

Ola Hodne Titlestad wrote:

Hi,

The main challenge with designing such a report in BIRT is that you need to know which data element the values belong to as the design is not a straight forward table where you could list the data elements row by row.

Yes you are right but that exercise has been done in order to move data from the actual non dhis system.

Normally I would not recommend BIRT at all for this report, but rather design a custom data entry form for this and then use the dataset report option to view the report. That would also give you the possibility of entering data using the same form. Simply set up a dataset with the data elements you need and then design the form using the built in editor in DHIS2.

Fine.

If you want to use BIRT the easiest way would be to select exactly the data elements you need and then crosstab them so that the columns names would correspond to data element names. It is not very intuitive for a new report designer to use the codes A1-34 as you do with your query and data element shortnames as columns would be much easier. In report tables you can do this by selecting data elements as one of the cross-tabbed dimensions and then select the data elements you need. Since this is a weekly bulletin/report we need to add a reporting week parameter as well as a new relative period called reporting week. That can be done. For now you could test to do the same report by using a static period (one given week) and orgunit with parameter in repor table and then use this table in BIRT.

The A1-34 are not an accident invetion. The actual System uses that. So we are keeping that way. The actual system is the source for data until the migration ends. We want use DHIS. So we will not do another entering application.

Yeah, we need week as entering parameter. We gonna test the ideias from Murodullo. We will come here to tell what happend on the lab explosion :slight_smile:

I do not know other way to say Thanks for your support so I say Thanks a lot

Caveman

best regards,

Ola Hodne Titlestad

HISP

University of Oslo

On Wed, May 13, 2009 at 4:39 PM, Cintia Marisa <cintia.banze@gmail.com mailto:cintia.banze@gmail.com> wrote:

Hi,



In attachment one of the reports I need to build, maybe it will help

you guys to understand what i need.



I used the query below to get the data that i needed.





=============================================================



select a.periodid, a.sourceid, b.week, b.YR , b.startdate,

b.enddate, c.name <http://c.name>,

 sum(if(dataelementid=691,a.value,0)) as A1,

 sum(if(dataelementid=692,a.value,0)) as A2,

 sum(if(dataelementid=693,a.value,0)) as A3,

 sum(if(dataelementid=694,a.value,0)) as A4,

 sum(if(dataelementid=695,a.value,0)) as A5,

 sum(if(dataelementid=696,a.value,0)) as A6,

 sum(if(dataelementid=697,a.value,0)) as A7,

 sum(if(dataelementid=698,a.value,0)) as A8,

 sum(if(dataelementid=699,a.value,0)) as A9,

 sum(if(dataelementid=700,a.value,0)) as A10,

 sum(if(dataelementid=730,a.value,0)) as A11,

 sum(if(dataelementid=727,a.value,0)) as A12,

 sum(if(dataelementid=728,a.value,0)) as A13,

 sum(if(dataelementid=729,a.value,0)) as A14,

 sum(if(dataelementid=705,a.value,0)) as A15,

 sum(if(dataelementid=706,a.value,0)) as A16,

 sum(if(dataelementid=707,a.value,0)) as A17,

 sum(if(dataelementid=708,a.value,0)) as A18,

 sum(if(dataelementid=709,a.value,0)) as A19,

 sum(if(dataelementid=710,a.value,0)) as A20,

 sum(if(dataelementid=711,a.value,0)) as A21,

 sum(if(dataelementid=712,a.value,0)) as A22,

 sum(if(dataelementid=713,a.value,0)) as A23,

 sum(if(dataelementid=714,a.value,0)) as A24,

 sum(if(dataelementid=715,a.value,0)) as A25,

 sum(if(dataelementid=716,a.value,0)) as A26,

 sum(if(dataelementid=717,a.value,0)) as A27,

 sum(if(dataelementid=718,a.value,0)) as A28,

 sum(if(dataelementid=721,a.value,0)) as A29,

 sum(if(dataelementid=722,a.value,0)) as A30,

 sum(if(dataelementid=731,a.value,0)) as A31,

 sum(if(dataelementid=725,a.value,0)) as A32,

 sum(if(dataelementid=726,a.value,0)) as A33,

 sum(if(dataelementid=732,a.value,0)) as A34

 from dhis2_exp.datavalue a

       inner join modbas2dhis.period b on a.periodid = b.periodid

    --   inner join dhis2_exp.organisationunit c on a.sourceid =

c.organisationunitid

       where periodtypeid=7

 group by a.periodid, a.sourceid



=============================================================



regards







On Wed, May 13, 2009 at 12:50 PM, Ola Hodne Titlestad > > <olati@ifi.uio.no <mailto:olati@ifi.uio.no>> wrote:



    HI Cintia,



    I reply to the list so that we can share this discussion with

    the rest of the community.

    The report table concept has been developed in an evolutionary

    way based on various requirements from different countries. We

    are happy to further extend it to meet your needs in Mozambique.

    I am not sure I understand your problems of periods, and not

    sure what you mean by "doesn't seem to keep the keys to link the

    data elements, periods and organization units".



    If you like you could provide us more info on this, and if

    possible a screenshot of your report, and we could try to modify

    report tables functionality to meet your needs.





    best regards,

    Ola Hodne Titlestad

    HISP

    University of Oslo





    On Wed, May 13, 2009 at 12:40 PM, Cintia Marisa > > <cintia.banze@gmail.com <mailto:cintia.banze@gmail.com>> wrote:



        Hi, thanks for the help.



        I've already read the articles you sent to me.



        I'll try again, then I'll give you guys a feedback.



        I choose not use report table, mostly because of the

        periods. The problem Orvalho is having( we are  having)            with periods, make it difficult for us to create report tables.



        It, takes a long time for the table to be created, and it

        doesn't seem to keep the keys to link the data elements,

        periods and organization units as I need.



        In the reports I'm making i need to have cross tabulated

        data with org units, data elements and periods.



        I know report tables are mean to make my work easier, but i

        can't get them to provide the data the way I need.



        Thanks for the support.









                          

        On Wed, May 13, 2009 at 11:21 AM, Ola Hodne Titlestad > > <olati@ifi.uio.no <mailto:olati@ifi.uio.no>> wrote:



            Hi,



            When using standard reports (BIRT reports in DHIS 2) the

            only limitation is that you need to use the DHIS 2

            database as your source, but within that database you

            can create BIRT datasets based on any table or view as

            you like. This is simply because DHIS replaces the

            database connection string in the BIRT design file when

            you upload the report. This is done to make sure that

            the data source is available.



            Still, I'm wondering why you do not want to use report

            tables? Report tables are generic and very flexible and

            can provide routine data sources for your reports that

            are automatically updated to e.g. the latest month, the

            last quarter, acculmulative values so far this year and

            more.You can also specify exactly which data elements or

            indicators to use. Furthermore, report tables also allow

            for report paremeters where you can specify which

            orgunit to show data for, or all children below a

            selected orgunit, and also which month to use, so that

            you can reuse your design for many purposes. Report

            tables are small and automatically generated datamarts

            that you can use out of the box while other data sources

            most liley will need some kind of manual update like an

            export to datamart or similar.



            You can read more about report tables here:

            [https://answers.launchpad.net/dhis2/+question/61455](https://answers.launchpad.net/dhis2/+question/61455)

            [https://answers.launchpad.net/dhis2/+faq/370](https://answers.launchpad.net/dhis2/+faq/370)





            What kind of report are you designing and what made you

            choose not to use report tables?



            best regards,

            Ola Hodne Titlestad

            HISP

            University of Oslo





            On Wed, May 13, 2009 at 10:40 AM, Murodullo Latifov

<murodlatifov@yahoo.com mailto:murodlatifov@yahoo.com>

            wrote:



                Hi Cintia,



                ------------------------------------------------------------------------

                *From:* Cintia Marisa <cintia.banze@gmail.com

mailto:cintia.banze@gmail.com>

                *To:* dhis2-devs@lists.launchpad.net

mailto:dhis2-devs@lists.launchpad.net

                *Sent:* Wednesday, May 13, 2009 9:22:14 AM

                *Subject:* [Dhis2-devs] Providing another source

                table for reports



                Hi all,



                I'm trying to build the reports without using the

                Report Tables tools.



                When i add new report on dhis it gives a chance to

                provide another data source different from the

                report tables (" If selecting no report table, the

                user is responsible for providing the data source

                table. ").



                I just don't know how to tell DHSI that I want to

                use another data source.

                Any help on how to accomplish this?



                Thanks in advance



                --                    Cintia Marisa



                You can use BIRT to include your dataset. Simply

                create dataset under outline->DataSet. Simply choose

                "SQL select query" and make you sql statement on

                next screen, like "select * from yourtable where ..."



                murod









                _______________________________________________

                Mailing list: [https://launchpad.net/~dhis2-devs](https://launchpad.net/%7Edhis2-devs)

<https://launchpad.net/%7Edhis2-devs>

                Post to     : dhis2-devs@lists.launchpad.net

mailto:dhis2-devs@lists.launchpad.net

                Unsubscribe : [https://launchpad.net/~dhis2-devs](https://launchpad.net/%7Edhis2-devs)

<https://launchpad.net/%7Edhis2-devs>

                More help   : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)







            _______________________________________________

            Mailing list: [https://launchpad.net/~dhis2-devs](https://launchpad.net/%7Edhis2-devs)

<https://launchpad.net/%7Edhis2-devs>

            Post to     : dhis2-devs@lists.launchpad.net

mailto:dhis2-devs@lists.launchpad.net

            Unsubscribe : [https://launchpad.net/~dhis2-devs](https://launchpad.net/%7Edhis2-devs)

<https://launchpad.net/%7Edhis2-devs>

            More help   : [https://help.launchpad.net/ListHelp](https://help.launchpad.net/ListHelp)









        --            Cintia Marisa











--    Cintia Marisa


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


Cintia Marisa

Just a guess, but this reminds me of version incompatibility issues we have had before. I think your BIRT viewer and Murod’s deisgner (since he designed the report) are different versions.

Have you tried your BIRT viewer with reports designed with the same version? Try open Murod’s report in your report designer and preview it there and see what happens.
I am using BIRT v. 2.3 for both designer and viewer.

Ola

···

On Fri, May 15, 2009 at 10:26 AM, Cintia Marisa cintia.banze@gmail.com wrote:

Hi all,
1st
Thank u guys for the help.

2nd
Murod,

Thanks for the samples you sent, they were helpful.

But still, even with the samples you sent to me, when I try to upload and view the report in DHIS I get “no report design available” error.

Here’s the log:

====================================================

  • INFO 09:06:38,359 All startup routines done (DefaultStartupRoutineExecutor.java [Thread-1])

  • INFO 09:38:51,875 Upload file name: sample_params.rptdesign, content type: application/octet-stream (AddReportAction.java [http-8080-1])

  • INFO 09:38:51,875 New file: C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\birt-viewer\sample_params.rptdesign (AddReportAction.java [http-8080-1])

  • INFO 09:38:51,890 Report connection URL: jdbc:mysql://localhost/dhis2_exp?useUnicode=true&characterEncoding=UTF-8 (AddReportAction.java [http-8080-1])

org.eclipse.birt.report.exception.ViewerException: There is no report design object available.
at org.eclipse.birt.report.context.ViewerAttributeBean.__init(ViewerAttributeBean.java:233)
at org.eclipse.birt.report.context.BaseAttributeBean.init(BaseAttributeBean.java:233)

at org.eclipse.birt.report.context.ViewerAttributeBean.<init>(ViewerAttributeBean.java:116)
at org.eclipse.birt.report.context.BirtContext.__init(BirtContext.java:44)
at org.eclipse.birt.report.context.BaseContext.<init>(BaseContext.java:69)


at org.eclipse.birt.report.context.BirtContext.<init>(BirtContext.java:30)
at org.eclipse.birt.report.servlet.ViewerServlet.__getContext(ViewerServlet.java:150)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doGet(BirtSoapMessageDispatcherServlet.java:151)


at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)


at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)


at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)


at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)


at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)


at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)


at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)

====================================================

The error disappears if I upLoad the design without choose in BIRT a data source. But by doing that i got no data displayed.


Hi Cintia,

Remember to use Reply-all to make sure the list gets you reply as well.

So it’s not a BIRT viewer/designer incompatibility issue.

Does BIRT work inside DHIS at all? I mean if you create a report in BIRT based on a report table in DHIS and then upload the design, link to report table, and run the report. Still the same problem then?

best regards,
Ola Hodne Titlestad
HISP
University of Oslo

···

On Fri, May 15, 2009 at 12:19 PM, Cintia Marisa cintia.banze@gmail.com wrote:

I’ve checked, and it’s not a version incompatibility issue. It happens with my designs too.

Both my BIRT designer and viewer are the same version.

On Fri, May 15, 2009 at 12:14 PM, Ola Hodne Titlestad olati@ifi.uio.no wrote:

On Fri, May 15, 2009 at 10:26 AM, Cintia Marisa cintia.banze@gmail.com wrote:

Hi all,
1st
Thank u guys for the help.

2nd
Murod,

Thanks for the samples you sent, they were helpful.

But still, even with the samples you sent to me, when I try to upload and view the report in DHIS I get “no report design available” error.

Here’s the log:

====================================================

  • INFO 09:06:38,359 All startup routines done (DefaultStartupRoutineExecutor.java [Thread-1])

  • INFO 09:38:51,875 Upload file name: sample_params.rptdesign, content type: application/octet-stream (AddReportAction.java [http-8080-1])

  • INFO 09:38:51,875 New file: C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\birt-viewer\sample_params.rptdesign (AddReportAction.java [http-8080-1])

  • INFO 09:38:51,890 Report connection URL: jdbc:mysql://localhost/dhis2_exp?useUnicode=true&characterEncoding=UTF-8 (AddReportAction.java [http-8080-1])

org.eclipse.birt.report.exception.ViewerException: There is no report design object available.
at org.eclipse.birt.report.context.ViewerAttributeBean.__init(ViewerAttributeBean.java:233)
at org.eclipse.birt.report.context.BaseAttributeBean.init(BaseAttributeBean.java:233)

at org.eclipse.birt.report.context.ViewerAttributeBean.<init>(ViewerAttributeBean.java:116)
at org.eclipse.birt.report.context.BirtContext.__init(BirtContext.java:44)
at org.eclipse.birt.report.context.BaseContext.<init>(BaseContext.java:69)




at org.eclipse.birt.report.context.BirtContext.<init>(BirtContext.java:30)
at org.eclipse.birt.report.servlet.ViewerServlet.__getContext(ViewerServlet.java:150)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doGet(BirtSoapMessageDispatcherServlet.java:151)




at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)




at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)




at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)




at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)




at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)




at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)




at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)

====================================================

The error disappears if I upLoad the design without choose in BIRT a data source. But by doing that i got no data displayed.

Just a guess, but this reminds me of version incompatibility issues we have had before. I think your BIRT viewer and Murod’s deisgner (since he designed the report) are different versions.

Have you tried your BIRT viewer with reports designed with the same version? Try open Murod’s report in your report designer and preview it there and see what happens.
I am using BIRT v. 2.3 for both designer and viewer.

Ola


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


Cintia Marisa

Hi,

Sorry, about the reply thing. I keep forgetting.

And no, that doesn’t happen with report tables. The report work just fine, with a report table. the problem is when I use another source table.

···

On Fri, May 15, 2009 at 12:55 PM, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Hi Cintia,

Remember to use Reply-all to make sure the list gets you reply as well.

So it’s not a BIRT viewer/designer incompatibility issue.

Does BIRT work inside DHIS at all? I mean if you create a report in BIRT based on a report table in DHIS and then upload the design, link to report table, and run the report. Still the same problem then?

best regards,
Ola Hodne Titlestad
HISP
University of Oslo

On Fri, May 15, 2009 at 12:19 PM, Cintia Marisa cintia.banze@gmail.com wrote:

I’ve checked, and it’s not a version incompatibility issue. It happens with my designs too.

Both my BIRT designer and viewer are the same version.

On Fri, May 15, 2009 at 12:14 PM, Ola Hodne Titlestad olati@ifi.uio.no wrote:

On Fri, May 15, 2009 at 10:26 AM, Cintia Marisa cintia.banze@gmail.com wrote:

Hi all,
1st
Thank u guys for the help.

2nd
Murod,

Thanks for the samples you sent, they were helpful.

But still, even with the samples you sent to me, when I try to upload and view the report in DHIS I get “no report design available” error.

Here’s the log:

====================================================

  • INFO 09:06:38,359 All startup routines done (DefaultStartupRoutineExecutor.java [Thread-1])

  • INFO 09:38:51,875 Upload file name: sample_params.rptdesign, content type: application/octet-stream (AddReportAction.java [http-8080-1])

  • INFO 09:38:51,875 New file: C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\birt-viewer\sample_params.rptdesign (AddReportAction.java [http-8080-1])

  • INFO 09:38:51,890 Report connection URL: jdbc:mysql://localhost/dhis2_exp?useUnicode=true&characterEncoding=UTF-8 (AddReportAction.java [http-8080-1])

org.eclipse.birt.report.exception.ViewerException: There is no report design object available.
at org.eclipse.birt.report.context.ViewerAttributeBean.__init(ViewerAttributeBean.java:233)
at org.eclipse.birt.report.context.BaseAttributeBean.init(BaseAttributeBean.java:233)

at org.eclipse.birt.report.context.ViewerAttributeBean.<init>(ViewerAttributeBean.java:116)
at org.eclipse.birt.report.context.BirtContext.__init(BirtContext.java:44)
at org.eclipse.birt.report.context.BaseContext.<init>(BaseContext.java:69)





at org.eclipse.birt.report.context.BirtContext.<init>(BirtContext.java:30)
at org.eclipse.birt.report.servlet.ViewerServlet.__getContext(ViewerServlet.java:150)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doGet(BirtSoapMessageDispatcherServlet.java:151)





at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)





at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)





at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)





at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)





at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)





at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)





at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)

====================================================

The error disappears if I upLoad the design without choose in BIRT a data source. But by doing that i got no data displayed.

Just a guess, but this reminds me of version incompatibility issues we have had before. I think your BIRT viewer and Murod’s deisgner (since he designed the report) are different versions.

Have you tried your BIRT viewer with reports designed with the same version? Try open Murod’s report in your report designer and preview it there and see what happens.
I am using BIRT v. 2.3 for both designer and viewer.

Ola


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


Cintia Marisa


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


Cintia Marisa

Sure,
In attachment the design.

c03.rptdesign (145 KB)

···

On Mon, May 18, 2009 at 9:19 AM, Murodullo Latifov murodlatifov@yahoo.com wrote:

Hi Cintia,

Could you please send me your report file?

regards,
murod


From: Cintia Marisa cintia.banze@gmail.com
To: Ola Hodne Titlestad olati@ifi.uio.no

Cc: DHIS 2 developers dhis2-devs@lists.launchpad.net
Sent: Friday, May 15, 2009 3:52:31 PM

Subject: Re: [Dhis2-devs] Providing another source table for reports

Hi,

Sorry, about the reply thing. I keep forgetting.

And no, that doesn’t happen with report tables. The report work just fine, with a report table. the problem is when I use another source table.

On Fri, May 15, 2009 at 12:55 PM, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Hi Cintia,

Remember to use Reply-all to make sure the list gets you reply as well.

So it’s not a BIRT viewer/designer incompatibility issue.

Does BIRT work inside DHIS at all? I mean if you create a report in BIRT based on a report table in DHIS and then upload the design, link to report table, and run the report. Still the same problem then?

best regards,
Ola Hodne Titlestad
HISP
University of Oslo

On Fri, May 15, 2009 at 12:19 PM, Cintia Marisa cintia.banze@gmail.com wrote:

I’ve checked, and it’s not a version incompatibility issue. It happens with my designs too.

Both my BIRT designer and viewer are the same version.

On Fri, May 15, 2009 at 12:14 PM, Ola Hodne Titlestad olati@ifi.uio.no wrote:

On Fri, May 15, 2009 at 10:26 AM, Cintia Marisa cintia.banze@gmail.com wrote:

Hi all,
1st
Thank u guys for the help.

2nd
Murod,

Thanks for the samples you sent, they were helpful.

But still, even with the samples you sent to me, when I try to upload and view the report in DHIS I get “no report design available” error.

Here’s the log:

====================================================

  • INFO 09:06:38,359 All startup routines done (DefaultStartupRoutineExecutor.java [Thread-1])

  • INFO 09:38:51,875 Upload file name: sample_params.rptdesign, content type: application/octet-stream (AddReportAction.java [http-8080-1])

  • INFO 09:38:51,875 New file: C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\birt-viewer\sample_params.rptdesign (AddReportAction.java [http-8080-1])

  • INFO 09:38:51,890 Report connection URL: jdbc:mysql://localhost/dhis2_exp?useUnicode=true&characterEncoding=UTF-8 (AddReportAction.java [http-8080-1])

org.eclipse.birt.report.exception.ViewerException: There is no report design object available.
at org.eclipse.birt.report.context.ViewerAttributeBean.__init(ViewerAttributeBean.java:233)
at org.eclipse.birt.report.context.BaseAttributeBean.init(BaseAttributeBean.java:233)

at org.eclipse.birt.report.context.ViewerAttributeBean.<init>(ViewerAttributeBean.java:116)
at org.eclipse.birt.report.context.BirtContext.__init(BirtContext.java:44)
at org.eclipse.birt.report.context.BaseContext.<init>(BaseContext.java:69)






at org.eclipse.birt.report.context.BirtContext.<init>(BirtContext.java:30)
at org.eclipse.birt.report.servlet.ViewerServlet.__getContext(ViewerServlet.java:150)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doGet(BirtSoapMessageDispatcherServlet.java:151)






at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)






at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)






at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)






at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)






at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)






at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)






at [org.apache.tomcat.util.net](http://org.apache.tomcat.util.net).JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)

====================================================

The error disappears if I upLoad the design without choose in BIRT a data source. But by doing that i got no data displayed.

Just a guess, but this reminds me of version incompatibility issues we have had before. I think your BIRT viewer and Murod’s deisgner (since he designed the report) are different versions.

Have you tried your BIRT viewer with reports designed with the same version? Try open Murod’s report in your report designer and preview it there and see what happens.
I am using BIRT v. 2.3 for both designer and viewer.

Ola


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


Cintia Marisa


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


Cintia Marisa


Cintia Marisa

Hi Cintia,

This report does not have any Data Sorce and Data Set defined. Can you please send report with data set definitions please?

regards,
murod

···

From: Cintia Marisa cintia.banze@gmail.com
To: Murodullo Latifov murodlatifov@yahoo.com; DHIS 2 developers dhis2-devs@lists.launchpad.net
Sent: Monday, May 18, 2009 2:50:51 PM
Subject: Re:
[Dhis2-devs] Providing another source table for reports

Sure,
In attachment the design.

On Mon, May 18, 2009 at 9:19 AM, Murodullo Latifov murodlatifov@yahoo.com wrote:

Hi Cintia,

Could you please send me your report file?

regards,
murod


From: Cintia Marisa cintia.banze@gmail.com
To: Ola Hodne Titlestad olati@ifi.uio.no

Cc: DHIS 2 developers dhis2-devs@lists.launchpad.net
Sent: Friday, May 15, 2009 3:52:31 PM

Subject: Re: [Dhis2-devs] Providing another source
table for reports

Hi,

Sorry, about the reply thing. I keep forgetting.

And no, that doesn’t happen with report tables. The report work just fine, with a report table. the problem is when I use another source table.

On Fri, May 15, 2009 at 12:55 PM, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Hi Cintia,

Remember to use Reply-all to make sure the list gets you reply as well.

So it’s not a BIRT viewer/designer incompatibility issue.

Does BIRT work inside DHIS at all? I mean if you create a report in BIRT based on a report table in DHIS and then upload the design, link to report table, and run the report. Still the same problem then?

best regards,
Ola Hodne Titlestad
HISP
University of Oslo

On Fri, May 15, 2009 at 12:19 PM, Cintia Marisa cintia.banze@gmail.com wrote:

I’ve checked, and it’s not a version incompatibility issue. It happens with my designs too.

Both my BIRT designer and viewer are the same version.

On Fri, May 15, 2009 at 12:14 PM, Ola Hodne Titlestad olati@ifi.uio.no wrote:

On Fri, May 15, 2009 at 10:26 AM, Cintia Marisa cintia.banze@gmail.com wrote:

Hi all,
1st
Thank u guys for the help.

2nd
Murod,

Thanks for the samples you sent, they were helpful.

But still, even with the samples you sent to me, when I try to upload and view the report in DHIS I get “no report design available” error.

Here’s the log:

====================================================

  • INFO 09:06:38,359 All startup routines done (DefaultStartupRoutineExecutor.java [Thread-1])

  • INFO 09:38:51,875 Upload file name: sample_params.rptdesign, content type: application/octet-stream (AddReportAction.java [http-8080-1])

  • INFO 09:38:51,875 New file: C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\birt-viewer\sample_params.rptdesign (AddReportAction.java [http-8080-1])

  • INFO 09:38:51,890 Report connection URL: jdbc:mysql://localhost/dhis2_exp?useUnicode=true&characterEncoding=UTF-8 (AddReportAction.java [http-8080-1])

org.eclipse.birt.report.exception.ViewerException: There is no report design object available.
at org.eclipse.birt.report.context.ViewerAttributeBean.__init(ViewerAttributeBean.java:233)
at org.eclipse.birt.report.context.BaseAttributeBean.init(BaseAttributeBean.java:233)

at org.eclipse.birt.report.context.ViewerAttributeBean.<init>(ViewerAttributeBean.java:116)
at org.eclipse.birt.report.context.BirtContext.__init(BirtContext.java:44)
at org.eclipse.birt.report.context.BaseContext.<init>(BaseContext.java:69)






at org.eclipse.birt.report.context.BirtContext.<init>(BirtContext.java:30)
at org.eclipse.birt.report.servlet.ViewerServlet.__getContext(ViewerServlet.java:150)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doGet(BirtSoapMessageDispatcherServlet.java:151)






at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)






at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)






at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)






at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)






at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)






at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)






at [org.apache.tomcat.util.net](http://org.apache.tomcat.util.net).JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)

====================================================

The error disappears if I upLoad the design without choose in BIRT a data source. But by doing that i got no data displayed.

Just a guess, but this reminds me of version incompatibility issues we have had before. I think your BIRT viewer and Murod’s deisgner (since he designed the report) are different versions.

Have you tried your BIRT viewer with reports designed with the same version? Try open Murod’s report in your report designer and preview it there and see what happens.
I am using BIRT v. 2.3 for both designer and viewer.

Ola


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


Cintia Marisa


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


Cintia Marisa


Cintia Marisa

Sorry 'bout that.

In attachment with data source and data set defined.

c03.rptdesign (193 KB)

···

On Mon, May 18, 2009 at 3:23 PM, Murodullo Latifov murodlatifov@yahoo.com wrote:

Hi Cintia,

This report does not have any Data Sorce and Data Set defined. Can you please send report with data set definitions please?

regards,
murod


From: Cintia Marisa cintia.banze@gmail.com

Subject: Re: [Dhis2-devs] Providing another source table for reports

To: Murodullo Latifov murodlatifov@yahoo.com; DHIS 2 developers dhis2-devs@lists.launchpad.net

Sent: Monday, May 18, 2009 2:50:51 PM

Sure,
In attachment the design.

On Mon, May 18, 2009 at 9:19 AM, Murodullo Latifov murodlatifov@yahoo.com wrote:

Hi Cintia,

Could you please send me your report file?

regards,
murod


From: Cintia Marisa cintia.banze@gmail.com
To: Ola Hodne Titlestad olati@ifi.uio.no

Cc: DHIS 2 developers dhis2-devs@lists.launchpad.net
Sent: Friday, May 15, 2009 3:52:31 PM

Subject: Re: [Dhis2-devs] Providing another source table for reports

Hi,

Sorry, about the reply thing. I keep forgetting.

And no, that doesn’t happen with report tables. The report work just fine, with a report table. the problem is when I use another source table.

On Fri, May 15, 2009 at 12:55 PM, Ola Hodne Titlestad olati@ifi.uio.no wrote:

Hi Cintia,

Remember to use Reply-all to make sure the list gets you reply as well.

So it’s not a BIRT viewer/designer incompatibility issue.

Does BIRT work inside DHIS at all? I mean if you create a report in BIRT based on a report table in DHIS and then upload the design, link to report table, and run the report. Still the same problem then?

best regards,
Ola Hodne Titlestad
HISP
University of Oslo

On Fri, May 15, 2009 at 12:19 PM, Cintia Marisa cintia.banze@gmail.com wrote:

I’ve checked, and it’s not a version incompatibility issue. It happens with my designs too.

Both my BIRT designer and viewer are the same version.

On Fri, May 15, 2009 at 12:14 PM, Ola Hodne Titlestad olati@ifi.uio.no wrote:

On Fri, May 15, 2009 at 10:26 AM, Cintia Marisa cintia.banze@gmail.com wrote:

Hi all,
1st
Thank u guys for the help.

2nd
Murod,

Thanks for the samples you sent, they were helpful.

But still, even with the samples you sent to me, when I try to upload and view the report in DHIS I get “no report design available” error.

Here’s the log:

====================================================

  • INFO 09:06:38,359 All startup routines done (DefaultStartupRoutineExecutor.java [Thread-1])

  • INFO 09:38:51,875 Upload file name: sample_params.rptdesign, content type: application/octet-stream (AddReportAction.java [http-8080-1])

  • INFO 09:38:51,875 New file: C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\birt-viewer\sample_params.rptdesign (AddReportAction.java [http-8080-1])

  • INFO 09:38:51,890 Report connection URL: jdbc:mysql://localhost/dhis2_exp?useUnicode=true&characterEncoding=UTF-8 (AddReportAction.java [http-8080-1])

org.eclipse.birt.report.exception.ViewerException: There is no report design object available.
at org.eclipse.birt.report.context.ViewerAttributeBean.__init(ViewerAttributeBean.java:233)
at org.eclipse.birt.report.context.BaseAttributeBean.init(BaseAttributeBean.java:233)

at org.eclipse.birt.report.context.ViewerAttributeBean.<init>(ViewerAttributeBean.java:116)
at org.eclipse.birt.report.context.BirtContext.__init(BirtContext.java:44)
at org.eclipse.birt.report.context.BaseContext.<init>(BaseContext.java:69)







at org.eclipse.birt.report.context.BirtContext.<init>(BirtContext.java:30)
at org.eclipse.birt.report.servlet.ViewerServlet.__getContext(ViewerServlet.java:150)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doGet(BirtSoapMessageDispatcherServlet.java:151)







at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)







at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)







at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)







at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)







at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)







at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)







at [org.apache.tomcat.util.net](http://org.apache.tomcat.util.net).JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)

====================================================

The error disappears if I upLoad the design without choose in BIRT a data source. But by doing that i got no data displayed.

Just a guess, but this reminds me of version incompatibility issues we have had before. I think your BIRT viewer and Murod’s deisgner (since he designed the report) are different versions.

Have you tried your BIRT viewer with reports designed with the same version? Try open Murod’s report in your report designer and preview it there and see what happens.
I am using BIRT v. 2.3 for both designer and viewer.

Ola


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


Cintia Marisa


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


Cintia Marisa


Cintia Marisa


Cintia Marisa

Hi Cintia,

c03_with_params.rptdesign (197 KB)

···

From: Cintia Marisa cintia.banze@gmail.com
To: Murodullo Latifov murodlatifov@yahoo.com
Cc: DHIS 2 developers dhis2-devs@lists.launchpad.net
Sent: Monday, May 18, 2009 8:11:03 PM
Subject: Re: [Dhis2-devs] Providing another source table for reports

Sorry 'bout that.
In attachment with data source and data set defined.

Please find attached report you have sent earlier with two parameters coming from tabela1 for name and startdate accordingly. Now you can select any of your units from dropdown list as well as startdate. This report works from dhis2 as well.
I am using birt report designer 2.3.1. Check if you are using the same version, I had some difficulties with opening your report, seems from different version.
First rename database name to your database name, user name and pass too.

regards,
murod

Hi,
Thanx for the help!

The report works just fine in BIRT, but i can’t get it to work on DHIS.
I still got “no report design available” error.

And i’m using version 2.3.1 for both BIRT designer and viewer.

···

On Mon, May 18, 2009 at 11:35 PM, Murodullo Latifov murodlatifov@yahoo.com wrote:

Hi Cintia,


From: Cintia Marisa cintia.banze@gmail.com
To: Murodullo Latifov murodlatifov@yahoo.com

Cc: DHIS 2 developers dhis2-devs@lists.launchpad.net

Subject: Re: [Dhis2-devs] Providing another source table for reports

Sent: Monday, May 18, 2009 8:11:03 PM

Sorry 'bout that.
In attachment with data source and data set defined.

Please find attached report you have sent earlier with two parameters coming from tabela1 for name and startdate accordingly. Now you can select any of your units from dropdown list as well as startdate. This report works from dhis2 as well.

I am using birt report designer 2.3.1. Check if you are using the same version, I had some difficulties with opening your report, seems from different version.
First rename database name to your database name, user name and pass too.

regards,
murod


Cintia Marisa

Hi Cintia,

···

From: Cintia Marisa cintia.banze@gmail.com
To: Murodullo Latifov murodlatifov@yahoo.com
Cc: DHIS 2 developers dhis2-devs@lists.launchpad.net
Sent: Wednesday, May 20, 2009 2:31:40 PM
Subject: Re: [Dhis2-devs] Providing another source table for reports

Hi,
Thanx for the help!

The report works just fine in BIRT, but i can’t get it to work on DHIS.
I still got “no report design available” error.

And i’m using version 2.3.1 for both BIRT designer and viewer.

It seems your birt viewer on your dhis server is configured incorrectly. I would recommend reconfiguring birt viewer for dhis.

regards,
murod

Everything seems fine with the configuration, but i still got the error.

···

On Wed, May 20, 2009 at 10:35 PM, Murodullo Latifov murodlatifov@yahoo.com wrote:

Hi Cintia,


From: Cintia Marisa cintia.banze@gmail.com
To: Murodullo Latifov murodlatifov@yahoo.com

Cc: DHIS 2 developers dhis2-devs@lists.launchpad.net

Subject: Re: [Dhis2-devs] Providing another source table for reports

Sent: Wednesday, May 20, 2009 2:31:40 PM

Hi,
Thanx for the help!

The report works just fine in BIRT, but i can’t get it to work on DHIS.
I still got “no report design available” error.

And i’m using version 2.3.1 for both BIRT designer and viewer.

It seems your birt viewer on your dhis server is configured incorrectly. I would recommend reconfiguring birt viewer for dhis.

regards,
murod


Cintia Marisa