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
harikrishnan@4429
     1
<?xml version="1.0" encoding="UTF-8"  ?>
harikrishnan@4429
     2
<!-- Created with iReport - A designer for JasperReports -->
harikrishnan@4429
     3
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
harikrishnan@4429
     4
<jasperReport
jeneive@4948
     5
         name="ReportTaxInvoiceSale"
jeneive@4948
     6
         columnCount="1"
jeneive@4948
     7
         printOrder="Vertical"
jeneive@4948
     8
         orientation="Portrait"
jeneive@4948
     9
         pageWidth="605"
jeneive@4948
    10
         pageHeight="842"
jeneive@4948
    11
         columnWidth="605"
jeneive@4948
    12
         columnSpacing="0"
jeneive@4948
    13
         leftMargin="0"
jeneive@4948
    14
         rightMargin="0"
jeneive@4948
    15
         topMargin="0"
jeneive@4948
    16
         bottomMargin="0"
jeneive@4948
    17
         whenNoDataType="NoPages"
jeneive@4948
    18
         isTitleNewPage="false"
jeneive@4948
    19
         isSummaryNewPage="false">
jeneive@4948
    20
    <property name="ireport.scriptlethandling" value="0" />
jeneive@4948
    21
    <property name="ireport.encoding" value="UTF-8" />
jeneive@4948
    22
    <import value="java.util.*" />
jeneive@4948
    23
    <import value="net.sf.jasperreports.engine.*" />
jeneive@4948
    24
    <import value="net.sf.jasperreports.engine.data.*" />
harikrishnan@4429
    25
jeneive@4948
    26
    <style 
jeneive@4948
    27
        name="default"
jeneive@4948
    28
        isDefault="false"
jeneive@4948
    29
        vAlign="Middle"
jeneive@4948
    30
        fontName="Bitstream Vera Sans"
jeneive@4948
    31
        fontSize="10"
jeneive@4948
    32
    />
jeneive@4948
    33
    <style 
jeneive@4948
    34
        name="Report_Title"
jeneive@4948
    35
        isDefault="false"
jeneive@4948
    36
        fontName="Bitstream Vera Sans"
jeneive@4948
    37
        fontSize="18"
jeneive@4948
    38
    />
jeneive@4948
    39
    <style 
jeneive@4948
    40
        name="Report_Subtitle"
jeneive@4948
    41
        isDefault="false"
jeneive@4948
    42
        forecolor="#555555"
jeneive@4948
    43
        fontName="Bitstream Vera Sans"
jeneive@4948
    44
        fontSize="14"
jeneive@4948
    45
    />
jeneive@4948
    46
    <style 
jeneive@4948
    47
        name="Total_Field"
jeneive@4948
    48
        isDefault="false"
jeneive@4948
    49
        mode="Opaque"
jeneive@4948
    50
        forecolor="#000000"
jeneive@4948
    51
        backcolor="#CCCCCC"
jeneive@4948
    52
        vAlign="Middle"
jeneive@4948
    53
    />
jeneive@4948
    54
    <style 
jeneive@4948
    55
        name="Detail_Header"
jeneive@4948
    56
        isDefault="false"
jeneive@4948
    57
        mode="Opaque"
jeneive@4948
    58
        forecolor="#FFFFFF"
jeneive@4948
    59
        backcolor="#555555"
jeneive@4948
    60
        vAlign="Middle"
jeneive@4948
    61
    />
jeneive@4948
    62
    <style 
jeneive@4948
    63
        name="GroupHeader_DarkGray"
jeneive@4948
    64
        isDefault="false"
jeneive@4948
    65
        mode="Opaque"
jeneive@4948
    66
        forecolor="#FFFFFF"
jeneive@4948
    67
        backcolor="#555555"
jeneive@4948
    68
        vAlign="Middle"
jeneive@4948
    69
        fontName="Bitstream Vera Sans"
jeneive@4948
    70
        fontSize="14"
jeneive@4948
    71
    />
jeneive@4948
    72
    <style 
jeneive@4948
    73
        name="GroupHeader_Gray"
jeneive@4948
    74
        isDefault="false"
jeneive@4948
    75
        mode="Opaque"
jeneive@4948
    76
        backcolor="#999999"
jeneive@4948
    77
    />
jeneive@4948
    78
    <style 
jeneive@4948
    79
        name="Detail_Line"
jeneive@4948
    80
        isDefault="false"
