Forgive me, I am quite new with Jasper and it is probably something simple.
Have to create a report from a single REST service with multiple data objects. One root branch being the main, sorted, piece of data, and the other root nodes being data that will be used by subreports.
Good part, the parameters, get passed to the subreport just fine, bad part is the datasource doesn't display all of the data. some fields populate while others don't. pull the sub report out, and set it up as a stand alone, and it works just fine. Turn it back into a subreport and I have the same problem.
Any help would be much appreciated.
Here is the main and the sub:
main report (vtrRg1_3.jrxml):
..<?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.5.0.final using JasperReports Library version 6.5.0 --> <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="vtrRg1" pageWidth="612" pageHeight="792" columnWidth="576" leftMargin="18" rightMargin="18" topMargin="36" bottomMargin="36" uuid="7d64267c-a58e-4254-81c8-a0abc0372b03"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="localhost_connect.xml"/> <property name="com.jaspersoft.studio.unit." value="inch"/> <property name="com.jaspersoft.studio.unit.pageHeight" value="inch"/> <property name="com.jaspersoft.studio.unit.pageWidth" value="inch"/> <property name="com.jaspersoft.studio.unit.topMargin" value="inch"/> <property name="com.jaspersoft.studio.unit.bottomMargin" value="inch"/> <property name="com.jaspersoft.studio.unit.leftMargin" value="inch"/> <property name="com.jaspersoft.studio.unit.rightMargin" value="inch"/> <property name="com.jaspersoft.studio.unit.columnWidth" value="inch"/> <property name="com.jaspersoft.studio.unit.columnSpacing" value="inch"/> <parameter name="MySubReportDataSource" class="net.sf.jasperreports.engine.JRDataSource" isForPrompting="false"/> <queryString language="WebServiceQuery"> <![CDATA[{ "getparameters" : { }, "fields" : [ { "name" : "crtCd", "expression" : "crtCd" }, { "name" : "crtNm", "expression" : "crtNm" }, { "name" : "lcnCd", "expression" : "lcnCd" }, { "name" : "lcnNm", "expression" : "lcnNm" }, { "name" : "ctgryCd", "expression" : "ctgryCd" }, { "name" : "ctgryNm", "expression" : "ctgryNm" }, { "name" : "stDtRng", "expression" : "stDtRng" }, { "name" : "edDtRng", "expression" : "edDtRng" } ], "options" : { "contentType" : "application/parameter", "rootPath" : "resultObject.sortObject", "baseUrl" : "vtrRg.json" }, "headersMap" : { }, "queryData" : "", "GETParameters" : { } }]]> </queryString> <field name="crtCd" class="java.lang.Integer"/> <field name="crtNm" class="java.lang.String"/> <field name="lcnCd" class="java.lang.String"/> <field name="lcnNm" class="java.lang.String"/> <field name="ctgryCd" class="java.lang.String"/> <field name="ctgryNm" class="java.lang.String"/> <field name="stDtRng" class="java.sql.Timestamp"/> <field name="edDtRng" class="java.sql.Timestamp"/> <group name="Group1" isStartNewPage="true" isReprintHeaderOnEachPage="true"> <groupExpression><![CDATA[$F{lcnNm}]]></groupExpression> <groupHeader> <band height="61"> <textField> <reportElement x="102" y="12" width="360" height="12" uuid="674eaf2b-c1bc-44c8-a721-2ae25fd67e1e"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="oscaRptArial" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$F{lcnNm}.toUpperCase()]]></textFieldExpression> </textField> <textField> <reportElement x="102" y="36" width="360" height="12" uuid="a4e5d7eb-20f5-4107-aa57-39dfb522bb9a"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="oscaRptArial" isBold="true"/> </textElement> <textFieldExpression><![CDATA["FROM: " + (new java.text.SimpleDateFormat("dd-MMM-yyyy").format($F{stDtRng})) + " TO: " + (new java.text.SimpleDateFormat("dd-MMM-yyyy").format($F{edDtRng}))]]></textFieldExpression> </textField> <staticText> <reportElement x="102" y="24" width="360" height="12" uuid="96140b50-e4b3-4596-9b64-2ca9a2032b77"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="oscaRptArial" isBold="true"/> </textElement> <text><![CDATA[CIRCUIT COURT VOTERS REGISTRATION]]></text> </staticText> <staticText> <reportElement x="474" y="12" width="48" height="12" uuid="674d2581-75c6-41b9-899a-d6d77de4fcd6"/> <textElement textAlignment="Right" verticalAlignment="Bottom"> <font fontName="oscaRptArial" size="8" isBold="true"/> </textElement> <text><![CDATA[Time: ]]></text> </staticText> <staticText> <reportElement x="474" y="24" width="48" height="12" uuid="f1bb0b74-7e42-4c51-9bb4-940f246bb981"/> <textElement textAlignment="Right" verticalAlignment="Bottom"> <font fontName="oscaRptArial" size="8" isBold="true"/> </textElement> <text><![CDATA[Page: ]]></text> </staticText> <textField pattern="h:mm:ss a"> <reportElement x="522" y="12" width="54" height="12" uuid="4408e953-2f0f-45da-8a9c-e2921dc2111f"/> <textElement textAlignment="Right" verticalAlignment="Bottom"> <font fontName="oscaRptArial" size="8" isBold="false"/> </textElement> <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression> </textField> <textField> <reportElement x="522" y="24" width="54" height="12" uuid="4edb77e6-ae7e-4d60-80d3-a20346ee9454"/> <textElement textAlignment="Right" verticalAlignment="Bottom"> <font fontName="oscaRptArial" size="8" isBold="false"/> </textElement> <textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression> </textField> <textField> <reportElement x="1" y="15" width="100" height="30" uuid="b26226ce-8bc6-4ef3-aa45-7f509772d3f9"/> <textFieldExpression><![CDATA[$F{lcnCd}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="0" width="102" height="12" uuid="79406867-1e2c-49fd-845a-e3c62b03ce5b"/> <textElement> <font fontName="oscaRptArial" size="8" isBold="true"/> </textElement> <text><![CDATA[Report: CZR0072 v 0.0.2]]></text> </staticText> <textField> <reportElement x="102" y="0" width="360" height="12" uuid="af14ff75-68ed-493a-95c7-be11aae5f65d"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="oscaRptArial" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$F{crtNm}.toUpperCase()]]></textFieldExpression> </textField> <staticText> <reportElement x="474" y="0" width="48" height="12" uuid="c1c744f0-cb2c-4165-8d24-96be9b72a4f6"/> <textElement textAlignment="Right" verticalAlignment="Bottom"> <font fontName="oscaRptArial" size="8" isBold="true"/> </textElement> <text><![CDATA[Date: ]]></text> </staticText> <textField pattern="dd-MMM-YYYY"> <reportElement x="522" y="0" width="54" height="12" uuid="02a6a036-763d-4bab-8c7f-3bb7865a2a20"/> <textElement textAlignment="Right" verticalAlignment="Bottom"> <font fontName="oscaRptArial" size="8" isBold="false"/> </textElement> <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression> </textField> <textField> <reportElement x="0" y="48" width="576" height="12" uuid="76578635-9696-4455-824d-ee120a7c4aef"/> <box> <bottomPen lineWidth="1.0"/> </box> <textElement> <font fontName="oscaRptArial"/> </textElement> <textFieldExpression><![CDATA[""]]></textFieldExpression> </textField> </band> <band height="59"> <staticText> <reportElement x="1" y="6" width="120" height="24" uuid="8313d82a-f319-4234-81ba-247fc2983e3a"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> </box> <textElement> <font fontName="oscaRptArial" isBold="true"/> </textElement> <text><![CDATA[ NAME]]></text> </staticText> <staticText> <reportElement x="121" y="6" width="100" height="24" uuid="f0f26cf5-cad4-4f7a-a210-ddfe5955f6e8"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> </box> <textElement> <font fontName="oscaRptArial" isBold="true"/> </textElement> <text><![CDATA[ CASE NO]]></text> </staticText> <textField> <reportElement x="221" y="6" width="140" height="24" uuid="8317259b-a973-49af-801c-28d51a3d9cbd"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> </box> <textElement> <font fontName="oscaRptArial" isBold="true"/> </textElement> <textFieldExpression><![CDATA[" DOB" + CHAR(13) + " SSN (Last 4 Digits)"]]></textFieldExpression> </textField> <staticText> <reportElement x="361" y="6" width="216" height="24" uuid="701ed2d3-1996-43b5-94f6-b12ca6f96899"/> <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> <font fontName="oscaRptArial" isBold="true"/> </textElement> <text><![CDATA[ LAST KNOWN ADDRESS]]></text> </staticText> </band> <band height="50"> <staticText> <reportElement x="0" y="0" width="100" height="20" uuid="37a9d8ff-4961-419c-b4cc-a5f4012b7b5f"/> <text><![CDATA[Group Header]]></text> </staticText> </band> </groupHeader> <groupFooter> <band height="63"> <staticText> <reportElement x="0" y="0" width="100" height="20" uuid="30b2106e-df67-41a6-9b6e-315d68280b70"/> <text><![CDATA[Group Footer]]></text> </staticText> </band> </groupFooter> </group> <background> <band splitType="Stretch"/> </background> <detail> <band height="55" splitType="Stretch"> <textField> <reportElement x="0" y="0" width="220" height="12" uuid="99573432-9931-40b2-8f77-ea7cb00f8731"/> <textElement> <font fontName="oscaRptArial" isBold="true" isUnderline="true"/> </textElement> <textFieldExpression><![CDATA[$F{ctgryNm}.toUpperCase()]]></textFieldExpression> </textField> <subreport> <reportElement x="1" y="12" width="543" height="28" isPrintWhenDetailOverflows="true" uuid="bfd8a1f2-4b3e-4656-9426-419c7eae7336"/> <subreportParameter name="authParametersKey"> <subreportParameterExpression><![CDATA[$P{authParametersKey}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="authTypeKey"> <subreportParameterExpression><![CDATA[$P{authTypeKey}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="languageKey"> <subreportParameterExpression><![CDATA[$P{languageKey}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="uriKey"> <subreportParameterExpression><![CDATA[$P{uriKey}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="verbKey"> <subreportParameterExpression><![CDATA[$P{verbKey}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="REPORT_PARAMETERS_MAP"> <subreportParameterExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="category"> <subreportParameterExpression><![CDATA[$F{ctgryCd}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="ctrCd"> <subreportParameterExpression><![CDATA[$F{crtCd}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="lcnCd"> <subreportParameterExpression><![CDATA[$F{lcnCd}]]></subreportParameterExpression> </subreportParameter> <dataSourceExpression><![CDATA[((com.jaspersoft.webservice.data.query.IWSDataSource)$P{REPORT_DATA_SOURCE}).clone("resultObject.individuals")]]></dataSourceExpression> <subreportExpression><![CDATA["vtrRgCat4.jasper"]]></subreportExpression> </subreport> </band> </detail> </jasperReport> ..
sub report (vtrCat4.jrxml):
..<?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.5.0.final using JasperReports Library version 6.5.0 --> <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="vtrRgCat4" pageWidth="612" pageHeight="792" columnWidth="576" leftMargin="18" rightMargin="18" topMargin="36" bottomMargin="36" uuid="ae49cf25-8cd6-485e-82a8-0d055a82747e"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/> <property name="com.jaspersoft.studio.unit." value="inch"/> <property name="com.jaspersoft.studio.unit.pageHeight" value="inch"/> <property name="com.jaspersoft.studio.unit.pageWidth" value="inch"/> <property name="com.jaspersoft.studio.unit.topMargin" value="inch"/> <property name="com.jaspersoft.studio.unit.bottomMargin" value="inch"/> <property name="com.jaspersoft.studio.unit.leftMargin" value="inch"/> <property name="com.jaspersoft.studio.unit.rightMargin" value="inch"/> <property name="com.jaspersoft.studio.unit.columnWidth" value="inch"/> <property name="com.jaspersoft.studio.unit.columnSpacing" value="inch"/> <parameter name="ctrCd" class="java.lang.Integer" isForPrompting="false"/> <parameter name="lcnCd" class="java.lang.String" isForPrompting="false"/> <parameter name="category" class="java.lang.String" isForPrompting="false"/> <queryString language="WebServiceQuery"> <![CDATA[{ "getparameters" : { }, "fields" : [ { "name" : "ctgryCd", "expression" : "ctgryCd" }, { "name" : "caseId", "expression" : "caseId" }, { "name" : "lcnCd", "expression" : "lcnCd" }, { "name" : "crtCd", "expression" : "crtCd" }, { "name" : "lstNm", "expression" : "lstNm" }, { "name" : "mdlNm", "expression" : "mdlNm" }, { "name" : "fstNm", "expression" : "fstNm" }, { "name" : "dob", "expression" : "dob" }, { "name" : "lst4SSN", "expression" : "lst4SSN" }, { "name" : "lstKnwnAddr", "expression" : "lstKnwnAddr" } ], "options" : { "contentType" : "application/json", "rootPath" : "resultObject.individuals", "baseUrl" : "vtrRg.json" }, "headersMap" : { }, "queryData" : "", "GETParameters" : { } }]]> </queryString> <field name="ctgryCd" class="java.lang.String"/> <field name="caseId" class="java.lang.String"/> <field name="lcnCd" class="java.lang.String"/> <field name="crtCd" class="java.lang.Integer"/> <field name="lstNm" class="java.lang.String"/> <field name="mdlNm" class="java.lang.String"/> <field name="fstNm" class="java.lang.String"/> <field name="dob" class="java.lang.String"/> <field name="lst4SSN" class="java.lang.String"/> <field name="lstKnwnAddr" class="java.lang.String"/> <variable name="displayName" class="java.lang.String"> <variableExpression><![CDATA[($F{lstNm} != null ? $F{lstNm}.trim() : "") + RTRIM(", " + ($F{fstNm} != null ? $F{fstNm}.trim() : "") + " " + ($F{mdlNm} != null ? $F{mdlNm}.trim() : ""))]]></variableExpression> </variable> <background> <band splitType="Stretch"/> </background> <detail> <band height="119" splitType="Stretch"> <textField> <reportElement x="0" y="20" width="100" height="30" uuid="cdab0eb2-1a6f-4c3a-a94e-54e44bb7c2b2"/> <textFieldExpression><![CDATA[$P{ctrCd}]]></textFieldExpression> </textField> <textField> <reportElement x="110" y="20" width="100" height="30" uuid="6878a31d-e02f-41bc-bb8b-7c46e59eb150"/> <textFieldExpression><![CDATA[$P{lcnCd}]]></textFieldExpression> </textField> <textField> <reportElement x="220" y="20" width="100" height="30" uuid="27529f20-e1dd-4ac0-840a-82d07e58d14e"/> <textFieldExpression><![CDATA[$P{category}]]></textFieldExpression> </textField> <staticText> <reportElement x="0" y="0" width="100" height="18" uuid="a5b35b00-f50e-47d2-96f5-0b4d6545b96f"/> <text><![CDATA[In subreport]]></text> </staticText> <staticText> <reportElement x="0" y="90" width="100" height="18" uuid="052ba25c-ca13-4027-9428-928c0ddd3d84"/> <text><![CDATA[End of subreport]]></text> </staticText> <textField> <reportElement x="0" y="50" width="63" height="30" isPrintWhenDetailOverflows="true" uuid="eb3145ef-dc56-40c5-8b3a-1e72737735a9"/> <textFieldExpression><![CDATA[$F{ctgryCd}]]></textFieldExpression> </textField> <textField> <reportElement x="63" y="50" width="57" height="30" isPrintWhenDetailOverflows="true" uuid="696c8648-90b5-4cca-b5cb-9e9254ef3eb6"/> <textFieldExpression><![CDATA[$F{caseId}]]></textFieldExpression> </textField> <textField> <reportElement x="120" y="50" width="57" height="30" isPrintWhenDetailOverflows="true" uuid="e9da7b05-79c3-4e28-acda-7b9aa64b82cd"/> <textFieldExpression><![CDATA[$F{lcnCd}]]></textFieldExpression> </textField> <textField> <reportElement x="167" y="52" width="57" height="30" isPrintWhenDetailOverflows="true" uuid="23e26db1-fd7f-4f48-b6b6-ae428ab1ba78"/> <textFieldExpression><![CDATA[$F{crtCd}]]></textFieldExpression> </textField> <textField> <reportElement x="224" y="52" width="57" height="30" isPrintWhenDetailOverflows="true" uuid="86df78dd-f8ff-4d7a-a63d-a34470b806cf"/> <textFieldExpression><![CDATA[$F{lstNm}]]></textFieldExpression> </textField> <textField> <reportElement x="281" y="52" width="57" height="30" isPrintWhenDetailOverflows="true" uuid="8e61f160-72ae-4c17-85b4-f269a87c37c7"/> <textFieldExpression><![CDATA[$F{mdlNm}]]></textFieldExpression> </textField> <textField> <reportElement x="338" y="52" width="57" height="30" isPrintWhenDetailOverflows="true" uuid="f7a2fe68-ea82-4732-b65e-f01f0a5abd2c"/> <textFieldExpression><![CDATA[$F{fstNm}]]></textFieldExpression> </textField> <textField> <reportElement x="395" y="52" width="57" height="30" isPrintWhenDetailOverflows="true" uuid="a7dffa02-23ad-4583-a623-19844b098880"/> <textFieldExpression><![CDATA[$F{dob}]]></textFieldExpression> </textField> <textField> <reportElement x="452" y="52" width="57" height="30" isPrintWhenDetailOverflows="true" uuid="bc3d71c0-f4ad-4164-9d49-08a19ec61bc8"/> <textFieldExpression><![CDATA[$F{lst4SSN}]]></textFieldExpression> </textField> <textField> <reportElement x="509" y="52" width="57" height="30" isPrintWhenDetailOverflows="true" uuid="952a11c4-7be3-40a7-b83b-3593af00fa21"/> <textFieldExpression><![CDATA[$F{lstKnwnAddr}]]></textFieldExpression> </textField> </band> </detail> </jasperReport> ..
Here is an example of what the json object will resemble:
..{ "dbLocation" : "jdbc/abcd_123", "totalAttempts" : 1, "accessedTableDetails" : { }, "resultObject" : { "sortObject" : [ {"crtCd" : "77", "crtNm" : "77th Judicial Circuit", "lcnCd" : "Z4", "lcnNm" : "Associate Div Middle Earth", "ctgryCd" : "ELC", "ctgryNm" : "ELECTION LAW CONVICTIONS", "stDtRng" : "2011-01-01 00:00:00.000", "edDtRng" : "2017-12-12 23:59:59.999" }, {"crtCd" : "77", "crtNm" : "77th Judicial Circuit", "lcnCd" : "Z4", "lcnNm" : "Associate Div Middle Earth", "ctgryCd" : "FEL", "ctgryNm" : "FELONY CONVICTIONS", "stDtRng" : "2011-01-01 00:00:00.000", "edDtRng" : "2017-12-12 23:59:59.999" }, {"crtCd" : "77", "crtNm" : "77th Judicial Circuit", "lcnCd" : "Z4", "lcnNm" : "Associate Div Middle Earth", "ctgryCd" : "INC", "ctgryNm" : "INCAPACITATED ADULTS", "stDtRng" : "2011-01-01 00:00:00.000", "edDtRng" : "2017-12-12 23:59:59.999" }, {"crtCd" : "77", "crtNm" : "77th Judicial Circuit", "lcnCd" : "DQ", "lcnNm" : "OZ", "ctgryCd" : "ELC", "ctgryNm" : "ELECTION LAW CONVICTIONS", "stDtRng" : "2011-01-01 00:00:00.000", "edDtRng" : "2017-12-12 23:59:59.999" }, {"crtCd" : "77", "crtNm" : "77th Judicial Circuit", "lcnCd" : "DQ", "lcnNm" : "OZ", "ctgryCd" : "INC", "ctgryNm" : "INCAPACITATED ADULTS", "stDtRng" : "2011-01-01 00:00:00.000", "edDtRng" : "2017-12-12 23:59:59.999" }, {"crtCd" : "77", "crtNm" : "77th Judicial Circuit", "lcnCd" : "DQ", "lcnNm" : "OZ", "ctgryCd" : "FEL", "ctgryNm" : "FELONY CONVICTIONS", "stDtRng" : "2011-01-01 00:00:00.000", "edDtRng" : "2017-12-12 23:59:59.999" }, {"crtCd" : "77", "crtNm" : "77th Judicial Circuit", "lcnCd" : "IT", "lcnNm" : "Lidsville", "ctgryCd" : "ELC", "ctgryNm" : "ELECTION LAW CONVICTIONS", "stDtRng" : "2011-01-01 00:00:00.000", "edDtRng" : "2017-12-12 23:59:59.999" }, {"crtCd" : "77", "crtNm" : "77th Judicial Circuit", "lcnCd" : "IT", "lcnNm" : "Lidsville", "ctgryCd" : "INC", "ctgryNm" : "INCAPACITATED ADULTS", "stDtRng" : "2011-01-01 00:00:00.000", "edDtRng" : "2017-12-12 23:59:59.999" }, {"crtCd" : "77", "crtNm" : "77th Judicial Circuit", "lcnCd" : "IT", "lcnNm" : "Lidsville", "ctgryCd" : "FEL", "ctgryNm" : "FELONY CONVICTIONS", "stDtRng" : "2011-01-01 00:00:00.000", "edDtRng" : "2017-12-12 23:59:59.999" } ], "individuals" : [ {"ctgryCd" : "FEL", "caseId" : "17QP-CR43215678", "lcnCd" : "Z4", "crtCd" : "77", "lstNm" : "GOODBOY", "mdlNm" : "D", "fstNm" : "JUNIOR", "dob" : "1977-09-02 00:00:00.000", "lst4SSN" : "2112", "lstKnwnAddr" : "156 RAILROD RD, MOCKINGBIRD HEIGHTS, MO 65999" }, {"ctgryCd" : "FEL", "caseId" : "17QP-CR12121212", "lcnCd" : "Z4", "crtCd" : "77", "lstNm" : "MARY", "mdlNm" : "B", "fstNm" : "TYPHOID", "dob" : "1967-10-19 00:00:00.000", "lst4SSN" : "4583", "lstKnwnAddr" : "PO BOX 357, MOCKINGBIRD HEIGHTS, MO 65999" }, {"ctgryCd" : "FEL", "caseId" : "17QP-CR87654321", "lcnCd" : "DQ", "crtCd" : "77", "lstNm" : "WONKA", "mdlNm" : null, "fstNm" : "WILLIE", "dob" : "1960-06-11 00:00:00.000", "lst4SSN" : "0666", "lstKnwnAddr" : "RT 1 BOX 768, MOCKINGBIRD HEIGHTS, MO 65999" }, {"ctgryCd" : "FEL", "caseId" : "17QP-CR12345678", "lcnCd" : "DQ", "crtCd" : "77", "lstNm" : "GOOD", "mdlNm" : "B", "fstNm" : "JOHNNY", "dob" : "1970-01-01 00:00:00.000", "lst4SSN" : "2233", "lstKnwnAddr" : "123 SOUTH MAIN, MOCKINGBIRD HEIGHTS, MO 65999" }, {"ctgryCd" : "INC", "caseId" : "17QP-CR00999900", "lcnCd" : "DQ", "crtCd" : "77", "lstNm" : "DREAD", "mdlNm" : "D", "fstNm" : "JUDGE", "dob" : "2000-01-01 00:00:00.000", "lst4SSN" : "", "lstKnwnAddr" : "NURSING HOME, MOCKINGBIRD HEIGHTS, MO 65999" }, {"ctgryCd" : "ELC", "caseId" : "17QP-CR99999998", "lcnCd" : "DQ", "crtCd" : "77", "lstNm" : "POINDEXTER", "mdlNm" : "WEE", "fstNm" : "PEA", "dob" : "2000-01-01 00:00:00.000", "lst4SSN" : "1234", "lstKnwnAddr" : "HOME FOR THE CRIMINALLY INSANE, 1314 MOCKINGBIRD LN, MOCKINGBIRD HEIGHTS, MO 65999" } ] }, "dataElementErrors" : null, "statusCode" : "OK" } ..
OK, I think I understand what is missing. I haven't defined the "subFieldsMap". What is appearing are those fields that just happen to be the same as the master report.
If anyone could provide me some assistance to define the "Default Value Expresion" for the "subFieldsMap" I would greatly appreciate it.
Have managed to get data to appear in subreport, but now it only repeats the last record 6 times.