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