src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoiceSale.jrxml
author Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan@openbravo.com>
Tue, 25 Mar 2014 17:08:07 +0530
changeset 22768 1dcbf92e17e9
parent 22717 8f8910c3f90c
child 26742 d2bbde0c3d66
permissions -rw-r--r--
Related to 25289: Invoice Taxes Report: Some taxes' width comes out of the pdf
ivan@11848
     1
<?xml version="1.0" encoding="UTF-8"?>
pandeeswari@22768
     2
<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="ReportTaxInvoiceSale" pageWidth="535" pageHeight="842" columnWidth="535" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
ivan@11848
     3
	<property name="ireport.scriptlethandling" value="0"/>
ivan@11848
     4
	<property name="ireport.encoding" value="UTF-8"/>
ioritz@18035
     5
	<property name="ireport.zoom" value="1.0"/>
ioritz@18035
     6
	<property name="ireport.x" value="0"/>
ioritz@18035
     7
	<property name="ireport.y" value="0"/>
ivan@11848
     8
	<import value="net.sf.jasperreports.engine.*"/>
ivan@11848
     9
	<import value="java.util.*"/>
ivan@11848
    10
	<import value="net.sf.jasperreports.engine.data.*"/>
ivan@11848
    11
	<style name="default" vAlign="Middle" fontName="Bitstream Vera Sans" fontSize="10"/>
ivan@11848
    12
	<style name="Report_Title" fontName="Bitstream Vera Sans" fontSize="18"/>
ivan@11848
    13
	<style name="Report_Subtitle" forecolor="#555555" fontName="Bitstream Vera Sans" fontSize="14"/>
ivan@11848
    14
	<style name="Total_Field" mode="Opaque" forecolor="#000000" backcolor="#CCCCCC" vAlign="Middle"/>
ivan@11848
    15
	<style name="Detail_Header" mode="Opaque" forecolor="#FFFFFF" backcolor="#555555" vAlign="Middle"/>
ivan@11848
    16
	<style name="GroupHeader_DarkGray" mode="Opaque" forecolor="#FFFFFF" backcolor="#555555" vAlign="Middle" fontName="Bitstream Vera Sans" fontSize="14"/>
ivan@11848
    17
	<style name="GroupHeader_Gray" mode="Opaque" backcolor="#999999"/>
ivan@11848
    18
	<style name="Detail_Line" fontName="Bitstream Vera Sans" fontSize="9">
ivan@11848
    19
		<conditionalStyle>
ivan@11848
    20
			<conditionExpression><![CDATA[new Boolean($V{TAXNAME_COUNT}.intValue()%2==1)]]></conditionExpression>
ivan@11848
    21
			<style mode="Opaque" backcolor="#CCCCCC" fontName="Bitstream Vera Sans" fontSize="9"/>
ivan@11848
    22
		</conditionalStyle>
ivan@11848
    23
	</style>
ivan@11848
    24
	<style name="Total_Gray" mode="Opaque" forecolor="#000000" backcolor="#CCCCCC"/>
ivan@11848
    25
	<parameter name="ATTACH" class="java.lang.String" isForPrompting="false"/>
ivan@11848
    26
	<parameter name="BASE_WEB" class="java.lang.String" isForPrompting="false"/>
ivan@11848
    27
	<parameter name="BASE_DESIGN" class="java.lang.String" isForPrompting="false"/>
ivan@11848
    28
	<parameter name="LANGUAGE" class="java.lang.String" isForPrompting="false">
ivan@11848
    29
		<defaultValueExpression><![CDATA["en_US"]]></defaultValueExpression>
ivan@11848
    30
	</parameter>
ivan@11848
    31
	<parameter name="USER_CLIENT" class="java.lang.String" isForPrompting="false">
ivan@11848
    32
		<defaultValueExpression><![CDATA["'1000000'"]]></defaultValueExpression>
ivan@11848
    33
	</parameter>
ivan@11848
    34
	<parameter name="USER_ORG" class="java.lang.String" isForPrompting="false">
