← Back to team overview

dhis2-users team mailing list archive

Re: Help

 

Hi David,
For custom sql based reports have a look at section 13.4.3 in the user doc:

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

You can only run DHIS 2 with one unerlying database, the one you specify in
hibernate.properties. But you can then create custom sql against any entity
in this db, add a nice layout on top of that with iReport and make it
available to the users as a standard report with runtime parameters in the
DHIS 2 UI. Instructions in the link above.

Ola
-------
On Feb 7, 2013 8:28 AM, "Nyaika David" <davie2086@xxxxxxxxx> wrote:

> Hi Guys
>
> In the dhis-live/conf/hibernate.properties directory, i see there are
> settings for connecting to postgres database.  can i be able to access the
> postgres database entities within  DHIS2 for use in report generation
>
>
> Thanks in advance for your help :)
>
> --
> Regards
> David Nyaika
> Software Developer(SCJP,SCWCD Certified)
> IICS Technologies, Muyenga
> Phone:+256706353274
> Skype:davie2086
> Email: davie2086@xxxxxxxxx
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>

References