← Back to team overview

dhis2-devs team mailing list archive

Re: Providing another source table for reports



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:

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

best regards,
Ola Hodne Titlestad
University of Oslo

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

> Hi Cintia,
> ------------------------------
> *From:* Cintia Marisa <cintia.banze@xxxxxxxxx>
> *To:* dhis2-devs@xxxxxxxxxxxxxxxxxxx
> *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>
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> More help   : https://help.launchpad.net/ListHelp