Thread Previous • Date Previous • Date Next • Thread Next |
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
Thread Previous • Date Previous • Date Next • Thread Next |