Fixes Issue 10516: The amount column in the invoice taxes report is too narrow
authorjeneive malarkodi <jeneive.malarkodi@openbravo.com>
Thu, 17 Sep 2009 11:33:34 +0530
changeset 4948 16fbb48b2f19
parent 4947 f0621d03cc05
child 4949 ab430a3eb9dd
Fixes Issue 10516: The amount column in the invoice taxes report is too narrow
src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoiceSale.jrxml
--- a/src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoiceSale.jrxml	Wed Sep 16 16:45:20 2009 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoiceSale.jrxml	Thu Sep 17 11:33:34 2009 +0530
@@ -2,162 +2,146 @@
 <!-- Created with iReport - A designer for JasperReports -->
 <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
 <jasperReport
-		 name="ReportTaxInvoiceSale"
-		 columnCount="1"
-		 printOrder="Vertical"
-		 orientation="Portrait"
-		 pageWidth="535"
-		 pageHeight="842"
-		 columnWidth="535"
-		 columnSpacing="0"
-		 leftMargin="0"
-		 rightMargin="0"
-		 topMargin="0"
-		 bottomMargin="0"
-		 whenNoDataType="NoPages"
-		 isTitleNewPage="false"
-		 isSummaryNewPage="false">
-	<property name="ireport.scriptlethandling" value="0" />
-	<property name="ireport.encoding" value="UTF-8" />
-	<import value="java.util.*" />
-	<import value="net.sf.jasperreports.engine.*" />
-	<import value="net.sf.jasperreports.engine.data.*" />
+         name="ReportTaxInvoiceSale"
+         columnCount="1"
+         printOrder="Vertical"
+         orientation="Portrait"
+         pageWidth="605"
+         pageHeight="842"
+         columnWidth="605"
+         columnSpacing="0"
+         leftMargin="0"
+         rightMargin="0"
+         topMargin="0"
+         bottomMargin="0"
+         whenNoDataType="NoPages"
+         isTitleNewPage="false"
+         isSummaryNewPage="false">
+    <property name="ireport.scriptlethandling" value="0" />
+    <property name="ireport.encoding" value="UTF-8" />
+    <import value="java.util.*" />
+    <import value="net.sf.jasperreports.engine.*" />
+    <import value="net.sf.jasperreports.engine.data.*" />
 
-	<style 
-		name="default"
-		isDefault="false"
-		vAlign="Middle"
-		fontName="Bitstream Vera Sans"
-		fontSize="10"
-	>
-	</style>
-	<style 
-		name="Report_Title"
-		isDefault="false"
-		fontName="Bitstream Vera Sans"
-		fontSize="18"
-	>
-					<box leftPadding="5"></box>
-	</style>
-	<style 
-		name="Report_Subtitle"
-		isDefault="false"
-		forecolor="#555555"
-		fontName="Bitstream Vera Sans"
-		fontSize="14"
-	>
-					<box leftPadding="5"></box>
-	</style>
-	<style 
-		name="Total_Field"
-		isDefault="false"
-		mode="Opaque"
-		forecolor="#000000"
-		backcolor="#CCCCCC"
-		vAlign="Middle"
-	>
-					<box leftPadding="5"></box>
-	</style>
-	<style 
-		name="Detail_Header"
-		isDefault="false"
-		mode="Opaque"
-		forecolor="#FFFFFF"
-		backcolor="#555555"
-		vAlign="Middle"
-	>
-					<box leftPadding="5">					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
-					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
-</box>
-	</style>
-	<style 
-		name="GroupHeader_DarkGray"
-		isDefault="false"
-		mode="Opaque"
-		forecolor="#FFFFFF"
-		backcolor="#555555"
-		vAlign="Middle"
-		fontName="Bitstream Vera Sans"
-		fontSize="14"
-	>
-					<box leftPadding="5"></box>
-	</style>
-	<style 
-		name="GroupHeader_Gray"
-		isDefault="false"
-		mode="Opaque"
-		backcolor="#999999"
-	>
-	</style>
-	<style 
-		name="Detail_Line"
-		isDefault="false"
-		fontName="Bitstream Vera Sans"
-		fontSize="9"
-	>
+    <style 
+        name="default"
+        isDefault="false"
+        vAlign="Middle"
+        fontName="Bitstream Vera Sans"
+        fontSize="10"
+    />
+    <style 
+        name="Report_Title"
+        isDefault="false"
+        fontName="Bitstream Vera Sans"
+        fontSize="18"
+    />
+    <style 
+        name="Report_Subtitle"
+        isDefault="false"
+        forecolor="#555555"
+        fontName="Bitstream Vera Sans"
+        fontSize="14"
+    />
+    <style 
+        name="Total_Field"
+        isDefault="false"
+        mode="Opaque"
+        forecolor="#000000"
+        backcolor="#CCCCCC"
+        vAlign="Middle"
+    />
+    <style 
+        name="Detail_Header"
+        isDefault="false"
+        mode="Opaque"
+        forecolor="#FFFFFF"
+        backcolor="#555555"
+        vAlign="Middle"
+    />
+    <style 
+        name="GroupHeader_DarkGray"
+        isDefault="false"
+        mode="Opaque"
+        forecolor="#FFFFFF"
+        backcolor="#555555"
+        vAlign="Middle"
+        fontName="Bitstream Vera Sans"
+        fontSize="14"
+    />
+    <style 
+        name="GroupHeader_Gray"
+        isDefault="false"
+        mode="Opaque"
+        backcolor="#999999"
+    />
+    <style 
+        name="Detail_Line"
+        isDefault="false"
+        fontName="Bitstream Vera Sans"
+        fontSize="9"
+    >
 