ivan@11848
    35
		<defaultValueExpression><![CDATA["'0','1000000'"]]></defaultValueExpression>
ivan@11848
    36
	</parameter>
ivan@11848
    37
	<parameter name="REPORT_TITLE" class="java.lang.String" isForPrompting="false">
ivan@11848
    38
		<defaultValueExpression><![CDATA["REPORT TITLE"]]></defaultValueExpression>
ivan@11848
    39
	</parameter>
ivan@11848
    40
	<parameter name="REPORT_SUBTITLE" class="java.lang.String" isForPrompting="false">
ivan@11848
    41
		<defaultValueExpression><![CDATA["Sale"]]></defaultValueExpression>
ivan@11848
    42
	</parameter>
ivan@11848
    43
	<parameter name="aux_client" class="java.lang.String" isForPrompting="false">
ivan@11848
    44
		<defaultValueExpression><![CDATA[$P{USER_CLIENT}.equals("") ? " " : " AND C_INVOICE.AD_CLIENT_ID IN ("+$P{USER_CLIENT}+") "]]></defaultValueExpression>
ivan@11848
    45
	</parameter>
ivan@11848
    46
	<parameter name="aux_org" class="java.lang.String" isForPrompting="false">
ivan@11848
    47
		<defaultValueExpression><![CDATA[$P{USER_ORG}.equals("") ? " " : " AND C_INVOICE.AD_ORG_ID IN ("+$P{USER_ORG}+") "]]></defaultValueExpression>
ivan@11848
    48
	</parameter>
ivan@11848
    49
	<parameter name="cCountryId" class="java.lang.String">
ivan@11848
    50
		<defaultValueExpression><![CDATA["100"]]></defaultValueExpression>
ivan@11848
    51
	</parameter>
ivan@11848
    52
	<parameter name="parDateFrom" class="java.util.Date"/>
ivan@11848
    53
	<parameter name="parDateTo" class="java.util.Date"/>
ivan@11848
    54
	<parameter name="ReportData" class="java.lang.String" isForPrompting="false">
ivan@11848
    55
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
ivan@11848
    56
	</parameter>
ivan@11848
    57
	<parameter name="SALE" class="java.lang.String" isForPrompting="false"/>
ivan@11848
    58
	<parameter name="DETAIL" class="java.lang.String" isForPrompting="false"/>
ivan@11848
    59
	<parameter name="NUMBERFORMAT" class="java.text.DecimalFormat" isForPrompting="false"/>
ivan@11848
    60
	<parameter name="LOCALE" class="java.util.Locale" isForPrompting="false"/>
ivan@11848
    61
	<parameter name="PARAM_CURRENCY" class="java.lang.String" isForPrompting="false">
ivan@11848
    62
		<defaultValueExpression><![CDATA["102"]]></defaultValueExpression>
ivan@11848
    63
	</parameter>
ivan@11848
    64
	<queryString>
