dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hi Jeton,

after version 2.2 the report tables are not written as a physical database
table anymore. It is rather generated as a custom JR data source within DHIS
2. This implies that you can continue to develop iReport designs as before
but only utilize the fields and functions provided by the report table (no
sql). To get started please generate the report table and click "Download as
JRXML" and use this file as a template/starting point for your design. The
reason for this move was that the shared database table approach did not
work well in high concurrency environments.

regards,

Lars


On Mon, Jun 27, 2011 at 1:53 AM, Jeton Mehmeti <jeton_lesnadekon@xxxxxxxxxxx
> wrote:

>  Good morning Lars,
>
> I am wanting to make standard report thru ireport but cannot fetch data
> from sql query.
>
> The information on table reports show no table name report to include in
> the ireport sql query as is shown on DHIS2 user manual. (Attached: report
> table)
>
> An example of report query is given on the user manual (attached) and I can
> see the query is build based on the table name, which the current version of
> DHIS 2.3 is not showing, therefore not able to fetch data from a particular
> report table without the correct table name.
>
> Appreciate your help.
>
> Thanks,
>
> Jeton
>