dhis2-users team mailing list archive

[Ola Hodne Titlestad <olati@xxxxxxxxxx>]

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 <dcerdil@xxxxxxxxx> 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     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>