ioritz@18035
    65
		<![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,
ioritz@18035
    66
      SUM(CASE WHEN DOCBASETYPE IN ('ARC','APC') THEN -1 * (C_CURRENCY_CONVERT_RATE(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, ICR.RATE))
ioritz@18035
    67
       ELSE (C_CURRENCY_CONVERT_RATE(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, ICR.RATE)) END) AS TAXBASEAMT,
ioritz@18035
    68
      SUM(CASE WHEN DOCBASETYPE IN ('ARC','APC') THEN -1 * (C_CURRENCY_CONVERT_RATE(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, ICR.RATE))
ioritz@18035
    69
       ELSE (C_CURRENCY_CONVERT_RATE(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, ICR.RATE)) END) AS TAXAMT, '' AS ADTREEID,C_CURRENCY_SYMBOL($P{PARAM_CURRENCY}, 0, 'Y') AS CURRENCY,'' AS SUM_AMOUNT,'' AS Tax_BASE
ioritz@18035
    70
      FROM C_TAX, C_INVOICETAX, C_INVOICE
ioritz@18035
    71
        LEFT JOIN C_CONVERSION_RATE_DOCUMENT ICR ON C_INVOICE.C_INVOICE_ID = ICR.C_INVOICE_ID,
ioritz@18035
    72
        C_BPARTNER_LOCATION, C_LOCATION, C_BPARTNER, C_DOCTYPE
carlos@0
    73
      WHERE C_TAX.C_TAX_ID=C_INVOICETAX.C_TAX_ID
carlos@0
    74
      AND C_INVOICETAX.C_INVOICE_ID=C_INVOICE.C_INVOICE_ID
carlos@0
    75
      AND C_INVOICE.C_BPARTNER_LOCATION_ID = C_BPARTNER_LOCATION.C_BPARTNER_LOCATION_ID
carlos@0
    76
      AND C_BPARTNER_LOCATION.C_LOCATION_ID = C_LOCATION.C_LOCATION_ID
carlos@0
    77
      AND C_INVOICE.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID
eduardo@1271
    78
      AND C_INVOICE.C_DOCTYPE_ID = C_DOCTYPE.C_DOCTYPE_ID
carlos@0
    79
      AND C_INVOICE.PROCESSED = 'Y'
carlos@0
    80
      AND C_INVOICE.ISACTIVE = 'Y'
carlos@0
    81
      AND C_INVOICE.ISSOTRX = 'Y'
carlos@0
    82
      AND C_LOCATION.C_COUNTRY_ID = $P{cCountryId}
carlos@0
    83
      AND C_INVOICE.DATEINVOICED >= $P{parDateFrom}
carlos@0
    84
      AND C_INVOICE.DATEINVOICED < $P{parDateTo}
ioritz@18035
    85
    AND 1=1 $P!{aux_client}
harikrishnan@4429
    86
AND 1=1 $P!{aux_org}
ioritz@18035
    87
      AND 1=1
carlos@0
    88
      GROUP BY C_INVOICE.DOCUMENTNO, C_INVOICE.DATEINVOICED, C_TAX.NAME, C_BPARTNER.NAME, C_INVOICE.ISSOTRX
carlos@0
    89
      HAVING SUM(C_INVOICETAX.TAXBASEAMT) <> 0
ivan@11848
    90
      ORDER BY C_TAX.NAME, C_INVOICE.DATEINVOICED]]>
ivan@11848
    91
	</queryString>
ivan@11848
    92
	<field name="SALES" class="java.lang.String"/>
ivan@11848
    93
	<field name="NATIONAL" class="java.lang.String"/>
ivan@11848
    94
	<field name="DOCUMENTNO" class="java.lang.String"/>
ivan@11848
    95
	<field name="DATEINVOICED" class="java.sql.Timestamp"/>
ivan@11848
    96
	<field name="BPARTNER" class="java.lang.String"/>
ivan@11848
    97
	<field name="TAXNAME" class="java.lang.String"/>
ivan@11848
    98
	<field name="TAXBASEAMT" class="java.math.BigDecimal"/>
ivan@11848
    99
	<field name="TAXAMT" class="java.math.BigDecimal"/>
ivan@11848
   100
	<field name="ADTREEID" class="java.lang.String"/>
ivan@11848
   101
	<field name="CURRENCY" class="java.lang.String"/>
ivan@11848
   102
	<field name="SUM_AMOUNT" class="java.lang.String"/>
ivan@11848
   103
	<field name="Tax_BASE" class="java.lang.String"/>
ivan@11848
   104
	<variable name="sumTaxBaseAmt" class="java.math.BigDecimal" resetType="Group" resetGroup="TAXNAME" calculation="Sum">
ivan@11848
   105
		<variableExpression><![CDATA[$F{TAXBASEAMT}]]></variableExpression>
ivan@11848
   106
	</variable>
ivan@11848
   107
	<variable name="sumImport" class="java.math.BigDecimal" resetType="Group" resetGroup="TAXNAME" calculation="Sum">
ivan@11848
   108
		<variableExpression><![CDATA[$F{TAXAMT}]]></variableExpression>
