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