jeneive@4948
    81
        fontName="Bitstream Vera Sans"
jeneive@4948
    82
        fontSize="9"
jeneive@4948
    83
    >
harikrishnan@4429
    84
jeneive@4948
    85
        <conditionalStyle>
jeneive@4948
    86
            <conditionExpression><![CDATA[new Boolean($V{TAXNAME_COUNT}.intValue()%2==1)]]></conditionExpression>
jeneive@4948
    87
            <style 
jeneive@4948
    88
                name="Detail_Line"
jeneive@4948
    89
                isDefault="false"
jeneive@4948
    90
                mode="Opaque"
jeneive@4948
    91
                backcolor="#CCCCCC"
jeneive@4948
    92
                fontName="Bitstream Vera Sans"
jeneive@4948
    93
                fontSize="9"
jeneive@4948
    94
            />
jeneive@4948
    95
        </conditionalStyle>
jeneive@4948
    96
    </style>
jeneive@4948
    97
    <style 
jeneive@4948
    98
        name="Total_Gray"
jeneive@4948
    99
        isDefault="false"
jeneive@4948
   100
        mode="Opaque"
jeneive@4948
   101
        forecolor="#000000"
jeneive@4948
   102
        backcolor="#CCCCCC"
jeneive@4948
   103
    />
harikrishnan@4429
   104
jeneive@4948
   105
    <parameter name="ATTACH" isForPrompting="false" class="java.lang.String"/>
jeneive@4948
   106
    <parameter name="BASE_WEB" isForPrompting="false" class="java.lang.String"/>
jeneive@4948
   107
    <parameter name="BASE_DESIGN" isForPrompting="false" class="java.lang.String"/>
jeneive@4948
   108
    <parameter name="LANGUAGE" isForPrompting="false" class="java.lang.String">
jeneive@4948
   109
        <defaultValueExpression ><![CDATA["en_US"]]></defaultValueExpression>
jeneive@4948
   110
    </parameter>
jeneive@4948
   111
    <parameter name="USER_CLIENT" isForPrompting="false" class="java.lang.String">
jeneive@4948
   112
        <defaultValueExpression ><![CDATA["'1000000'"]]></defaultValueExpression>
jeneive@4948
   113
    </parameter>
jeneive@4948
   114
    <parameter name="USER_ORG" isForPrompting="false" class="java.lang.String">
jeneive@4948
   115
        <defaultValueExpression ><![CDATA["'0','1000000'"]]></defaultValueExpression>
jeneive@4948
   116
    </parameter>
jeneive@4948
   117
    <parameter name="REPORT_TITLE" isForPrompting="false" class="java.lang.String">
jeneive@4948
   118
        <defaultValueExpression ><![CDATA["REPORT TITLE"]]></defaultValueExpression>
jeneive@4948
   119
    </parameter>
jeneive@4948
   120
    <parameter name="REPORT_SUBTITLE" isForPrompting="false" class="java.lang.String">
jeneive@4948
   121
        <defaultValueExpression ><![CDATA["Sale"]]></defaultValueExpression>
jeneive@4948
   122
    </parameter>
jeneive@4948
   123
    <parameter name="aux_client" isForPrompting="false" class="java.lang.String">
jeneive@4948
   124
        <defaultValueExpression ><![CDATA[$P{USER_CLIENT}.equals("") ? " " : " AND C_INVOICE.AD_CLIENT_ID IN ("+$P{USER_CLIENT}+") "]]></defaultValueExpression>
jeneive@4948
   125
    </parameter>
jeneive@4948
   126
    <parameter name="aux_org" isForPrompting="false" class="java.lang.String">
jeneive@4948
   127
        <defaultValueExpression ><![CDATA[$P{USER_ORG}.equals("") ? " " : " AND C_INVOICE.AD_ORG_ID IN ("+$P{USER_ORG}+") "]]></defaultValueExpression>
jeneive@4948
   128
    </parameter>
jeneive@4948
   129
    <parameter name="cCountryId" isForPrompting="true" class="java.lang.String">
jeneive@4948
   130
        <defaultValueExpression ><![CDATA["100"]]></defaultValueExpression>
jeneive@4948
   131
    </parameter>
jeneive@4948
   132
    <parameter name="parDateFrom" isForPrompting="true" class="java.util.Date"/>
jeneive@4948
   133
    <parameter name="parDateTo" isForPrompting="true" class="java.util.Date"/>
