dhis2-users team mailing list archive

["D. Cenk Erdil" <dcerdil@xxxxxxxxx>]

Hello,

One of our team members has tried to sent an email to the list but
apparently it kept bouncing back. I’m forwarding Laura’s original message
in lieu of her. Any help is appreciated.

Basically my take of the issue basically is that there are two parameters
in a Jasper report, one of them (Org Units) gets populated, but the other
(Reporting Period drop down) does not. Hence you cannot generate reports.

We have gone through underlying XML code to update SQL statement
accordingly to reflect the schema changes from 2.4 to 2.13, but apparently
there is no SQL snippet(s) that generate(s) reporting periods (or we’ve
missed it).

A screenshot of the non-working drop down, and the current Jasper report
design of the report are attached.


Thanks,
--
-Cenk.

D. Cenk Erdil, PhD
HMIS Manager
ICAP at Columbia University <http://icap.columbia.edu/>



*From:* Lincks, Laura E.
*Sent:* Monday, May 05, 2014 12:52 PM
*To:* DHIS 2 User Group
*Subject:* Can't select parameter in Jasper report

We have a version of DHIS 2.13 running. It was upgraded from version 2.4
There are a series of Standard Jasper reports from the old version which do
not run in 2.13.

The reports are of the type “Japser report with report table data source”.
Most of the reports in question are generated by first selecting a
Reporting Period and then an Organisation Unit as parameters. I am able to
access the underlying Report table in DHIS 2.13 and I am prompted with the
parameter selection screen but I cannot select the Reporting Period.
Accessing the pulldown menu produces no list of dates. (The Organisation
Unit tree appears and is accessible, but without passing a reporting period
parameter, the report fails.)

While I can “Get current design” of the Standard Report I cannot edit or
see the source of the associated Report Table which appears to be what
passes the parameters to the standard report. I am new at generating Jasper
reports in DHIS and don’t know what I am missing. Any help would be
appreciated.

TIA.


*Laura E. Lincks*
Database Developer
ICAP - Columbia University
Mailman School of Public Health
60 Haven Ave, Floor B1
New York, NY 10032
Tel: 212 304 7132

Attachment: Screen Shot 2014-05-20 at 12.34.42 PM.png
Description: PNG image

Attachment: CARTX 20 Bar Graph New ART - Gender Age By Quarter.jrxml.xml
Description: XML document