Jump to content
We've recently updated our Privacy Statement, available here ×

Not able to view the nested subreport over the main report.


santhose

Recommended Posts

Hi,

I am facing an issue, which is bit complicated from my side. I have a main report and there are two sub report i.e (a & b) used in that. The second subreport (b) is quite simple and it works fine as it doesn't contain any subreport inside it. The issue is with the first subreport (a) which cantains another subreport lets call ©. C is not able to visible over the main report.

I am adding the files, so that anyone can tell me where things are going wrong !

Thanking you in Advance !!!

Main Report:

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.10.0.final using JasperReports Library version 6.10.0-unknown  -->
<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="Title_Certificate" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="e5d87220-dca6-4bdf-904a-1e6307050dbe">
    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="JSON Data Adapter "/>
    <property name="net.sf.jasperreports.export.json.escape.members" value="true"/>
    <property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w1" value="500"/>
    <property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w2" value="485"/>
    <queryString language="json">
        <![CDATA[data]]>
    </queryString>
    <field name="titleId" class="java.lang.String">
        <property name="net.sf.jasperreports.json.field.expression" value="titleId"/>
        <fieldDescription><![CDATA[titleId]]></fieldDescription>
    </field>
    <field name="shareRRRListName" class="java.lang.String">
        <property name="net.sf.jasperreports.json.field.expression" value="shareRRRListName"/>
        <fieldDescription><![CDATA[shareRRRListName]]></fieldDescription>
    </field>
    <field name="parcelDescription" class="java.lang.String">
        <property name="net.sf.jasperreports.json.field.expression" value="parcelDescription"/>
        <fieldDescription><![CDATA[parcelDescription]]></fieldDescription>
    </field>
    <field name="parcelId" class="java.lang.String">
        <property name="net.sf.jasperreports.json.field.expression" value="parcelId"/>
        <fieldDescription><![CDATA[parcelId]]></fieldDescription>
    </field>
    <field name="planId" class="java.lang.String">
        <property name="net.sf.jasperreports.json.field.expression" value="planId"/>
        <fieldDescription><![CDATA[planId]]></fieldDescription>
    </field>
    <field name="applicationId" class="java.lang.String">
        <property name="net.sf.jasperreports.json.field.expression" value="applicationId"/>
        <fieldDescription><![CDATA[applicationId]]></fieldDescription>
    </field>
    <field name="rrrCreatedDate" class="java.lang.String">
        <property name="net.sf.jasperreports.json.field.expression" value="rrrCreatedDate"/>
        <fieldDescription><![CDATA[rrrCreatedDate]]></fieldDescription>
    </field>
    <background>
        <band splitType="Stretch"/>
    </background>
    <title>
        <band height="90" splitType="Stretch">
            <staticText>
                <reportElement x="140" y="12" width="280" height="60" uuid="d0a7fff8-944b-4aab-9dc7-a1c19c31ca84"/>
                <textElement textAlignment="Center" verticalAlignment="Top">
                    <font fontName="URW Chancery L" size="43"/>
                </textElement>
                <text><![CDATA[Certificate of Title]]></text>
            </staticText>
            <staticText>
                <reportElement x="180" y="60" width="202" height="30" uuid="894cb948-3913-4537-858f-ad5a4c4d7857"/>
                <text><![CDATA[under the "Transfer of Land Act 1984"]]></text>
            </staticText>
        </band>
    </title>
    <detail>
        <band height="291" splitType="Stretch">
            <staticText>
                <reportElement x="0" y="20" width="553" height="48" uuid="e2cff774-7a2a-43b5-b75b-5e8f2e8c165b"/>
                <textElement>
                    <font isBold="false"/>
                </textElement>
                <text><![CDATA[The Registered Owner is the registered proprietor of a                      estate in the land described below subject to the reservations, conditions, and depth limit contained in the original grant (if a grant issued) and to the rights, restrictions, responsibilities indicated below. ]]></text>
            </staticText>
            <staticText>
                <reportElement x="0" y="68" width="110" height="17" uuid="28c5f8d7-990e-469c-98a4-cd81823d4e91"/>
                <textElement>
                    <font size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[Title Identifier]]></text>
            </staticText>
            <staticText>
                <reportElement x="0" y="86" width="140" height="17" uuid="d730d232-c782-49d8-b857-019e84b67597"/>
                <textElement>
                    <font size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[Description of Land]]></text>
            </staticText>
            <staticText>
                <reportElement x="80" y="128" width="97" height="12" uuid="a5ff8fdb-496d-4bf0-af44-a1334c6439e9"/>
                <textElement>
                    <font isBold="true"/>
                </textElement>
                <text><![CDATA[Parcel Identifier]]></text>
            </staticText>
            <staticText>
                <reportElement x="242" y="128" width="77" height="12" uuid="242ad083-57d0-4e1c-8c07-553f91d6e217"/>
                <textElement>
                    <font isBold="true"/>
                </textElement>
                <text><![CDATA[Plan Number]]></text>
            </staticText>
            <staticText>
                <reportElement x="0" y="146" width="140" height="17" uuid="1c6cd96d-4ac6-445d-9c56-a4b8983f889b"/>
                <textElement>
                    <font size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[Registered Owner ]]></text>
            </staticText>
            <staticText>
                <reportElement x="210" y="147" width="10" height="17" uuid="cd0284d2-d043-4105-aba0-7e8d54faea7f">
                    <printWhenExpression><![CDATA[!$F{shareRRRListName}.isEmpty()]]></printWhenExpression>
                </reportElement>
                <text><![CDATA[,]]></text>
            </staticText>
            <staticText>
                <reportElement x="311" y="147" width="10" height="17" uuid="c17f3f44-d1e7-4820-ab2b-6371b3c81a19"/>
                <text><![CDATA[,]]></text>
            </staticText>
            <subreport>
                <reportElement positionType="Float" x="0" y="210" width="250" height="10" isPrintWhenDetailOverflows="true" uuid="236926cb-352a-4c80-a5d3-2b1442a07949"/>
                <dataSourceExpression><![CDATA[((net.sf.jasperreports.engine.data.JsonDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("rrr")]]></dataSourceExpression>
                <subreportExpression><![CDATA["RRR_Subreport.jasper"]]></subreportExpression>
            </subreport>
            <textField>
                <reportElement x="117" y="69" width="59" height="17" uuid="45a5596d-6ae0-4bdc-a1b5-eb6a229ddf1d"/>
                <textFieldExpression><![CDATA[$F{titleId}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="228" y="0" width="122" height="20" uuid="03f92bd7-f1c5-4a52-9f8f-57c55439ce7f">
                    <printWhenExpression><![CDATA[!$F{shareRRRListName}.isEmpty()]]></printWhenExpression>
                </reportElement>
                <textFieldExpression><![CDATA[$F{shareRRRListName}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="280" y="20" width="70" height="14" uuid="f44dbe5a-3dbf-46a6-a158-3ac6504848d1">
                    <printWhenExpression><![CDATA[!$F{shareRRRListName}.isEmpty()]]></printWhenExpression>
                </reportElement>
                <textFieldExpression><![CDATA[$F{shareRRRListName}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="80" y="105" width="121" height="17" uuid="6e7170b0-df0c-4607-ae88-811fd775c2ba"/>
                <textFieldExpression><![CDATA[$F{parcelDescription}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="179" y="128" width="61" height="12" uuid="af117310-b955-4fd5-83d1-a48dc01ddddd"/>
                <textFieldExpression><![CDATA[$F{parcelId}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="318" y="128" width="72" height="12" uuid="c01fb7c6-a51d-412f-a37a-fd1919c292b2"/>
                <textFieldExpression><![CDATA[$F{planId}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="140" y="147" width="70" height="17" uuid="6516539d-fe13-46d1-8f02-85680caa9f2c">
                    <printWhenExpression><![CDATA[!$F{shareRRRListName}.isEmpty()]]></printWhenExpression>
                </reportElement>
                <textFieldExpression><![CDATA[$F{shareRRRListName}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="221" y="147" width="90" height="17" uuid="47fcc98a-9415-49da-8cc8-58e2c95fc679"/>
                <textFieldExpression><![CDATA[$F{applicationId}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="321" y="147" width="145" height="17" uuid="93ee9534-c6ff-4608-9ada-774d843d2ddd"/>
                <textFieldExpression><![CDATA[$F{rrrCreatedDate}]]></textFieldExpression>
            </textField>
            <subreport isUsingCache="false" overflowType="Stretch">
                <reportElement positionType="Float" x="0" y="170" width="250" height="10" isPrintWhenDetailOverflows="true" uuid="41455171-d813-4092-808b-ac59d58622fd"/>
                <dataSourceExpression><![CDATA[((net.sf.jasperreports.engine.data.JsonDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("share")]]></dataSourceExpression>
                <subreportExpression><![CDATA["Share_Ratio.jasper"]]></subreportExpression>
            </subreport>
            <staticText>
                <reportElement positionType="Float" x="0" y="187" width="250" height="17" uuid="08691b1a-7694-49d2-a4dd-1459f04c842c"/>
                <textElement>
                    <font size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[Rights, Restrictions, Responsibilities]]></text>
            </staticText>
        </band>
    </detail>
    <pageFooter>
        <band height="94" splitType="Stretch">
            <staticText>
                <reportElement x="-1" y="8" width="71" height="14" uuid="4e2cde97-f82f-44cb-8a99-51d0ebd7850a"/>
                <textElement>
                    <font fontName="URW Chancery L"/>
                </textElement>
                <text><![CDATA[Title Number:]]></text>
            </staticText>
            <staticText>
                <reportElement x="0" y="28" width="90" height="14" uuid="da49afde-adf7-464f-98ca-2039044f759b"/>
                <textElement>
                    <font fontName="URW Chancery L"/>
                </textElement>
                <text><![CDATA[Title Registered:]]></text>
            </staticText>
            <staticText>
                <reportElement x="508" y="28" width="20" height="12" uuid="8180b444-574c-4a8d-b07c-23eddfbb3b1d"/>
                <text><![CDATA[of]]></text>
            </staticText>
            <textField>
                <reportElement x="491" y="28" width="30" height="12" uuid="d91910ba-2640-47ef-8229-b4f48017252b"/>
                <textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="523" y="28" width="30" height="12" uuid="5d7dee74-2995-4eb6-a963-3d86bfc218a8">
                    <property name="com.jaspersoft.studio.unit.height" value="px"/>
                </reportElement>
                <textFieldExpression><![CDATA[$V{PAGE_COUNT}]]></textFieldExpression>
            </textField>
            <staticText>
                <reportElement x="466" y="28" width="40" height="12" uuid="36c505bc-3190-4b3e-9b6b-485c707d297f"/>
                <textElement>
                    <font fontName="URW Chancery L"/>
                </textElement>
                <text><![CDATA[Page]]></text>
            </staticText>
            <staticText>
                <reportElement x="430" y="7" width="40" height="12" uuid="50cb84ac-2046-4398-a693-ad49d7e88bb2"/>
                <textElement>
                    <font fontName="URW Chancery L"/>
                </textElement>
                <text><![CDATA[issued:]]></text>
            </staticText>
            <staticText>
                <reportElement x="151" y="50" width="253" height="30" uuid="79e78464-0135-40ff-b915-58196dff56e4"/>
                <textElement>
                    <font fontName="URW Chancery L"/>
                </textElement>
                <text><![CDATA[Warning, before dealing with this land search the current land registry]]></text>
            </staticText>
            <textField>
                <reportElement x="60" y="8" width="60" height="13" uuid="8111f3e5-16f0-4b5e-94d8-34f06d1cca9d"/>
                <textFieldExpression><![CDATA[$F{titleId}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="84" y="28" width="100" height="14" uuid="3eb91189-22a6-4a86-8e32-0a21782adc08"/>
                <textFieldExpression><![CDATA[$F{rrrCreatedDate}]]></textFieldExpression>
            </textField>
        </band>
    </pageFooter>
</jasperReport>


first Subreport (a)

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.10.0.final using JasperReports Library version 6.10.0-unknown  -->
<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="Share_Ratio" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="f607f8c6-7e47-4c29-8b08-bda8e9b702ee">
    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="JSON Data Adapter "/>
    <queryString language="JSON">
        <![CDATA[data.share]]>
    </queryString>
    <field name="shareNominator" class="java.lang.String">
        <property name="net.sf.jasperreports.json.field.expression" value="shareNominator"/>
        <fieldDescription><![CDATA[shareNominator]]></fieldDescription>
    </field>
    <field name="shareDenominator" class="java.lang.String">
        <property name="net.sf.jasperreports.json.field.expression" value="shareDenominator"/>
        <fieldDescription><![CDATA[shareDenominator]]></fieldDescription>
    </field>
    <field name="sharePercentage" class="java.lang.String">
        <property name="net.sf.jasperreports.json.field.expression" value="sharePercentage"/>
        <fieldDescription><![CDATA[sharePercentage]]></fieldDescription>
    </field>
    <background>
        <band splitType="Stretch"/>
    </background>
    <detail>
        <band height="42" splitType="Stretch">
            <staticText>
                <reportElement positionType="Float" x="100" y="10" width="100" height="17" uuid="11020114-2264-4d5a-ae02-5c9c4a19fb43"/>
                <text><![CDATA[as to be undivided]]></text>
            </staticText>
            <staticText>
                <reportElement positionType="Float" x="270" y="10" width="40" height="17" uuid="c99195b4-1ee3-4b9d-adf8-2140dc60c10e"/>
                <text><![CDATA[interest]]></text>
            </staticText>
            <textField>
                <reportElement positionType="Float" x="231" y="10" width="17" height="17" uuid="fa321db9-239e-4e22-9883-c0a1a6eece6b"/>
                <textFieldExpression><![CDATA[$F{shareNominator}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement positionType="Float" x="200" y="10" width="20" height="17" uuid="e8ab2ba3-895f-4da0-b5a1-a17679e57826"/>
                <textFieldExpression><![CDATA[$F{sharePercentage}]]></textFieldExpression>
            </textField>
            <staticText>
                <reportElement positionType="Float" x="220" y="10" width="10" height="17" uuid="dfe400fc-9402-4301-93e8-323814f7123d"/>
                <text><![CDATA[,]]></text>
            </staticText>
            <staticText>
                <reportElement positionType="Float" x="248" y="10" width="10" height="17" uuid="3b2e7b17-4ae3-4411-a0be-bf218a914cc2"/>
                <text><![CDATA[/]]></text>
            </staticText>
            <textField>
                <reportElement positionType="Float" x="258" y="10" width="10" height="17" uuid="e991262f-89c7-435a-9e76-ea73de9aa96c"/>
                <textFieldExpression><![CDATA[$F{shareDenominator}]]></textFieldExpression>
            </textField>
            <subreport>
                <reportElement x="0" y="0" width="310" height="10" isPrintWhenDetailOverflows="true" uuid="d7eea04c-fa4a-41cb-a0eb-8b53d7739c2a"/>
                <dataSourceExpression><![CDATA[((net.sf.jasperreports.engine.data.JsonDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("sharePartyDTOSet")]]></dataSourceExpression>
                <subreportExpression><![CDATA["Share_Party.jasper"]]></subreportExpression>
            </subreport>
            <line>
                <reportElement positionType="Float" x="101" y="33" width="464" height="1" uuid="d02110f0-de91-4b4f-b7bc-479c615f1a8f"/>
            </line>
        </band>
    </detail>
</jasperReport>


second subreport (b) ----- It works fine !

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.10.0.final using JasperReports Library version 6.10.0-unknown  -->
<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="RRR_Subreport" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="78c14694-52d3-41b7-b193-55ee2bb9e12b">
    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="JSON Data Adapter "/>
    <queryString language="JSON">
        <![CDATA[data.rrr]]>
    </queryString>
    <field name="rrrListName" class="java.lang.String">
        <property name="net.sf.jasperreports.json.field.expression" value="rrrListName"/>
        <fieldDescription><![CDATA[rrrListName]]></fieldDescription>
    </field>
    <field name="applicationId" class="java.lang.String">
        <property name="net.sf.jasperreports.json.field.expression" value="applicationId"/>
        <fieldDescription><![CDATA[applicationId]]></fieldDescription>
    </field>
    <field name="createdDate" class="java.lang.String">
        <property name="net.sf.jasperreports.json.field.expression" value="createdDate"/>
        <fieldDescription><![CDATA[createdDate]]></fieldDescription>
    </field>
    <field name="rightHolder" class="java.lang.String">
        <property name="net.sf.jasperreports.json.field.expression" value="rightHolder"/>
        <fieldDescription><![CDATA[rightHolder]]></fieldDescription>
    </field>
    <field name="notationText" class="java.lang.String">
        <property name="net.sf.jasperreports.json.field.expression" value="notationText"/>
        <fieldDescription><![CDATA[notationText]]></fieldDescription>
    </field>
    <field name="sourceId" class="java.lang.String">
        <property name="net.sf.jasperreports.json.field.expression" value="sourceId"/>
        <fieldDescription><![CDATA[sourceId]]></fieldDescription>
    </field>
    <background>
        <band splitType="Stretch"/>
    </background>
    <title>
        <band splitType="Stretch"/>
    </title>
    <pageHeader>
        <band splitType="Stretch"/>
    </pageHeader>
    <columnHeader>
        <band splitType="Stretch"/>
    </columnHeader>
    <detail>
        <band height="113" splitType="Stretch">
            <staticText>
                <reportElement x="80" y="2" width="97" height="12" uuid="45160e11-a822-4acc-8c29-9d21414ae46b"/>
                <textElement>
                    <font isBold="true"/>
                </textElement>
                <text><![CDATA[Nature]]></text>
            </staticText>
            <staticText>
                <reportElement x="80" y="90" width="118" height="12" uuid="13ca6212-45ea-4318-a74a-ec53043bedd0"/>
                <textElement>
                    <font isBold="true"/>
                </textElement>
                <text><![CDATA[Reference]]></text>
            </staticText>
            <staticText>
                <reportElement x="80" y="40" width="118" height="12" uuid="30272401-c982-48df-aab3-f4bfb5e2448b">
                    <printWhenExpression><![CDATA[!$F{applicationId}.isEmpty()]]></printWhenExpression>
                </reportElement>
                <textElement>
                    <font isBold="true"/>
                </textElement>
                <text><![CDATA[Rightholder]]></text>
            </staticText>
            <staticText>
                <reportElement x="80" y="20" width="118" height="12" uuid="cb328967-0f3b-4942-bb7c-3a16d2a11e11"/>
                <textElement>
                    <font isBold="true"/>
                </textElement>
                <text><![CDATA[Registration ID/Date]]></text>
            </staticText>
            <staticText>
                <reportElement x="80" y="60" width="118" height="12" uuid="5999d10e-6553-4bda-952b-2c1f3763b6ff"/>
                <textElement>
                    <font isBold="true"/>
                </textElement>
                <text><![CDATA[Notation]]></text>
            </staticText>
            <textField>
                <reportElement x="242" y="2" width="100" height="12" uuid="9f21b52b-7edd-4012-b0f8-d4228e039ab5">
                    <printWhenExpression><![CDATA[!$F{rrrListName}.isEmpty()]]></printWhenExpression>
                </reportElement>
                <textFieldExpression><![CDATA[$F{rrrListName}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="242" y="20" width="100" height="12" uuid="38782f3c-73d8-4712-b4d2-fea66dbdcd9d">
                    <printWhenExpression><![CDATA[!$F{applicationId}.isEmpty()]]></printWhenExpression>
                </reportElement>
                <textFieldExpression><![CDATA[$F{applicationId}]]></textFieldExpression>
            </textField>
            <staticText>
                <reportElement x="342" y="20" width="8" height="12" uuid="67a6dad2-2519-4b36-b42f-1615befb8463">
                    <printWhenExpression><![CDATA[!$F{applicationId}.isEmpty()]]></printWhenExpression>
                </reportElement>
                <text><![CDATA[,]]></text>
            </staticText>
            <textField>
                <reportElement x="350" y="20" width="100" height="12" uuid="ea10ac79-df8b-4af6-a3b4-3969bed2e26a"/>
                <textFieldExpression><![CDATA[$F{createdDate}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="242" y="40" width="100" height="12" uuid="8b95b0f8-b303-49a3-a889-e601cdca23f5">
                    <printWhenExpression><![CDATA[!$F{rightHolder}.isEmpty()]]></printWhenExpression>
                </reportElement>
                <textFieldExpression><![CDATA[$F{rightHolder}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="242" y="60" width="308" height="12" uuid="8747a162-8eb4-431e-b17b-9016ea87cb2b">
                    <printWhenExpression><![CDATA[!$F{notationText}.isEmpty()]]></printWhenExpression>
                </reportElement>
                <textFieldExpression><![CDATA[$F{notationText}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="242" y="90" width="105" height="12" uuid="10c516c8-866b-4a4c-8f1a-d8a61dbe37cc">
                    <printWhenExpression><![CDATA[!$F{sourceId}.isEmpty()]]></printWhenExpression>
                </reportElement>
                <textFieldExpression><![CDATA[$F{sourceId}]]></textFieldExpression>
            </textField>
            <line direction="BottomUp">
                <reportElement x="80" y="110" width="470" height="1" uuid="8fe3aa20-e66e-48b1-88df-4782ab70f2a5">
                    <property name="com.jaspersoft.studio.unit.width" value="px"/>
                    <property name="com.jaspersoft.studio.unit.height" value="px"/>
                </reportElement>
            </line>
        </band>
    </detail>
</jasperReport>

 

Nested subreport ©

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.10.0.final using JasperReports Library version 6.10.0-unknown  -->
<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="Share_Party" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="2989e163-4d61-48e5-8447-8251de8a0bca">
    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="JSON Data Adapter "/>
    <queryString language="JSON">
        <![CDATA[data.share.sharePartyDTOSet]]>
    </queryString>
    <field name="sharePartyName" class="java.lang.String">
        <property name="net.sf.jasperreports.json.field.expression" value="sharePartyName"/>
        <fieldDescription><![CDATA[sharePartyName]]></fieldDescription>
    </field>
    <field name="sharePartyJob" class="java.lang.String">
        <property name="net.sf.jasperreports.json.field.expression" value="sharePartyJob"/>
        <fieldDescription><![CDATA[sharePartyJob]]></fieldDescription>
    </field>
    <field name="sharePartyAddressText" class="java.lang.String">
        <property name="net.sf.jasperreports.json.field.expression" value="sharePartyAddressText"/>
        <fieldDescription><![CDATA[sharePartyAddressText]]></fieldDescription>
    </field>
    <background>
        <band splitType="Stretch"/>
    </background>
    <detail>
        <band height="37" splitType="Immediate">
            <staticText>
                <reportElement x="194" y="2" width="10" height="17" uuid="c733d545-de8e-4968-ac53-6ea3ac3804ca"/>
                <text><![CDATA[,]]></text>
            </staticText>
            <staticText>
                <reportElement x="101" y="20" width="19" height="17" uuid="3896348d-1594-43bc-b0a7-07d3b708f118"/>
                <text><![CDATA[of]]></text>
            </staticText>
            <textField>
                <reportElement x="20" y="2" width="110" height="18" uuid="8583b263-93ab-4d15-acf7-bef90193750a"/>
                <textFieldExpression><![CDATA[$F{sharePartyName}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="116" y="2" width="78" height="18" uuid="1cdea6a3-fd45-49fa-8deb-7c689deeb089"/>
                <textFieldExpression><![CDATA[$F{sharePartyJob}]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="120" y="20" width="330" height="17" uuid="6de632e5-e6c1-4c7f-a2d9-e4ca3b392ba5"/>
                <textFieldExpression><![CDATA[$F{sharePartyAddressText}]]></textFieldExpression>
            </textField>
        </band>
    </detail>
</jasperReport>


Am also adding the json, so that it provides more of the context to you guys to solve it.

{
   "status":true,
   "data":{
      "titleId":"TIDg534",
      "shareRRRListName":null,
      "parcelDescription":"Part Lot 2  / PLNa201",
      "parcelId":"PIDa384",
      "planId":"PLNa201",
      "applicationId":"APPa229",
      "rrrCreatedDate":"2019-09-30T18:25:42.585+0000",
      "share":[
         {
            "shareNominator":"2",
            "shareDenominator":"3",
            "sharePercentage":"null",
            "sharePartyDTOSet":[
               {
                  "sharePartyName":"Kriselle Janina,",
                  "sharePartyJob":"Manufacturing Administrator",
                  "sharePartyAddressText":"22 Jellicoe Parade,  Oneroa, Marlborough, 9674, New Zealand"
               },
               {
                  "sharePartyName":"Adrianna Shields,",
                  "sharePartyJob":"Administration Strategist",
                  "sharePartyAddressText":"8 Butterfield Place,   Lokko, Tasman, 9253, New Zealand"
               }
            ]
         },
         {
            "shareNominator":"1",
            "shareDenominator":"3",
            "sharePercentage":"null",
            "sharePartyDTOSet":[
               {
                  "sharePartyName":"Tonita Steuber,",
                  "sharePartyJob":"IT Strategist",
                  "sharePartyAddressText":"906 Express Parkway,  Apam, Marlborough, 9084, New Zealand"
               }
            ]
         }
      ],
      "rrr":[
         {
            "rrrListName":"Mortgage",
            "applicationId":"APPa229",
            "createdDate":"2019-09-30T18:30:09.607+0000",
            "rightHolder":"Brendan Smith",
            "notationText":null,
            "sourceId":"DOCa209"
         },
         {
            "rrrListName":"Fishing Right",
            "applicationId":"APPa229",
            "createdDate":"2019-09-30T17:55:28.315+0000",
            "rightHolder":"Kean Romany",
            "notationText":null,
            "sourceId":null
         },
         {
            "rrrListName":"Water Right",
            "applicationId":"APPa229",
            "createdDate":"2019-09-30T18:15:51.157+0000",
            "rightHolder":null,
            "notationText":null,
            "sourceId":null
         },
         {
            "rrrListName":"Tenancy",
            "applicationId":null,
            "createdDate":"2007-09-12T10:28:31.632+0000",
            "rightHolder":"Johnna Schneider",
            "notationText":"Registered Tenancy",
            "sourceId":"DOCa202"
         },
         {
            "rrrListName":"Fishing Right",
            "applicationId":"APPa229",
            "createdDate":"2019-09-30T17:45:39.220+0000",
            "rightHolder":"Kean Romany",
            "notationText":null,
            "sourceId":null
         },
         {
            "rrrListName":"Right of Access",
            "applicationId":"APPa229",
            "createdDate":"2019-09-30T17:50:11.461+0000",
            "rightHolder":"Brya Arpita",
            "notationText":null,
            "sourceId":null
         },
         {
            "rrrListName":"Lease (99 year)",
            "applicationId":"APPa229",
            "createdDate":"2019-09-30T18:28:00.372+0000",
            "rightHolder":"Phyllis Edwin",
            "notationText":null,
            "sourceId":"DOCa210"
         }
      ]
   },
   "msg":""
}

Hope the information and clear and expect an answer soon !

 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...