Iterating json array on subreport

0

Hi,

I searched already existing answers and got few tips what to do and also looked at this http://jasperreports.sourceforge.net/sample.reference/jsondatasource/ but couldn't iterate my jsonarray. Also this might quite basic question.

My Json looks like this:

{
  "customer": "test",
  "mappedExpenses": [
    {
      "uId": "lfpq3f0vfeqm2t9",
      "currencyId": "EUR",
      "type": "one",
    },
    {
      "uId": "plslhkxshfrpmn29",
      "currencyId": "EUR",
      "type": "two",
    }
  ]
}
 
And my jrxml files look like this 
 
main.jrxml
<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Tapaturma/Ammattitauti-Ilmoitus" pageWidth="595" pageHeight="842" columnWidth="545" leftMargin="30" rightMargin="20" topMargin="20" bottomMargin="20" uuid="4aab7094-0c60-44e4-969e-7571942136a8">
<property name="ireport.zoom" value="1.5"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="sub" class="net.sf.jasperreports.engine.JasperReport"/>
<queryString language="json">
<![CDATA[mappedExpenses]]>
</queryString>
<field name="type" class="java.lang.String">
<fieldDescription><![CDATA[type]]></fieldDescription>
</field>
<detail>
<band height="196">
<subreport>
<reportElement positionType="Float" isPrintRepeatedValues="false" x="0" y="82" width="545" height="41" uuid="55732254-51f9-4434-aa69-c750a822aafc"/>
<subreportParameter name="type">
<subreportParameterExpression><![CDATA[$F{type}]]></subreportParameterExpression>
</subreportParameter>
<dataSourceExpression><![CDATA[((net.sf.jasperreports.engine.data.JsonDataSource)$P{REPORT_DATA_SOURCE}).subDataSource()]]></dataSourceExpression>
<subreportExpression><![CDATA[$P{sub}]]></subreportExpression>
</subreport>
</band>
</detail>
</jasperReport>
 
 
sub.jrxml
<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="tyonantajaSubreport" pageWidth="595" pageHeight="822" columnWidth="595" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="0c7de36a-8d80-48f1-9866-a4c25af4ae34">
<property name="ireport.zoom" value="2.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<queryString language="json">
<![CDATA[mappedExpenses]]>
</queryString>
<field name="typeFromZero" class="java.lang.String">
<fieldDescription><![CDATA[mappedExpenses[0].type]]></fieldDescription>
</field>
<field name="mappedExpenses" class="java.lang.Object"/>
<field name="type" class="java.lang.String">
<fieldDescription><![CDATA[type]]></fieldDescription>
</field>
<background>
<band/>
</background>
<detail>
<band height="214">
<textField isBlankWhenNull="true">
<reportElement x="25" y="21" width="280" height="11" uuid="c4435536-5e25-497f-ac4c-123ef740955f"/>
<textElement>
<font fontName="ArialMT" size="9"/>
</textElement>
<textFieldExpression><![CDATA[$F{typeFromZero}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="25" y="47" width="280" height="11" uuid="683e297f-1ac4-4d95-a9b3-4f033df9af09"/>
<textElement>
<font fontName="ArialMT" size="9"/>
</textElement>
<textFieldExpression><![CDATA[$F{type}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="25" y="74" width="515" height="33" uuid="bc3ccf2b-ad35-4c44-b228-2b9af97554b1"/>
<textElement>
<font fontName="ArialMT" size="9"/>
</textElement>
<textFieldExpression><![CDATA[$F{mappedExpenses}]]></textFieldExpression>
</textField>
</band>
</detail>
</jasperReport>
 
Now on my pdf I get values for "typeFromZero" and "mappedExpenses". mappedExpenses has value array and and everything as Json inside it like in the json: 
[
    {
      "uId": "lfpq3f0vfeqm2t9",
      "currencyId": "EUR",
      "type": "one",
    },
    {
      "uId": "plslhkxshfrpmn29",
      "currencyId": "EUR",
      "type": "two",
    }
  ]

But "type" has nothing. How can I repeat the types? Or actually how can I repeate all values from the array as sub bands/reports?

For creating the PDF in java I use:

JasperPrint jasperPrint =JasperFillManager.fillReport(JasperCompileManager.compileReport(inputStream), parameters, source);
JasperExportManager.exportReportToPdf(jasperPrint)

 

 

teemu.alander's picture
Joined: Nov 11 2014 - 8:20am
Last seen: 5 years 1 week ago

have you found the solution, sir?

i faced the same issue and still not get any clue

newbie wan - 5 years 3 days ago

try the latest version of Jaspersoft Studio :D

newbie wan - 4 years 11 months ago

0 Answers:

No answers yet
Feedback
randomness