Jump to content
  • resulting in disorganization of gridline


    sohan617therkar
    CategoryBug report
    PriorityImmediate
    ReproducibilityN/A
    ResolutionOpen
    SeverityCritical
    StatusNew
    Versionv4.7.0

    Not able to wrap the data when width of the data coming is greater than the width of the field in jasper ireport designer. so resulting in disorganization of gridline.please help.

     

    <?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="report11" language="groovy" pageWidth="753" pageHeight="870" columnWidth="748" leftMargin="5" rightMargin="0" topMargin="0" bottomMargin="0" isSummaryWithPageHeaderAndFooter="true" uuid="d2957160-7257-47ae-a26e-538d894b271b">

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

                                                    <pen lineWidth="0.5" lineColor="#000000"/>

                                    </box>

                    </style>

                    <style name="table_CH" mode="Opaque" backcolor="#BFE1FF">

                                    <box>

                                                    <pen lineWidth="0.5" lineColor="#000000"/>

                                    </box>

                    </style>

                    <style name="table_TD" mode="Opaque" backcolor="#FFFFFF">

                                    <box>

                                                    <pen lineWidth="0.5" lineColor="#000000"/>

                                    </box>

                                    <conditionalStyle>

                                                    <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression>

                                                    <style backcolor="#EFF7FF"/>

                                    </conditionalStyle>

                    </style>

                    <style name="ListRow" mode="Opaque" backcolor="#F0F8FF" fill="Solid" scaleImage="FillFrame" hAlign="Left" pattern="" isStrikeThrough="false">

                                    <pen lineStyle="Dashed"/>

                                    <conditionalStyle>

                                                    <conditionExpression><![CDATA[boolean.valueOf($V{REPORT_COUNT}.intValue() %2 == 0)]]></conditionExpression>

                                                    <style backcolor="#FFFFFF"/>

                                    </conditionalStyle>

                    </style>

                    <style name="table 1">

                                    <box>

                                                    <pen lineWidth="1.0" lineColor="#000000"/>

                                    </box>

                    </style>

                    <style name="table 1_TH" mode="Opaque" backcolor="#FAEBD7">

                                    <box>

                                                    <pen lineWidth="0.5" lineColor="#000000"/>

                                    </box>

                    </style>

                    <style name="table 1_CH" mode="Opaque" backcolor="#FFE4BF">

                                    <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="Crosstab Data Text" hAlign="Center"/>

                    <style name="GridLine" mode="Opaque" forecolor="#A1A9A9" backcolor="#A1A9A9" fill="Solid" scaleImage="FillFrame" hAlign="Left" pattern="" isStrikeThrough="false">

                                    <pen lineStyle="Dashed"/>

                                    <conditionalStyle>

                                                    <conditionExpression><![CDATA[boolean.valueOf($V{REPORT_COUNT}.intValue() %2 == 0)]]></conditionExpression>

                                                    <style backcolor="#FFFFFF"/>

                                    </conditionalStyle>

                    </style>

                    <subDataset name="RecordsCount" uuid="4ec8eaea-8b14-44ee-9f0b-28da69b73fe9">

                                    <queryString language="SQL">

                                                    <![CDATA[select count(*) count from ATJDDBA.TCDS_FA_ACCT_CNTL]]>

                                    </queryString>

                                    <field name="COUNT" class="java.lang.Integer"/>

                    </subDataset>

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

                                    <defaultValueExpression><![CDATA["c:\\sohan\\Temp\\"]]></defaultValueExpression>

                    </parameter>

                    <parameter name="rowCount" class="java.lang.Number"/>

                    <parameter name="accountType" class="java.lang.String"/>

                    <queryString language="SQL">

                                    <![CDATA[select ACL_CONTROL_NBR,ACT_BRANCH_CD,ACL_MKT_VAL_FUND,ACT_BASE_CRNCY,ACL_TOTL_COST_FUND

                     from ATJDDBA.TCDS_FA_ACCT_CNTL

                     order by ACT_BASE_CRNCY ,  ACT_BRANCH_CD desc]]>

                    </queryString>

                    <field name="ACL_CONTROL_NBR" class="java.lang.Integer"/>

                    <field name="ACT_BRANCH_CD" class="java.lang.String"/>

                    <field name="ACL_MKT_VAL_FUND" class="java.lang.Double"/>

                    <field name="ACT_BASE_CRNCY" class="java.lang.String"/>

                    <field name="ACL_TOTL_COST_FUND" class="java.lang.Double"/>

                    <variable name="VAL_1" class="java.lang.Double" resetType="Group" resetGroup="ACT_BASE_CRNCY" calculation="Sum">

                                    <variableExpression><![CDATA[$F{ACL_MKT_VAL_FUND}]]></variableExpression>

                    </variable>

                    <variable name="VAL_2" class="java.lang.Double" resetType="Group" resetGroup="ACT_BASE_CRNCY" calculation="Sum">

                                    <variableExpression><![CDATA[$F{ACL_TOTL_COST_FUND}]]></variableExpression>

                    </variable>

                    <variable name="Brach_cd1" class="java.lang.Double" resetType="Group" resetGroup="ACT_BRANCH_CD" calculation="Sum">

                                    <variableExpression><![CDATA[$F{ACL_MKT_VAL_FUND}]]></variableExpression>

                    </variable>

                    <variable name="Brach_cd2" class="java.lang.Double" resetType="Group" resetGroup="ACT_BRANCH_CD" calculation="Sum">

                                    <variableExpression><![CDATA[$F{ACL_TOTL_COST_FUND}]]></variableExpression>

                    </variable>

                    <variable name="Grandtotal_mktval" class="java.lang.Double" calculation="Sum">

                                    <variableExpression><![CDATA[$F{ACL_MKT_VAL_FUND}]]></variableExpression>

                    </variable>

                    <variable name="Grandtotal_costfund" class="java.lang.Double" calculation="Sum">

                                    <variableExpression><![CDATA[$F{ACL_TOTL_COST_FUND}]]></variableExpression>

                    </variable>

                    <variable name="RecordsCount" class="java.lang.Double" calculation="Count">

                                    <variableExpression><![CDATA[$V{ACT_BASE_CRNCY_COUNT}]]></variableExpression>

                    </variable>

                    <variable name="lineIndex" class="java.lang.Integer">

                                    <variableExpression><![CDATA[integer.valueOf($V{lineIndex}.intValue() + 1)]]></variableExpression>

                                    <initialValueExpression><![CDATA[integer.valueOf(0)]]></initialValueExpression>

                    </variable>

                    <variable name="running_sum" class="java.lang.String" calculation="Sum">

                                    <variableExpression><![CDATA[$F{ACL_MKT_VAL_FUND}]]></variableExpression>

                    </variable>

                    <variable name="ACL_MKT_VAL_FUND_SUM" class="java.lang.Double" calculation="Sum">

                                    <variableExpression><![CDATA[$F{ACL_MKT_VAL_FUND}]]></variableExpression>

                    </variable>

                    <group name="ACT_BASE_CRNCY">

                                    <groupExpression><![CDATA[$F{ACT_BASE_CRNCY}]]></groupExpression>

                                    <groupHeader>

                                                    <band/>

                                    </groupHeader>

                                    <groupFooter>

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

                                                                    <frame>

                                                                                    <reportElement uuid="f0f75d7a-af0b-422e-a65d-6535c62285d1" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="748" height="26" backcolor="#CCCCCC"/>

                                                                                    <staticText>

                                                                                                    <reportElement uuid="caf6f055-e378-4d66-89f8-5632a71c2ec6" x="8" y="0" width="66" height="13"/>

                                                                                                    <textElement verticalAlignment="Top">

                                                                                                                    <font fontName="Arial" isBold="true"/>

                                                                                                    </textElement>

                                                                                                    <text><![CDATA[sub Total]]></text>

                                                                                    </staticText>

                                                                                    <textField isStretchWithOverflow="true" pattern="##,###,###,##0.00" isBlankWhenNull="true">

                                                                                                    <reportElement uuid="49c24ab4-269a-46a9-8f9e-58a824072f3b" positionType="Float" x="452" y="0" width="137" height="13"/>

                                                                                                    <textElement textAlignment="Right" verticalAlignment="Top">

                                                                                                                    <font fontName="Arial" isBold="true"/>

                                                                                                                    <paragraph lineSpacing="Single"/>

                                                                                                    </textElement>

                                                                                                    <textFieldExpression><![CDATA[$V{VAL_1}]]></textFieldExpression>

                                                                                    </textField>

                                                                                    <textField isStretchWithOverflow="true" pattern="##,###,###,##0.00" isBlankWhenNull="true">

                                                                                                    <reportElement uuid="49c24ab4-269a-46a9-8f9e-58a824072f3b" positionType="Float" x="605" y="0" width="140" height="13"/>

                                                                                                    <textElement textAlignment="Right" verticalAlignment="Top">

                                                                                                                    <font fontName="Arial" isBold="true"/>

                                                                                                    </textElement>

                                                                                                    <textFieldExpression><![CDATA[$V{VAL_2}]]></textFieldExpression>

                                                                                    </textField>

                                                                                    <textField isStretchWithOverflow="true" pattern="">

                                                                                                    <reportElement uuid="292d6d83-21cc-466c-9e5c-9e12c02a146d" isPrintRepeatedValues="false" mode="Transparent" x="75" y="0" width="60" height="13"/>

                                                                                                    <textElement verticalAlignment="Top">

                                                                                                                    <font fontName="Arial" isBold="true"/>

                                                                                                    </textElement>

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

                                                                                    </textField>

                                                                                    <line>

                                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" style="GridLine" stretchType="RelativeToBandHeight" x="290" y="0" width="1" height="13"/>

                                                                                                    <graphicElement>

                                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                                    </graphicElement>

                                                                                    </line>

                                                                                    <line>

                                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" style="GridLine" stretchType="RelativeToBandHeight" x="440" y="0" width="1" height="13"/>

                                                                                                    <graphicElement>

                                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                                    </graphicElement>

                                                                                    </line>

                                                                                    <line>

                                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" style="GridLine" stretchType="RelativeToBandHeight" x="600" y="0" width="1" height="13"/>

                                                                                                    <graphicElement>

                                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                                    </graphicElement>

                                                                                    </line>

                                                                                    <line>

                                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" style="GridLine" stretchType="RelativeToBandHeight" x="70" y="0" width="1" height="13"/>

                                                                                                    <graphicElement>

                                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                                    </graphicElement>

                                                                                    </line>

                                                                                    <line>

                                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" style="GridLine" stretchType="RelativeToBandHeight" x="150" y="0" width="1" height="13"/>

                                                                                                    <graphicElement>

                                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                                    </graphicElement>

                                                                                    </line>

                                                                                    <line>

                                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" style="GridLine" stretchType="RelativeToBandHeight" x="0" y="0" width="1" height="13"/>

                                                                                                    <graphicElement>

                                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                                    </graphicElement>

                                                                                    </line>

                                                                                    <line>

                                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" style="GridLine" stretchType="RelativeToBandHeight" x="746" y="0" width="1" height="13"/>

                                                                                                    <graphicElement>

                                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                                    </graphicElement>

                                                                                    </line>

                                                                                    <textField isStretchWithOverflow="true" pattern="##,###,###,##0.00" isBlankWhenNull="true">

                                                                                                    <reportElement uuid="69f8f694-0677-419e-a58a-4f9e155c8a8f" positionType="Float" x="489" y="13" width="100" height="13" isRemoveLineWhenBlank="true">

                                                                                                                    <printWhenExpression><![CDATA[$P{rowCount}.doubleValue()==$V{REPORT_COUNT}.doubleValue()]]></printWhenExpression>

                                                                                                    </reportElement>

                                                                                                    <textElement textAlignment="Right" verticalAlignment="Top">

                                                                                                                    <font fontName="Arial" isBold="true"/>

                                                                                                    </textElement>

                                                                                                    <textFieldExpression><![CDATA[$V{Grandtotal_mktval}]]></textFieldExpression>

                                                                                    </textField>

                                                                                    <textField isStretchWithOverflow="true" pattern="##,###,###,##0.00" isBlankWhenNull="true">

                                                                                                    <reportElement uuid="9c7519c7-0a31-46fc-aaf5-731f5cf121a9" positionType="Float" x="605" y="13" width="140" height="13" isRemoveLineWhenBlank="true">

                                                                                                                    <printWhenExpression><![CDATA[$P{rowCount}.doubleValue()==$V{REPORT_COUNT}.doubleValue()]]></printWhenExpression>

                                                                                                    </reportElement>

                                                                                                    <textElement textAlignment="Right" verticalAlignment="Top">

                                                                                                                    <font fontName="Arial" isBold="true"/>

                                                                                                    </textElement>

                                                                                                    <textFieldExpression><![CDATA[$V{Grandtotal_costfund}]]></textFieldExpression>

                                                                                    </textField>

                                                                                    <staticText>

                                                                                                    <reportElement uuid="729dac13-eee9-4973-b573-e6ad32db03ac" positionType="Float" x="8" y="13" width="62" height="13" isRemoveLineWhenBlank="true">

                                                                                                                    <printWhenExpression><![CDATA[$P{rowCount}.doubleValue()==$V{REPORT_COUNT}.doubleValue()]]></printWhenExpression>

                                                                                                    </reportElement>

                                                                                                    <textElement verticalAlignment="Top">

                                                                                                                    <font fontName="Arial" isBold="true"/>

                                                                                                    </textElement>

                                                                                                    <text><![CDATA[Grand Total]]></text>

                                                                                    </staticText>

                                                                                    <line>

                                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" style="GridLine" positionType="Float" x="290" y="13" width="1" height="13" isRemoveLineWhenBlank="true">

                                                                                                                    <printWhenExpression><![CDATA[$P{rowCount}.doubleValue()==$V{REPORT_COUNT}.doubleValue()]]></printWhenExpression>

                                                                                                    </reportElement>

                                                                                                    <graphicElement>

                                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                                    </graphicElement>

                                                                                    </line>

                                                                                    <line>

                                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" style="GridLine" positionType="Float" x="440" y="13" width="1" height="13" isRemoveLineWhenBlank="true">

                                                                                                                    <printWhenExpression><![CDATA[$P{rowCount}.doubleValue()==$V{REPORT_COUNT}.doubleValue()]]></printWhenExpression>

                                                                                                    </reportElement>

                                                                                                    <graphicElement>

                                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                                    </graphicElement>

                                                                                    </line>

                                                                                    <line>

                                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" style="GridLine" positionType="Float" x="600" y="13" width="1" height="13" isRemoveLineWhenBlank="true">

                                                                                                                    <printWhenExpression><![CDATA[$P{rowCount}.doubleValue()==$V{REPORT_COUNT}.doubleValue()]]></printWhenExpression>

                                                                                                    </reportElement>

                                                                                                    <graphicElement>

                                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                                    </graphicElement>

                                                                                    </line>

                                                                                    <line>

                                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" style="GridLine" positionType="Float" x="70" y="13" width="1" height="13" isRemoveLineWhenBlank="true">

                                                                                                                    <printWhenExpression><![CDATA[$P{rowCount}.doubleValue()==$V{REPORT_COUNT}.doubleValue()]]></printWhenExpression>

                                                                                                    </reportElement>

                                                                                                    <graphicElement>

                                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                                    </graphicElement>

                                                                                    </line>

                                                                                    <line>

                                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" style="GridLine" positionType="Float" mode="Opaque" x="150" y="13" width="1" height="13" isRemoveLineWhenBlank="true">

                                                                                                                    <printWhenExpression><![CDATA[$P{rowCount}.doubleValue()==$V{REPORT_COUNT}.doubleValue()]]></printWhenExpression>

                                                                                                    </reportElement>

                                                                                                    <graphicElement>

                                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                                    </graphicElement>

                                                                                    </line>

                                                                                    <line>

                                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" style="GridLine" positionType="Float" x="0" y="13" width="1" height="13" isRemoveLineWhenBlank="true">

                                                                                                                    <printWhenExpression><![CDATA[$P{rowCount}.doubleValue()==$V{REPORT_COUNT}.doubleValue()]]></printWhenExpression>

                                                                                                    </reportElement>

                                                                                                    <graphicElement>

                                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                                    </graphicElement>

                                                                                    </line>

                                                                                    <line>

                                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" style="GridLine" positionType="Float" x="746" y="13" width="1" height="13" isRemoveLineWhenBlank="true">

                                                                                                                    <printWhenExpression><![CDATA[$P{rowCount}.doubleValue()==$V{REPORT_COUNT}.doubleValue()]]></printWhenExpression>

                                                                                                    </reportElement>

                                                                                                    <graphicElement>

                                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                                    </graphicElement>

                                                                                    </line>

                                                                    </frame>

                                                    </band>

                                    </groupFooter>

                    </group>

                    <group name="ACT_BRANCH_CD">

                                    <groupExpression><![CDATA[$F{ACT_BRANCH_CD}]]></groupExpression>

                                    <groupHeader>

                                                    <band/>

                                    </groupHeader>

                                    <groupFooter>

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

                                                                    <frame>

                                                                                    <reportElement uuid="f0f75d7a-af0b-422e-a65d-6535c62285d1" stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="747" height="13" isRemoveLineWhenBlank="true" backcolor="#CCCCCC"/>

                                                                                    <staticText>

                                                                                                    <reportElement uuid="caf6f055-e378-4d66-89f8-5632a71c2ec6" x="8" y="0" width="67" height="13"/>

                                                                                                    <textElement verticalAlignment="Top">

                                                                                                                    <font fontName="Arial" isBold="true"/>

                                                                                                    </textElement>

                                                                                                    <text><![CDATA[sub Total]]></text>

                                                                                    </staticText>

                                                                                    <textField isStretchWithOverflow="true" pattern="##,###,###,##0.00">

                                                                                                    <reportElement uuid="49c24ab4-269a-46a9-8f9e-58a824072f3b" positionType="Float" stretchType="RelativeToBandHeight" x="457" y="0" width="137" height="13"/>

                                                                                                    <textElement textAlignment="Right" verticalAlignment="Top">

                                                                                                                    <font fontName="Arial" isBold="true"/>

                                                                                                    </textElement>

                                                                                                    <textFieldExpression><![CDATA[$V{Brach_cd1}]]></textFieldExpression>

                                                                                    </textField>

                                                                                    <textField isStretchWithOverflow="true" pattern="##,###,###,##0.00">

                                                                                                    <reportElement uuid="49c24ab4-269a-46a9-8f9e-58a824072f3b" positionType="Float" stretchType="RelativeToBandHeight" x="607" y="0" width="140" height="13"/>

                                                                                                    <textElement textAlignment="Right" verticalAlignment="Top">

                                                                                                                    <font fontName="Arial" isBold="true"/>

                                                                                                    </textElement>

                                                                                                    <textFieldExpression><![CDATA[$V{Brach_cd2}]]></textFieldExpression>

                                                                                    </textField>

                                                                                    <textField isStretchWithOverflow="true">

                                                                                                    <reportElement uuid="bbdfd392-1058-4084-82b7-744ded4a84b3" stretchType="RelativeToBandHeight" x="75" y="0" width="60" height="13"/>

                                                                                                    <textElement textAlignment="Left" verticalAlignment="Top">

                                                                                                                    <font fontName="Arial" isBold="true"/>

                                                                                                    </textElement>

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

                                                                                    </textField>

                                                                                    <line direction="BottomUp">

                                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" key=""vertical"" stretchType="RelativeToBandHeight" x="290" y="0" width="1" height="13"/>

                                                                                                    <graphicElement>

                                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                                    </graphicElement>

                                                                                    </line>

                                                                                    <line direction="BottomUp">

                                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" key=""vertical"" stretchType="RelativeToBandHeight" x="440" y="0" width="1" height="13"/>

                                                                                                    <graphicElement>

                                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                                    </graphicElement>

                                                                                    </line>

                                                                                    <line direction="BottomUp">

                                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" key=""vertical"" stretchType="RelativeToBandHeight" x="600" y="0" width="1" height="13"/>

                                                                                                    <graphicElement>

                                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                                    </graphicElement>

                                                                                    </line>

                                                                                    <line direction="BottomUp">

                                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" key=""vertical"" stretchType="RelativeToBandHeight" x="70" y="0" width="1" height="13"/>

                                                                                                    <graphicElement>

                                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                                    </graphicElement>

                                                                                    </line>

                                                                                    <line direction="BottomUp">

                                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" key=""vertical"" stretchType="RelativeToBandHeight" x="150" y="0" width="1" height="13"/>

                                                                                                    <graphicElement>

                                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                                    </graphicElement>

                                                                                    </line>

                                                                                    <line direction="BottomUp">

                                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" key=""vertical"" stretchType="RelativeToBandHeight" x="0" y="0" width="1" height="13"/>

                                                                                                    <graphicElement>

                                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                                    </graphicElement>

                                                                                    </line>

                                                                                    <line direction="BottomUp">

                                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" key=""vertical"" stretchType="RelativeToBandHeight" x="746" y="0" width="1" height="13"/>

                                                                                                    <graphicElement>

                                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                                    </graphicElement>

                                                                                    </line>

                                                                    </frame>

                                                    </band>

                                    </groupFooter>

                    </group>

                    <background>

                                    <band splitType="Stretch"/>

                    </background>

                    <pageHeader>

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

                                                    <frame>

                                                                    <reportElement uuid="a2c6f7cc-dcbc-4cee-b4b6-fd9041e9b7ee" mode="Opaque" x="-1" y="0" width="747" height="90" backcolor="#5EA5CE"/>

                                                                    <textField isStretchWithOverflow="true" pattern="dd-MMM-yyyy hh:mm:ss">

                                                                                    <reportElement uuid="6a9403e9-e4a2-4123-a85e-10827f60752d" mode="Transparent" x="630" y="60" width="116" height="15" forecolor="#185194"/>

                                                                                    <textElement>

                                                                                                    <font fontName="Arial" size="8" isBold="true"/>

                                                                                    </textElement>

                                                                                    <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>

                                                                    </textField>

                                                                    <textField>

                                                                                    <reportElement uuid="28015534-eba5-460f-bb09-be51f174e75d" x="630" y="75" width="31" height="15" forecolor="#185194"/>

                                                                                    <textElement textAlignment="Left">

                                                                                                    <font fontName="Arial" size="8" isBold="true"/>

                                                                                    </textElement>

                                                                                    <textFieldExpression><![CDATA[$V{PAGE_NUMBER}+" of"]]></textFieldExpression>

                                                                    </textField>

                                                                    <textField isStretchWithOverflow="true" evaluationTime="Report">

                                                                                    <reportElement uuid="2d36c847-0368-4cdf-ac5f-b83456845714" mode="Transparent" x="645" y="75" width="67" height="15" forecolor="#185194"/>

                                                                                    <textElement>

                                                                                                    <font fontName="Arial" size="8" isBold="true" isItalic="false"/>

                                                                                    </textElement>

                                                                                    <textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>

                                                                    </textField>

                                                                    <staticText>

                                                                                    <reportElement uuid="32163e6e-5ff3-4536-8e12-504d86d7149d" mode="Transparent" x="538" y="60" width="68" height="15" forecolor="#FFFFFF"/>

                                                                                    <textElement>

                                                                                                    <font fontName="Arial" size="9" isBold="true"/>

                                                                                    </textElement>

                                                                                    <text><![CDATA[Created On]]></text>

                                                                    </staticText>

                                                                    <staticText>

                                                                                    <reportElement uuid="147fabd6-d111-40eb-8742-a35405780010" x="538" y="75" width="68" height="15" forecolor="#FFFFFF"/>

                                                                                    <textElement>

                                                                                                    <font fontName="Arial" size="9" isBold="true"/>

                                                                                    </textElement>

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

                                                                    </staticText>

                                                                    <staticText>

                                                                                    <reportElement uuid="32163e6e-5ff3-4536-8e12-504d86d7149d" mode="Transparent" x="7" y="30" width="68" height="15" forecolor="#FFFFFF"/>

                                                                                    <textElement>

                                                                                                    <font fontName="Arial" size="9" isBold="true"/>

                                                                                    </textElement>

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

                                                                    </staticText>

                                                                    <staticText>

                                                                                    <reportElement uuid="32163e6e-5ff3-4536-8e12-504d86d7149d" mode="Transparent" x="7" y="45" width="111" height="15" forecolor="#FFFFFF"/>

                                                                                    <textElement>

                                                                                                    <font fontName="Arial" size="9" isBold="true"/>

                                                                                    </textElement>

                                                                                    <text><![CDATA[Valuation Status]]></text>

                                                                    </staticText>

                                                                    <staticText>

                                                                                    <reportElement uuid="32163e6e-5ff3-4536-8e12-504d86d7149d" mode="Transparent" x="8" y="60" width="110" height="15" forecolor="#FFFFFF"/>

                                                                                    <textElement>

                                                                                                    <font fontName="Arial" size="9" isBold="true"/>

                                                                                    </textElement>

                                                                                    <text><![CDATA[Valuation Version]]></text>

                                                                    </staticText>

                                                                    <staticText>

                                                                                    <reportElement uuid="32163e6e-5ff3-4536-8e12-504d86d7149d" mode="Transparent" x="7" y="75" width="68" height="15" forecolor="#FFFFFF"/>

                                                                                    <textElement>

                                                                                                    <font fontName="Arial" size="9" isBold="true"/>

                                                                                    </textElement>

                                                                                    <text><![CDATA[As Of Date]]></text>

                                                                    </staticText>

                                                                    <staticText>

                                                                                    <reportElement uuid="de386116-ea9b-4078-9070-33479e66afbb" x="330" y="0" width="92" height="25" forecolor="#185194"/>

                                                                                    <textElement>

                                                                                                    <font fontName="Arial" size="15" isBold="true"/>

                                                                                    </textElement>

                                                                                    <text><![CDATA[by Currency]]></text>

                                                                    </staticText>

                                                                    <staticText>

                                                                                    <reportElement uuid="147fabd6-d111-40eb-8742-a35405780010" x="257" y="75" width="113" height="15" forecolor="#FFFFFF"/>

                                                                                    <textElement>

                                                                                                    <font fontName="Arial" size="9" isBold="true"/>

                                                                                    </textElement>

                                                                                    <text><![CDATA[summary Indicatior]]></text>

                                                                    </staticText>

                                                                    <staticText>

                                                                                    <reportElement uuid="32163e6e-5ff3-4536-8e12-504d86d7149d" mode="Transparent" x="257" y="60" width="113" height="15" forecolor="#FFFFFF"/>

                                                                                    <textElement>

                                                                                                    <font fontName="Arial" size="9" isBold="true"/>

                                                                                    </textElement>

                                                                                    <text><![CDATA[Valuation Currency]]></text>

                                                                    </staticText>

                                                                    <staticText>

                                                                                    <reportElement uuid="de386116-ea9b-4078-9070-33479e66afbb" x="370" y="60" width="52" height="15" forecolor="#185194"/>

                                                                                    <textElement>

                                                                                                    <font fontName="Arial" size="8" isBold="true"/>

                                                                                    </textElement>

                                                                                    <text><![CDATA[Fund CCY]]></text>

                                                                    </staticText>

                                                                    <staticText>

                                                                                    <reportElement uuid="de386116-ea9b-4078-9070-33479e66afbb" x="370" y="75" width="52" height="15" forecolor="#185194"/>

                                                                                    <textElement>

                                                                                                    <font fontName="Arial" size="8" isBold="true"/>

                                                                                    </textElement>

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

                                                                    </staticText>

                                                                    <staticText>

                                                                                    <reportElement uuid="de386116-ea9b-4078-9070-33479e66afbb" x="118" y="45" width="92" height="15" forecolor="#185194"/>

                                                                                    <textElement>

                                                                                                    <font fontName="Arial" size="8" isBold="true"/>

                                                                                    </textElement>

                                                                                    <text><![CDATA[Daily Official]]></text>

                                                                    </staticText>

                                                                    <staticText>

                                                                                    <reportElement uuid="de386116-ea9b-4078-9070-33479e66afbb" x="118" y="60" width="92" height="15" forecolor="#185194"/>

                                                                                    <textElement>

                                                                                                    <font fontName="Arial" size="8" isBold="true"/>

                                                                                    </textElement>

                                                                                    <text><![CDATA[Latest NAV]]></text>

                                                                    </staticText>

                                                                    <staticText>

                                                                                    <reportElement uuid="de386116-ea9b-4078-9070-33479e66afbb" x="118" y="75" width="92" height="15" forecolor="#185194"/>

                                                                                    <textElement>

                                                                                                    <font fontName="Arial" size="8" isBold="true"/>

                                                                                    </textElement>

                                                                                    <text><![CDATA[Most Recent]]></text>

                                                                    </staticText>

                                                                    <textField isStretchWithOverflow="true" hyperlinkType="LocalAnchor">

                                                                                    <reportElement uuid="57ea5292-0260-4017-9b31-d2404d44d42b" x="118" y="30" width="172" height="15" forecolor="#185194"/>

                                                                                    <textElement>

                                                                                                    <font fontName="Arial" size="8" isBold="true" isUnderline="true"/>

                                                                                    </textElement>

                                                                                    <textFieldExpression><![CDATA[$P{accountType}]]></textFieldExpression>

                                                                                    <hyperlinkAnchorExpression><![CDATA["summary"]]></hyperlinkAnchorExpression>

                                                                                    <hyperlinkTooltipExpression><![CDATA["Click here to see accounts summary"]]></hyperlinkTooltipExpression>

                                                                    </textField>

                                                    </frame>

                                    </band>

                    </pageHeader>

                    <columnHeader>

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

                                                    <frame>

                                                                    <reportElement uuid="7ee4e834-5cf1-4b2c-b9bc-62ad7e4ec605" mode="Opaque" x="0" y="0" width="747" height="17" backcolor="#A1A9A9"/>

                                                                    <staticText>

                                                                                    <reportElement uuid="a9e9d9b6-9411-4c47-9c10-f840609ec797" x="157" y="0" width="100" height="13" forecolor="#FFFFFF"/>

                                                                                    <textElement>

                                                                                                    <font fontName="Arial" isBold="true"/>

                                                                                    </textElement>

                                                                                    <text><![CDATA[Account Number]]></text>

                                                                    </staticText>

                                                                    <staticText>

                                                                                    <reportElement uuid="1a10ab79-1ed7-484e-bade-447b52b2f865" x="294" y="0" width="100" height="13" forecolor="#FFFFFF"/>

                                                                                    <textElement>

                                                                                                    <font fontName="Arial" isBold="true"/>

                                                                                    </textElement>

                                                                                    <text><![CDATA[branch Code ]]></text>

                                                                    </staticText>

                                                                    <staticText>

                                                                                    <reportElement uuid="1a10ab79-1ed7-484e-bade-447b52b2f865" x="478" y="0" width="70" height="13" forecolor="#FFFFFF"/>

                                                                                    <textElement textAlignment="Right">

                                                                                                    <font fontName="Arial" isBold="true"/>

                                                                                    </textElement>

                                                                                    <text><![CDATA[Market Value]]></text>

                                                                    </staticText>

                                                                    <staticText>

                                                                                    <reportElement uuid="a9e9d9b6-9411-4c47-9c10-f840609ec797" x="654" y="0" width="60" height="13" forecolor="#FFFFFF"/>

                                                                                    <textElement textAlignment="Right">

                                                                                                    <font fontName="Arial" isBold="true"/>

                                                                                    </textElement>

                                                                                    <text><![CDATA[Total Cost]]></text>

                                                                    </staticText>

                                                                    <staticText>

                                                                                    <reportElement uuid="1ddaeeae-75f1-4834-8b44-1de90e513129" stretchType="RelativeToBandHeight" mode="Transparent" x="75" y="0" width="64" height="13" isRemoveLineWhenBlank="true" forecolor="#FFFFFF"/>

                                                                                    <textElement>

                                                                                                    <font fontName="Arial" isBold="true"/>

                                                                                    </textElement>

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

                                                                    </staticText>

                                                    </frame>

                                    </band>

                    </columnHeader>

                    <detail>

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

                                                    <frame>

                                                                    <reportElement uuid="13ff5c0c-81b1-4d86-87ef-2429c3ba7ada" style="ListRow" mode="Opaque" x="0" y="0" width="747" height="13"/>

                                                                    <line direction="BottomUp">

                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" key=""vertical"" stretchType="RelativeToBandHeight" x="600" y="0" width="1" height="13" isPrintInFirstWholeBand="true"/>

                                                                                    <graphicElement>

                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                    </graphicElement>

                                                                    </line>

                                                                    <textField isStretchWithOverflow="true" pattern="##,###,###,##0.00">

                                                                                    <reportElement uuid="bbdfd392-1058-4084-82b7-744ded4a84b3" positionType="Float" stretchType="RelativeToBandHeight" x="605" y="0" width="127" height="13"/>

                                                                                    <textElement textAlignment="Right" verticalAlignment="Top">

                                                                                                    <font fontName="Arial"/>

                                                                                    </textElement>

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

                                                                    </textField>

                                                                    <line direction="BottomUp">

                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" key=""vertical"" stretchType="RelativeToBandHeight" x="70" y="0" width="1" height="13" isPrintInFirstWholeBand="true"/>

                                                                                    <graphicElement>

                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                    </graphicElement>

                                                                    </line>

                                                                    <line direction="BottomUp">

                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" key=""vertical"" stretchType="RelativeToBandHeight" x="440" y="0" width="1" height="13" isPrintInFirstWholeBand="true"/>

                                                                                    <graphicElement>

                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                    </graphicElement>

                                                                    </line>

                                                                    <textField isStretchWithOverflow="true" pattern="##,###,###,##0.00">

                                                                                    <reportElement uuid="bbdfd392-1058-4084-82b7-744ded4a84b3" positionType="Float" stretchType="RelativeToBandHeight" x="537" y="0" width="42" height="13"/>

                                                                                    <textElement textAlignment="Right" verticalAlignment="Top">

                                                                                                    <font fontName="Arial" isPdfEmbedded="false"/>

                                                                                    </textElement>

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

                                                                    </textField>

                                                                    <line direction="BottomUp">

                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" key=""vertical"" stretchType="RelativeToBandHeight" x="150" y="0" width="1" height="13" isPrintInFirstWholeBand="true"/>

                                                                                    <graphicElement>

                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                    </graphicElement>

                                                                    </line>

                                                                    <textField isStretchWithOverflow="true">

                                                                                    <reportElement uuid="bbdfd392-1058-4084-82b7-744ded4a84b3" positionType="Float" stretchType="RelativeToBandHeight" mode="Transparent" x="157" y="0" width="80" height="13"/>

                                                                                    <box leftPadding="0"/>

                                                                                    <textElement verticalAlignment="Middle">

                                                                                                    <font fontName="Arial"/>

                                                                                                    <paragraph lineSpacing="Double"/>

                                                                                    </textElement>

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

                                                                    </textField>

                                                                    <line direction="BottomUp">

                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" key=""vertical"" stretchType="RelativeToBandHeight" x="290" y="0" width="1" height="13" isPrintInFirstWholeBand="true"/>

                                                                                    <graphicElement>

                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                    </graphicElement>

                                                                    </line>

                                                                    <textField isStretchWithOverflow="true">

                                                                                    <reportElement uuid="bbdfd392-1058-4084-82b7-744ded4a84b3" positionType="Float" stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" x="294" y="0" width="75" height="13" isPrintWhenDetailOverflows="true"/>

                                                                                    <textElement textAlignment="Left" verticalAlignment="Top">

                                                                                                    <font fontName="Arial"/>

                                                                                    </textElement>

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

                                                                    </textField>

                                                                    <line direction="BottomUp">

                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" key=""vertical"" stretchType="RelativeToBandHeight" x="0" y="0" width="1" height="13" isPrintInFirstWholeBand="true"/>

                                                                                    <graphicElement>

                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                    </graphicElement>

                                                                    </line>

                                                                    <line direction="BottomUp">

                                                                                    <reportElement uuid="59ff529c-79ad-48a0-9310-31a0add1538b" key=""vertical"" stretchType="RelativeToBandHeight" x="746" y="0" width="1" height="13" isPrintInFirstWholeBand="true"/>

                                                                                    <graphicElement>

                                                                                                    <pen lineWidth="1.0" lineStyle="Solid"/>

                                                                                    </graphicElement>

                                                                    </line>

                                                                    <textField isStretchWithOverflow="true" pattern="" hyperlinkType="LocalAnchor">

                                                                                    <reportElement uuid="292d6d83-21cc-466c-9e5c-9e12c02a146d" positionType="Float" stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" mode="Transparent" x="75" y="0" width="25" height="13"/>

                                                                                    <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="2"/>

                                                                                    <textElement verticalAlignment="Top">

                                                                                                    <font fontName="Arial"/>

                                                                                    </textElement>

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

                                                                    </textField>

                                                    </frame>

                                    </band>

                    </detail>

                    <columnFooter>

                                    <band splitType="Prevent"/>

                    </columnFooter>

                    <pageFooter>

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

                                                    <frame>

                                                                    <reportElement uuid="a7eac429-4225-4b7a-b5e7-5686719bc4da" mode="Opaque" x="0" y="0" width="747" height="22" backcolor="#5EA5CE"/>

                                                    </frame>

                                    </band>

                    </pageFooter>

                    <summary>

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

                                                    <subreport>

                                                                    <reportElement uuid="8d63f2af-ad05-4c9b-ba4d-6408f5ba93d2" x="0" y="2" width="747" height="194" isPrintWhenDetailOverflows="true" printWhenGroupChanges="ACT_BASE_CRNCY"/>

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

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

                                                    </subreport>

                                                    <break>

                                                                    <reportElement uuid="1dae9c27-6442-42f6-83f4-67088b71e045" x="0" y="0" width="100" height="1"/>

                                                    </break>

                                    </band>

                    </summary>

    </jasperReport>

     

     

     


    Attachments:

    User Feedback

    Recommended Comments

    There are no comments to display.


×
×
  • Create New...