ivan@11848
   109
	</variable>
ivan@11848
   110
	<variable name="sumAmount" class="java.lang.String">
ivan@11848
   111
		<variableExpression><![CDATA[$V{sumImport}.toString()]]></variableExpression>
ivan@11848
   112
	</variable>
ivan@11848
   113
	<group name="TAXNAME">
ivan@11848
   114
		<groupExpression><![CDATA[$F{TAXNAME}]]></groupExpression>
ivan@11848
   115
		<groupHeader>
pandeeswari@22768
   116
			<band height="44" splitType="Stretch">
ivan@11848
   117
				<staticText>
pandeeswari@22768
   118
					<reportElement key="staticText" style="GroupHeader_DarkGray" x="1" y="0" width="100" height="20"/>
ivan@11848
   119
					<box leftPadding="5">
ivan@11848
   120
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   121
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   122
						<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   123
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   124
					</box>
ivan@11848
   125
					<textElement>
ivan@11848
   126
						<font pdfFontName="Helvetica"/>
ivan@11848
   127
					</textElement>
ivan@11848
   128
					<text><![CDATA[Tax Type]]></text>
ivan@11848
   129
				</staticText>
pandeeswari@22768
   130
				<textField pattern="" isBlankWhenNull="true">
pandeeswari@22768
   131
					<reportElement key="textField" style="GroupHeader_DarkGray" x="101" y="0" width="433" height="20"/>
ivan@11848
   132
					<box leftPadding="5">
ivan@11848
   133
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   134
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   135
						<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   136
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   137
					</box>
ivan@11848
   138
					<textElement>
ivan@11848
   139
						<font pdfFontName="Helvetica"/>
ivan@11848
   140
					</textElement>
ivan@11848
   141
					<textFieldExpression class="java.lang.String"><![CDATA[$F{TAXNAME}]]></textFieldExpression>
ivan@11848
   142
				</textField>
ivan@11848
   143
				<line>
ivan@11848
   144
					<reportElement key="line-2" stretchType="RelativeToBandHeight" x="0" y="1" width="1" height="43" forecolor="#555555"/>
pandeeswari@22768
   145
					<graphicElement>
pandeeswari@22768
   146
						<pen lineWidth="2.0"/>
pandeeswari@22768
   147
					</graphicElement>
ivan@11848
   148
				</line>
ivan@11848
   149
				<line>
pandeeswari@22768
   150
					<reportElement key="line-3" stretchType="RelativeToBandHeight" x="534" y="1" width="1" height="43" forecolor="#555555"/>
pandeeswari@22768
   151
					<graphicElement>
pandeeswari@22768
   152
						<pen lineWidth="2.0"/>
pandeeswari@22768
   153
					</graphicElement>
ivan@11848
   154
				</line>
ivan@11848
   155
				<staticText>
pandeeswari@22768
   156
					<reportElement key="element-90" style="Detail_Header" x="10" y="28" width="90" height="16">
ivan@11848
   157
						<printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
ivan@11848
   158
					</reportElement>
ivan@11848
   159
					<box leftPadding="5">
ivan@11848
   160
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   161
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   162
						<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   163
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   164
					</box>
ivan@11848
   165
					<textElement/>
ivan@11848
   166
					<text><![CDATA[Invoice]]></text>
ivan@11848
   167
				</staticText>
ivan@11848
   168
				<staticText>
pandeeswari@22768
   169
					<reportElement key="element-90" style="Detail_Header" x="100" y="28" width="70" height="16">
ivan@11848
   170
						<printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
ivan@11848
   171
					</reportElement>
ivan@11848
   172
					<box leftPadding="5">
ivan@11848
   173
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   174
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   175
						<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   176
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   177
					</box>
ivan@11848
   178
					<textElement/>
ivan@11848
   179
					<text><![CDATA[Date]]></text>
ivan@11848
   180
				</staticText>
ivan@11848
   181
				<staticText>
pandeeswari@22768
   182
					<reportElement key="element-90" style="Detail_Header" x="170" y="28" width="170" height="16">
