dhis2-devs team mailing list archive
Mailing list archive
Re: Providing another source table for reports
From: Cintia Marisa <cintia.banze@xxxxxxxxx>
Sent: Wednesday, May 13, 2009 9:22:14 AM
Subject: [Dhis2-devs] Providing another source table for reports
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
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 ..."