Help

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 :slight_smile:

ยทยทยท

โ€“
Regards
David Nyaika
Software Developer(SCJP,SCWCD Certified)

IICS Technologies, Muyenga
Phone:+256706353274

Skype:davie2086
Email: davie2086@gmail.com

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@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 :slight_smile:

โ€“
Regards
David Nyaika
Software Developer(SCJP,SCWCD Certified)

IICS Technologies, Muyenga
Phone:+256706353274

Skype:davie2086
Email: davie2086@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