-		<conditionalStyle>
-			<conditionExpression><![CDATA[new Boolean($V{TAXNAME_COUNT}.intValue()%2==1)]]></conditionExpression>
-			<style 
-				name="Detail_Line"
-				isDefault="false"
-				mode="Opaque"
-				backcolor="#CCCCCC"
-				fontName="Bitstream Vera Sans"
-				fontSize="9"
-			>
-			</style>
-		</conditionalStyle>
-	</style>
-	<style 
-		name="Total_Gray"
-		isDefault="false"
-		mode="Opaque"
-		forecolor="#000000"
-		backcolor="#CCCCCC"
-	>
-	</style>
+        <conditionalStyle>
+            <conditionExpression><![CDATA[new Boolean($V{TAXNAME_COUNT}.intValue()%2==1)]]></conditionExpression>
+            <style 
+                name="Detail_Line"
+                isDefault="false"
+                mode="Opaque"
+                backcolor="#CCCCCC"
+                fontName="Bitstream Vera Sans"
+                fontSize="9"
+            />
+        </conditionalStyle>
+    </style>
+    <style 
+        name="Total_Gray"
+        isDefault="false"
+        mode="Opaque"
+        forecolor="#000000"
+        backcolor="#CCCCCC"
+    />
 
-	<parameter name="ATTACH" isForPrompting="false" class="java.lang.String"/>
-	<parameter name="BASE_WEB" isForPrompting="false" class="java.lang.String"/>
-	<parameter name="BASE_DESIGN" isForPrompting="false" class="java.lang.String"/>
-	<parameter name="LANGUAGE" isForPrompting="false" class="java.lang.String">
-		<defaultValueExpression ><![CDATA["en_US"]]></defaultValueExpression>
-	</parameter>
-	<parameter name="USER_CLIENT" isForPrompting="false" class="java.lang.String">
-		<defaultValueExpression ><![CDATA["'1000000'"]]></defaultValueExpression>
-	</parameter>
-	<parameter name="USER_ORG" isForPrompting="false" class="java.lang.String">
-		<defaultValueExpression ><![CDATA["'0','1000000'"]]></defaultValueExpression>
-	</parameter>
-	<parameter name="REPORT_TITLE" isForPrompting="false" class="java.lang.String">
-		<defaultValueExpression ><![CDATA["REPORT TITLE"]]></defaultValueExpression>
-	</parameter>
-	<parameter name="REPORT_SUBTITLE" isForPrompting="false" class="java.lang.String">
-		<defaultValueExpression ><![CDATA["Sale"]]></defaultValueExpression>
-	</parameter>
-	<parameter name="aux_client" isForPrompting="false" class="java.lang.String">
-		<defaultValueExpression ><![CDATA[$P{USER_CLIENT}.equals("") ? " " : " AND C_INVOICE.AD_CLIENT_ID IN ("+$P{USER_CLIENT}+") "]]></defaultValueExpression>
-	</parameter>
-	<parameter name="aux_org" isForPrompting="false" class="java.lang.String">
-		<defaultValueExpression ><![CDATA[$P{USER_ORG}.equals("") ? " " : " AND C_INVOICE.AD_ORG_ID IN ("+$P{USER_ORG}+") "]]></defaultValueExpression>
-	</parameter>
-	<parameter name="cCountryId" isForPrompting="true" class="java.lang.String">
-		<defaultValueExpression ><![CDATA["100"]]></defaultValueExpression>
-	</parameter>
-	<parameter name="parDateFrom" isForPrompting="true" class="java.util.Date"/>
-	<parameter name="parDateTo" isForPrompting="true" class="java.util.Date"/>
-	<parameter name="ReportData" isForPrompting="false" class="java.lang.String">
-		<defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
-	</parameter>
-	<parameter name="SALE" isForPrompting="false" class="java.lang.String"/>
-	<parameter name="DETAIL" isForPrompting="false" class="java.lang.String"/>
-	<parameter name="NUMBERFORMAT" isForPrompting="false" class="java.text.DecimalFormat"/>
-	<parameter name="LOCALE" isForPrompting="false" class="java.util.Locale"/>
-	<parameter name="PARAM_CURRENCY" isForPrompting="false" class="java.lang.String">
-		<defaultValueExpression ><![CDATA["102"]]></defaultValueExpression>
-	</parameter>
-	<queryString><![CDATA[SELECT C_INVOICE.ISSOTRX AS SALES, 'Y' AS NATIONAL, C_INVOICE.DOCUMENTNO AS DOCUMENTNO, C_INVOICE.DATEINVOICED, C_BPARTNER.NAME AS BPARTNER, LTRIM(RTRIM(C_TAX.NAME, ' '), ' ') AS TAXNAME, 
+    <parameter name="ATTACH" isForPrompting="false" class="java.lang.String"/>
+    <parameter name="BASE_WEB" isForPrompting="false" class="java.lang.String"/>
+    <parameter name="BASE_DESIGN" isForPrompting="false" class="java.lang.String"/>
+    <parameter name="LANGUAGE" isForPrompting="false" class="java.lang.String">
+        <defaultValueExpression ><![CDATA["en_US"]]></defaultValueExpression>
+    </parameter>
+    <parameter name="USER_CLIENT" isForPrompting="false" class="java.lang.String">
+        <defaultValueExpression ><![CDATA["'1000000'"]]></defaultValueExpression>
+    </parameter>
+    <parameter name="USER_ORG" isForPrompting="false" class="java.lang.String">
+        <defaultValueExpression ><![CDATA["'0','1000000'"]]></defaultValueExpression>
+    </parameter>
+    <parameter name="REPORT_TITLE" isForPrompting="false" class="java.lang.String">
+        <defaultValueExpression ><![CDATA["REPORT TITLE"]]></defaultValueExpression>
+    </parameter>
+    <parameter name="REPORT_SUBTITLE" isForPrompting="false" class="java.lang.String">
+        <defaultValueExpression ><![CDATA["Sale"]]></defaultValueExpression>
+    </parameter>
+    <parameter name="aux_client" isForPrompting="false" class="java.lang.String">
+        <defaultValueExpression ><![CDATA[$P{USER_CLIENT}.equals("") ? " " : " AND C_INVOICE.AD_CLIENT_ID IN ("+$P{USER_CLIENT}+") "]]></defaultValueExpression>
+    </parameter>
+    <parameter name="aux_org" isForPrompting="false" class="java.lang.String">
+        <defaultValueExpression ><![CDATA[$P{USER_ORG}.equals("") ? " " : " AND C_INVOICE.AD_ORG_ID IN ("+$P{USER_ORG}+") "]]></defaultValueExpression>
+    </parameter>
+    <parameter name="cCountryId" isForPrompting="true" class="java.lang.String">
+        <defaultValueExpression ><![CDATA["100"]]></defaultValueExpression>
+    </parameter>
+    <parameter name="parDateFrom" isForPrompting="true" class="java.util.Date"/>
+    <parameter name="parDateTo" isForPrompting="true" class="java.util.Date"/>
+    <parameter name="ReportData" isForPrompting="false" class="java.lang.String">
+        <defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
+    </parameter>
+    <parameter name="SALE" isForPrompting="false" class="java.lang.String"/>
+    <parameter name="DETAIL" isForPrompting="false" class="java.lang.String"/>
+    <parameter name="NUMBERFORMAT" isForPrompting="false" class="java.text.DecimalFormat"/>
+    <parameter name="LOCALE" isForPrompting="false" class="java.util.Locale"/>
+    <parameter name="PARAM_CURRENCY" isForPrompting="false" class="java.lang.String">
+        <defaultValueExpression ><![CDATA["102"]]></defaultValueExpression>
+    </parameter>
+    <queryString><![CDATA[SELECT C_INVOICE.ISSOTRX AS SALES, 'Y' AS NATIONAL, C_INVOICE.DOCUMENTNO AS DOCUMENTNO, C_INVOICE.DATEINVOICED, C_BPARTNER.NAME AS BPARTNER, LTRIM(RTRIM(C_TAX.NAME, ' '), ' ') AS TAXNAME, 
       SUM(CASE WHEN DOCBASETYPE IN ('ARC','APC') THEN -1 * (C_CURRENCY_CONVERT(C_INVOICETAX.TAXBASEAMT, C_INVOICE.C_CURRENCY_ID,$P{PARAM_CURRENCY}, TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICETAX.AD_CLIENT_ID, C_INVOICETAX.AD_ORG_ID))
        ELSE (C_CURRENCY_CONVERT(C_INVOICETAX.TAXBASEAMT, C_INVOICE.C_CURRENCY_ID,$P{PARAM_CURRENCY}, TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICETAX.AD_CLIENT_ID, C_INVOICETAX.AD_ORG_ID)) END) AS TAXBASEAMT, 
       SUM(CASE WHEN DOCBASETYPE IN ('ARC','APC') THEN -1 * (C_CURRENCY_CONVERT(C_INVOICETAX.TAXAMT, C_INVOICE.C_CURRENCY_ID, $P{PARAM_CURRENCY}, TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())), NULL, C_INVOICETAX.AD_CLIENT_ID, C_INVOICETAX.AD_ORG_ID))
@@ -175,503 +159,408 @@
       AND C_LOCATION.C_COUNTRY_ID = $P{cCountryId}
       AND C_INVOICE.DATEINVOICED >= $P{parDateFrom}
       AND C_INVOICE.DATEINVOICED < $P{parDateTo}
-	AND 1=1 $P!{aux_client} 
+    AND 1=1 $P!{aux_client} 
 AND 1=1 $P!{aux_org}
       AND 1=1 
       GROUP BY C_INVOICE.DOCUMENTNO, C_INVOICE.DATEINVOICED, C_TAX.NAME, C_BPARTNER.NAME, C_INVOICE.ISSOTRX
       HAVING SUM(C_INVOICETAX.TAXBASEAMT) <> 0
       ORDER BY C_TAX.NAME, C_INVOICE.DATEINVOICED]]></queryString>
 
-	<field name="SALES" class="java.lang.String"/>
-	<field name="NATIONAL" class="java.lang.String"/>
-	<field name="DOCUMENTNO" class="java.lang.String"/>
-	<field name="DATEINVOICED" class="java.sql.Timestamp"/>
-	<field name="BPARTNER" class="java.lang.String"/>
-	<field name="TAXNAME" class="java.lang.String"/>
-	<field name="TAXBASEAMT" class="java.math.BigDecimal"/>
-	<field name="TAXAMT" class="java.math.BigDecimal"/>
-	<field name="ADTREEID" class="java.lang.String"/>
-	<field name="CURRENCY" class="java.lang.String"/>
-	<field name="SUM_AMOUNT" class="java.lang.String"/>
-	<field name="Tax_BASE" class="java.lang.String"/>
+    <field name="SALES" class="java.lang.String"/>
+    <field name="NATIONAL" class="java.lang.String"/>
+    <field name="DOCUMENTNO" class="java.lang.String"/>
+    <field name="DATEINVOICED" class="java.sql.Timestamp"/>
+    <field name="BPARTNER" class="java.lang.String"/>
+    <field name="TAXNAME" class="java.lang.String"/>
+    <field name="TAXBASEAMT" class="java.math.BigDecimal"/>
+    <field name="TAXAMT" class="java.math.BigDecimal"/>
+    <field name="ADTREEID" class="java.lang.String"/>
+    <field name="CURRENCY" class="java.lang.String"/>
+    <field name="SUM_AMOUNT" class="java.lang.String"/>
+    <field name="Tax_BASE" class="java.lang.String"/>
 
-	<variable name="sumTaxBaseAmt" class="java.math.BigDecimal" resetType="Group" resetGroup="TAXNAME" calculation="Sum">
-		<variableExpression><![CDATA[$F{TAXBASEAMT}]]></variableExpression>
-	</variable>
-	<variable name="sumImport" class="java.math.BigDecimal" resetType="Group" resetGroup="TAXNAME" calculation="Sum">
-		<variableExpression><![CDATA[$F{TAXAMT}]]></variableExpression>
-	</variable>
-	<variable name="sumAmount" class="java.lang.String" resetType="Report" calculation="Nothing">
-		<variableExpression><![CDATA[$V{sumImport}.toString()]]></variableExpression>
-	</variable>
+    <variable name="sumTaxBaseAmt" class="java.math.BigDecimal" resetType="Group" resetGroup="TAXNAME" calculation="Sum">
+        <variableExpression><![CDATA[$F{TAXBASEAMT}]]></variableExpression>
+    </variable>
+    <variable name="sumImport" class="java.math.BigDecimal" resetType="Group" resetGroup="TAXNAME" calculation="Sum">
+        <variableExpression><![CDATA[$F{TAXAMT}]]></variableExpression>
+    </variable>
+    <variable name="sumAmount" class="java.lang.String" resetType="Report" calculation="Nothing">
+        <variableExpression><![CDATA[$V{sumImport}.toString()]]></variableExpression>
+    </variable>
 
-		<group  name="TAXNAME" >
-			<groupExpression><![CDATA[$F{TAXNAME}]]></groupExpression>
-			<groupHeader>
-			<band height="44"  isSplitAllowed="true" >
-				<staticText>
-					<reportElement
-						style="GroupHeader_DarkGray"
-						x="1"
-						y="0"
-						width="100"
-						height="20"
-						key="staticText"/>
-					<box leftPadding="5">					<pen lineWidth="0.0"/>
-					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-					<bottomPen lineWidth="0.0" lineColor="#000000"/>
-					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-</box>
-					<textElement>
-						<font pdfFontName="Helvetica"/>
-					</textElement>
-				<text><![CDATA[Tax Type]]></text>
-				</staticText>
-				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
-					<reportElement
-						style="GroupHeader_DarkGray"
-						x="101"
-						y="0"
-						width="433"
-						height="20"
-						key="textField"/>
-					<box leftPadding="5">					<pen lineWidth="0.0"/>
-					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-					<bottomPen lineWidth="0.0" lineColor="#000000"/>
-					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-</box>
-					<textElement>
-						<font pdfFontName="Helvetica"/>
-					</textElement>
-				<textFieldExpression   class="java.lang.String"><![CDATA[$F{TAXNAME}]]></textFieldExpression>
-				</textField>
-				<line direction="TopDown">
-					<reportElement
-						x="0"
-						y="1"
-						width="0"
-						height="43"
-						forecolor="#555555"
-						key="line-2"
-						stretchType="RelativeToBandHeight"/>
-					<graphicElement stretchType="RelativeToBandHeight">
-					<pen lineWidth="2.0" lineStyle="Solid"/>
-</graphicElement>
-				</line>
-				<line direction="TopDown">
-					<reportElement
-						x="534"
-						y="1"
-						width="0"
-						height="43"
-						forecolor="#555555"
-						key="line-3"
-						stretchType="RelativeToBandHeight"/>
-					<graphicElement stretchType="RelativeToBandHeight">
-					<pen lineWidth="2.0" lineStyle="Solid"/>
-</graphicElement>
-				</line>
-				<staticText>
-					<reportElement
-						style="Detail_Header"
-						x="10"
-						y="28"
-						width="90"
-						height="16"
-						key="element-90">
-							<printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
-						</reportElement>
-					<box leftPadding="5">					<pen lineWidth="0.0"/>
-					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
-					<bottomPen lineWidth="0.0" lineColor="#000000"/>
-					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
-</box>
-					<textElement>
-						<font/>
-					</textElement>
-				<text><![CDATA[Invoice]]></text>
-				</staticText>
-				<staticText>
-					<reportElement
-						style="Detail_Header"
-						x="100"
-						y="28"
-						width="70"
-						height="16"
-						key="element-90">
-							<printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
-						</reportElement>
-					<box leftPadding="5">					<pen lineWidth="0.0"/>
-					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
-					<bottomPen lineWidth="0.0" lineColor="#000000"/>
-					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
-</box>
-					<textElement>
-						<font/>
-					</textElement>
-				<text><![CDATA[Date]]></text>
-				</staticText>
-				<staticText>
-					<reportElement
-						style="Detail_Header"
-						x="170"
-						y="28"
-						width="170"
-						height="16"
-						key="element-90">
-							<printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
-						</reportElement>
-					<box leftPadding="5">					<pen lineWidth="0.0"/>
-					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
-					<bottomPen lineWidth="0.0" lineColor="#000000"/>
-					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
-</box>
-					<textElement>
-						<font/>
-					</textElement>
-				<text><![CDATA[Business Partner]]></text>
-				</staticText>
-				<staticText>
-					<reportElement
-						style="Detail_Header"
-						x="340"
-						y="28"
-						width="90"
-						height="16"
-						key="element-90"/>
-					<box leftPadding="5">					<pen lineWidth="0.0"/>
-					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
-					<bottomPen lineWidth="0.0" lineColor="#000000"/>
-					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
-</box>
-					<textElement textAlignment="Right">
-						<font/>
-					</textElement>
-				<text><![CDATA[Taxable Base]]></text>
-				</staticText>
-				<staticText>
-					<reportElement
-						style="Detail_Header"
-						x="430"
-						y="28"
-						width="90"
-						height="16"
-						key="element-90"/>
-					<box leftPadding="5">					<pen lineWidth="0.0"/>
-					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-					<leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
-					<bottomPen lineWidth="0.0" lineColor="#000000"/>
-					<rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/>
-</box>
-					<textElement textAlignment="Right">
-						<font/>
-					</textElement>
-				<text><![CDATA[Amount]]></text>
-				</staticText>
-			</band>
-			</groupHeader>
-			<groupFooter>
-			<band height="25"  isSplitAllowed="true" >
-				<line direction="TopDown">
-					<reportElement
-						x="0"
-						y="0"
-						width="0"
-						height="20"
-						forecolor="#555555"
-						key="line-32"
-						stretchType="RelativeToBandHeight"/>
-					<graphicElement stretchType="RelativeToBandHeight">
-					<pen lineWidth="2.0" lineStyle="Solid"/>
-</graphicElement>
-				</line>
-				<line direction="TopDown">
-					<reportElement
-						x="534"
-						y="0"
-						width="0"
-						height="20"
-						forecolor="#555555"
-						key="line-33"
-						stretchType="RelativeToBandHeight"/>
-					<graphicElement stretchType="RelativeToBandHeight">
-					<pen lineWidth="2.0" lineStyle="Solid"/>
-</graphicElement>
-				</line>
-				<line direction="TopDown">
-					<reportElement
-						x="0"
-						y="20"
-						width="535"
-						height="0"
-						forecolor="#555555"
-						key="line-34"/>
-					<graphicElement stretchType="NoStretch">
-					<pen lineWidth="2.0" lineStyle="Solid"/>
-</graphicElement>
-				</line>
-				<staticText>
-					<reportElement
-						style="default"
-						x="10"
-						y="1"
-						width="90"
-						height="16"
-						key="staticText-4"/>
-					<box>					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-					<bottomPen lineWidth="0.0" lineColor="#000000"/>
-					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-</box>
-					<textElement textAlignment="Right">
-						<font fontName="Bitstream Vera Sans"/>
-					</textElement>
-				<text><![CDATA[Total:]]></text>
-				</staticText>
-				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
-					<reportElement
-						style="Total_Field"
-						x="100"
-						y="1"
-						width="240"
-						height="16"
-						key="textField"/>
-					<box leftPadding="5">					<pen lineWidth="0.0"/>
-					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-					<bottomPen lineWidth="0.0" lineColor="#000000"/>
-					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-</box>
-					<textElement verticalAlignment="Middle">
-						<font/>
-					</textElement>
-				<textFieldExpression   class="java.lang.Integer"><![CDATA[$V{TAXNAME_COUNT}]]></textFieldExpression>
-				</textField>
-				<line direction="TopDown">
-					<reportElement
-						x="10"
-						y="0"
-						width="510"
-						height="0"
-						forecolor="#666666"
-						key="line-37"/>
-					<graphicElement stretchType="NoStretch">
-					<pen lineWidth="0.25" lineStyle="Solid"/>
-</graphicElement>
-				</line>
-				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
-					<reportElement
-						style="Total_Field"
-						x="430"
-						y="1"
-						width="90"
-						height="16"
-						key="textField"/>
-					<box leftPadding="5">					<pen lineWidth="0.0"/>
-					<topPen lineWidth="0.0"/>
-					<leftPen lineWidth="0.0"/>
-					<bottomPen lineWidth="0.0"/>
-					<rightPen lineWidth="0.0"/>
-</box>
-					<textElement textAlignment="Right">
-						<font/>
-					</textElement>
-				<textFieldExpression   class="java.lang.String"><![CDATA[$V{sumImport}.toString()+$F{CURRENCY}]]></textFieldExpression>
-				</textField>
-				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
-					<reportElement
-						style="Total_Field"
-						x="340"
-						y="1"
-						width="90"
-						height="16"
-						key="textField"/>
-					<box leftPadding="5">					<pen lineWidth="0.0"/>
-					<topPen lineWidth="0.0"/>
-					<leftPen lineWidth="0.0"/>
-					<bottomPen lineWidth="0.0"/>
-					<rightPen lineWidth="0.0"/>
-</box>
-					<textElement textAlignment="Right" verticalAlignment="Middle">
-						<font/>
-					</textElement>
-				<textFieldExpression   class="java.lang.String"><![CDATA[$V{sumTaxBaseAmt}.toString()+$F{CURRENCY}]]></textFieldExpression>
-				</textField>
-			</band>
-			</groupFooter>
-		</group>
-		<background>
-			<band height="0"  isSplitAllowed="true" >
-			</band>
-		</background>
-		<title>
-			<band height="0"  isSplitAllowed="true" >
-			</band>
-		</title>
-		<pageHeader>
-			<band height="20"  isSplitAllowed="true" >
-				<textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
-					<reportElement
-						style="Report_Subtitle"
-						x="0"
-						y="0"
-						width="535"
-						height="20"
-						key="textField"/>
-					<box leftPadding="5">					<pen lineWidth="0.0"/>
-					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-					<bottomPen lineWidth="0.0" lineColor="#000000"/>
-					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-</box>
-					<textElement>
-						<font/>
-					</textElement>
-				<textFieldExpression   class="java.lang.String"><![CDATA[$P{SALE}]]></textFieldExpression>
-				</textField>
-			</band>
-		</pageHeader>
-		<columnHeader>
-			<band height="0"  isSplitAllowed="true" >
-			</band>
-		</columnHeader>
-		<detail>
-			<band height="14"  isSplitAllowed="true" >
-				<printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
-				<line direction="TopDown">
-					<reportElement
-						x="534"
-						y="0"
-						width="0"
-						height="14"
-						forecolor="#555555"
-						key="line-16"
-						stretchType="RelativeToBandHeight"/>
-					<graphicElement stretchType="RelativeToBandHeight">
-					<pen lineWidth="2.0" lineStyle="Solid"/>
-</graphicElement>
-				</line>
-				<line direction="TopDown">
-					<reportElement
-						x="0"
-						y="0"
-						width="0"
-						height="14"
-						forecolor="#555555"
-						key="line-17"
-						stretchType="RelativeToBandHeight"/>
-					<graphicElement stretchType="RelativeToBandHeight">
-					<pen lineWidth="2.0" lineStyle="Solid"/>
-</graphicElement>
-				</line>
-				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
-					<reportElement
-						style="Detail_Line"
-						x="10"
-						y="0"
-						width="90"
-						height="14"
-						key="textField"/>
-					<box leftPadding="2" rightPadding="2">					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-					<leftPen lineWidth="0.25" lineStyle="Solid" lineColor="#666666"/>
-					<bottomPen lineWidth="0.0" lineColor="#000000"/>
-					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-</box>
-					<textElement verticalAlignment="Middle">
-						<font/>
-					</textElement>
-				<textFieldExpression   class="java.lang.String"><![CDATA[$F{DOCUMENTNO}]]></textFieldExpression>
-				</textField>
-				<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
-					<reportElement
-						style="Detail_Line"
-						x="100"
-						y="0"
-						width="70"
-						height="14"
-						key="textField"/>
-					<box leftPadding="2" rightPadding="2">					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-					<leftPen lineWidth="0.25" lineStyle="Solid" lineColor="#666666"/>
-					<bottomPen lineWidth="0.0" lineColor="#000000"/>
-					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-</box>
-					<textElement verticalAlignment="Middle">
-						<font/>
-					</textElement>
-				<textFieldExpression   class="java.sql.Timestamp"><![CDATA[$F{DATEINVOICED}]]></textFieldExpression>
-				</textField>
-				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
-					<reportElement
-						style="Detail_Line"
-						x="170"
-						y="0"
-						width="170"
-						height="14"
-						key="textField"/>
-					<box leftPadding="2" rightPadding="2">					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-					<leftPen lineWidth="0.25" lineStyle="Solid" lineColor="#666666"/>
-					<bottomPen lineWidth="0.0" lineColor="#000000"/>
-					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-</box>
-					<textElement verticalAlignment="Middle">
-						<font/>
-					</textElement>
-				<textFieldExpression   class="java.lang.String"><![CDATA[$F{BPARTNER}]]></textFieldExpression>
-				</textField>
-				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
-					<reportElement
-						style="Detail_Line"
-						x="340"
-						y="0"
-						width="90"
-						height="14"
-						key="textField"/>
-					<box leftPadding="2" rightPadding="2">					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-					<leftPen lineWidth="0.25" lineStyle="Solid" lineColor="#666666"/>
-					<bottomPen lineWidth="0.0" lineColor="#000000"/>
-					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-</box>
-					<textElement textAlignment="Right" verticalAlignment="Middle">
-						<font/>
-					</textElement>
-				<textFieldExpression   class="java.lang.String"><![CDATA[($F{TAXBASEAMT}!=null)?$P{NUMBERFORMAT}.format($F{TAXBASEAMT})+$F{CURRENCY}:new String(" ")]]></textFieldExpression>
-				</textField>
-				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
-					<reportElement
-						style="Detail_Line"
-						x="430"
-						y="0"
-						width="90"
-						height="14"
-						key="textField"/>
-					<box leftPadding="2" rightPadding="2">					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
-					<leftPen lineWidth="0.25" lineStyle="Solid" lineColor="#666666"/>
-					<bottomPen lineWidth="0.0" lineColor="#000000"/>
-					<rightPen lineWidth="0.25" lineStyle="Solid" lineColor="#666666"/>
-</box>
-					<textElement textAlignment="Right" verticalAlignment="Middle">
-						<font/>
-					</textElement>
-				<textFieldExpression   class="java.lang.String"><![CDATA[($F{TAXAMT}!=null)?$P{NUMBERFORMAT}.format($F{TAXAMT})+$F{CURRENCY}:new String(" ")]]></textFieldExpression>
-				</textField>
-			</band>
-		</detail>
-		<columnFooter>
-			<band height="0"  isSplitAllowed="true" >
-			</band>
-		</columnFooter>
-		<pageFooter>
-			<band height="0"  isSplitAllowed="true" >
-			</band>
-		</pageFooter>
-		<summary>
-			<band height="0"  isSplitAllowed="true" >
-			</band>
-		</summary>
-</jasperReport>
+        <group  name="TAXNAME" >
+            <groupExpression><![CDATA[$F{TAXNAME}]]></groupExpression>
+            <groupHeader>
+            <band height="44"  isSplitAllowed="true" >
+                <staticText>
+                    <reportElement
+                        style="GroupHeader_DarkGray"
+                        x="1"
+                        y="0"
+                        width="100"
+                        height="20"
+                        key="staticText"/>
+                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
+                    <textElement>
+                        <font pdfFontName="Helvetica"/>
+                    </textElement>
+                <text><![CDATA[Tax Type]]></text>
+                </staticText>
+                <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
+                    <reportElement
+                        style="GroupHeader_DarkGray"
+                        x="101"
+                        y="0"
+                        width="503"
+                        height="20"
+                        key="textField"/>
+                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
+                    <textElement>
+                        <font pdfFontName="Helvetica"/>
+                    </textElement>
+                <textFieldExpression   class="java.lang.String"><![CDATA[$F{TAXNAME}]]></textFieldExpression>
+                </textField>
+                <line direction="TopDown">
+                    <reportElement
+                        x="0"
+                        y="1"
+                        width="0"
+                        height="43"
+                        forecolor="#555555"
+                        key="line-2"
+                        stretchType="RelativeToBandHeight"/>
+                    <graphicElement stretchType="RelativeToBandHeight"/>
+                </line>
+                <line direction="TopDown">
+                    <reportElement
+                        x="604"
+                        y="0"
+                        width="0"
+                        height="43"
+                        forecolor="#555555"
+                        key="line-3"
+                        stretchType="RelativeToBandHeight"/>
+                    <graphicElement stretchType="RelativeToBandHeight"/>
+                </line>
+                <staticText>
+                    <reportElement
+                        style="Detail_Header"
+                        x="10"
+                        y="28"
+                        width="90"
+                        height="16"
+                        key="element-90">
+                            <printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
+                        </reportElement>
+                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
+                    <textElement>
+                        <font/>
+                    </textElement>
+                <text><![CDATA[Invoice]]></text>
+                </staticText>
+                <staticText>
+                    <reportElement
+                        style="Detail_Header"
+                        x="100"
+                        y="28"
+                        width="70"
+                        height="16"
+                        key="element-90">
+                            <printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
+                        </reportElement>
+                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
+                    <textElement>
+                        <font/>
+                    </textElement>
+                <text><![CDATA[Date]]></text>
+                </staticText>
+                <staticText>
+                    <reportElement
+                        style="Detail_Header"
+                        x="170"
+                        y="28"
+                        width="165"
+                        height="16"
+                        key="element-90">
+                            <printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
+                        </reportElement>
+                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
+                    <textElement>
+                        <font/>
+                    </textElement>
+                <text><![CDATA[Business Partner]]></text>
+                </staticText>
+                <staticText>
+                    <reportElement
+                        style="Detail_Header"
+                        x="335"
+                        y="28"
+                        width="117"
+                        height="16"
+                        key="element-90"/>
+                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
+                    <textElement textAlignment="Right">
+                        <font/>
+                    </textElement>
+                <text><![CDATA[Taxable Base]]></text>
+                </staticText>
+                <staticText>
+                    <reportElement
+                        style="Detail_Header"
+                        x="452"
+                        y="28"
+                        width="114"
+                        height="16"
+                        key="element-90"/>
+                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
+                    <textElement textAlignment="Right">
+                        <font/>
+                    </textElement>
+                <text><![CDATA[Amount]]></text>
+                </staticText>
+            </band>
+            </groupHeader>
+            <groupFooter>
+            <band height="25"  isSplitAllowed="true" >
+                <line direction="TopDown">
+                    <reportElement
+                        x="0"
+                        y="0"
+                        width="0"
+                        height="20"
+                        forecolor="#555555"
+                        key="line-32"
+                        stretchType="RelativeToBandHeight"/>
+                    <graphicElement stretchType="RelativeToBandHeight"/>
+                </line>
+                <line direction="TopDown">
+                    <reportElement
+                        x="604"
+                        y="0"
+                        width="0"
+                        height="20"
+                        forecolor="#555555"
+                        key="line-33"
+                        stretchType="RelativeToBandHeight"/>
+                    <graphicElement stretchType="RelativeToBandHeight"/>
+                </line>
+                <line direction="TopDown">
+                    <reportElement
+                        x="0"
+                        y="20"
+                        width="603"
+                        height="0"
+                        forecolor="#555555"
+                        key="line-34"/>
+                    <graphicElement stretchType="NoStretch"/>
+                </line>
+                <staticText>
+                    <reportElement
+                        style="default"
+                        x="199"
+                        y="0"
+                        width="90"
+                        height="16"
+                        key="staticText-4"/>
+                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
+                    <textElement textAlignment="Right">
+                        <font fontName="Bitstream Vera Sans"/>
+                    </textElement>
+                <text><![CDATA[Total:]]></text>
+                </staticText>
+                <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
+                    <reportElement
+                        style="Total_Field"
+                        x="294"
+                        y="0"
+                        width="33"
+                        height="16"
+                        key="textField"/>
+                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
+                    <textElement verticalAlignment="Middle">
+                        <font/>
+                    </textElement>
+                <textFieldExpression   class="java.lang.Integer"><![CDATA[$V{TAXNAME_COUNT}]]></textFieldExpression>
+                </textField>
+                <line direction="TopDown">
+                    <reportElement
+                        x="10"
+                        y="0"
+                        width="510"
+                        height="0"
+                        forecolor="#666666"
+                        key="line-37"/>
+                    <graphicElement stretchType="NoStretch"/>
+                </line>
+                <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
+                    <reportElement
+                        style="Total_Field"
+                        x="452"
+                        y="0"
+                        width="114"
+                        height="17"
+                        key="textField"/>
+                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
+                    <textElement textAlignment="Right">
+                        <font/>
+                    </textElement>
+                <textFieldExpression   class="java.lang.String"><![CDATA[($V{sumImport}!=null)?$P{NUMBERFORMAT}.format($V{sumImport})+$F{CURRENCY}:new String(" ")]]></textFieldExpression>
+                </textField>
+                <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
+                    <reportElement
+                        style="Total_Field"
+                        x="335"
+                        y="0"
+                        width="117"
+                        height="16"
+                        key="textField"/>
+                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
+                    <textElement textAlignment="Right" verticalAlignment="Middle">
+                        <font/>
+                    </textElement>
+                <textFieldExpression   class="java.lang.String"><![CDATA[($V{sumTaxBaseAmt}!=null)?$P{NUMBERFORMAT}.format($V{sumTaxBaseAmt})+$F{CURRENCY}:new String(" ")]]></textFieldExpression>
+                </textField>
+            </band>
+            </groupFooter>
+        </group>
+        <background>
+            <band height="0"  isSplitAllowed="true" >
+            </band>
+        </background>
+        <title>
+            <band height="0"  isSplitAllowed="true" >
+            </band>
+        </title>
+        <pageHeader>
+            <band height="20"  isSplitAllowed="true" >
+                <textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
+                    <reportElement
+                        style="Report_Subtitle"
+                        x="1"
+                        y="0"
+                        width="602"
+                        height="20"
+                        key="textField"/>
+                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
+                    <textElement>
+                        <font/>
+                    </textElement>
+                <textFieldExpression   class="java.lang.String"><![CDATA[$P{SALE}]]></textFieldExpression>
+                </textField>
+            </band>
+        </pageHeader>
+        <columnHeader>
+            <band height="0"  isSplitAllowed="true" >
+            </band>
+        </columnHeader>
+        <detail>
+            <band height="14"  isSplitAllowed="true" >
+                <printWhenExpression><![CDATA[new Boolean($P{DETAIL}.equals("Y"))]]></printWhenExpression>
+                <line direction="TopDown">
+                    <reportElement
+                        x="603"
+                        y="-6"
+                        width="0"
+                        height="14"
+                        forecolor="#555555"
+                        key="line-16"
+                        stretchType="RelativeToBandHeight"/>
+                    <graphicElement stretchType="RelativeToBandHeight"/>
+                </line>
+                <line direction="TopDown">
+                    <reportElement
+                        x="0"
+                        y="0"
+                        width="0"
+                        height="14"
+                        forecolor="#555555"
+                        key="line-17"
+                        stretchType="RelativeToBandHeight"/>
+                    <graphicElement stretchType="RelativeToBandHeight"/>
+                </line>
+                <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
+                    <reportElement
+                        style="Detail_Line"
+                        x="10"
+                        y="0"
+                        width="90"
+                        height="14"
+                        key="textField"/>
+                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
+                    <textElement verticalAlignment="Middle">
+                        <font/>
+                    </textElement>
+                <textFieldExpression   class="java.lang.String"><![CDATA[$F{DOCUMENTNO}]]></textFieldExpression>
+                </textField>
+                <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
+                    <reportElement
+                        style="Detail_Line"
+                        x="100"
+                        y="0"
+                        width="70"
+                        height="14"
+                        key="textField"/>
+                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
+                    <textElement verticalAlignment="Middle">
+                        <font/>
+                    </textElement>
+                <textFieldExpression   class="java.sql.Timestamp"><![CDATA[$F{DATEINVOICED}]]></textFieldExpression>
+                </textField>
+                <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
+                    <reportElement
+                        style="Detail_Line"
+                        x="170"
+                        y="0"
+                        width="165"
+                        height="14"
+                        key="textField"/>
+                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
+                    <textElement verticalAlignment="Middle">
+                        <font/>
+                    </textElement>
+                <textFieldExpression   class="java.lang.String"><![CDATA[$F{BPARTNER}]]></textFieldExpression>
+                </textField>
+                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
+                    <reportElement
+                        style="Detail_Line"
+                        x="335"
+                        y="0"
+                        width="117"
+                        height="14"
+                        key="textField"/>
+                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
+                    <textElement textAlignment="Right" verticalAlignment="Middle">
+                        <font size="9"/>
+                    </textElement>
+                <textFieldExpression   class="java.lang.String"><![CDATA[($F{TAXBASEAMT}!=null)?$P{NUMBERFORMAT}.format($F{TAXBASEAMT})+$F{CURRENCY}:new String(" ")]]></textFieldExpression>
+                </textField>
+                <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
+                    <reportElement
+                        style="Detail_Line"
+                        x="452"
+                        y="0"
+                        width="114"
+                        height="14"
+                        key="textField"/>
+                    <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="2" rightBorder="None" rightBorderColor="#000000" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
+                    <textElement textAlignment="Right" verticalAlignment="Middle">
+                        <font/>
+                    </textElement>
+                <textFieldExpression   class="java.lang.String"><![CDATA[($F{TAXAMT}!=null)?$P{NUMBERFORMAT}.format($F{TAXAMT})+$F{CURRENCY}:new String(" ")]]></textFieldExpression>
+                </textField>
+            </band>
+        </detail>
+        <columnFooter>
+            <band height="0"  isSplitAllowed="true" >
+            </band>
+        </columnFooter>
+        <pageFooter>
+            <band height="0"  isSplitAllowed="true" >
+            </band>
+        </pageFooter>
+        <summary>
+            <band height="0"  isSplitAllowed="true" >
+            </band>
+        </summary>
+</jasperReport>
\ No newline at end of file