dhis2-devs team mailing list archive

[Paulo Grácio <pgracio@xxxxxxxxxxxxxxxxxxxx>]

From: Paulo Grácio [mailto:pgracio@xxxxxxxxxxxxxxxxxxxx] 
Sent: terça-feira, 10 de Dezembro de 2013 14:58
To: 'Lars Helge Øverland';
Subject: RE: Community Features in DHIS2

Hi Lars,

Pivot Table Data, and;
Lars: “This has been corrected - now both for pivot table and for standard reports (report table). Fixed in trunk and version 2.13.”

This still has a problem once data on Jasper Reports is not being
rendered correctly. Data appears in a random way. After analysing the
code our conclusions are:

-	Data is being displayed in a random way because on DataElementCategoryOptionCombo.hbm.xml categoryOptions are mapped to a Set, using HashSet implementation. It makes no guarantees as to the iteration order of the set; in particular, it does not guarantee that the order will remain constant over time.
-	When calling getName() it has a random behaviour on Jasper Report expect a fixed name like:

<field name="escolaridade (nenhuma, ccr)" class="java.lang.Double"/>
<field name="escolaridade (cpppf, nenhuma)" class="java.lang.Double"/>
<field name="escolaridade (nenhuma, clínica de tb)" class="java.lang.Double"/>

And sometimes we get

escolaridade (nenhuma, ccr)
escolaridade (nenhuma, cpppf)
escolaridade (nenhuma, clínica de tb)

others

escolaridade (ccr , nenhuma)
escolaridade (nenhuma, cpppf)
escolaridade (clínica de tb, nenhuma)

is this rational correct?

Kind regards,
Paulo Grácio

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1240399

Title:
  No data in Report Tables generated from Pivot Tables with DataElement
  - Details (categories)

Status in DHIS 2:
  Fix Committed

Bug description:
  Problem with Pivot Tables and generated Report Tables:

    Create one Pivot Table that show data, but the Report Table
  generated from the Pivot Table don’t show anything, the pivot table is
  created with Data Element - Details (Categories).

  (the report table don´t show any data, even after the Analytics and
  Datamart update tables)

  (The Version I’m using is: 2.13-SNAPSHOT, Build revision: 12639, Build
  date: 2013-10-14 16:04 , I have this behavior at the snapshot
  [http://apps.dhis2.org/dev/dhis-web-pivot/app/index.html], version
  2.13, see attach
  https://bugs.launchpad.net/dhis2/+bug/1240399/+attachment/3879065/+files
  /pivot-table_generated-report-table.png)

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1240399/+subscriptions