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

mehtaruchi1312

Members
  • Posts

    2
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Everything posted by mehtaruchi1312

  1. This is XML code <?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="76f79fff-a6c6-46db-a1f4-9f49a86eafe1"> <property name="ireport.zoom" value="1.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <style name="table"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <topPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <topPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <topPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 1"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 1_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 1_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 1_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 2"> <box> <topPen lineWidth="1.0" lineColor="#FFFFFF"/> <bottomPen lineWidth="1.0" lineColor="#FFFFFF"/> </box> </style> <style name="table 2_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <topPen lineWidth="0.5" lineColor="#FFFFFF"/> <bottomPen lineWidth="0.5" lineColor="#FFFFFF"/> </box> </style> <style name="table 2_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <topPen lineWidth="0.5" lineColor="#FFFFFF"/> <bottomPen lineWidth="0.5" lineColor="#FFFFFF"/> </box> </style> <style name="table 2_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <topPen lineWidth="0.5" lineColor="#FFFFFF"/> <bottomPen lineWidth="0.5" lineColor="#FFFFFF"/> </box> </style> <style name="table 3"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 3_TH" mode="Opaque" backcolor="#FFFAF0"> <box> <topPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 3_CH" mode="Opaque" backcolor="#FFEABF"> <box> <topPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 3_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <topPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 4"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 4_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <topPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 4_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <topPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 4_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <topPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 5"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 5_TH" mode="Opaque" backcolor="#FF0000"> <box> <topPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 5_CH" mode="Opaque" backcolor="#FFE6E6"> <box> <topPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 5_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <topPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 6"> <box> <pen lineWidth="1.0" lineColor="#FFFFFF"/> </box> </style> <style name="table 6_TH" mode="Opaque" backcolor="#FFFFFF"> <box> <topPen lineWidth="0.5" lineColor="#FFFFFF"/> <bottomPen lineWidth="0.5" lineColor="#FFFFFF"/> </box> </style> <style name="table 6_CH" mode="Opaque" backcolor="#FFBFBF"> <box> <topPen lineWidth="0.5" lineColor="#FFFFFF"/> <bottomPen lineWidth="0.5" lineColor="#FFFFFF"/> </box> </style> <style name="table 6_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <topPen lineWidth="0.5" lineColor="#FFFFFF"/> <bottomPen lineWidth="0.5" lineColor="#FFFFFF"/> </box> </style> <style name="Crosstab Data Text" hAlign="Center"/> <style name="table 7"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 7_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 7_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 7_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 8"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 8_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 8_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 8_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 9"> <box> <pen lineWidth="1.0" lineColor="#FFFFFF"/> </box> </style> <style name="table 9_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <topPen lineWidth="0.5" lineColor="#FFFFFF"/> <bottomPen lineWidth="0.5" lineColor="#FFFFFF"/> </box> </style> <style name="table 9_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <topPen lineWidth="0.5" lineColor="#FFFFFF"/> <bottomPen lineWidth="0.5" lineColor="#FFFFFF"/> </box> </style> <style name="table 9_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <topPen lineWidth="0.5" lineColor="#FFFFFF"/> <bottomPen lineWidth="0.5" lineColor="#FFFFFF"/> </box> </style> <subDataset name="report1" uuid="a2d7c589-8926-4a35-9107-e556e876cd80"> <queryString language="SQL"> <![CDATA[select * from normals]]> </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> <group name="gender_id"> <groupExpression><![CDATA[$F{gender_id}]]></groupExpression> </group> </subDataset> <subDataset name="dataset1" uuid="1e52d501-fe89-4614-bcdd-49b941d5fd7d"/> <subDataset name="report" uuid="b1ebceac-ceca-4838-89db-38d7a2b85df1"> <queryString language="SQL"> <![CDATA[select * from normals]]> </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> <group name="gender_id"> <groupExpression><![CDATA[$F{gender_id}]]></groupExpression> </group> </subDataset> <subDataset name="Table Dataset 1" uuid="af5dd4c2-bc49-46be-a57d-bb05fc40ae0f"/> <subDataset name="dataset2" uuid="1b2503e0-7528-441a-aa39-25ab677df96c"/> <subDataset name="dataset3" uuid="4a20eb2f-c263-4bf5-8244-ccac30e338fc"/> <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="73" splitType="Stretch"/> </title> <pageHeader> <band height="110" splitType="Stretch"> <subreport> <reportElement x="0" y="0" width="555" height="110" uuid="e11f8a45-6ec5-41cc-bb05-e378877daf15"/> <subreportParameter name="patient_id"> <subreportParameterExpression><![CDATA[$F{patient_id}]]></subreportParameterExpression> </subreportParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "ghbdesign_subreport1.jasper"]]></subreportExpression> </subreport> </band> </pageHeader> <columnHeader> <band height="61" splitType="Stretch"> <staticText> <reportElement x="13" y="13" width="100" height="20" uuid="814ffc54-3f73-4117-a37f-c290482b1996"/> <text><![CDATA[HEAMOGRAM]]></text> </staticText> </band> </columnHeader> <detail> <band height="171" splitType="Stretch"> <staticText> <reportElement x="13" y="13" width="77" height="20" uuid="b10a5d33-9513-4871-8530-be43151183eb"/> <text><![CDATA[TESTS]]></text> </staticText> <staticText> <reportElement x="149" y="13" width="77" height="20" uuid="911403e0-54f3-443a-b130-aa6df71a4fac"/> <text><![CDATA[RESULT]]></text> </staticText> <staticText> <reportElement x="270" y="13" width="67" height="20" uuid="f1e668d9-b512-4aeb-bdb8-a163dacbed7c"/> <text><![CDATA[uNITS]]></text> </staticText> <staticText> <reportElement x="409" y="13" width="100" height="20" uuid="875afa92-be05-4592-99f9-d4f302bcbd67"/> <text><![CDATA[NORMALS]]></text> </staticText> <textField> <reportElement x="149" y="49" width="100" height="20" uuid="9d86d609-c338-4a40-9fdc-f84c6bce9948"/> <textFieldExpression><![CDATA[$F{hb}]]></textFieldExpression> </textField> <staticText> <reportElement x="13" y="49" width="100" height="20" uuid="0ba275af-02eb-4837-888b-f803b6eef143"/> <text><![CDATA[hb]]></text> </staticText> <textField> <reportElement x="149" y="87" width="100" height="20" uuid="91e5d62d-c0b2-447b-9625-8688b6edb1de"/> <textFieldExpression><![CDATA[$F{rbccount}]]></textFieldExpression> </textField> <staticText> <reportElement x="13" y="87" width="100" height="20" uuid="0a2f6b64-9163-4105-a6f2-8503175ee563"/> <text><![CDATA[rbccount]]></text> </staticText> <componentElement> <reportElement key="table 9" style="table 9" x="409" y="49" width="90" height="76" uuid="d2e19b1b-df79-49c3-a692-9b85d2e6e8c8"/> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd"> <datasetRun subDataset="report1" uuid="b99d29e4-39ee-4340-9a05-07a0364e6dd1"> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="90" uuid="dce22893-5cd3-4cd8-a0dc-9982858bff18"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="a474e618-dfc5-4a04-816d-0177d95316d9"/> <textFieldExpression><![CDATA[$F{gender_id}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="5dd0836f-2f29-420d-ada1-1c0b3f984d75"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="652c4d91-2556-45c5-995b-9ffead6879d9"/> <textFieldExpression><![CDATA[$F{gender}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="f4c4b2a2-dd94-406b-b75a-8b46ab6fc554"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="39a641f5-674f-4cca-aa97-ac6aa3f9520e"/> <textFieldExpression><![CDATA[$F{hb}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="986583ed-57d5-4b06-ab9e-59f4f8801b69"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="29d13ea2-3701-48c0-9b11-d9e7f4373790"/> <textFieldExpression><![CDATA[$F{rbccount}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="74cdfcd4-ebeb-4584-82e7-a706386c8466"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="dcda59fc-8953-4c86-a9cb-7c305f4691fc"/> <textFieldExpression><![CDATA[$F{hct}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="3d7493ef-0c5a-4c3b-a3cd-165243710131"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="11e96a86-d210-44da-8adc-9aac2f347275"/> <textFieldExpression><![CDATA[$F{mcv}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="8daf796d-5fd7-4dd7-9ab2-5d56bb0097da"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="81f32d6d-aee8-4b01-8a4b-cfaed4291ae4"/> <textFieldExpression><![CDATA[$F{mch}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="80c365d7-0519-4fcd-b12c-2a6dd0005c6b"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="b55176e6-39af-4002-9ec2-9c1d18caa996"/> <textFieldExpression><![CDATA[$F{mchc}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="de040fd6-7b1d-4c17-8a01-f458024ac31e"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="6724256d-5f7f-4397-8e80-bd9beb7c5776"/> <textFieldExpression><![CDATA[$F{r.d.w}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="9d5713fd-c42f-4c81-a508-744ca16abdf7"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="179e05aa-5746-4fae-8bcc-5f7d36b80b6e"/> <textFieldExpression><![CDATA[$F{wbc}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="8914a6dd-8024-43b7-aaef-b3c99d8c891f"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="b4a1d7ab-24ab-4db6-8cc1-417a527e1e70"/> <textFieldExpression><![CDATA[$F{nutrophils}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="328fc86f-9d57-4087-ac6a-9b5b4ae95ac9"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="d2f90192-b567-409c-bdef-f3b2c10e2de4"/> <textFieldExpression><![CDATA[$F{lymphocyts}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="ae15b1b4-a087-4df7-bfa7-6abbc32e0f58"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="b9cd94b9-6b1d-4d8c-afb4-7888fb1db7f1"/> <textFieldExpression><![CDATA[$F{eosinopils}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="b900e226-58b3-473a-8395-8fed3c042f86"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="08c49af8-7806-4833-9fc4-910388a94fa5"/> <textFieldExpression><![CDATA[$F{monocytes}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="80659e48-09ab-48e7-af63-f3cef6fb3b2e"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="57d69081-dc36-4ae2-9aca-ff75a50e2dac"/> <textFieldExpression><![CDATA[$F{basophils}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="8167a487-bc59-44e0-b2d9-05b6e52c946a"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="d3803754-5912-4c2a-b613-77a328838d4b"/> <textFieldExpression><![CDATA[$F{precellline1}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="7a001282-2b16-4043-a72b-c15c7fb68818"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="4f97105c-9b65-4d81-8030-7ba67104408f"/> <textFieldExpression><![CDATA[$F{precellline2}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="19653d76-37e1-492a-a353-b29e131ab158"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="f9bf298c-cc63-4aa7-b1f7-db0d03fc593d"/> <textFieldExpression><![CDATA[$F{malarialparaline1}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="e43b4684-c1ae-46a3-ae24-c3b85884d9cd"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="fa56c073-19d4-4324-b405-f6f7a22426ef"/> <textFieldExpression><![CDATA[$F{e.s.r}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="8b946dd7-c19e-4d4c-bfe9-a24e196e6e14"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="eeb62f18-d2c2-4fe8-b6a4-6984fd046322"/> <textFieldExpression><![CDATA[$F{platelets}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="83ba64a1-3229-4359-ae8f-0aae5a07f40b"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="a30befc9-d04a-478a-a95e-197f83472824"/> <textFieldExpression><![CDATA[$F{ps1}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="7c4b2ea8-6661-4c46-bff2-0ec267f7c835"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="34b85744-26e6-41d7-9d45-d50f722f0531"/> <textFieldExpression><![CDATA[$F{ps2}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="390ffda6-6d4b-4a5c-aa88-f2a65890df63"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="dca8820e-35bf-41fd-ba77-3df74555133f"/> <textFieldExpression><![CDATA[$F{ps3}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="b4889dd8-b8d2-4139-9894-93e9894739d4"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="85947a1c-124c-48d1-9d34-d788de3deab7"/> <textFieldExpression><![CDATA[$F{ps4}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="140fd10f-7066-411d-8d8a-509417956a22"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="e2795993-738d-48fd-a111-58ca0a9323bc"/> <textFieldExpression><![CDATA[$F{ps5}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="974a58c7-b7f7-4a75-8e8b-72a30a72e075"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="3169cca4-e391-402f-84d3-5d24ec8369e5"/> <textFieldExpression><![CDATA[$F{comments}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="cd5c1eb2-9ff0-47d5-8aad-83d96fd48c34"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="948f4974-56ea-44a6-ad6a-5cbf6486cbe2"/> <textFieldExpression><![CDATA[$F{p.d.w}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="1f4a88de-68e5-4dd6-8496-f897508fb46e"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="2dd49b6e-9292-46ef-a80a-5f018b93f05d"/> <textFieldExpression><![CDATA[$F{mpv}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="90" uuid="29f52e7a-535c-4a4b-8cfd-576bfc844f8c"> <jr:detailCell style="table 9_TD" height="20"> <textField> <reportElement x="0" y="0" width="90" height="20" uuid="6f17d315-d7bf-4c93-98b3-a8ba35882544"/> <textFieldExpression><![CDATA[$F{p_lcr}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> </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. 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>
×
×
  • Create New...