jeneive@4948
   134
    <parameter name="ReportData" isForPrompting="false" class="java.lang.String">
jeneive@4948
   135
        <defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
jeneive@4948
   136
    </parameter>
jeneive@4948
   137
    <parameter name="SALE" isForPrompting="false" class="java.lang.String"/>
jeneive@4948
   138
    <parameter name="DETAIL" isForPrompting="false" class="java.lang.String"/>
jeneive@4948
   139
    <parameter name="NUMBERFORMAT" isForPrompting="false" class="java.text.DecimalFormat"/>
jeneive@4948
   140
    <parameter name="LOCALE" isForPrompting="false" class="java.util.Locale"/>
jeneive@4948
   141
    <parameter name="PARAM_CURRENCY" isForPrompting="false" class="java.lang.String">
jeneive@4948
   142
        <defaultValueExpression ><![CDATA["102"]]></defaultValueExpression>
jeneive@4948
   143
    </parameter>
jeneive@4948
   144
    <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, 
harikrishnan@4429
   145
      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))
harikrishnan@4429
   146
       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, 
harikrishnan@4429
   147
      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))
harikrishnan@4429
   148
       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
eduardo@1271
   149
      FROM C_TAX, C_INVOICETAX, C_INVOICE, C_BPARTNER_LOCATION, C_LOCATION, C_BPARTNER, C_DOCTYPE
carlos@0
   150
      WHERE C_TAX.C_TAX_ID=C_INVOICETAX.C_TAX_ID
carlos@0
   151
      AND C_INVOICETAX.C_INVOICE_ID=C_INVOICE.C_INVOICE_ID
carlos@0
   152
      AND C_INVOICE.C_BPARTNER_LOCATION_ID = C_BPARTNER_LOCATION.C_BPARTNER_LOCATION_ID
carlos@0
   153
      AND C_BPARTNER_LOCATION.C_LOCATION_ID = C_LOCATION.C_LOCATION_ID
carlos@0
   154
      AND C_INVOICE.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID
eduardo@1271
   155
      AND C_INVOICE.C_DOCTYPE_ID = C_DOCTYPE.C_DOCTYPE_ID
carlos@0
   156
      AND C_INVOICE.PROCESSED = 'Y'
carlos@0
   157
      AND C_INVOICE.ISACTIVE = 'Y'
carlos@0
   158
      AND C_INVOICE.ISSOTRX = 'Y'
carlos@0
   159
      AND C_LOCATION.C_COUNTRY_ID = $P{cCountryId}
carlos@0
   160
      AND C_INVOICE.DATEINVOICED >= $P{parDateFrom}
carlos@0
   161
      AND C_INVOICE.DATEINVOICED < $P{parDateTo}
jeneive@4948
   162
    AND 1=1 $P!{aux_client} 
harikrishnan@4429
   163
AND 1=1 $P!{aux_org}
carlos@0
   164
      AND 1=1 
carlos@0
   165
      GROUP BY C_INVOICE.DOCUMENTNO, C_INVOICE.DATEINVOICED, C_TAX.NAME, C_BPARTNER.NAME, C_INVOICE.ISSOTRX
carlos@0
   166
      HAVING SUM(C_INVOICETAX.TAXBASEAMT) <> 0
harikrishnan@4429
   167
      ORDER BY C_TAX.NAME, C_INVOICE.DATEINVOICED]]></queryString>
harikrishnan@4429
   168
jeneive@4948
   169
    <field name="SALES" class="java.lang.String"/>
jeneive@4948
   170
    <field name="NATIONAL" class="java.lang.String"/>
jeneive@4948
   171
    <field name="DOCUMENTNO" class="java.lang.String"/>
jeneive@4948
   172
    <field name="DATEINVOICED" class="java.sql.Timestamp"/>
jeneive@4948
   173
    <field name="BPARTNER" class="java.lang.String"/>
jeneive@4948
   174
    <field name="TAXNAME" class="java.lang.String"/>
jeneive@4948
   175
    <field name="TAXBASEAMT" class="java.math.BigDecimal"/>
jeneive@4948
   176
    <field name="TAXAMT" class="java.math.BigDecimal"/>
jeneive@4948
   177
    <field name="ADTREEID" class="java.lang.String"/>
jeneive@4948
   178
    <field name="CURRENCY" class="java.lang.String"/>
