technocluez

I am building software for petrol pump. In that I have a report of creditors. In that report I am showing all creditors details i.e. Total amount of credit and debit , balance for each creditor. I am passing arraylist of creditors Id from Java code. I used jrbeancollectiondatasource as a parameter in jasper. I am getting exception. net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query: select c.CUSTOMER_ID,c.CUSTOMER_NAME,c.CONTACT_NO,c.EMAIL_ID,c.Reference_NAME,c.ADDRESS from PETROLPUMP.CREDITLIST c where c.isDeleted=false and c.CUSTOMER_ID=[1, 2] And the data from arraylist is passing as it is. One by one value is not getting passed.How should I do it? //here is my code snippet <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.5.0.final using JasperReports Library version 6.5.0 --> <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Creditdetails" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isSummaryWithPageHeaderAndFooter="true" isIgnorePagination="true" uuid="ced95029-b569-4027-895c-af2843a4e088"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="petrolpump adapter"/> <style name="Title" fontName="Times New Roman" fontSize="50" isBold="true"/> <style name="SubTitle" forecolor="#736343" fontName="Arial" fontSize="18"/> <style name="Column header" forecolor="#666666" fontName="Arial" fontSize="12" isBold="true"/> <style name="Detail" fontName="Arial" fontSize="12"/> <style name="Row" mode="Transparent"> <conditionalStyle> <conditionExpression><![CDATA[$V{REPORT_COUNT}%2 == 0]]></conditionExpression> <style backcolor="#E6DAC3"/> </conditionalStyle> </style> <style name="Table_TH" mode="Opaque" backcolor="#C5CFD9"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_CH" mode="Opaque" backcolor="#EDF4FA"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 1_TH" mode="Opaque" backcolor="#C5CFD9"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 1_CH" mode="Opaque" backcolor="#EDF4FA"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 1_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <subDataset name="Dataset1" uuid="e7405fec-8c74-4e03-a159-c8a808d91a1c"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="petrolpump adapter"/> <parameter name="customerSelected" class="net.sf.jasperreports.engine.data.JRBeanCollectionDataSource"/> <queryString language="SQL"> <![CDATA[sELECT CAST(gc.CREATED_ON As Date) ,n.NOZZEL_NAME,gc.QUANTITY, gc.CREDIT_AMT ,gc.REMARKS FROM PETROLPUMP.GIVECREDIT gc join PETROLPUMP.NOZZEL n on gc.NOZZEL_ID =n.NOZZEL_ID where gc.isDeleted=false and gc.CUSTOMER_ID=$P!{customerSelected}]]> </queryString> <field name="CAST(GC.CREATED_ON AS DATE)" class="java.sql.Date"> <property name="com.jaspersoft.studio.field.label" value="CAST(GC.CREATED_ON AS DATE)"/> </field> <field name="NOZZEL_NAME" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="NOZZEL_NAME"/> <property name="com.jaspersoft.studio.field.tree.path" value="NOZZEL"/> </field> <field name="QUANTITY" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="QUANTITY"/> <property name="com.jaspersoft.studio.field.tree.path" value="GIVECREDIT"/> </field> <field name="CREDIT_AMT" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="CREDIT_AMT"/> <property name="com.jaspersoft.studio.field.tree.path" value="GIVECREDIT"/> </field> <field name="REMARKS" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="REMARKS"/> <property name="com.jaspersoft.studio.field.tree.path" value="GIVECREDIT"/> </field> <variable name="TotalQuantity" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[new BigDecimal($F{QUANTITY})]]></variableExpression> </variable> <variable name="TotalCredit" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[new BigDecimal($F{CREDIT_AMT})]]></variableExpression> </variable> <group name="CAST(GC.CREATED_ON AS DATE)"> <groupExpression><![CDATA[$F{CAST(GC.CREATED_ON AS DATE)}]]></groupExpression> </group> <group name="NOZZEL_NAME"> <groupExpression><![CDATA[$F{NOZZEL_NAME}]]></groupExpression> </group> <group name="QUANTITY"> <groupExpression><![CDATA[$F{QUANTITY}]]></groupExpression> </group> <group name="CREDIT_AMT"> <groupExpression><![CDATA[$F{CREDIT_AMT}]]></groupExpression> </group> <group name="REMARKS"> <groupExpression><![CDATA[$F{REMARKS}]]></groupExpression> </group> </subDataset> <subDataset name="Dataset2" uuid="d2edd08a-7836-4b54-b609-d5e20b22a8bf"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="petrolpump adapter"/> <parameter name="customerSelected" class="net.sf.jasperreports.engine.data.JRBeanCollectionDataSource"/> <queryString language="SQL"> <![CDATA[sELECT CAST( d.CREATED_ON AS Date),d.DEBIT_AMT FROM PETROLPUMP.DEBIT d where d.ISDELETED =false and d.CUSTOMER_ID=$P!{customerSelected}]]> </queryString> <field name="CAST(D.CREATED_ON AS DATE)" class="java.sql.Date"> <property name="com.jaspersoft.studio.field.label" value="CAST(D.CREATED_ON AS DATE)"/> </field> <field name="DEBIT_AMT" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="DEBIT_AMT"/> <property name="com.jaspersoft.studio.field.tree.path" value="DEBIT"/> </field> <variable name="TotalDebit" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[new BigDecimal($F{DEBIT_AMT})]]></variableExpression> </variable> </subDataset> <parameter name="customerSelected" class="java.util.ArrayList"/> <queryString language="SQL"> <![CDATA[select c.CUSTOMER_ID,c.CUSTOMER_NAME,c.CONTACT_NO,c.EMAIL_ID,c.Reference_NAME,c.ADDRESS from PETROLPUMP.CREDITLIST c where c.isDeleted=false and c.CUSTOMER_ID=$P!{customerSelected}]]> </queryString> <field name="CUSTOMER_ID" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="CUSTOMER_ID"/> <property name="com.jaspersoft.studio.field.tree.path" value="CREDITLIST"/> </field> <field name="CUSTOMER_NAME" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="CUSTOMER_NAME"/> <property name="com.jaspersoft.studio.field.tree.path" value="CREDITLIST"/> </field> <field name="CONTACT_NO" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="CONTACT_NO"/> <property name="com.jaspersoft.studio.field.tree.path" value="CREDITLIST"/> </field> <field name="EMAIL_ID" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="EMAIL_ID"/> <property name="com.jaspersoft.studio.field.tree.path" value="CREDITLIST"/> </field> <field name="REFERENCE_NAME" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="REFERENCE_NAME"/> <property name="com.jaspersoft.studio.field.tree.path" value="CREDITLIST"/> </field> <field name="ADDRESS" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="ADDRESS"/> <property name="com.jaspersoft.studio.field.tree.path" value="CREDITLIST"/> </field> <variable name="credit_total" class="java.math.BigDecimal" calculation="System"/> <variable name="debit_total" class="java.math.BigDecimal" calculation="System"/> <background> <band splitType="Stretch"/> </background> <title> <band height="216" splitType="Stretch"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.spreadsheet.SpreadsheetLayout"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> <image> <reportElement x="1" y="0" width="164" height="146" uuid="ddc15723-2728-421f-b95e-2df9faf64ce1"/> <imageExpression><![CDATA["IMG-20171223-WA0022.jpg"]]></imageExpression> </image> <staticText> <reportElement style="Title" x="190" y="30" width="365" height="62" uuid="1a652692-054a-40f3-ade5-68d8da36626d"/> <textElement verticalAlignment="Middle"> <font size="30"/> </textElement> <text><![CDATA[uddhavesh Petroleum]]></text> </staticText> <staticText> <reportElement style="SubTitle" x="358" y="100" width="196" height="22" uuid="88d4231e-f014-4b0d-b871-1737ba63a1ae"/> <textElement> <font fontName="Times New Roman"/> </textElement> <text><![CDATA[DEALER:ESSAR OIL]]></text> </staticText> <staticText> <reportElement x="-1" y="150" width="555" height="26" uuid="f0bfb1ea-a85a-47cd-a1a4-43f22b45e80f"/> <textElement textAlignment="Left" verticalAlignment="Middle" markup="none"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[ Report of Credit Details of ]]></text> </staticText> <line> <reportElement positionType="FixRelativeToBottom" x="-1" y="200" width="555" height="1" uuid="1a61a836-d137-48b1-ad67-6ff64600bf93"> <property name="com.jaspersoft.studio.unit.height" value="px"/> <property name="com.jaspersoft.studio.unit.x" value="px"/> <property name="com.jaspersoft.studio.unit.y" value="px"/> <property name="com.jaspersoft.studio.unit.width" value="px"/> </reportElement> <graphicElement> <pen lineWidth="0.5" lineColor="#999999"/> </graphicElement> </line> <textField isStretchWithOverflow="true"> <reportElement x="300" y="150" width="255" height="26" uuid="1254c54f-ea53-40db-9732-1bbcbc598ebe"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$F{CUSTOMER_NAME}]]></textFieldExpression> </textField> </band> </title> <pageHeader> <band splitType="Stretch"/> </pageHeader> <columnHeader> <band height="558" splitType="Stretch"> <property name="com.jaspersoft.studio.unit.height" value="px"/> <staticText> <reportElement style="Column header" positionType="Float" x="0" y="0" width="111" height="26" forecolor="#000000" uuid="1ac5a7bb-ee22-4130-b13f-863a62023ce7"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="b0a40767-ea97-46b2-81d7-734b410999e2"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </reportElement> <textElement textAlignment="Left" verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[Customer Name:]]></text> </staticText> <textField isStretchWithOverflow="true"> <reportElement style="Detail" positionType="Float" x="120" y="0" width="360" height="26" uuid="c5ff4332-5b24-4cee-a544-4b8c8a8f9473"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="b0a40767-ea97-46b2-81d7-734b410999e2"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </reportElement> <textElement textAlignment="Left" verticalAlignment="Middle"> <font size="14" isBold="false"/> </textElement> <textFieldExpression><![CDATA[$F{CUSTOMER_NAME}]]></textFieldExpression> </textField> <staticText> <reportElement positionType="Float" x="1" y="40" width="110" height="26" uuid="4af33329-da68-4649-a00e-ad40f1fe6a66"> <property name="com.jaspersoft.studio.unit.height" value="px"/> </reportElement> <textElement textAlignment="Left" verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[Refernce Name:]]></text> </staticText> <textField> <reportElement positionType="Float" x="120" y="40" width="220" height="26" uuid="a1740668-2cee-45cb-8814-b66bf25a509c"> <property name="com.jaspersoft.studio.unit.height" value="px"/> </reportElement> <textElement textAlignment="Left" verticalAlignment="Middle"> <font size="14"/> </textElement> <textFieldExpression><![CDATA[$F{REFERENCE_NAME}]]></textFieldExpression> </textField> <staticText> <reportElement positionType="Float" x="-1" y="80" width="112" height="26" uuid="55d49d35-29d0-4169-852d-1bc730e6d6f5"> <property name="com.jaspersoft.studio.unit.height" value="px"/> </reportElement> <textElement textAlignment="Left" verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[Address:]]></text> </staticText> <textField> <reportElement positionType="Float" x="120" y="80" width="435" height="26" uuid="207e9294-14ef-4c26-a143-2ebb2495d818"> <property name="com.jaspersoft.studio.unit.height" value="px"/> </reportElement> <textElement textAlignment="Left" verticalAlignment="Middle"> <font size="14"/> </textElement> <textFieldExpression><![CDATA[$F{ADDRESS}]]></textFieldExpression> </textField> <staticText> <reportElement positionType="Float" x="1" y="120" width="110" height="30" uuid="c0a5c6a2-db57-4c3d-962a-0664379af790"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[E-mail ID:]]></text> </staticText> <textField> <reportElement positionType="Float" x="120" y="120" width="260" height="30" uuid="87ec8264-304e-477d-9a51-d59d944c90f2"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font size="14"/> </textElement> <textFieldExpression><![CDATA[$F{EMAIL_ID}]]></textFieldExpression> </textField> <staticText> <reportElement positionType="Float" x="1" y="160" width="110" height="30" uuid="85a81867-da0b-493b-89f3-3b8761dfbdd9"/> <textElement verticalAlignment="Middle"> <font size="14" isBold="true" isItalic="false"/> </textElement> <text><![CDATA[Contact No:]]></text> </staticText> <textField> <reportElement positionType="Float" x="120" y="160" width="210" height="30" uuid="4b6d4303-9466-4649-a2da-f956f81c1e65"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font size="14"/> </textElement> <textFieldExpression><![CDATA[$F{CONTACT_NO}]]></textFieldExpression> </textField> <componentElement> <reportElement positionType="Float" x="-1" y="210" width="551" height="150" uuid="1fd75819-07a3-4a24-8342-c4a42f4c0435"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> <property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/> <property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/> <property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/> </reportElement> <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="Dataset1" uuid="a4fab1ee-e844-4137-a69a-1817c1da9aa4"> <datasetParameter name="customerSelected"> <datasetParameterExpression><![CDATA[$P{customerSelected}]]></datasetParameterExpression> </datasetParameter> <dataSourceExpression><![CDATA[$P{customerSelected}]]></dataSourceExpression> <returnValue fromVariable="TotalCredit" toVariable="credit_total"/> </datasetRun> <jr:column width="110" uuid="ab97710d-8570-41ab-bd1f-3cb28a8952e4"> <jr:tableHeader style="Table_TH" height="30"/> <jr:tableFooter style="Table_TH" height="30"/> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="110" height="30" uuid="591054fa-1c97-4603-84ee-2f1923ec395d"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[CREDIT DATE]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField pattern="MMM d, yyyy"> <reportElement x="0" y="0" width="110" height="30" uuid="6c369199-b11c-431c-8a04-fcf43724bdae"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="14"/> </textElement> <textFieldExpression><![CDATA[$F{CAST(GC.CREATED_ON AS DATE)}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="110" uuid="dd4d83d1-78d0-4d16-871a-d31bea67e633"> <jr:tableHeader style="Table_TH" height="30"/> <jr:tableFooter style="Table_TH" height="30"> <staticText> <reportElement x="0" y="0" width="110" height="30" uuid="fb921a07-31ff-4f62-be64-5298bbe482ff"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[TOTAL]]></text> </staticText> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="110" height="30" uuid="25c103fa-2228-407e-915f-d0759dea8cd1"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[NOZZEL NAME]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="110" height="30" uuid="4fe95af2-805e-4d2f-aca5-0ed3a76925d8"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="14"/> </textElement> <textFieldExpression><![CDATA[$F{NOZZEL_NAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="110" uuid="7d4749ff-9273-4095-8fc5-afd88c1061fb"> <jr:tableHeader style="Table_TH" height="30"/> <jr:tableFooter style="Table_TH" height="30"> <textField> <reportElement x="0" y="0" width="110" height="30" uuid="a1d2cef7-6cfb-4184-8252-4d6c9d6c9ea2"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$V{TotalQuantity}]]></textFieldExpression> </textField> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="110" height="30" uuid="f3564254-8342-41ac-b987-ccbb08d7915c"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[QUANTITY]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="110" height="30" uuid="111f294a-af7a-42ae-8018-fffbccaaf281"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="14"/> </textElement> <textFieldExpression><![CDATA[$F{QUANTITY}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="111" uuid="28152b9e-e7ce-48a2-bc97-877829f940c3"> <jr:tableHeader style="Table_TH" height="30"/> <jr:tableFooter style="Table_TH" height="30"> <textField> <reportElement x="0" y="0" width="111" height="30" uuid="f23cc514-71d1-46cf-a763-f71635c63c90"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$V{TotalCredit}]]></textFieldExpression> </textField> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="111" height="30" uuid="422e2f0e-2623-4ab8-a682-4cec5f25fdbd"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[CREDIT AMOUNT]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="111" height="30" uuid="bb5bedaf-e638-477d-bec5-0a4528a004a8"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="14"/> </textElement> <textFieldExpression><![CDATA[$F{CREDIT_AMT}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="110" uuid="3f048312-a3f5-46cd-ba06-04cf7c1eab04"> <jr:tableHeader style="Table_TH" height="30"/> <jr:tableFooter style="Table_TH" height="30"/> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="110" height="30" uuid="9283c221-a3b9-4356-8975-3f672699c95b"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[REMARKS]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="110" height="30" uuid="8bc899c1-f140-4324-9bc8-8e0a2486dbac"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="14"/> </textElement> <textFieldExpression><![CDATA[$F{REMARKS}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> <componentElement> <reportElement positionType="Float" x="0" y="400" width="553" height="151" uuid="750e2cf9-4cf3-4b0c-958f-5a111abbcdbd"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> <property name="com.jaspersoft.studio.table.style.table_header" value="Table 1_TH"/> <property name="com.jaspersoft.studio.table.style.column_header" value="Table 1_CH"/> <property name="com.jaspersoft.studio.table.style.detail" value="Table 1_TD"/> </reportElement> <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="Dataset2" uuid="96e40beb-0e4e-4ee3-8c1f-4a6258fe174d"> <datasetParameter name="customerSelected"> <datasetParameterExpression><![CDATA[$P{customerSelected}]]></datasetParameterExpression> </datasetParameter> <dataSourceExpression><![CDATA[$P{customerSelected}]]></dataSourceExpression> <returnValue fromVariable="TotalDebit" toVariable="debit_total"/> </datasetRun> <jr:column width="277" uuid="a343c68c-ebb3-4dc9-afaa-b1090bb6fe9a"> <jr:tableHeader style="Table 1_TH" height="30"/> <jr:tableFooter style="Table 1_TH" height="30"> <staticText> <reportElement x="0" y="0" width="277" height="30" uuid="050aaf8b-3297-4789-b127-c79db3701b6a"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[TOTAL]]></text> </staticText> </jr:tableFooter> <jr:columnHeader style="Table 1_CH" height="30"> <staticText> <reportElement x="0" y="0" width="277" height="30" uuid="b509d418-fbd1-4d95-9acb-fad218864705"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[DEBIT DATE]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table 1_CH" height="30"/> <jr:detailCell style="Table 1_TD" height="30"> <textField pattern="MMM d, yyyy"> <reportElement x="0" y="0" width="277" height="30" uuid="811dbab1-34f4-48f0-80e8-53191a446652"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="14"/> </textElement> <textFieldExpression><![CDATA[$F{CAST(D.CREATED_ON AS DATE)}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="276" uuid="b6bcc630-a409-4ccc-8aa7-5f08e3ef8319"> <jr:tableHeader style="Table 1_TH" height="30"/> <jr:tableFooter style="Table 1_TH" height="30"> <textField> <reportElement x="0" y="0" width="276" height="30" uuid="c0cbb7b6-0c55-4695-87d8-2bc79ed83248"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$V{TotalDebit}]]></textFieldExpression> </textField> </jr:tableFooter> <jr:columnHeader style="Table 1_CH" height="30"> <staticText> <reportElement x="0" y="0" width="276" height="30" uuid="5927fce9-de93-4c1a-a5f7-9e74aa42b93c"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[DEBIT_AMT]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table 1_CH" height="30"/> <jr:detailCell style="Table 1_TD" height="30"> <textField> <reportElement x="0" y="0" width="276" height="30" uuid="4bad5fa3-b71e-4232-8119-77a88ba4e812"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="14"/> </textElement> <textFieldExpression><![CDATA[$F{DEBIT_AMT}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> <staticText> <reportElement positionType="Float" x="20" y="370" width="120" height="20" uuid="60a8355b-a917-478d-bc15-3e08fafe10a8"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[Debit Details of]]></text> </staticText> <textField> <reportElement positionType="Float" x="140" y="370" width="100" height="20" uuid="6edc4f21-de29-4920-b6c7-ce032b335788"/> <textElement verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$F{CUSTOMER_NAME}]]></textFieldExpression> </textField> </band> </columnHeader> <pageFooter> <band height="25" splitType="Stretch"> <frame> <reportElement mode="Opaque" x="-21" y="1" width="597" height="24" forecolor="#D0B48E" backcolor="#F2EBDF" uuid="183682bc-d976-4756-83e0-6625a3f98ed1"/> <textField evaluationTime="Report"> <reportElement style="Column header" x="533" y="0" width="40" height="20" forecolor="#736343" uuid="0193f9b3-1559-491a-8580-b6988863b6a1"/> <textElement verticalAlignment="Middle"> <font size="10" isBold="false"/> </textElement> <textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression> </textField> <textField> <reportElement style="Column header" x="453" y="0" width="80" height="20" forecolor="#736343" uuid="d00b105e-494b-418b-8ac9-8b1b4824f4f0"/> <textElement textAlignment="Right" verticalAlignment="Middle"> <font size="10" isBold="false"/> </textElement> <textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression> </textField> <textField pattern="EEEEE dd MMMMM yyyy"> <reportElement style="Column header" x="22" y="1" width="197" height="20" forecolor="#736343" uuid="0616f3fe-0354-456f-8911-ec30ec51a5ae"> <property name="net.sf.jasperreports.export.xls.pattern" value="ddd, mmm d, yyyy"/> </reportElement> <textElement verticalAlignment="Middle"> <font size="10" isBold="false"/> </textElement> <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression> </textField> </frame> </band> </pageFooter> <summary> <band height="44" splitType="Stretch"> <property name="com.jaspersoft.studio.unit.height" value="px"/> <staticText> <reportElement x="50" y="10" width="100" height="27" uuid="2ee52400-ed35-4004-91b0-dc7f963663b3"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <text><![CDATA[balance:]]></text> </staticText> <textField> <reportElement x="150" y="10" width="100" height="27" uuid="108e045c-0e24-460e-8d61-1f329e4a7f68"/> <textElement textAlignment="Left" verticalAlignment="Middle"> <font size="14" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$V{credit_total}.subtract($V{debit_total})]]></textFieldExpression> </textField> </band> </summary> </jasperReport>