Hi All,
We are getting null in jasper soft studio with below inputs. We have Json Array in our json. We are using JsonDatasource. suprisingly, Json data source compute the number of elements in Json array however values are not getting printed.
Is this bug with JsonDataSource?
we have below Json as data source.
{
"DataItem": {
"AB-CDEF": {
"GroupData": {
"OGF": {
"FRN": [
"Chin-tan",
"14",
"14",
"14",
"15"
]
}
}
}
}
}
Below is our JRXML.
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.12.0.final using JasperReports Library version 6.12.1-ac0eebdb29e4c0985457bab279a6db744d661530 -->
<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="Demo_Phone_list" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="cd0a2f09-0067-489b-8fe7-c8cbec7635c6">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="sample_list_phone_1"/>
<subDataset name="Dataset1" uuid="5337e69f-16e4-447d-a9e7-fbe6d25a479f">
<property name="com.jaspersoft.studio.data.defaultdataadapter"/>
<queryString language="JSON">
<![CDATA[]]>
</queryString>
<field name="FirmReferenceNumber" class="java.lang.String">
<property name="net.sf.jasperreports.json.field.expression" value="[0]"/>
<fieldDescription><![CDATA[FirmReferenceNumber]]></fieldDescription>
</field>
</subDataset>
<queryString language="json">
<![CDATA[]]>
</queryString>
<background>
<band splitType="Stretch"/>
</background>
<detail>
<band height="100" splitType="Stretch">
<componentElement>
<reportElement x="346" y="30" width="320" height="60" uuid="46f04a61-454e-43e8-af82-f4b6490e2080"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="Dataset1" uuid="16a9a001-6c9b-4847-aa98-40b2c4c7296d">
<dataSourceExpression><![CDATA[((net.sf.jasperreports.engine.data.JsonDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("DataItem.AB-CDEF.GroupData.OGF.FRN")]]></dataSourceExpression>
</datasetRun>
<jr:listContents height="60" width="320">
<textField>
<reportElement x="100" y="19" width="188" height="30" uuid="4b05337f-4af5-4a13-a057-11324d2e4cff"/>
<box>
<topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{FirmReferenceNumber}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
</band>
</detail>
</jasperReport>
Regards,
Chintan
2 Answers:
With JSON you need to change the field expression from "[0]" to ".", like so:
<field name="FirmReferenceNumber" class="java.lang.String"> <property name="net.sf.jasperreports.json.field.expression" value="."/> <fieldDescription><![CDATA[FirmReferenceNumber]]></fieldDescription> </field>
Your Query is empty
It should have something like below:
<queryString language="jsonql">
<![CDATA[Northwind.Customers.*( PostalCode > 2 && Country == "Germany")]]>
</queryString>
Possible issues: You wrote a query but did not click on read fields(metadata)
Awesome. Thanks Narcism.
Regards
Chintan