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