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