jeneive@4948
   179
    <field name="SUM_AMOUNT" class="java.lang.String"/>
jeneive@4948
   180
    <field name="Tax_BASE" class="java.lang.String"/>
harikrishnan@4429
   181
jeneive@4948
   182
    <variable name="sumTaxBaseAmt" class="java.math.BigDecimal" resetType="Group" resetGroup="TAXNAME" calculation="Sum">
jeneive@4948
   183
        <variableExpression><![CDATA[$F{TAXBASEAMT}]]></variableExpression>
jeneive@4948
   184
    </variable>
jeneive@4948
   185
    <variable name="sumImport" class="java.math.BigDecimal" resetType="Group" resetGroup="TAXNAME" calculation="Sum">
jeneive@4948
   186
        <variableExpression><![CDATA[$F{TAXAMT}]]></variableExpression>
jeneive@4948
   187
    </variable>
jeneive@4948
   188
    <variable name="sumAmount" class="java.lang.String" resetType="Report" calculation="Nothing">
jeneive@4948
   189
        <variableExpression><![CDATA[$V{sumImport}.toString()]]></variableExpression>
jeneive@4948
   190
    </variable>
harikrishnan@4429
   191
jeneive@4948
   192
        <group  name="TAXNAME" >
jeneive@4948
   193
            <groupExpression><![CDATA[$F{TAXNAME}]]></groupExpression>
jeneive@4948
   194
            <groupHeader>
jeneive@4948
   195
            <band height="44"  isSplitAllowed="true" >
jeneive@4948
   196
                <staticText>
jeneive@4948
   197
                    <reportElement
jeneive@4948
   198
                        style="GroupHeader_DarkGray"
jeneive@4948
   199
                        x="1"
jeneive@4948
   200
                        y="0"
jeneive@4948
   201
                        width="100"
jeneive@4948
   202
                        height="20"
jeneive@4948
   203
                        key="staticText"/>
jeneive@4948
   204
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
jeneive@4948
   205
                    <textElement>
jeneive@4948
   206
                        <font pdfFontName="Helvetica"/>
jeneive@4948
   207
                    </textElement>
jeneive@4948
   208
                <text><![CDATA[Tax Type]]></text>
jeneive@4948
   209
                </staticText>
jeneive@4948
   210
                <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
jeneive@4948
   211
                    <reportElement
jeneive@4948
   212
                        style="GroupHeader_DarkGray"
jeneive@4948
   213
                        x="101"
jeneive@4948
   214
                        y="0"
jeneive@4948
   215
                        width="503"
jeneive@4948
   216
                        height="20"
jeneive@4948
   217
                        key="textField"/>
jeneive@4948
   218
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
jeneive@4948
   219
                    <textElement>
jeneive@4948
   220
                        <font pdfFontName="Helvetica"/>
jeneive@4948
   221
                    </textElement>
jeneive@4948
   222
                <textFieldExpression   class="java.lang.String"><![CDATA[$F{TAXNAME}]]></textFieldExpression>
jeneive@4948
   223
                </textField>
jeneive@4948
   224
                <line direction="TopDown">
jeneive@4948
   225
                    <reportElement
jeneive@4948
   226
                        x="0"
jeneive@4948
   227
                        y="1"
jeneive@4948
   228
                        width="0"
jeneive@4948
   229
                        height="43"
jeneive@4948
   230
                        forecolor="#555555"
jeneive@4948
   231
                        key="line-2"
jeneive@4948
   232
                        stretchType="RelativeToBandHeight"/>
jeneive@4948
   233
                    <graphicElement stretchType="RelativeToBandHeight"/>
jeneive@4948
   234
                </line>
jeneive@4948
   235
                <line direction="TopDown">
jeneive@4948
   236
                    <reportElement
jeneive@4948
   237
                        x="604"
jeneive@4948
   238
                        y="0"
jeneive@4948
   239
                        width="0"
jeneive@4948
   240
                        height="43"
jeneive@4948
   241
                        forecolor="#555555"
jeneive@4948
   242
                        key="line-3"
jeneive@4948
   243
                        stretchType="RelativeToBandHeight"/>
jeneive@4948
   244
                    <graphicElement stretchType="RelativeToBandHeight"/>
jeneive@4948
   245
                </line>
jeneive@4948
   246
                <staticText>
jeneive@4948
   247
                    <reportElement