ivan@11848
   183
						<printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
ivan@11848
   184
					</reportElement>
ivan@11848
   185
					<box leftPadding="5">
ivan@11848
   186
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   187
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   188
						<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   189
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   190
					</box>
ivan@11848
   191
					<textElement/>
ivan@11848
   192
					<text><![CDATA[Business Partner]]></text>
ivan@11848
   193
				</staticText>
ivan@11848
   194
				<staticText>
pandeeswari@22768
   195
					<reportElement key="element-90" style="Detail_Header" x="340" y="28" width="90" height="16"/>
ivan@11848
   196
					<box leftPadding="5">
ivan@11848
   197
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   198
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   199
						<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   200
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   201
					</box>
ivan@11848
   202
					<textElement textAlignment="Right"/>
ivan@11848
   203
					<text><![CDATA[Taxable Base]]></text>
ivan@11848
   204
				</staticText>
ivan@11848
   205
				<staticText>
pandeeswari@22768
   206
					<reportElement key="element-90" style="Detail_Header" x="430" y="28" width="90" height="16"/>
ivan@11848
   207
					<box leftPadding="5">
ivan@11848
   208
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   209
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   210
						<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   211
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   212
					</box>
ivan@11848
   213
					<textElement textAlignment="Right"/>
ivan@11848
   214
					<text><![CDATA[Amount]]></text>
ivan@11848
   215
				</staticText>
ivan@11848
   216
			</band>
ivan@11848
   217
		</groupHeader>
ivan@11848
   218
		<groupFooter>
ivan@11848
   219
			<band height="25" splitType="Stretch">
ivan@11848
   220
				<line>
ivan@11848
   221
					<reportElement key="line-32" stretchType="RelativeToBandHeight" x="0" y="0" width="1" height="20" forecolor="#555555"/>
pandeeswari@22768
   222
					<graphicElement>
pandeeswari@22768
   223
						<pen lineWidth="2.0"/>
pandeeswari@22768
   224
					</graphicElement>
ivan@11848
   225
				</line>
ivan@11848
   226
				<line>
pandeeswari@22768
   227
					<reportElement key="line-33" stretchType="RelativeToBandHeight" x="534" y="0" width="1" height="20" forecolor="#555555"/>
pandeeswari@22768
   228
					<graphicElement>
pandeeswari@22768
   229
						<pen lineWidth="2.0"/>
pandeeswari@22768
   230
					</graphicElement>
ivan@11848
   231
				</line>
ivan@11848
   232
				<line>
pandeeswari@22768
   233
					<reportElement key="line-34" x="0" y="20" width="535" height="1" forecolor="#555555"/>
pandeeswari@22768
   234
					<graphicElement>
pandeeswari@22768
   235
						<pen lineWidth="2.0"/>
pandeeswari@22768
   236
					</graphicElement>
ivan@11848
   237
				</line>
ivan@11848
   238
				<staticText>
pandeeswari@22768
   239
					<reportElement key="staticText-4" style="default" x="10" y="1" width="90" height="16"/>
ivan@11848
   240
					<box>
ivan@11848
   241
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   242
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   243
						<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   244
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   245
					</box>
ivan@11848
   246
					<textElement textAlignment="Right">
ivan@11848
   247
						<font fontName="Bitstream Vera Sans"/>
ivan@11848
   248
					</textElement>
ivan@11848
   249
					<text><![CDATA[Total:]]></text>
ivan@11848
   250
				</staticText>
ivan@11848
   251
				<textField isBlankWhenNull="false">
pandeeswari@22768
   252
					<reportElement key="textField" style="Total_Field" x="100" y="1" width="240" height="16"/>
ivan@11848
   253
					<box leftPadding="5">
ivan@11848
   254
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   255
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   256
						<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   257
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   258
					</box>
ivan@11848
   259
					<textElement verticalAlignment="Middle"/>
ivan@11848
   260
					<textFieldExpression class="java.lang.Integer"><![CDATA[$V{TAXNAME_COUNT}]]></textFieldExpression>
