dhis2-users team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

On Fri, Dec 21, 2012 at 11:14 AM, Wilson,Randy <rwilson@xxxxxxx> wrote:

>  Hi Lars and Jason,****
>
> ** **
>
> I agree as well.  Remember the views are actually crucial for custom
> iReports as well – so a mydatamart only solution is not sufficient.  We
> have extended our system with tables to manage results based financing data
> (dataelement tariffs and storage of banking details for orgunits).  As a
> result we need to be able to create SQL views that include these foreign
> tables to be used as the datasources for standard reports.****
>
> **
>

Okay. Hopefully the sql reports/scheduling ideas suggested above can
facilitate that.

On a general note, in 2.10 you can create SQL based standard reports where
you can do any SQL statement you like, as well as including dynamic report
parameters in the SQL which can be selected from the user interface at
report generation time:

http://dhis2.org/doc/snapshot/en/user/html/ch13s04.html#d5e2266