jeneive@4948
   248
                        style="Detail_Header"
jeneive@4948
   249
                        x="10"
jeneive@4948
   250
                        y="28"
jeneive@4948
   251
                        width="90"
jeneive@4948
   252
                        height="16"
jeneive@4948
   253
                        key="element-90">
jeneive@4948
   254
                            <printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
jeneive@4948
   255
                        </reportElement>
jeneive@4948
   256
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
jeneive@4948
   257
                    <textElement>
jeneive@4948
   258
                        <font/>
jeneive@4948
   259
                    </textElement>
jeneive@4948
   260
                <text><![CDATA[Invoice]]></text>
jeneive@4948
   261
                </staticText>
jeneive@4948
   262
                <staticText>
jeneive@4948
   263
                    <reportElement
jeneive@4948
   264
                        style="Detail_Header"
jeneive@4948
   265
                        x="100"
jeneive@4948
   266
                        y="28"
jeneive@4948
   267
                        width="70"
jeneive@4948
   268
                        height="16"
jeneive@4948
   269
                        key="element-90">
jeneive@4948
   270
                            <printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
jeneive@4948
   271
                        </reportElement>
jeneive@4948
   272
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
jeneive@4948
   273
                    <textElement>
jeneive@4948
   274
                        <font/>
jeneive@4948
   275
                    </textElement>
jeneive@4948
   276
                <text><![CDATA[Date]]></text>
jeneive@4948
   277
                </staticText>
jeneive@4948
   278
                <staticText>
jeneive@4948
   279
                    <reportElement
jeneive@4948
   280
                        style="Detail_Header"
jeneive@4948
   281
                        x="170"
jeneive@4948
   282
                        y="28"
jeneive@4948
   283
                        width="165"
jeneive@4948
   284
                        height="16"
jeneive@4948
   285
                        key="element-90">
jeneive@4948
   286
                            <printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
jeneive@4948
   287
                        </reportElement>
jeneive@4948
   288
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
jeneive@4948
   289
                    <textElement>
jeneive@4948
   290
                        <font/>
jeneive@4948
   291
                    </textElement>
jeneive@4948
   292
                <text><![CDATA[Business Partner]]></text>
jeneive@4948
   293
                </staticText>
jeneive@4948
   294
                <staticText>
jeneive@4948
   295
                    <reportElement
jeneive@4948
   296
                        style="Detail_Header"
jeneive@4948
   297
                        x="335"
jeneive@4948
   298
                        y="28"
jeneive@4948
   299
                        width="117"
jeneive@4948
   300
                        height="16"
jeneive@4948
   301
                        key="element-90"/>
jeneive@4948
   302
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
jeneive@4948
   303
                    <textElement textAlignment="Right">
jeneive@4948
   304
                        <font/>
jeneive@4948
   305
                    </textElement>
jeneive@4948
   306
                <text><![CDATA[Taxable Base]]></text>
jeneive@4948
   307
                </staticText>
jeneive@4948
   308
                <staticText>
jeneive@4948
   309
                    <reportElement
jeneive@4948
   310
                        style="Detail_Header"
jeneive@4948
   311
                        x="452"
jeneive@4948
   312
                        y="28"
jeneive@4948
   313
                        width="114"
jeneive@4948
   314
                        height="16"
jeneive@4948
   315
                        key="element-90"/>
jeneive@4948
   316
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
jeneive@4948
   317
                    <textElement textAlignment="Right">
jeneive@4948
   318
                        <font/>
jeneive@4948
   319
                    </textElement>
jeneive@4948
   320
                <text><![CDATA[Amount]]></text>
jeneive@4948
   321
                </staticText>
jeneive@4948
   322
            </band>
jeneive@4948
   323
            </groupHeader>
jeneive@4948
   324
            <groupFooter>
jeneive@4948
   325
            <band height="25"  isSplitAllowed="true" >
jeneive@4948
   326
                <line direction="TopDown">
jeneive@4948
   327
                    <reportElement
jeneive@4948
   328
                        x="0"
jeneive@4948
   329
                        y="0"
jeneive@4948
   330
                        width="0"
jeneive@4948
   331
                        height="20"
jeneive@4948
   332
                        forecolor="#555555"
jeneive@4948
   333
                        key="line-32"
jeneive@4948
   334
                        stretchType="RelativeToBandHeight"/>
jeneive@4948
   335
                    <graphicElement stretchType="RelativeToBandHeight"/>
