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

mehtaruchi1312

Members
  • Posts

    2
  • Joined

  • Last visited

mehtaruchi1312's Achievements

Newbie

Newbie (1/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  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...