kojohn407 Posted January 18 Share Posted January 18 <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.19.1.final using JasperReports Library version 6.19.1-867c00bf88cd4d784d404379d6c05e1b419e8a4c --> <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="CONSO_TRIAL_FCY" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isIgnorePagination="true" uuid="fe432b91-bbe4-427f-abfd-fe07e7dbc2dc"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="MDB_PRE_CUSTOM"/> <property name="com.jaspersoft.studio.unit." value="pixel"/> <property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/> <property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/> <property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/> <property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="net.sf.jasperreports.export.xls.exclude.origin.keep.first.band.1" value="pageHeader"/> <property name="net.sf.jasperreports.export.xls.exclude.origin.band.2" value="pageFooter"/> <property name="net.sf.jasperreports.export.xls.exclude.origin.band.3" value="lastPageFooter"/> <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true"/> <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns" value="true"/> <property name="net.sf.jasperreports.export.xls.white.page.background" value="false"/> <property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/> <property name="net.sf.jasperreports.export.xls.ignore.graphics" value="false"/> <property name="net.sf.jasperreports.export.xls.ignore.cell.border" value="true"/> <parameter name="VI_TRAN_DATE" class="java.sql.Date"/> <parameter name="VI_BRANCH_CODE" class="java.lang.String"/> <parameter name="VI_CURRENCY_CODE" class="java.lang.String"/> <parameter name="SUBREPORT_BRANCH_NAME_LANDSCAPE" class="net.sf.jasperreports.engine.JasperReport"> <parameterDescription><![CDATA[]]></parameterDescription> <defaultValueExpression><![CDATA[$P{SUBREPORT_BRANCH_NAME_LANDSCAPE}]]></defaultValueExpression> </parameter> <queryString language="plsql"> <![CDATA[{call CUSTOM.RPT_CONSO_TRIAL_FCY($P{ORACLE_REF_CURSOR},$P{VI_TRAN_DATE},$P{VI_BRANCH_CODE},$P{VI_CURRENCY_CODE})}]]> </queryString> <field name="ACCOUNT_NUMBER" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="ACCOUNT_NUMBER"/> <property name="com.jaspersoft.studio.field.label" value="ACCOUNT_NUMBER"/> </field> <field name="TYPE" class="java.math.BigDecimal"> <property name="com.jaspersoft.studio.field.name" value="TYPE"/> <property name="com.jaspersoft.studio.field.label" value="TYPE"/> </field> <field name="DESCRIPTION" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="DESCRIPTION"/> <property name="com.jaspersoft.studio.field.label" value="DESCRIPTION"/> </field> <field name="FCY_ASS" class="java.math.BigDecimal"> <property name="com.jaspersoft.studio.field.name" value="FCY_ASS"/> <property name="com.jaspersoft.studio.field.label" value="FCY_ASS"/> </field> <field name="ASSETS" class="java.math.BigDecimal"> <property name="com.jaspersoft.studio.field.name" value="ASSETS"/> <property name="com.jaspersoft.studio.field.label" value="ASSETS"/> </field> <field name="FCY_LIA" class="java.math.BigDecimal"> <property name="com.jaspersoft.studio.field.name" value="FCY_LIA"/> <property name="com.jaspersoft.studio.field.label" value="FCY_LIA"/> </field> <field name="LIABILITIES" class="java.math.BigDecimal"> <property name="com.jaspersoft.studio.field.name" value="LIABILITIES"/> <property name="com.jaspersoft.studio.field.label" value="LIABILITIES"/> </field> <variable name="GT_ASS" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[$F{ASSETS}]]></variableExpression> <initialValueExpression><![CDATA[$F{ASSETS}]]></initialValueExpression> </variable> <variable name="GT_LIA" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[$F{LIABILITIES}]]></variableExpression> <initialValueExpression><![CDATA[$F{LIABILITIES}]]></initialValueExpression> </variable> <variable name="GT_FCY_ASS" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[$F{FCY_ASS}]]></variableExpression> <initialValueExpression><![CDATA[$F{FCY_ASS}]]></initialValueExpression> </variable> <variable name="GT_FCY_LIA" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[$F{FCY_LIA}]]></variableExpression> <initialValueExpression><![CDATA[$F{FCY_LIA}]]></initialValueExpression> </variable> <background> <band splitType="Stretch"/> </background> <title> <band height="80"> <textField> <reportElement isPrintRepeatedValues="false" x="0" y="0" width="800" height="20" isPrintInFirstWholeBand="true" uuid="ab6966b0-3f84-4cc0-8d67-e27906b36e6a"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Times New Roman" size="12" isBold="true"/> </textElement> <textFieldExpression><![CDATA["MD Bank(PCL)"]]></textFieldExpression> </textField> <textField> <reportElement isPrintRepeatedValues="false" x="0" y="40" width="800" height="20" isPrintInFirstWholeBand="true" uuid="ef05614d-5f50-4591-a1ad-0c2d452b52b4"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Times New Roman" size="12" isBold="true"/> </textElement> <textFieldExpression><![CDATA[($P{VI_BRANCH_CODE}==null || $P{VI_BRANCH_CODE}.isEmpty()?"Consolidated General":"General")+" Trial Balance As On " +new SimpleDateFormat("dd/MM/yyyy").format($P{VI_TRAN_DATE})+ " ( " + ($P{VI_CURRENCY_CODE} == null || $P{VI_CURRENCY_CODE}.isEmpty() ? "ALL" : $P{VI_CURRENCY_CODE}) +" )"]]></textFieldExpression> </textField> <subreport> <reportElement isPrintRepeatedValues="false" x="0" y="20" width="800" height="20" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="true" uuid="72b4b8d3-47bc-4e1d-964a-9654384de5a2"/> <subreportParameter name="VI_BRANCH_CODE"> <subreportParameterExpression><![CDATA[$P{VI_BRANCH_CODE}]]></subreportParameterExpression> </subreportParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression><![CDATA[$P{SUBREPORT_BRANCH_NAME_LANDSCAPE}]]></subreportExpression> </subreport> <textField pattern="MMMMM dd, yyyy"> <reportElement isPrintRepeatedValues="false" x="570" y="60" width="230" height="20" isPrintInFirstWholeBand="true" uuid="a0278c63-37ef-459b-9f55-7c0462c4d5a6"/> <box rightPadding="3"/> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Times New Roman" size="10" isBold="true"/> </textElement> <textFieldExpression><![CDATA["Printed Date : "+new SimpleDateFormat("dd.MM.yyyy").format(new java.util.Date())]]></textFieldExpression> </textField> </band> </title> <columnHeader> <band height="20" splitType="Stretch"> <staticText> <reportElement x="0" y="0" width="120" height="20" uuid="9940355e-ac00-4cae-8cf1-0afb9d4af3c1"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="51eb4fc0-085b-4506-84b6-e89c2590aeaf"/> </reportElement> <box> <pen lineWidth="0.5" lineColor="#6E7A75"/> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Times New Roman" size="10" isBold="true"/> </textElement> <text><![CDATA[DrFCY]]></text> </staticText> <staticText> <reportElement x="240" y="0" width="110" height="20" uuid="601631ec-63e0-4204-847a-73d449a815eb"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="7b2133df-79cd-491a-9115-e2837a148dec"/> </reportElement> <box> <pen lineWidth="0.5" lineColor="#6E7A75"/> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Times New Roman" size="10" isBold="true"/> </textElement> <text><![CDATA[Account Number]]></text> </staticText> <staticText> <reportElement x="350" y="0" width="220" height="20" uuid="7a8ed302-5aa0-481b-97ff-316540426d5d"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="847e1637-d26a-4ea1-8692-bdc3ef52deb4"/> </reportElement> <box> <pen lineWidth="0.5" lineColor="#6E7A75"/> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Times New Roman" size="10" isBold="true"/> </textElement> <text><![CDATA[Description]]></text> </staticText> <staticText> <reportElement x="690" y="0" width="110" height="20" uuid="ff15d9d8-fb71-4517-a111-b3311b8557a9"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="7588b665-9696-4877-9ec4-ac26aba27bbd"/> </reportElement> <box> <pen lineWidth="0.5" lineColor="#6E7A75"/> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Times New Roman" size="10" isBold="true"/> </textElement> <text><![CDATA[CrMMK]]></text> </staticText> <staticText> <reportElement x="570" y="0" width="120" height="20" uuid="0b221390-8162-485d-a2f2-7830d48cbb19"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="7588b665-9696-4877-9ec4-ac26aba27bbd"/> </reportElement> <box> <pen lineWidth="0.5" lineColor="#6E7A75"/> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Times New Roman" size="10" isBold="true"/> </textElement> <text><![CDATA[CrFCY]]></text> </staticText> <staticText> <reportElement x="120" y="0" width="120" height="20" uuid="07831822-0585-47da-a4c1-0b7be92e5588"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="51eb4fc0-085b-4506-84b6-e89c2590aeaf"/> </reportElement> <box> <pen lineWidth="0.5" lineColor="#6E7A75"/> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Times New Roman" size="10" isBold="true"/> </textElement> <text><![CDATA[DrMMK]]></text> </staticText> </band> </columnHeader> <detail> <band height="20" splitType="Stretch"> <textField isBlankWhenNull="true"> <reportElement x="240" y="0" width="110" height="20" uuid="9c16cdf8-0a24-413e-be0d-88ea546ad03b"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="8c84b781-3c73-4643-87ee-9eb2f0702539"/> </reportElement> <box> <pen lineWidth="0.5" lineColor="#6E7A75"/> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Times New Roman" size="9"/> </textElement> <textFieldExpression><![CDATA[$F{ACCOUNT_NUMBER}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="350" y="0" width="220" height="20" uuid="f32347b4-d1cb-4a97-8b10-3cb12dc7122b"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="47d8b82f-df10-4910-8b86-b690390f9750"/> </reportElement> <box leftPadding="3"> <pen lineWidth="0.5" lineColor="#6E7A75"/> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> </box> <textElement textAlignment="Left" verticalAlignment="Middle"> <font fontName="Times New Roman" size="9"/> </textElement> <textFieldExpression><![CDATA[$F{DESCRIPTION}]]></textFieldExpression> </textField> <textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true"> <reportElement x="0" y="0" width="120" height="20" uuid="0c7cab3e-8ff3-4ac8-a430-776725683406"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="455a875a-19e2-4082-95cf-ebf5b94b8190"/> </reportElement> <box rightPadding="3"> <pen lineWidth="0.5" lineColor="#6E7A75"/> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Times New Roman" size="9"/> </textElement> <textFieldExpression><![CDATA[$F{FCY_ASS}]]></textFieldExpression> </textField> <textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true"> <reportElement x="120" y="0" width="120" height="20" uuid="b110281f-066b-4b42-8776-b4c1c44c3d28"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e8d336a3-fc2a-4e65-b6c8-9b9fb69c372c"/> </reportElement> <box rightPadding="3"> <pen lineWidth="0.5" lineColor="#6E7A75"/> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Times New Roman" size="9"/> </textElement> <textFieldExpression><![CDATA[$F{ASSETS}]]></textFieldExpression> </textField> <textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true"> <reportElement x="570" y="0" width="120" height="20" uuid="e50f421a-97c1-4db5-bf24-22a468ef0098"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3fbc01b4-aa97-456c-8094-aa8daa365c76"/> </reportElement> <box rightPadding="3"> <pen lineWidth="0.5" lineColor="#6E7A75"/> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Times New Roman" size="9"/> </textElement> <textFieldExpression><![CDATA[$F{FCY_LIA}]]></textFieldExpression> </textField> <textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true"> <reportElement x="690" y="0" width="110" height="20" uuid="80372fa1-e595-4479-9d1b-6f49b41efd05"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="7d5d87ec-ea78-4721-bc90-21c24c8d1ff3"/> </reportElement> <box rightPadding="3"> <pen lineWidth="0.5" lineColor="#6E7A75"/> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Times New Roman" size="9"/> </textElement> <textFieldExpression><![CDATA[$F{LIABILITIES}]]></textFieldExpression> </textField> </band> </detail> <summary> <band height="20" splitType="Stretch"> <staticText> <reportElement x="240" y="0" width="110" height="20" uuid="44b905d6-c43a-4f1a-b3f5-dbeb2743cfc2"/> <box> <pen lineWidth="0.5" lineColor="#6E7A75"/> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> </box> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement x="350" y="0" width="220" height="20" uuid="3b67c414-73e8-442c-88a6-0f95ff574178"/> <box> <pen lineWidth="0.5" lineColor="#6E7A75"/> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Times New Roman" isBold="true"/> </textElement> <text><![CDATA[Grand Total]]></text> </staticText> <textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true"> <reportElement x="690" y="0" width="110" height="20" uuid="9381c59e-b857-44d7-ba6f-755f65116565"/> <box rightPadding="3"> <pen lineWidth="0.5" lineColor="#6E7A75"/> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Times New Roman" size="10" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$V{GT_LIA}]]></textFieldExpression> </textField> <textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true"> <reportElement x="120" y="0" width="120" height="20" uuid="b239c74d-ff59-4d45-902a-f43594e1b155"/> <box rightPadding="3"> <pen lineWidth="0.5" lineColor="#6E7A75"/> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Times New Roman" size="10" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$V{GT_ASS}]]></textFieldExpression> </textField> <textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true"> <reportElement x="0" y="0" width="120" height="20" uuid="f53dddc2-c723-4f23-ba79-85f1df562368"/> <box rightPadding="3"> <pen lineWidth="0.5" lineColor="#6E7A75"/> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Times New Roman" size="10" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$V{GT_FCY_ASS}]]></textFieldExpression> </textField> <textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true"> <reportElement x="570" y="0" width="120" height="20" uuid="27f5b01f-ad3e-49dd-b013-74ef796483b1"/> <box rightPadding="3"> <pen lineWidth="0.5" lineColor="#6E7A75"/> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#6E7A75"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Times New Roman" size="10" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$V{GT_FCY_LIA}]]></textFieldExpression> </textField> </band> </summary> </jasperReport> Link to comment Share on other sites More sharing options...
kojohn407 Posted January 18 Author Share Posted January 18 I want only one header column as TotalAmt if all the data of fcy_ass are equal with all the data of assets. Link to comment Share on other sites More sharing options...
Tirupathi Mangalarapu Posted January 19 Share Posted January 19 Hello There, You can uncheck "Print Repeated Values" on the text element properties or you can move all the elements inside a Frame and uncheck "Print Repeated Values" on the whole frame. Let us know if that helps. Thank you 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now