jeneive@4948
   336
                </line>
jeneive@4948
   337
                <line direction="TopDown">
jeneive@4948
   338
                    <reportElement
jeneive@4948
   339
                        x="604"
jeneive@4948
   340
                        y="0"
jeneive@4948
   341
                        width="0"
jeneive@4948
   342
                        height="20"
jeneive@4948
   343
                        forecolor="#555555"
jeneive@4948
   344
                        key="line-33"
jeneive@4948
   345
                        stretchType="RelativeToBandHeight"/>
jeneive@4948
   346
                    <graphicElement stretchType="RelativeToBandHeight"/>
jeneive@4948
   347
                </line>
jeneive@4948
   348
                <line direction="TopDown">
jeneive@4948
   349
                    <reportElement
jeneive@4948
   350
                        x="0"
jeneive@4948
   351
                        y="20"
jeneive@4948
   352
                        width="603"
jeneive@4948
   353
                        height="0"
jeneive@4948
   354
                        forecolor="#555555"
jeneive@4948
   355
                        key="line-34"/>
jeneive@4948
   356
                    <graphicElement stretchType="NoStretch"/>
jeneive@4948
   357
                </line>
jeneive@4948
   358
                <staticText>
jeneive@4948
   359
                    <reportElement
jeneive@4948
   360
                        style="default"
jeneive@4948
   361
                        x="199"
jeneive@4948
   362
                        y="0"
jeneive@4948
   363
                        width="90"
jeneive@4948
   364
                        height="16"
jeneive@4948
   365
                        key="staticText-4"/>
jeneive@4948
   366
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
jeneive@4948
   367
                    <textElement textAlignment="Right">
jeneive@4948
   368
                        <font fontName="Bitstream Vera Sans"/>
jeneive@4948
   369
                    </textElement>
jeneive@4948
   370
                <text><![CDATA[Total:]]></text>
jeneive@4948
   371
                </staticText>
jeneive@4948
   372
                <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
jeneive@4948
   373
                    <reportElement
jeneive@4948
   374
                        style="Total_Field"
jeneive@4948
   375
                        x="294"
jeneive@4948
   376
                        y="0"
jeneive@4948
   377
                        width="33"
jeneive@4948
   378
                        height="16"
jeneive@4948
   379
                        key="textField"/>
jeneive@4948
   380
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
jeneive@4948
   381
                    <textElement verticalAlignment="Middle">
jeneive@4948
   382
                        <font/>
jeneive@4948
   383
                    </textElement>
jeneive@4948
   384
                <textFieldExpression   class="java.lang.Integer"><![CDATA[$V{TAXNAME_COUNT}]]></textFieldExpression>
jeneive@4948
   385
                </textField>
jeneive@4948
   386
                <line direction="TopDown">
jeneive@4948
   387
                    <reportElement
jeneive@4948
   388
                        x="10"
jeneive@4948
   389
                        y="0"
jeneive@4948
   390
                        width="510"
jeneive@4948
   391
                        height="0"
jeneive@4948
   392
                        forecolor="#666666"
jeneive@4948
   393
                        key="line-37"/>
jeneive@4948
   394
                    <graphicElement stretchType="NoStretch"/>
jeneive@4948
   395
                </line>
jeneive@4948
   396
                <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
jeneive@4948
   397
                    <reportElement
jeneive@4948
   398
                        style="Total_Field"
jeneive@4948
   399
                        x="452"
jeneive@4948
   400
                        y="0"
jeneive@4948
   401
                        width="114"
jeneive@4948
   402
                        height="17"
jeneive@4948
   403
                        key="textField"/>
jeneive@4948
   404
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
jeneive@4948
   405
                    <textElement textAlignment="Right">
jeneive@4948
   406
                        <font/>
jeneive@4948
   407
                    </textElement>
jeneive@4948
   408
                <textFieldExpression   class="java.lang.String"><![CDATA[($V{sumImport}!=null)?$P{NUMBERFORMAT}.format($V{sumImport})+$F{CURRENCY}:new String(" ")]]></textFieldExpression>
jeneive@4948
   409
                </textField>
jeneive@4948
   410
                <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
jeneive@4948
   411
                    <reportElement
jeneive@4948
   412
                        style="Total_Field"
jeneive@4948
   413
                        x="335"
jeneive@4948
   414
                        y="0"
jeneive@4948
   415
                        width="117"
