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" <davie2...@gmail.com> 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: davie2...@gmail.com > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-users@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp