My subreport does not display data while previewing main report

[mehtaruchi1312]

I have to attach 2 xml file one is main report xml and 2 is subreport file

1. XML file for main report

<?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="heamogram" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="5c7cceab-c206-4681-99df-5b99284b9f22">

<property name="ireport.zoom" value="1.0"/>

<property name="ireport.x" value="0"/>

<property name="ireport.y" value="0"/>

<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">

<defaultValueExpression><![CDATA["C:\Users\DELL3537\Desktop\"]]></defaultValueExpression>

</parameter>

<queryString>

<![CDATA[select * from heamogram]]>

</queryString>

<field name="t_i" class="java.lang.Integer">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="patient_id" class="java.lang.Integer">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="gender_id" class="java.lang.Integer">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="gender" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="hb" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="rbccount" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="hct" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="mcv" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="mch" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="mchc" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="r.d.w" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="wbc" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="nutrophils" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="lymphocyts" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="eosinopils" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="monocytes" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="basophils" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="precellline1" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="precellline2" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="malarialparaline1" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="e.s.r" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="platelets" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="ps1" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="ps2" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="ps3" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="ps4" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="ps5" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="comments" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="p.d.w" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="mpv" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="p_lcr" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="comment2" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<background>

<band splitType="Stretch"/>

</background>

<title>

<band height="79" splitType="Stretch"/>

</title>

<pageHeader>

<band height="35" splitType="Stretch"/>

</pageHeader>

<columnHeader>

<band height="61" splitType="Stretch">

<staticText>

<reportElement x="16" y="18" width="100" height="20" uuid="24c69bba-7a1d-47f9-8ed5-229d89bd685b"/>

<textElement>

<font fontName="Century Gothic" size="13" isBold="true"/>

</textElement>

<text><![CDATA[HEAMOGRAM]]></text>

</staticText>

</band>

</columnHeader>

<detail>

<band height="178" splitType="Stretch">

<staticText>

<reportElement x="19" y="9" width="59" height="20" uuid="daf9be5f-f7ee-48f2-aee0-940c117cfc77"/>

<text><![CDATA[TEST]]></text>

</staticText>

<staticText>

<reportElement x="129" y="9" width="74" height="20" uuid="da9a5375-7dba-4266-a68c-b974a1cd51b4"/>

<text><![CDATA[RESULT]]></text>

</staticText>

<staticText>

<reportElement x="277" y="9" width="62" height="20" uuid="854e3bc3-3c3b-4126-af10-531fc1d16534"/>

<text><![CDATA[uNITS]]></text>

</staticText>

<staticText>

<reportElement x="408" y="9" width="100" height="20" uuid="33c5decf-bf69-4d50-a265-870855f3137f"/>

<text><![CDATA[NORMALS]]></text>

</staticText>

<textField>

<reportElement x="129" y="47" width="100" height="20" uuid="2beeefe8-e3ea-41c5-9e14-8a85fd86e58d"/>

<textFieldExpression><![CDATA[$F{hb}]]></textFieldExpression>

</textField>

<staticText>

<reportElement x="16" y="47" width="100" height="20" uuid="c8552595-28e5-4750-b963-b039020f8418"/>

<text><![CDATA[hb]]></text>

</staticText>

<textField>

<reportElement x="129" y="79" width="100" height="20" uuid="362d9a6e-1fa2-489b-8a0a-4916633289ba"/>

<textFieldExpression><![CDATA[$F{rbccount}]]></textFieldExpression>

</textField>

<staticText>

<reportElement x="16" y="79" width="100" height="20" uuid="d8d23bde-ff8d-4fd4-b0d2-05c046799c62"/>

<text><![CDATA[rbccount]]></text>

</staticText>

<subreport>

<reportElement x="408" y="47" width="116" height="121" uuid="c2329b62-fa72-4c38-b3f7-0e3ba1e0953f"/>

<subreportParameter name="gender_id">

<subreportParameterExpression><![CDATA[$F{gender_id}]]></subreportParameterExpression>

</subreportParameter>

<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>

<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "heamogram_subreport2.jasper"]]></subreportExpression>

</subreport>

</band>

</detail>

<columnFooter>

<band height="45" splitType="Stretch"/>

</columnFooter>

<pageFooter>

<band height="54" splitType="Stretch"/>

</pageFooter>

<summary>

<band height="42" splitType="Stretch"/>

</summary>

</jasperReport>

 

2. Subreport XML file

 

<?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="heamogram_subreport2" language="groovy" pageWidth="555" pageHeight="802" columnWidth="555" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="47b43412-a9f9-45a1-b545-5dfe79ef82da">

<property name="ireport.zoom" value="1.0"/>

<property name="ireport.x" value="0"/>

<property name="ireport.y" value="0"/>

<parameter name="gender_id" class="java.lang.Integer">

<defaultValueExpression><![CDATA[1]]></defaultValueExpression>

</parameter>

<queryString>

<![CDATA[select * from female where gender_id=$P{gender_id}]]>

</queryString>

<field name="gender_id" class="java.lang.Integer">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="gender" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="hb" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="rbccount" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="hct" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="mcv" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="mch" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="mchc" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="r.d.w" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="wbc" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="nutrophils" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="lymphocyts" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="eosinopils" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="monocytes" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="basophils" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="precellline1" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="precellline2" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="malarialparaline1" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="e.s.r" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="platelets" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="ps1" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="ps2" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="ps3" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="ps4" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="ps5" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="comments" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="p.d.w" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="mpv" class="java.lang.Double">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<field name="p_lcr" class="java.lang.String">

<fieldDescription><![CDATA[]]></fieldDescription>

</field>

<background>

<band splitType="Stretch"/>

</background>

<detail>

<band height="125" splitType="Stretch">

<staticText>

<reportElement x="313" y="19" width="100" height="20" uuid="0053e9ac-8dea-4d6e-8be3-e31c33f027c6"/>

<text><![CDATA[hb]]></text>

</staticText>

<textField>

<reportElement x="413" y="19" width="100" height="20" uuid="c50b7173-8967-4134-9211-cd86c7cf290a"/>

<textFieldExpression><![CDATA[$F{hb}]]></textFieldExpression>

</textField>

<staticText>

<reportElement x="313" y="44" width="100" height="20" uuid="a3a9a9b8-abd4-4ca7-a638-a63ac18af6a4"/>

<text><![CDATA[rbccount]]></text>

</staticText>

<textField>

<reportElement x="413" y="44" width="100" height="20" uuid="2b336e41-3c2d-4a58-8ae5-e505792d640d"/>

<textFieldExpression><![CDATA[$F{rbccount}]]></textFieldExpression>

</textField>

<staticText>

<reportElement x="313" y="64" width="100" height="20" uuid="0590d8c7-84b7-4c7c-9184-5f7e1c85c677"/>

<text><![CDATA[hct]]></text>

</staticText>

<textField>

<reportElement x="413" y="64" width="100" height="20" uuid="eb063e8a-e578-4bb6-9bba-2a56f5c3dba8"/>

<textFieldExpression><![CDATA[$F{hct}]]></textFieldExpression>

</textField>

<staticText>

<reportElement x="313" y="84" width="100" height="20" uuid="bcf0bc69-8835-48b0-9c6b-a6599466d062"/>

<text><![CDATA[mcv]]></text>

</staticText>

<textField>

<reportElement x="413" y="84" width="100" height="20" uuid="5d49f9d7-185c-4ad5-81d7-ce2e6bf445fd"/>

<textFieldExpression><![CDATA[$F{mcv}]]></textFieldExpression>

</textField>

</band>

</detail>

</jasperReport>