jeneive@4948
   416
                        height="16"
jeneive@4948
   417
                        key="textField"/>
jeneive@4948
   418
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
jeneive@4948
   419
                    <textElement textAlignment="Right" verticalAlignment="Middle">
jeneive@4948
   420
                        <font/>
jeneive@4948
   421
                    </textElement>
jeneive@4948
   422
                <textFieldExpression   class="java.lang.String"><![CDATA[($V{sumTaxBaseAmt}!=null)?$P{NUMBERFORMAT}.format($V{sumTaxBaseAmt})+$F{CURRENCY}:new String(" ")]]></textFieldExpression>
jeneive@4948
   423
                </textField>
jeneive@4948
   424
            </band>
jeneive@4948
   425
            </groupFooter>
jeneive@4948
   426
        </group>
jeneive@4948
   427
        <background>
jeneive@4948
   428
            <band height="0"  isSplitAllowed="true" >
jeneive@4948
   429
            </band>
jeneive@4948
   430
        </background>
jeneive@4948
   431
        <title>
jeneive@4948
   432
            <band height="0"  isSplitAllowed="true" >
jeneive@4948
   433
            </band>
jeneive@4948
   434
        </title>
jeneive@4948
   435
        <pageHeader>
jeneive@4948
   436
            <band height="20"  isSplitAllowed="true" >
jeneive@4948
   437
                <textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
jeneive@4948
   438
                    <reportElement
jeneive@4948
   439
                        style="Report_Subtitle"
jeneive@4948
   440
                        x="1"
jeneive@4948
   441
                        y="0"
jeneive@4948
   442
                        width="602"
jeneive@4948
   443
                        height="20"
jeneive@4948
   444
                        key="textField"/>
jeneive@4948
   445
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
jeneive@4948
   446
                    <textElement>
jeneive@4948
   447
                        <font/>
jeneive@4948
   448
                    </textElement>
jeneive@4948
   449
                <textFieldExpression   class="java.lang.String"><![CDATA[$P{SALE}]]></textFieldExpression>
jeneive@4948
   450
                </textField>
jeneive@4948
   451
            </band>
jeneive@4948
   452
        </pageHeader>
jeneive@4948
   453
        <columnHeader>
jeneive@4948
   454
            <band height="0"  isSplitAllowed="true" >
jeneive@4948
   455
            </band>
jeneive@4948
   456
        </columnHeader>
jeneive@4948
   457
        <detail>
jeneive@4948
   458
            <band height="14"  isSplitAllowed="true" >
jeneive@4948
   459
                <printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
jeneive@4948
   460
                <line direction="TopDown">
jeneive@4948
   461
                    <reportElement
jeneive@4948
   462
                        x="603"
jeneive@4948
   463
                        y="-6"
jeneive@4948
   464
                        width="0"
jeneive@4948
   465
                        height="14"
jeneive@4948
   466
                        forecolor="#555555"
jeneive@4948
   467
                        key="line-16"
jeneive@4948
   468
                        stretchType="RelativeToBandHeight"/>
jeneive@4948
   469
                    <graphicElement stretchType="RelativeToBandHeight"/>
jeneive@4948
   470
                </line>
jeneive@4948
   471
                <line direction="TopDown">
jeneive@4948
   472
                    <reportElement
jeneive@4948
   473
                        x="0"
jeneive@4948
   474
                        y="0"
jeneive@4948
   475
                        width="0"
jeneive@4948
   476
                        height="14"
jeneive@4948
   477
                        forecolor="#555555"
jeneive@4948
   478
                        key="line-17"
jeneive@4948
   479
                        stretchType="RelativeToBandHeight"/>
jeneive@4948
   480
                    <graphicElement stretchType="RelativeToBandHeight"/>
jeneive@4948
   481
                </line>
jeneive@4948
   482
                <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
jeneive@4948
   483
                    <reportElement
jeneive@4948
   484
                        style="Detail_Line"
jeneive@4948
   485
                        x="10"
jeneive@4948
   486
                        y="0"
jeneive@4948
   487
                        width="90"
jeneive@4948
   488
                        height="14"
jeneive@4948
   489
                        key="textField"/>
jeneive@4948
   490
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
jeneive@4948
   491
                    <textElement verticalAlignment="Middle">
jeneive@4948
   492
                        <font/>
jeneive@4948
   493
                    </textElement>