ivan@11848
   261
				</textField>
ivan@11848
   262
				<line>
ivan@11848
   263
					<reportElement key="line-37" x="10" y="0" width="510" height="1" forecolor="#666666"/>
ivan@11848
   264
				</line>
ivan@11848
   265
				<textField isBlankWhenNull="false">
pandeeswari@22768
   266
					<reportElement key="textField" style="Total_Field" x="430" y="1" width="90" height="16"/>
ivan@11848
   267
					<box leftPadding="5">
ivan@11848
   268
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   269
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   270
						<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   271
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   272
					</box>
ivan@11848
   273
					<textElement textAlignment="Right"/>
ivan@11848
   274
					<textFieldExpression class="java.lang.String"><![CDATA[($V{sumImport}!=null)?$P{NUMBERFORMAT}.format($V{sumImport})+$F{CURRENCY}:new String(" ")]]></textFieldExpression>
ivan@11848
   275
				</textField>
ivan@11848
   276
				<textField isBlankWhenNull="false">
pandeeswari@22768
   277
					<reportElement key="textField" style="Total_Field" x="340" y="1" width="90" height="16"/>
ivan@11848
   278
					<box leftPadding="5">
ivan@11848
   279
						<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   280
						<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   281
						<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   282
						<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   283
					</box>
ivan@11848
   284
					<textElement textAlignment="Right" verticalAlignment="Middle"/>
ivan@11848
   285
					<textFieldExpression class="java.lang.String"><![CDATA[($V{sumTaxBaseAmt}!=null)?$P{NUMBERFORMAT}.format($V{sumTaxBaseAmt})+$F{CURRENCY}:new String(" ")]]></textFieldExpression>
ivan@11848
   286
				</textField>
ivan@11848
   287
			</band>
ivan@11848
   288
		</groupFooter>
ivan@11848
   289
	</group>
ivan@11848
   290
	<background>
ivan@11848
   291
		<band splitType="Stretch"/>
ivan@11848
   292
	</background>
ivan@11848
   293
	<title>
ivan@11848
   294
		<band splitType="Stretch"/>
ivan@11848
   295
	</title>
ivan@11848
   296
	<pageHeader>
ivan@11848
   297
		<band height="20" splitType="Stretch">
ivan@11848
   298
			<textField isStretchWithOverflow="true" isBlankWhenNull="false">
pandeeswari@22768
   299
				<reportElement key="textField" style="Report_Subtitle" x="1" y="0" width="535" height="20"/>
ivan@11848
   300
				<box leftPadding="5">
ivan@11848
   301
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   302
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   303
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   304
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   305
				</box>
ivan@11848
   306
				<textElement/>
ivan@11848
   307
				<textFieldExpression class="java.lang.String"><![CDATA[$P{SALE}]]></textFieldExpression>
ivan@11848
   308
			</textField>
ivan@11848
   309
		</band>
ivan@11848
   310
	</pageHeader>
ivan@11848
   311
	<columnHeader>
ivan@11848
   312
		<band splitType="Stretch"/>
ivan@11848
   313
	</columnHeader>
ivan@11848
   314
	<detail>
ivan@11848
   315
		<band height="14" splitType="Stretch">
ivan@11848
   316
			<printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
ivan@11848
   317
			<line>
pandeeswari@22768
   318
				<reportElement key="line-16" stretchType="RelativeToBandHeight" x="534" y="0" width="1" height="14" forecolor="#555555"/>
pandeeswari@22768
   319
				<graphicElement>
pandeeswari@22768
   320
					<pen lineWidth="2.0"/>
pandeeswari@22768
   321
				</graphicElement>
ivan@11848
   322
			</line>
ivan@11848
   323
			<line>
ivan@11848
   324
				<reportElement key="line-17" stretchType="RelativeToBandHeight" x="0" y="0" width="1" height="14" forecolor="#555555"/>
pandeeswari@22768
   325
				<graphicElement>
