Hi Cenk and Laura, I think the way standard reports are implemented, and especially the parameters part, have changed a lot between 2.4 and 2.13, so I am quite sure that your old standard reports from 2.4 will not work out of the box in DHIS v. 2.13. And your email confirms that I guess...
I can't remember exactly how it was changed, but what you can do is to create a new standard report in 2.13, choose "Jasper report with report table data source" under Type, and the click on "Get current design". That should give you a template of what the xml format supported in 2.13 is. Open that file in a text editor and you will see that there is a section in the beginning where the parameters are listed. Then I suggest you give it a try to merge the old report design with the new template and make sure you get the new format for parameters correct. Sorry if this wasn't very helpful. A search through the email archives for dev and user lists might give you better answers. I remember that at some point it was a rather painful upgrade of the standard reports, but that was a long time ago. Maybe others have better memory of that than I do... Ola ----- ---------------------------------- Ola Hodne Titlestad (Mr) HISP Department of Informatics University of Oslo Mobile: +47 48069736 Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link<https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norge&hl=en&ie=UTF8&sll=59.893855,10.785116&sspn=0.222842,0.585709&oq=eftas%C3%A5sen+68,+0687+Oslo,+&t=h&hnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norway&z=16> On 21 May 2014 19:10, D. Cenk Erdil <[email protected]> wrote: > > 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 > > > > > > > > > > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