jeneive@4948
   494
                <textFieldExpression   class="java.lang.String"><![CDATA[$F{DOCUMENTNO}]]></textFieldExpression>
jeneive@4948
   495
                </textField>
jeneive@4948
   496
                <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
jeneive@4948
   497
                    <reportElement
jeneive@4948
   498
                        style="Detail_Line"
jeneive@4948
   499
                        x="100"
jeneive@4948
   500
                        y="0"
jeneive@4948
   501
                        width="70"
jeneive@4948
   502
                        height="14"
jeneive@4948
   503
                        key="textField"/>
jeneive@4948
   504
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
jeneive@4948
   505
                    <textElement verticalAlignment="Middle">
jeneive@4948
   506
                        <font/>
jeneive@4948
   507
                    </textElement>
jeneive@4948
   508
                <textFieldExpression   class="java.sql.Timestamp"><![CDATA[$F{DATEINVOICED}]]></textFieldExpression>
jeneive@4948
   509
                </textField>
jeneive@4948
   510
                <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
jeneive@4948
   511
                    <reportElement
jeneive@4948
   512
                        style="Detail_Line"
jeneive@4948
   513
                        x="170"
jeneive@4948
   514
                        y="0"
jeneive@4948
   515
                        width="165"
jeneive@4948
   516
                        height="14"
jeneive@4948
   517
                        key="textField"/>
jeneive@4948
   518
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
jeneive@4948
   519
                    <textElement verticalAlignment="Middle">
jeneive@4948
   520
                        <font/>
jeneive@4948
   521
                    </textElement>
jeneive@4948
   522
                <textFieldExpression   class="java.lang.String"><![CDATA[$F{BPARTNER}]]></textFieldExpression>
jeneive@4948
   523
                </textField>
jeneive@4948
   524
                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
jeneive@4948
   525
                    <reportElement
jeneive@4948
   526
                        style="Detail_Line"
jeneive@4948
   527
                        x="335"
jeneive@4948
   528
                        y="0"
jeneive@4948
   529
                        width="117"
jeneive@4948
   530
                        height="14"
jeneive@4948
   531
                        key="textField"/>
jeneive@4948
   532
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
jeneive@4948
   533
                    <textElement textAlignment="Right" verticalAlignment="Middle">
jeneive@4948
   534
                        <font size="9"/>
jeneive@4948
   535
                    </textElement>
jeneive@4948
   536
                <textFieldExpression   class="java.lang.String"><![CDATA[($F{TAXBASEAMT}!=null)?$P{NUMBERFORMAT}.format($F{TAXBASEAMT})+$F{CURRENCY}:new String(" ")]]></textFieldExpression>
jeneive@4948
   537
                </textField>
jeneive@4948
   538
                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
jeneive@4948
   539
                    <reportElement
jeneive@4948
   540
                        style="Detail_Line"
jeneive@4948
   541
                        x="452"
jeneive@4948
   542
                        y="0"
jeneive@4948
   543
                        width="114"
jeneive@4948
   544
                        height="14"
jeneive@4948
   545
                        key="textField"/>
jeneive@4948
   546
                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
jeneive@4948
   547
                    <textElement textAlignment="Right" verticalAlignment="Middle">
jeneive@4948
   548
                        <font/>
jeneive@4948
   549
                    </textElement>
jeneive@4948
   550
                <textFieldExpression   class="java.lang.String"><![CDATA[($F{TAXAMT}!=null)?$P{NUMBERFORMAT}.format($F{TAXAMT})+$F{CURRENCY}:new String(" ")]]></textFieldExpression>
jeneive@4948
   551
                </textField>
jeneive@4948
   552
            </band>
jeneive@4948
   553
        </detail>
jeneive@4948
   554
        <columnFooter>
jeneive@4948
   555
            <band height="0"  isSplitAllowed="true" >
jeneive@4948
   556
            </band>
jeneive@4948
   557
        </columnFooter>
jeneive@4948
   558
        <pageFooter>
jeneive@4948
   559
            <band height="0"  isSplitAllowed="true" >
jeneive@4948
   560
            </band>
jeneive@4948
   561
        </pageFooter>
jeneive@4948
   562
        <summary>
jeneive@4948
   563
            <band height="0"  isSplitAllowed="true" >
jeneive@4948
   564
            </band>
jeneive@4948
   565
        </summary>
jeneive@4948
   566
</jasperReport>