pandeeswari@22768
   326
					<pen lineWidth="2.0"/>
pandeeswari@22768
   327
				</graphicElement>
ivan@11848
   328
			</line>
ivan@11848
   329
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
ivan@11848
   330
				<reportElement key="textField" style="Detail_Line" x="10" y="0" width="90" height="14"/>
ivan@11848
   331
				<box leftPadding="2" rightPadding="2">
ivan@11848
   332
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   333
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   334
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   335
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   336
				</box>
ivan@11848
   337
				<textElement verticalAlignment="Middle"/>
ivan@11848
   338
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DOCUMENTNO}]]></textFieldExpression>
ivan@11848
   339
			</textField>
ivan@11848
   340
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
ivan@11848
   341
				<reportElement key="textField" style="Detail_Line" x="100" y="0" width="70" height="14"/>
ivan@11848
   342
				<box leftPadding="2" rightPadding="2">
ivan@11848
   343
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   344
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   345
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   346
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   347
				</box>
ivan@11848
   348
				<textElement verticalAlignment="Middle"/>
ivan@11848
   349
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{DATEINVOICED}]]></textFieldExpression>
ivan@11848
   350
			</textField>
ivan@11848
   351
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
pandeeswari@22768
   352
				<reportElement key="textField" style="Detail_Line" x="170" y="0" width="170" height="14"/>
ivan@11848
   353
				<box leftPadding="2" rightPadding="2">
ivan@11848
   354
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   355
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   356
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   357
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   358
				</box>
ivan@11848
   359
				<textElement verticalAlignment="Middle"/>
ivan@11848
   360
				<textFieldExpression class="java.lang.String"><![CDATA[$F{BPARTNER}]]></textFieldExpression>
ivan@11848
   361
			</textField>
ivan@11848
   362
			<textField pattern="" isBlankWhenNull="false">
pandeeswari@22768
   363
				<reportElement key="textField" style="Detail_Line" x="340" y="0" width="90" height="14"/>
ivan@11848
   364
				<box leftPadding="2" rightPadding="2">
ivan@11848
   365
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   366
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   367
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   368
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   369
				</box>
ivan@11848
   370
				<textElement textAlignment="Right" verticalAlignment="Middle">
ivan@11848
   371
					<font size="9"/>
ivan@11848
   372
				</textElement>
ivan@11848
   373
				<textFieldExpression class="java.lang.String"><![CDATA[($F{TAXBASEAMT}!=null)?$P{NUMBERFORMAT}.format($F{TAXBASEAMT})+$F{CURRENCY}:new String(" ")]]></textFieldExpression>
ivan@11848
   374
			</textField>
ivan@11848
   375
			<textField pattern="" isBlankWhenNull="false">
pandeeswari@22768
   376
				<reportElement key="textField" style="Detail_Line" x="430" y="0" width="90" height="14"/>
ivan@11848
   377
				<box leftPadding="2" rightPadding="2">
ivan@11848
   378
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   379
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   380
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   381
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
ivan@11848
   382
				</box>
ivan@11848
   383
				<textElement textAlignment="Right" verticalAlignment="Middle"/>
ivan@11848
   384
				<textFieldExpression class="java.lang.String"><![CDATA[($F{TAXAMT}!=null)?$P{NUMBERFORMAT}.format($F{TAXAMT})+$F{CURRENCY}:new String(" ")]]></textFieldExpression>
ivan@11848
   385
			</textField>
ivan@11848
   386
		</band>
ivan@11848
   387
	</detail>
ivan@11848
   388
	<columnFooter>
ivan@11848
   389
		<band splitType="Stretch"/>
ivan@11848
   390
	</columnFooter>
ivan@11848
   391
	<pageFooter>
ivan@11848
   392
		<band splitType="Stretch"/>
ivan@11848
   393
	</pageFooter>
ivan@11848
   394
	<summary>
ivan@11848
   395
		<band splitType="Stretch"/>
ivan@11848
   396
	</summary>
ivan@11848
   397
</jasperReport>