dhis2-users team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

Hi Lars, Randy

I think this is what Randy has done.  Remote direct connection to the
database is possible and uses ssl, hence the connection string Randy
has posted above.

But I think the point is as Lars says, this is for development and
debugging.  Or if you need/want to share the iReports outside the
context of DHIS2.  Once the report is imported into DHIS2 you no
longer need the connection string.  That is why you don't see it with
Olav's reports.  Just the queries.  The connection is made using the
existing connection which DHIS2 will have open to the database.

Bob

On 21 February 2013 07:40, Lars Helge Øverland <larshelge@xxxxxxxxx> wrote:
> Hi Randy,
>
> what I typically do when creating iReports using custom queries is to set up
> a JDBC connection to the DHIS database straight from iReport. You can then
> use the preview function and preview your reports directly from ireport
> which simplifies debugging. One can either temporarily open the postgres
> database for remote connections (put a strong password first!) or install a
> copy of the database in a local postgres installation on your machine.
>
> regards,
>
> Lars
>
>
> On Fri, Feb 15, 2013 at 8:40 AM, Wilson,Randy <rwilson@xxxxxxx> wrote:
>>
>> We’ve been trying to publish iReports in our DHIS-2 instance using custom
>> queries and parameters, but continue to receive errors.  I was hoping to see
>> some examples on the demo site, but they are all based on report tables.
>> Could someone put some examples of iReports based on custom postgres queries
>> so that we can see how to configure connection strings.
>>
>>
>>
>> The documentation in the user guide is not adequate.
>>
>>
>>
>> Randy Wilson
>>
>>
>>
>>
>> _______________________________________________
>> 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
>>
>
>
> _______________________________________________
> 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
>