src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoiceSale.jrxml
author jeneive malarkodi <jeneive.malarkodi@openbravo.com>
Thu, 17 Sep 2009 11:33:34 +0530
changeset 4948 16fbb48b2f19
parent 4429 f5acd1a76230
child 11848 e900de861372
permissions -rw-r--r--
Fixes Issue 10516: The amount column in the invoice taxes report is too narrow
<?xml version="1.0" encoding="UTF-8"  ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport
         name="ReportTaxInvoiceSale"
         columnCount="1"
         printOrder="Vertical"
         orientation="Portrait"
         pageWidth="605"
         pageHeight="842"
         columnWidth="605"
         columnSpacing="0"
         leftMargin="0"
         rightMargin="0"
         topMargin="0"
         bottomMargin="0"
         whenNoDataType="NoPages"
         isTitleNewPage="false"
         isSummaryNewPage="false">
    <property name="ireport.scriptlethandling" value="0" />
    <property name="ireport.encoding" value="UTF-8" />
    <import value="java.util.*" />
    <import value="net.sf.jasperreports.engine.*" />
    <import value="net.sf.jasperreports.engine.data.*" />

    <style 
        name="default"
        isDefault="false"
        vAlign="Middle"
        fontName="Bitstream Vera Sans"
        fontSize="10"
    />
    <style 
        name="Report_Title"
        isDefault="false"
        fontName="Bitstream Vera Sans"
        fontSize="18"
    />
    <style 
        name="Report_Subtitle"
        isDefault="false"
        forecolor="#555555"
        fontName="Bitstream Vera Sans"
        fontSize="14"
    />
    <style 
        name="Total_Field"
        isDefault="false"
        mode="Opaque"
        forecolor="#000000"
        backcolor="#CCCCCC"
        vAlign="Middle"
    />
    <style 
        name="Detail_Header"
        isDefault="false"
        mode="Opaque"
        forecolor="#FFFFFF"
        backcolor="#555555"
        vAlign="Middle"
    />
    <style 
        name="GroupHeader_DarkGray"
        isDefault="false"
        mode="Opaque"
        forecolor="#FFFFFF"
        backcolor="#555555"
        vAlign="Middle"
        fontName="Bitstream Vera Sans"
        fontSize="14"
    />
    <style 
        name="GroupHeader_Gray"
        isDefault="false"
        mode="Opaque"
        backcolor="#999999"
    />
    <style 
        name="Detail_Line"
        isDefault="false"
        fontName="Bitstream Vera Sans"
        fontSize="9"
    >

        <conditionalStyle>
            <conditionExpression><![CDATA[new Boolean($V{TAXNAME_COUNT}.intValue()%2==1)]]></conditionExpression>
            <style 
                name="Detail_Line"
                isDefault="false"
                mode="Opaque"
                backcolor="#CCCCCC"
                fontName="Bitstream Vera Sans"
                fontSize="9"
            />
        </conditionalStyle>
    </style>
    <style 
        name="Total_Gray"
        isDefault="false"
        mode="Opaque"
        forecolor="#000000"
        backcolor="#CCCCCC"
    />

    <parameter name="ATTACH" isForPrompting="false" class="java.lang.String"/>
    <parameter name="BASE_WEB" isForPrompting="false" class="java.lang.String"/>
    <parameter name="BASE_DESIGN" isForPrompting="false" class="java.lang.String"/>
    <parameter name="LANGUAGE" isForPrompting="false" class="java.lang.String">
        <defaultValueExpression ><![CDATA["en_US"]]></defaultValueExpression>
    </parameter>
    <parameter name="USER_CLIENT" isForPrompting="false" class="java.lang.String">
        <defaultValueExpression ><![CDATA["'1000000'"]]></defaultValueExpression>
    </parameter>
    <parameter name="USER_ORG" isForPrompting="false" class="java.lang.String">
        <defaultValueExpression ><![CDATA["'0','1000000'"]]></defaultValueExpression>
    </parameter>
    <parameter name="REPORT_TITLE" isForPrompting="false" class="java.lang.String">
        <defaultValueExpression ><![CDATA["REPORT TITLE"]]></defaultValueExpression>
    </parameter>
    <parameter name="REPORT_SUBTITLE" isForPrompting="false" class="java.lang.String">
        <defaultValueExpression ><![CDATA["Sale"]]></defaultValueExpression>
    </parameter>
    <parameter name="aux_client" isForPrompting="false" class="java.lang.String">
        <defaultValueExpression ><![CDATA[$P{USER_CLIENT}.equals("") ? " " : " AND C_INVOICE.AD_CLIENT_ID IN ("+$P{USER_CLIENT}+") "]]></defaultValueExpression>
    </parameter>
    <parameter name="aux_org" isForPrompting="false" class="java.lang.String">
        <defaultValueExpression ><![CDATA[$P{USER_ORG}.equals("") ? " " : " AND C_INVOICE.AD_ORG_ID IN ("+$P{USER_ORG}+") "]]></defaultValueExpression>
    </parameter>
    <parameter name="cCountryId" isForPrompting="true" class="java.lang.String">
        <defaultValueExpression ><![CDATA["100"]]></defaultValueExpression>
    </parameter>
    <parameter name="parDateFrom" isForPrompting="true" class="java.util.Date"/>
    <parameter name="parDateTo" isForPrompting="true" class="java.util.Date"/>
    <parameter name="ReportData" isForPrompting="false" class="java.lang.String">
        <defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
    </parameter>
    <parameter name="SALE" isForPrompting="false" class="java.lang.String"/>
    <parameter name="DETAIL" isForPrompting="false" class="java.lang.String"/>
    <parameter name="NUMBERFORMAT" isForPrompting="false" class="java.text.DecimalFormat"/>
    <parameter name="LOCALE" isForPrompting="false" class="java.util.Locale"/>
    <parameter name="PARAM_CURRENCY" isForPrompting="false" class="java.lang.String">
        <defaultValueExpression ><![CDATA["102"]]></defaultValueExpression>
    </parameter>
    <queryString><![CDATA[SELECT C_INVOICE.ISSOTRX AS SALES, 'Y' AS NATIONAL, C_INVOICE.DOCUMENTNO AS DOCUMENTNO, C_INVOICE.DATEINVOICED, C_BPARTNER.NAME AS BPARTNER, LTRIM(RTRIM(C_TAX.NAME, ' '), ' ') AS TAXNAME, 
      SUM(CASE WHEN DOCBASETYPE IN ('ARC','APC') THEN -1 * (C_CURRENCY_CONVERT(C_INVOICETAX.TAXBASEAMT, C_INVOICE.C_CURRENCY_ID,$P{PARAM_CURRENCY}, TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICETAX.AD_CLIENT_ID, C_INVOICETAX.AD_ORG_ID))
       ELSE (C_CURRENCY_CONVERT(C_INVOICETAX.TAXBASEAMT, C_INVOICE.C_CURRENCY_ID,$P{PARAM_CURRENCY}, TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICETAX.AD_CLIENT_ID, C_INVOICETAX.AD_ORG_ID)) END) AS TAXBASEAMT, 
      SUM(CASE WHEN DOCBASETYPE IN ('ARC','APC') THEN -1 * (C_CURRENCY_CONVERT(C_INVOICETAX.TAXAMT, C_INVOICE.C_CURRENCY_ID, $P{PARAM_CURRENCY}, TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICETAX.AD_CLIENT_ID, C_INVOICETAX.AD_ORG_ID))
       ELSE (C_CURRENCY_CONVERT(C_INVOICETAX.TAXAMT, C_INVOICE.C_CURRENCY_ID, $P{PARAM_CURRENCY}, TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICETAX.AD_CLIENT_ID, C_INVOICETAX.AD_ORG_ID)) END) AS TAXAMT, '' AS ADTREEID,C_CURRENCY_SYMBOL($P{PARAM_CURRENCY}, 0, 'Y') AS CURRENCY,'' AS SUM_AMOUNT,'' AS Tax_BASE
      FROM C_TAX, C_INVOICETAX, C_INVOICE, C_BPARTNER_LOCATION, C_LOCATION, C_BPARTNER, C_DOCTYPE
      WHERE C_TAX.C_TAX_ID=C_INVOICETAX.C_TAX_ID
      AND C_INVOICETAX.C_INVOICE_ID=C_INVOICE.C_INVOICE_ID
      AND C_INVOICE.C_BPARTNER_LOCATION_ID = C_BPARTNER_LOCATION.C_BPARTNER_LOCATION_ID
      AND C_BPARTNER_LOCATION.C_LOCATION_ID = C_LOCATION.C_LOCATION_ID
      AND C_INVOICE.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID
      AND C_INVOICE.C_DOCTYPE_ID = C_DOCTYPE.C_DOCTYPE_ID
      AND C_INVOICE.PROCESSED = 'Y'
      AND C_INVOICE.ISACTIVE = 'Y'
      AND C_INVOICE.ISSOTRX = 'Y'
      AND C_LOCATION.C_COUNTRY_ID = $P{cCountryId}
      AND C_INVOICE.DATEINVOICED >= $P{parDateFrom}
      AND C_INVOICE.DATEINVOICED < $P{parDateTo}
    AND 1=1 $P!{aux_client} 
AND 1=1 $P!{aux_org}
      AND 1=1 
      GROUP BY C_INVOICE.DOCUMENTNO, C_INVOICE.DATEINVOICED, C_TAX.NAME, C_BPARTNER.NAME, C_INVOICE.ISSOTRX
      HAVING SUM(C_INVOICETAX.TAXBASEAMT) <> 0
      ORDER BY C_TAX.NAME, C_INVOICE.DATEINVOICED]]></queryString>

    <field name="SALES" class="java.lang.String"/>
    <field name="NATIONAL" class="java.lang.String"/>
    <field name="DOCUMENTNO" class="java.lang.String"/>
    <field name="DATEINVOICED" class="java.sql.Timestamp"/>
    <field name="BPARTNER" class="java.lang.String"/>
    <field name="TAXNAME" class="java.lang.String"/>
    <field name="TAXBASEAMT" class="java.math.BigDecimal"/>
    <field name="TAXAMT" class="java.math.BigDecimal"/>
    <field name="ADTREEID" class="java.lang.String"/>
    <field name="CURRENCY" class="java.lang.String"/>
    <field name="SUM_AMOUNT" class="java.lang.String"/>
    <field name="Tax_BASE" class="java.lang.String"/>

    <variable name="sumTaxBaseAmt" class="java.math.BigDecimal" resetType="Group" resetGroup="TAXNAME" calculation="Sum">
        <variableExpression><![CDATA[$F{TAXBASEAMT}]]></variableExpression>
    </variable>
    <variable name="sumImport" class="java.math.BigDecimal" resetType="Group" resetGroup="TAXNAME" calculation="Sum">
        <variableExpression><![CDATA[$F{TAXAMT}]]></variableExpression>
    </variable>
    <variable name="sumAmount" class="java.lang.String" resetType="Report" calculation="Nothing">
        <variableExpression><![CDATA[$V{sumImport}.toString()]]></variableExpression>
    </variable>

        <group  name="TAXNAME" >
            <groupExpression><![CDATA[$F{TAXNAME}]]></groupExpression>
            <groupHeader>
            <band height="44"  isSplitAllowed="true" >
                <staticText>
                    <reportElement
                        style="GroupHeader_DarkGray"
                        x="1"
                        y="0"
                        width="100"
                        height="20"
                        key="staticText"/>
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                    <textElement>
                        <font pdfFontName="Helvetica"/>
                    </textElement>
                <text><![CDATA[Tax Type]]></text>
                </staticText>
                <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                    <reportElement
                        style="GroupHeader_DarkGray"
                        x="101"
                        y="0"
                        width="503"
                        height="20"
                        key="textField"/>
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                    <textElement>
                        <font pdfFontName="Helvetica"/>
                    </textElement>
                <textFieldExpression   class="java.lang.String"><![CDATA[$F{TAXNAME}]]></textFieldExpression>
                </textField>
                <line direction="TopDown">
                    <reportElement
                        x="0"
                        y="1"
                        width="0"
                        height="43"
                        forecolor="#555555"
                        key="line-2"
                        stretchType="RelativeToBandHeight"/>
                    <graphicElement stretchType="RelativeToBandHeight"/>
                </line>
                <line direction="TopDown">
                    <reportElement
                        x="604"
                        y="0"
                        width="0"
                        height="43"
                        forecolor="#555555"
                        key="line-3"
                        stretchType="RelativeToBandHeight"/>
                    <graphicElement stretchType="RelativeToBandHeight"/>
                </line>
                <staticText>
                    <reportElement
                        style="Detail_Header"
                        x="10"
                        y="28"
                        width="90"
                        height="16"
                        key="element-90">
                            <printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
                        </reportElement>
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                    <textElement>
                        <font/>
                    </textElement>
                <text><![CDATA[Invoice]]></text>
                </staticText>
                <staticText>
                    <reportElement
                        style="Detail_Header"
                        x="100"
                        y="28"
                        width="70"
                        height="16"
                        key="element-90">
                            <printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
                        </reportElement>
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                    <textElement>
                        <font/>
                    </textElement>
                <text><![CDATA[Date]]></text>
                </staticText>
                <staticText>
                    <reportElement
                        style="Detail_Header"
                        x="170"
                        y="28"
                        width="165"
                        height="16"
                        key="element-90">
                            <printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
                        </reportElement>
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                    <textElement>
                        <font/>
                    </textElement>
                <text><![CDATA[Business Partner]]></text>
                </staticText>
                <staticText>
                    <reportElement
                        style="Detail_Header"
                        x="335"
                        y="28"
                        width="117"
                        height="16"
                        key="element-90"/>
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                    <textElement textAlignment="Right">
                        <font/>
                    </textElement>
                <text><![CDATA[Taxable Base]]></text>
                </staticText>
                <staticText>
                    <reportElement
                        style="Detail_Header"
                        x="452"
                        y="28"
                        width="114"
                        height="16"
                        key="element-90"/>
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                    <textElement textAlignment="Right">
                        <font/>
                    </textElement>
                <text><![CDATA[Amount]]></text>
                </staticText>
            </band>
            </groupHeader>
            <groupFooter>
            <band height="25"  isSplitAllowed="true" >
                <line direction="TopDown">
                    <reportElement
                        x="0"
                        y="0"
                        width="0"
                        height="20"
                        forecolor="#555555"
                        key="line-32"
                        stretchType="RelativeToBandHeight"/>
                    <graphicElement stretchType="RelativeToBandHeight"/>
                </line>
                <line direction="TopDown">
                    <reportElement
                        x="604"
                        y="0"
                        width="0"
                        height="20"
                        forecolor="#555555"
                        key="line-33"
                        stretchType="RelativeToBandHeight"/>
                    <graphicElement stretchType="RelativeToBandHeight"/>
                </line>
                <line direction="TopDown">
                    <reportElement
                        x="0"
                        y="20"
                        width="603"
                        height="0"
                        forecolor="#555555"
                        key="line-34"/>
                    <graphicElement stretchType="NoStretch"/>
                </line>
                <staticText>
                    <reportElement
                        style="default"
                        x="199"
                        y="0"
                        width="90"
                        height="16"
                        key="staticText-4"/>
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                    <textElement textAlignment="Right">
                        <font fontName="Bitstream Vera Sans"/>
                    </textElement>
                <text><![CDATA[Total:]]></text>
                </staticText>
                <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                    <reportElement
                        style="Total_Field"
                        x="294"
                        y="0"
                        width="33"
                        height="16"
                        key="textField"/>
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                    <textElement verticalAlignment="Middle">
                        <font/>
                    </textElement>
                <textFieldExpression   class="java.lang.Integer"><![CDATA[$V{TAXNAME_COUNT}]]></textFieldExpression>
                </textField>
                <line direction="TopDown">
                    <reportElement
                        x="10"
                        y="0"
                        width="510"
                        height="0"
                        forecolor="#666666"
                        key="line-37"/>
                    <graphicElement stretchType="NoStretch"/>
                </line>
                <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                    <reportElement
                        style="Total_Field"
                        x="452"
                        y="0"
                        width="114"
                        height="17"
                        key="textField"/>
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                    <textElement textAlignment="Right">
                        <font/>
                    </textElement>
                <textFieldExpression   class="java.lang.String"><![CDATA[($V{sumImport}!=null)?$P{NUMBERFORMAT}.format($V{sumImport})+$F{CURRENCY}:new String(" ")]]></textFieldExpression>
                </textField>
                <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                    <reportElement
                        style="Total_Field"
                        x="335"
                        y="0"
                        width="117"
                        height="16"
                        key="textField"/>
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                    <textElement textAlignment="Right" verticalAlignment="Middle">
                        <font/>
                    </textElement>
                <textFieldExpression   class="java.lang.String"><![CDATA[($V{sumTaxBaseAmt}!=null)?$P{NUMBERFORMAT}.format($V{sumTaxBaseAmt})+$F{CURRENCY}:new String(" ")]]></textFieldExpression>
                </textField>
            </band>
            </groupFooter>
        </group>
        <background>
            <band height="0"  isSplitAllowed="true" >
            </band>
        </background>
        <title>
            <band height="0"  isSplitAllowed="true" >
            </band>
        </title>
        <pageHeader>
            <band height="20"  isSplitAllowed="true" >
                <textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                    <reportElement
                        style="Report_Subtitle"
                        x="1"
                        y="0"
                        width="602"
                        height="20"
                        key="textField"/>
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
                    <textElement>
                        <font/>
                    </textElement>
                <textFieldExpression   class="java.lang.String"><![CDATA[$P{SALE}]]></textFieldExpression>
                </textField>
            </band>
        </pageHeader>
        <columnHeader>
            <band height="0"  isSplitAllowed="true" >
            </band>
        </columnHeader>
        <detail>
            <band height="14"  isSplitAllowed="true" >
                <printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
                <line direction="TopDown">
                    <reportElement
                        x="603"
                        y="-6"
                        width="0"
                        height="14"
                        forecolor="#555555"
                        key="line-16"
                        stretchType="RelativeToBandHeight"/>
                    <graphicElement stretchType="RelativeToBandHeight"/>
                </line>
                <line direction="TopDown">
                    <reportElement
                        x="0"
                        y="0"
                        width="0"
                        height="14"
                        forecolor="#555555"
                        key="line-17"
                        stretchType="RelativeToBandHeight"/>
                    <graphicElement stretchType="RelativeToBandHeight"/>
                </line>
                <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                    <reportElement
                        style="Detail_Line"
                        x="10"
                        y="0"
                        width="90"
                        height="14"
                        key="textField"/>
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
                    <textElement verticalAlignment="Middle">
                        <font/>
                    </textElement>
                <textFieldExpression   class="java.lang.String"><![CDATA[$F{DOCUMENTNO}]]></textFieldExpression>
                </textField>
                <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                    <reportElement
                        style="Detail_Line"
                        x="100"
                        y="0"
                        width="70"
                        height="14"
                        key="textField"/>
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
                    <textElement verticalAlignment="Middle">
                        <font/>
                    </textElement>
                <textFieldExpression   class="java.sql.Timestamp"><![CDATA[$F{DATEINVOICED}]]></textFieldExpression>
                </textField>
                <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                    <reportElement
                        style="Detail_Line"
                        x="170"
                        y="0"
                        width="165"
                        height="14"
                        key="textField"/>
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
                    <textElement verticalAlignment="Middle">
                        <font/>
                    </textElement>
                <textFieldExpression   class="java.lang.String"><![CDATA[$F{BPARTNER}]]></textFieldExpression>
                </textField>
                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                    <reportElement
                        style="Detail_Line"
                        x="335"
                        y="0"
                        width="117"
                        height="14"
                        key="textField"/>
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
                    <textElement textAlignment="Right" verticalAlignment="Middle">
                        <font size="9"/>
                    </textElement>
                <textFieldExpression   class="java.lang.String"><![CDATA[($F{TAXBASEAMT}!=null)?$P{NUMBERFORMAT}.format($F{TAXBASEAMT})+$F{CURRENCY}:new String(" ")]]></textFieldExpression>
                </textField>
                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
                    <reportElement
                        style="Detail_Line"
                        x="452"
                        y="0"
                        width="114"
                        height="14"
                        key="textField"/>
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
                    <textElement textAlignment="Right" verticalAlignment="Middle">
                        <font/>
                    </textElement>
                <textFieldExpression   class="java.lang.String"><![CDATA[($F{TAXAMT}!=null)?$P{NUMBERFORMAT}.format($F{TAXAMT})+$F{CURRENCY}:new String(" ")]]></textFieldExpression>
                </textField>
            </band>
        </detail>
        <columnFooter>
            <band height="0"  isSplitAllowed="true" >
            </band>
        </columnFooter>
        <pageFooter>
            <band height="0"  isSplitAllowed="true" >
            </band>
        </pageFooter>
        <summary>
            <band height="0"  isSplitAllowed="true" >
            </band>
        </summary>
</jasperReport>