src/org/openbravo/erpCommon/ad_reports/SimpleDimensionalComparative.jrxml
changeset 0 0247c26f10c6
child 1688 a92f1c657ca2
equal deleted inserted replaced
-1:000000000000 0:0247c26f10c6
       
     1 <?xml version="1.0" encoding="UTF-8"  ?>
       
     2 <!-- Created with iReport - A designer for JasperReports -->
       
     3 <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
       
     4 <jasperReport
       
     5 		 name="SimpleDimensionalComparative"
       
     6 		 columnCount="1"
       
     7 		 printOrder="Vertical"
       
     8 		 orientation="Landscape"
       
     9 		 pageWidth="842"
       
    10 		 pageHeight="595"
       
    11 		 columnWidth="730"
       
    12 		 columnSpacing="0"
       
    13 		 leftMargin="56"
       
    14 		 rightMargin="56"
       
    15 		 topMargin="56"
       
    16 		 bottomMargin="56"
       
    17 		 whenNoDataType="NoPages"
       
    18 		 isTitleNewPage="false"
       
    19 		 isSummaryNewPage="false">
       
    20 	<property name="ireport.scriptlethandling" value="0" />
       
    21 	<property name="ireport.encoding" value="UTF-8" />
       
    22 	<import value="java.util.*" />
       
    23 	<import value="net.sf.jasperreports.engine.*" />
       
    24 	<import value="net.sf.jasperreports.engine.data.*" />
       
    25 
       
    26 	<style 
       
    27 		name="default"
       
    28 		isDefault="true"
       
    29 		vAlign="Middle"
       
    30 		fontName="Bitstream Vera Sans"
       
    31 		fontSize="11"
       
    32 	/>
       
    33 	<style 
       
    34 		name="Report_Title"
       
    35 		isDefault="false"
       
    36 		leftPadding="5"
       
    37 		fontName="Bitstream Vera Sans"
       
    38 		fontSize="18"
       
    39 	/>
       
    40 	<style 
       
    41 		name="Report_Subtitle"
       
    42 		isDefault="false"
       
    43 		forecolor="#555555"
       
    44 		leftPadding="5"
       
    45 		fontName="Bitstream Vera Sans"
       
    46 		fontSize="14"
       
    47 	/>
       
    48 	<style 
       
    49 		name="Report_Data_Label"
       
    50 		isDefault="false"
       
    51 		vAlign="Middle"
       
    52 		fontName="Bitstream Vera Sans"
       
    53 		fontSize="11"
       
    54 		isBold="true"
       
    55 	/>
       
    56 	<style 
       
    57 		name="Report_Data_Field"
       
    58 		isDefault="false"
       
    59 		fontName="Bitstream Vera Sans"
       
    60 		fontSize="11"
       
    61 		isBold="false"
       
    62 	/>
       
    63 	<style 
       
    64 		name="Total_Field"
       
    65 		isDefault="false"
       
    66 		mode="Opaque"
       
    67 		forecolor="#000000"
       
    68 		backcolor="#CCCCCC"
       
    69 		vAlign="Middle"
       
    70 		leftPadding="5"
       
    71 		fontName="Bitstream Vera Sans"
       
    72 		fontSize="10"
       
    73 		isBold="true"
       
    74 	/>
       
    75 	<style 
       
    76 		name="Detail_Header"
       
    77 		isDefault="false"
       
    78 		mode="Opaque"
       
    79 		forecolor="#FFFFFF"
       
    80 		backcolor="#5D5D5D"
       
    81 		vAlign="Middle"
       
    82 		leftBorder="1Point"
       
    83 		leftBorderColor="#FFFFFF"
       
    84 		leftPadding="5"
       
    85 		rightBorder="1Point"
       
    86 		rightBorderColor="#FFFFFF"
       
    87 		fontName="Bitstream Vera Sans"
       
    88 		fontSize="10"
       
    89 		isBold="true"
       
    90 	/>
       
    91 	<style 
       
    92 		name="Detail_Line"
       
    93 		isDefault="false"
       
    94 		fontName="Bitstream Vera Sans"
       
    95 		fontSize="8"
       
    96 		isBold="true"
       
    97 	>
       
    98 
       
    99 		<conditionalStyle>
       
   100 			<conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==1)]]></conditionExpression>
       
   101 			<style 
       
   102 				name="Detail_Line"
       
   103 				isDefault="false"
       
   104 				mode="Opaque"
       
   105 				backcolor="#CCCCCC"
       
   106 			/>
       
   107 		</conditionalStyle>
       
   108 	</style>
       
   109 	<style 
       
   110 		name="Level1_Line"
       
   111 		isDefault="false"
       
   112 		mode="Opaque"
       
   113 		backcolor="#E5E5E5"
       
   114 		vAlign="Middle"
       
   115 		fontName="Bitstream Vera Sans"
       
   116 		fontSize="8"
       
   117 		isBold="true"
       
   118 	>
       
   119 
       
   120 		<conditionalStyle>
       
   121 			<conditionExpression><![CDATA[new Boolean(($P{DIMENSIONS}.intValue()==1)&&($V{NIVEL1_COUNT}.intValue()%2==1))]]></conditionExpression>
       
   122 			<style 
       
   123 				name="Level1_Line"
       
   124 				isDefault="false"
       
   125 				mode="Opaque"
       
   126 				backcolor="#FFFFFF"
       
   127 				vAlign="Middle"
       
   128 				fontName="Bitstream Vera Sans"
       
   129 				fontSize="8"
       
   130 				isBold="false"
       
   131 			/>
       
   132 		</conditionalStyle>
       
   133 			<conditionalStyle>
       
   134 				<conditionExpression><![CDATA[new Boolean(($P{DIMENSIONS}.intValue()==1)&&($V{NIVEL1_COUNT}.intValue()%2==0))]]></conditionExpression>
       
   135 				<style 
       
   136 					name="Level1_Line"
       
   137 					isDefault="false"
       
   138 					mode="Opaque"
       
   139 					backcolor="#E5E5E5"
       
   140 					vAlign="Middle"
       
   141 					fontName="Bitstream Vera Sans"
       
   142 					fontSize="8"
       
   143 					isBold="false"
       
   144 				/>
       
   145 			</conditionalStyle>
       
   146 	</style>
       
   147 	<style 
       
   148 		name="Level2_Line"
       
   149 		isDefault="false"
       
   150 		mode="Opaque"
       
   151 		backcolor="#CCCCCC"
       
   152 		vAlign="Middle"
       
   153 		fontName="Bitstream Vera Sans"
       
   154 		fontSize="8"
       
   155 		isBold="true"
       
   156 	>
       
   157 
       
   158 		<conditionalStyle>
       
   159 			<conditionExpression><![CDATA[new Boolean(($P{DIMENSIONS}.intValue()==2)&&($V{NIVEL1_COUNT}.intValue()%2==0))]]></conditionExpression>
       
   160 			<style 
       
   161 				name="Level2_Line"
       
   162 				isDefault="false"
       
   163 				mode="Opaque"
       
   164 				backcolor="#FFFFFF"
       
   165 				vAlign="Middle"
       
   166 				fontName="Bitstream Vera Sans"
       
   167 				fontSize="8"
       
   168 				isBold="false"
       
   169 			/>
       
   170 		</conditionalStyle>
       
   171 			<conditionalStyle>
       
   172 				<conditionExpression><![CDATA[new Boolean(($P{DIMENSIONS}.intValue()==2)&&($V{NIVEL1_COUNT}.intValue()%2==1))]]></conditionExpression>
       
   173 				<style 
       
   174 					name="Level2_Line"
       
   175 					isDefault="false"
       
   176 					mode="Opaque"
       
   177 					backcolor="#E5E5E5"
       
   178 					vAlign="Middle"
       
   179 					fontName="Bitstream Vera Sans"
       
   180 					fontSize="8"
       
   181 					isBold="false"
       
   182 				/>
       
   183 			</conditionalStyle>
       
   184 	</style>
       
   185 	<style 
       
   186 		name="Level3_Line"
       
   187 		isDefault="false"
       
   188 		mode="Opaque"
       
   189 		backcolor="#E5E5E5"
       
   190 		vAlign="Middle"
       
   191 		fontName="Bitstream Vera Sans"
       
   192 		fontSize="8"
       
   193 		isBold="true"
       
   194 	>
       
   195 
       
   196 		<conditionalStyle>
       
   197 			<conditionExpression><![CDATA[new Boolean(($P{DIMENSIONS}.intValue()==3)&&($V{NIVEL2_COUNT}.intValue()%2==0))]]></conditionExpression>
       
   198 			<style 
       
   199 				name="Level3_Line"
       
   200 				isDefault="false"
       
   201 				mode="Opaque"
       
   202 				backcolor="#FFFFFF"
       
   203 				vAlign="Middle"
       
   204 				fontName="Bitstream Vera Sans"
       
   205 				fontSize="8"
       
   206 				isBold="false"
       
   207 			/>
       
   208 		</conditionalStyle>
       
   209 			<conditionalStyle>
       
   210 				<conditionExpression><![CDATA[new Boolean(($P{DIMENSIONS}.intValue()==3)&&($V{NIVEL2_COUNT}.intValue()%2==1))]]></conditionExpression>
       
   211 				<style 
       
   212 					name="Level3_Line"
       
   213 					isDefault="false"
       
   214 					mode="Opaque"
       
   215 					backcolor="#E5E5E5"
       
   216 					vAlign="Middle"
       
   217 					fontName="Bitstream Vera Sans"
       
   218 					fontSize="8"
       
   219 					isBold="false"
       
   220 				/>
       
   221 			</conditionalStyle>
       
   222 	</style>
       
   223 	<style 
       
   224 		name="Level4_Line"
       
   225 		isDefault="false"
       
   226 		mode="Opaque"
       
   227 		backcolor="#CCCCCC"
       
   228 		vAlign="Middle"
       
   229 		fontName="Bitstream Vera Sans"
       
   230 		fontSize="8"
       
   231 		isBold="true"
       
   232 	>
       
   233 
       
   234 		<conditionalStyle>
       
   235 			<conditionExpression><![CDATA[new Boolean(($P{DIMENSIONS}.intValue()==4)&&($V{NIVEL3_COUNT}.intValue()%2==0))]]></conditionExpression>
       
   236 			<style 
       
   237 				name="Level4_Line"
       
   238 				isDefault="false"
       
   239 				backcolor="#FFFFFF"
       
   240 				vAlign="Middle"
       
   241 				fontName="Bitstream Vera Sans"
       
   242 				fontSize="8"
       
   243 				isBold="false"
       
   244 			/>
       
   245 		</conditionalStyle>
       
   246 			<conditionalStyle>
       
   247 				<conditionExpression><![CDATA[new Boolean(($P{DIMENSIONS}.intValue()==4)&&($V{NIVEL3_COUNT}.intValue()%2==1))]]></conditionExpression>
       
   248 				<style 
       
   249 					name="Level4_Line"
       
   250 					isDefault="false"
       
   251 					mode="Opaque"
       
   252 					backcolor="#E5E5E5"
       
   253 					vAlign="Middle"
       
   254 					fontName="Bitstream Vera Sans"
       
   255 					fontSize="8"
       
   256 					isBold="false"
       
   257 				/>
       
   258 			</conditionalStyle>
       
   259 	</style>
       
   260 	<style 
       
   261 		name="Level5_Line"
       
   262 		isDefault="false"
       
   263 		mode="Opaque"
       
   264 		backcolor="#E5E5E5"
       
   265 		vAlign="Middle"
       
   266 		fontName="Bitstream Vera Sans"
       
   267 		fontSize="8"
       
   268 		isBold="true"
       
   269 	>
       
   270 
       
   271 		<conditionalStyle>
       
   272 			<conditionExpression><![CDATA[new Boolean(($P{DIMENSIONS}.intValue()==5)&&($V{NIVEL4_COUNT}.intValue()%2==0))]]></conditionExpression>
       
   273 			<style 
       
   274 				name="Level5_Line"
       
   275 				isDefault="false"
       
   276 				mode="Opaque"
       
   277 				backcolor="#FFFFFF"
       
   278 				vAlign="Middle"
       
   279 				fontName="Bitstream Vera Sans"
       
   280 				fontSize="8"
       
   281 				isBold="false"
       
   282 			/>
       
   283 		</conditionalStyle>
       
   284 			<conditionalStyle>
       
   285 				<conditionExpression><![CDATA[new Boolean(($P{DIMENSIONS}.intValue()==5)&&($V{NIVEL4_COUNT}.intValue()%2==1))]]></conditionExpression>
       
   286 				<style 
       
   287 					name="Level5_Line"
       
   288 					isDefault="false"
       
   289 					mode="Opaque"
       
   290 					backcolor="#E5E5E5"
       
   291 					vAlign="Middle"
       
   292 					fontName="Bitstream Vera Sans"
       
   293 					fontSize="8"
       
   294 					isBold="false"
       
   295 				/>
       
   296 			</conditionalStyle>
       
   297 	</style>
       
   298 	<style 
       
   299 		name="Level6_Line"
       
   300 		isDefault="false"
       
   301 		backcolor="#CCCCCC"
       
   302 		vAlign="Middle"
       
   303 		fontName="Bitstream Vera Sans"
       
   304 		fontSize="8"
       
   305 		isBold="true"
       
   306 	/>
       
   307 	<style 
       
   308 		name="Level7_Line"
       
   309 		isDefault="false"
       
   310 		backcolor="#E5E5E5"
       
   311 		vAlign="Middle"
       
   312 		fontName="Bitstream Vera Sans"
       
   313 		fontSize="8"
       
   314 		isBold="true"
       
   315 	/>
       
   316 	<style 
       
   317 		name="Level8_Line"
       
   318 		isDefault="false"
       
   319 		backcolor="#CCCCCC"
       
   320 		vAlign="Middle"
       
   321 		fontName="Bitstream Vera Sans"
       
   322 		fontSize="8"
       
   323 		isBold="true"
       
   324 	/>
       
   325 	<style 
       
   326 		name="Level9_Line"
       
   327 		isDefault="false"
       
   328 		backcolor="#E5E5E5"
       
   329 		vAlign="Middle"
       
   330 		fontName="Bitstream Vera Sans"
       
   331 		fontSize="8"
       
   332 		isBold="true"
       
   333 	/>
       
   334 	<style 
       
   335 		name="Report_Footer"
       
   336 		isDefault="false"
       
   337 		vAlign="Middle"
       
   338 		fontName="Bitstream Vera Sans"
       
   339 		fontSize="11"
       
   340 	/>
       
   341 	<style 
       
   342 		name="Detail_Border"
       
   343 		isDefault="false"
       
   344 		forecolor="#8A8A8A"
       
   345 		pen="Thin"
       
   346 	/>
       
   347 
       
   348 	<parameter name="USER_ORG" isForPrompting="false" class="java.lang.String">
       
   349 		<defaultValueExpression ><![CDATA["0,1000000"]]></defaultValueExpression>
       
   350 	</parameter>
       
   351 	<parameter name="USER_CLIENT" isForPrompting="false" class="java.lang.String">
       
   352 		<defaultValueExpression ><![CDATA["0,1000000"]]></defaultValueExpression>
       
   353 	</parameter>
       
   354 	<parameter name="DATEFROM" isForPrompting="false" class="java.util.Date">
       
   355 		<defaultValueExpression ><![CDATA[(new SimpleDateFormat("dd-MM-yyyy")).parse("01-01-1900")]]></defaultValueExpression>
       
   356 	</parameter>
       
   357 	<parameter name="DATETO" isForPrompting="false" class="java.util.Date">
       
   358 		<defaultValueExpression ><![CDATA[(new SimpleDateFormat("dd-MM-yyyy")).parse("31-12-3000")]]></defaultValueExpression>
       
   359 	</parameter>
       
   360 	<parameter name="cBpGroupId" isForPrompting="false" class="java.lang.String">
       
   361 		<defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
       
   362 	</parameter>
       
   363 	<parameter name="cBpGroupId_Aux" isForPrompting="false" class="java.lang.String">
       
   364 		<defaultValueExpression ><![CDATA[$P{cBpGroupId}.equals("") ? " " : (" AND C_BP_Group.C_BP_Group_ID = " + $P{cBpGroupId})]]></defaultValueExpression>
       
   365 	</parameter>
       
   366 	<parameter name="cBpartnerId" isForPrompting="false" class="java.lang.String">
       
   367 		<defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
       
   368 	</parameter>
       
   369 	<parameter name="cBpartnerId_Aux" isForPrompting="false" class="java.lang.String">
       
   370 		<defaultValueExpression ><![CDATA[($P{cBpartnerId}.equals(""))?"  ":" AND C_BPartner.C_BPartner_ID IN " + $P{cBpartnerId}]]></defaultValueExpression>
       
   371 	</parameter>
       
   372 	<parameter name="mProductCategoryId" isForPrompting="false" class="java.lang.String">
       
   373 		<defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
       
   374 	</parameter>
       
   375 	<parameter name="mProductCategoryId_Aux" isForPrompting="false" class="java.lang.String">
       
   376 		<defaultValueExpression ><![CDATA[($P{mProductCategoryId}.equals(""))?"  ":" AND M_Product_Category.M_Product_Category_Id = " + $P{mProductCategoryId}]]></defaultValueExpression>
       
   377 	</parameter>
       
   378 	<parameter name="mProductId" isForPrompting="false" class="java.lang.String">
       
   379 		<defaultValueExpression ><![CDATA[""]]></defaultValueExpression>
       
   380 	</parameter>
       
   381 	<parameter name="mProductId_Aux" isForPrompting="false" class="java.lang.String">
       
   382 		<defaultValueExpression ><![CDATA[($P{mProductId}.equals(""))?" ":" AND M_Product.M_Product_ID IN " + $P{mProductId}]]></defaultValueExpression>
       
   383 	</parameter>
       
   384 	<parameter name="orderBy" isForPrompting="false" class="java.lang.String">
       
   385 		<defaultValueExpression ><![CDATA[" ORDER BY 1 "]]></defaultValueExpression>
       
   386 	</parameter>
       
   387 	<parameter name="REPORT_TITLE" isForPrompting="false" class="java.lang.String">
       
   388 		<defaultValueExpression ><![CDATA["Purchase Orders Report"]]></defaultValueExpression>
       
   389 	</parameter>
       
   390 	<parameter name="PRODUCT_LEVEL" isForPrompting="false" class="java.lang.Integer">
       
   391 		<defaultValueExpression ><![CDATA[new Integer(3)]]></defaultValueExpression>
       
   392 	</parameter>
       
   393 	<parameter name="THEME" isForPrompting="false" class="java.lang.String">
       
   394 		<defaultValueExpression ><![CDATA["Default"]]></defaultValueExpression>
       
   395 	</parameter>
       
   396 	<parameter name="BASE_WEB" isForPrompting="false" class="java.lang.String">
       
   397 		<defaultValueExpression ><![CDATA["/var/lib/tomcat-5.5/webapps/alerts/web"]]></defaultValueExpression>
       
   398 	</parameter>
       
   399 	<parameter name="REPORT_SUBTITLE" isForPrompting="false" class="java.lang.String"/>
       
   400 	<parameter name="LEVEL1_LABEL" isForPrompting="false" class="java.lang.String">
       
   401 		<defaultValueExpression ><![CDATA["Partner Group"]]></defaultValueExpression>
       
   402 	</parameter>
       
   403 	<parameter name="LEVEL2_LABEL" isForPrompting="false" class="java.lang.String">
       
   404 		<defaultValueExpression ><![CDATA["Product Category"]]></defaultValueExpression>
       
   405 	</parameter>
       
   406 	<parameter name="LEVEL3_LABEL" isForPrompting="false" class="java.lang.String">
       
   407 		<defaultValueExpression ><![CDATA["Product"]]></defaultValueExpression>
       
   408 	</parameter>
       
   409 	<parameter name="LEVEL4_LABEL" isForPrompting="false" class="java.lang.String">
       
   410 		<defaultValueExpression ><![CDATA["Partner"]]></defaultValueExpression>
       
   411 	</parameter>
       
   412 	<parameter name="LEVEL5_LABEL" isForPrompting="false" class="java.lang.String"/>
       
   413 	<parameter name="LEVEL6_LABEL" isForPrompting="false" class="java.lang.String"/>
       
   414 	<parameter name="LEVEL7_LABEL" isForPrompting="false" class="java.lang.String"/>
       
   415 	<parameter name="LEVEL8_LABEL" isForPrompting="false" class="java.lang.String"/>
       
   416 	<parameter name="LEVEL9_LABEL" isForPrompting="false" class="java.lang.String"/>
       
   417 	<parameter name="DIMENSIONS" isForPrompting="false" class="java.lang.Integer">
       
   418 		<defaultValueExpression ><![CDATA[new Integer(2)]]></defaultValueExpression>
       
   419 	</parameter>
       
   420 	<parameter name="GROUP_LEVEL" isForPrompting="false" class="java.lang.String">
       
   421 		<defaultValueExpression ><![CDATA["1.- Group1, 2.- Group2, 3.- Group3"]]></defaultValueExpression>
       
   422 	</parameter>
       
   423 	<parameter name="LEVEL_LABEL" isForPrompting="false" class="java.lang.String">
       
   424 		<defaultValueExpression ><![CDATA["1.- "+$P{LEVEL1_LABEL}
       
   425 +($P{LEVEL2_LABEL}==""?"":", 2.- "+$P{LEVEL2_LABEL})
       
   426 +($P{LEVEL3_LABEL}==""?"":", 3.- "+$P{LEVEL3_LABEL})
       
   427 +($P{LEVEL4_LABEL}==""?"":", 4.- "+$P{LEVEL4_LABEL})
       
   428 +($P{LEVEL5_LABEL}==""?"":", 5.- "+$P{LEVEL5_LABEL})]]></defaultValueExpression>
       
   429 	</parameter>
       
   430 	<parameter name="NUMBERFORMAT" isForPrompting="false" class="java.text.DecimalFormat"/>
       
   431 	<parameter name="LOCALE" isForPrompting="false" class="java.util.Locale"/>
       
   432 	<queryString><![CDATA[SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, SUM(LINENETAMT) AS AMOUNT, SUM(QTYORDERED) AS QTY, SUM(LINENETREF) AS AMOUNTREF, SUM(QTYORDEREDREF) AS QTYREF, '' AS ID, '' AS NAME, UOMSYMBOL
       
   433 FROM (SELECT to_char(M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID) AS NIVEL1, to_char(C_BP_GROUP.C_BP_GROUP_ID) AS NIVEL2, to_char('4') AS NIVEL3, to_char('5') AS NIVEL4, to_char('5') AS NIVEL5, 
       
   434 C_ORDERLINE.LINENETAMT, C_ORDERLINE.QTYORDERED, 0 AS LINENETREF, 0 AS QTYORDEREDREF, C_UOM.UOMSYMBOL
       
   435 FROM M_PRODUCT left join M_PRODUCT_CATEGORY on M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID 
       
   436                 right join C_ORDERLINE on C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID
       
   437                 right join C_ORDER on C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID,
       
   438 C_BPARTNER, C_BP_GROUP, C_UOM
       
   439 WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID
       
   440 AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID
       
   441 AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID
       
   442 AND C_ORDER.ISSOTRX = 'N'
       
   443 AND C_ORDER.PROCESSED = 'Y'
       
   444 AND C_ORDER.DATEORDERED >= to_date('01-01-2006', 'DD-MM-YYYY')
       
   445 AND C_ORDER.DATEORDERED < to_date('01-01-2007', 'DD-MM-YYYY')
       
   446 AND 1=1
       
   447 UNION ALL SELECT to_char('1') AS NIVEL1 , to_char('2') AS NIVEL2 , to_char('3') AS NIVEL3 , to_char('4') AS NIVEL4 , to_char('5') AS NIVEL5, 
       
   448 0 AS LINENETAMT, 0 AS QTYORDERED, C_ORDERLINE.LINENETAMT AS LINENETREF, C_ORDERLINE.QTYORDERED AS QTYORDEREDREF, C_UOM.UOMSYMBOL
       
   449 FROM M_PRODUCT left join M_PRODUCT_CATEGORY on M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID 
       
   450                 right join C_ORDERLINE on C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID
       
   451                 right join C_ORDER on C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID,
       
   452         C_BPARTNER, C_BP_GROUP, C_UOM
       
   453 WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID
       
   454 AND C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID
       
   455 AND C_ORDERLINE.C_UOM_ID = C_UOM.C_UOM_ID
       
   456 AND C_ORDER.ISSOTRX = 'N'
       
   457 AND C_ORDER.PROCESSED = 'Y'
       
   458 AND C_ORDER.DATEORDERED >= to_date('01-01-2007', 'DD-MM-YYYY')
       
   459 AND C_ORDER.DATEORDERED < to_date('01-01-2008', 'DD-MM-YYYY')
       
   460 AND 2=2) AA
       
   461 GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, UOMSYMBOL, 1
       
   462 ORDER BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, UOMSYMBOL, 1]]></queryString>
       
   463 
       
   464 	<field name="NIVEL1" class="java.lang.String"/>
       
   465 	<field name="NIVEL2" class="java.lang.String"/>
       
   466 	<field name="NIVEL3" class="java.lang.String"/>
       
   467 	<field name="NIVEL4" class="java.lang.String"/>
       
   468 	<field name="NIVEL5" class="java.lang.String"/>
       
   469 	<field name="AMOUNT" class="java.math.BigDecimal"/>
       
   470 	<field name="QTY" class="java.math.BigDecimal"/>
       
   471 	<field name="AMOUNTREF" class="java.math.BigDecimal"/>
       
   472 	<field name="QTYREF" class="java.math.BigDecimal"/>
       
   473 	<field name="ID" class="java.lang.String"/>
       
   474 	<field name="NAME" class="java.lang.String"/>
       
   475 	<field name="UOMSYMBOL" class="java.lang.String"/>
       
   476 
       
   477 	<variable name="QTY_SUM5" class="java.math.BigDecimal" resetType="Group" resetGroup="LEVEL5" calculation="Sum">
       
   478 		<variableExpression><![CDATA[$F{QTY}]]></variableExpression>
       
   479 		<initialValueExpression><![CDATA[new BigDecimal(0)]]></initialValueExpression>
       
   480 	</variable>
       
   481 	<variable name="QTY_SUM4" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL4" calculation="Sum">
       
   482 		<variableExpression><![CDATA[$F{QTY}]]></variableExpression>
       
   483 	</variable>
       
   484 	<variable name="QTY_SUM3" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL3" calculation="Sum">
       
   485 		<variableExpression><![CDATA[$F{QTY}]]></variableExpression>
       
   486 	</variable>
       
   487 	<variable name="QTY_SUM2" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL2" calculation="Sum">
       
   488 		<variableExpression><![CDATA[$F{QTY}]]></variableExpression>
       
   489 	</variable>
       
   490 	<variable name="QTY_SUM1" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL1" calculation="Sum">
       
   491 		<variableExpression><![CDATA[$F{QTY}]]></variableExpression>
       
   492 	</variable>
       
   493 	<variable name="QTYREF_SUM5" class="java.math.BigDecimal" resetType="Group" resetGroup="LEVEL5" calculation="Sum">
       
   494 		<variableExpression><![CDATA[$F{QTYREF}]]></variableExpression>
       
   495 		<initialValueExpression><![CDATA[new BigDecimal(0)]]></initialValueExpression>
       
   496 	</variable>
       
   497 	<variable name="QTYREF_SUM4" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL4" calculation="Sum">
       
   498 		<variableExpression><![CDATA[$F{QTYREF}]]></variableExpression>
       
   499 	</variable>
       
   500 	<variable name="QTYREF_SUM3" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL3" calculation="Sum">
       
   501 		<variableExpression><![CDATA[$F{QTYREF}]]></variableExpression>
       
   502 	</variable>
       
   503 	<variable name="QTYREF_SUM2" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL2" calculation="Sum">
       
   504 		<variableExpression><![CDATA[$F{QTYREF}]]></variableExpression>
       
   505 	</variable>
       
   506 	<variable name="QTYREF_SUM1" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL1" calculation="Sum">
       
   507 		<variableExpression><![CDATA[$F{QTYREF}]]></variableExpression>
       
   508 	</variable>
       
   509 	<variable name="AMOUNT_TOTAL" class="java.math.BigDecimal" resetType="Report" calculation="Sum">
       
   510 		<variableExpression><![CDATA[$F{AMOUNT}]]></variableExpression>
       
   511 	</variable>
       
   512 	<variable name="AMOUNT_SUM1" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL1" calculation="Sum">
       
   513 		<variableExpression><![CDATA[$F{AMOUNT}]]></variableExpression>
       
   514 	</variable>
       
   515 	<variable name="AMOUNT_SUM2" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL2" calculation="Sum">
       
   516 		<variableExpression><![CDATA[$F{AMOUNT}]]></variableExpression>
       
   517 	</variable>
       
   518 	<variable name="AMOUNT_SUM3" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL3" calculation="Sum">
       
   519 		<variableExpression><![CDATA[$F{AMOUNT}]]></variableExpression>
       
   520 	</variable>
       
   521 	<variable name="AMOUNT_SUM4" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL4" calculation="Sum">
       
   522 		<variableExpression><![CDATA[$F{AMOUNT}]]></variableExpression>
       
   523 	</variable>
       
   524 	<variable name="AMOUNT_SUM5" class="java.math.BigDecimal" resetType="Group" resetGroup="LEVEL5" calculation="Sum">
       
   525 		<variableExpression><![CDATA[$F{AMOUNT}]]></variableExpression>
       
   526 	</variable>
       
   527 	<variable name="AMOUNTREF_TOTAL" class="java.math.BigDecimal" resetType="Report" calculation="Sum">
       
   528 		<variableExpression><![CDATA[$F{AMOUNTREF}]]></variableExpression>
       
   529 	</variable>
       
   530 	<variable name="AMOUNTREF_SUM1" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL1" calculation="Sum">
       
   531 		<variableExpression><![CDATA[$F{AMOUNTREF}]]></variableExpression>
       
   532 	</variable>
       
   533 	<variable name="AMOUNTREF_SUM2" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL2" calculation="Sum">
       
   534 		<variableExpression><![CDATA[$F{AMOUNTREF}]]></variableExpression>
       
   535 	</variable>
       
   536 	<variable name="AMOUNTREF_SUM3" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL3" calculation="Sum">
       
   537 		<variableExpression><![CDATA[$F{AMOUNTREF}]]></variableExpression>
       
   538 	</variable>
       
   539 	<variable name="AMOUNTREF_SUM4" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL4" calculation="Sum">
       
   540 		<variableExpression><![CDATA[$F{AMOUNTREF}]]></variableExpression>
       
   541 	</variable>
       
   542 	<variable name="AMOUNTREF_SUM5" class="java.math.BigDecimal" resetType="Group" resetGroup="LEVEL5" calculation="Sum">
       
   543 		<variableExpression><![CDATA[$F{AMOUNTREF}]]></variableExpression>
       
   544 	</variable>
       
   545 	<variable name="AMT_PCT_1" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL1" calculation="Nothing">
       
   546 		<variableExpression><![CDATA[($V{AMOUNTREF_SUM1}.equals(new BigDecimal(0.0)))?null:$V{AMOUNT_SUM1}.subtract( $V{AMOUNTREF_SUM1} ).divide( $V{AMOUNTREF_SUM1}, 4)]]></variableExpression>
       
   547 	</variable>
       
   548 	<variable name="AMT_PCT_2" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL2" calculation="Nothing">
       
   549 		<variableExpression><![CDATA[($V{AMOUNTREF_SUM2}.equals(new BigDecimal(0.0)))?null:$V{AMOUNT_SUM2}.subtract( $V{AMOUNTREF_SUM2} ).divide( $V{AMOUNTREF_SUM2}, 0)]]></variableExpression>
       
   550 	</variable>
       
   551 	<variable name="AMT_PCT_3" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL3" calculation="Nothing">
       
   552 		<variableExpression><![CDATA[($V{AMOUNTREF_SUM3}.equals(new BigDecimal(0.0)))?null:$V{AMOUNT_SUM3}.subtract( $V{AMOUNTREF_SUM3} ).divide( $V{AMOUNTREF_SUM3}, 4)]]></variableExpression>
       
   553 	</variable>
       
   554 	<variable name="AMT_PCT_4" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL4" calculation="Nothing">
       
   555 		<variableExpression><![CDATA[($V{AMOUNTREF_SUM4}.equals(new BigDecimal(0.0)))?null:$V{AMOUNT_SUM4}.subtract( $V{AMOUNTREF_SUM4} ).divide( $V{AMOUNTREF_SUM4}, 4)]]></variableExpression>
       
   556 	</variable>
       
   557 	<variable name="AMT_PCT_5" class="java.math.BigDecimal" resetType="Group" resetGroup="LEVEL5" calculation="Nothing">
       
   558 		<variableExpression><![CDATA[($V{AMOUNTREF_SUM5}.equals(new BigDecimal(0.0)))?null:$V{AMOUNT_SUM5}.subtract( $V{AMOUNTREF_SUM5} ).divide( $V{AMOUNTREF_SUM5}, 4)]]></variableExpression>
       
   559 	</variable>
       
   560 	<variable name="AMT_PCT_T" class="java.math.BigDecimal" resetType="Report" calculation="Nothing">
       
   561 		<variableExpression><![CDATA[($V{AMOUNTREF_TOTAL}.equals(new BigDecimal(0.0)))?null:$V{AMOUNT_TOTAL}.subtract( $V{AMOUNTREF_TOTAL} ).divide( $V{AMOUNTREF_TOTAL}, 6)]]></variableExpression>
       
   562 	</variable>
       
   563 	<variable name="QTY_PCT_1" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL1" calculation="Nothing">
       
   564 		<variableExpression><![CDATA[($V{QTYREF_SUM1}.equals(new BigDecimal(0.0)))?null:$V{QTY_SUM1}.subtract( $V{QTYREF_SUM1} ).divide( $V{QTYREF_SUM1}, 4)]]></variableExpression>
       
   565 	</variable>
       
   566 	<variable name="QTY_PCT_2" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL2" calculation="Nothing">
       
   567 		<variableExpression><![CDATA[($V{QTYREF_SUM2}.equals(new BigDecimal(0.0)))?null:$V{QTY_SUM2}.subtract( $V{QTYREF_SUM2} ).divide( $V{QTYREF_SUM2}, 0)]]></variableExpression>
       
   568 	</variable>
       
   569 	<variable name="QTY_PCT_3" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL3" calculation="Nothing">
       
   570 		<variableExpression><![CDATA[($V{QTYREF_SUM3}.equals(new BigDecimal(0.0)))?null:$V{QTY_SUM3}.subtract( $V{QTYREF_SUM3} ).divide( $V{QTYREF_SUM3}, 4)]]></variableExpression>
       
   571 	</variable>
       
   572 	<variable name="QTY_PCT_4" class="java.math.BigDecimal" resetType="Group" resetGroup="NIVEL4" calculation="Nothing">
       
   573 		<variableExpression><![CDATA[($V{QTYREF_SUM4}.equals(new BigDecimal(0.0)))?null:$V{QTY_SUM4}.subtract( $V{QTYREF_SUM4} ).divide( $V{QTYREF_SUM4}, 4)]]></variableExpression>
       
   574 	</variable>
       
   575 	<variable name="QTY_PCT_5" class="java.math.BigDecimal" resetType="Group" resetGroup="LEVEL5" calculation="Nothing">
       
   576 		<variableExpression><![CDATA[($V{QTYREF_SUM5}.equals(new BigDecimal(0.0)))?null:$V{QTY_SUM5}.subtract( $V{QTYREF_SUM5} ).divide( $V{QTYREF_SUM5}, 4)]]></variableExpression>
       
   577 	</variable>
       
   578 
       
   579 		<group  name="TOTALIZE" >
       
   580 			<groupExpression><![CDATA[]]></groupExpression>
       
   581 			<groupHeader>
       
   582 			<band height="0"  isSplitAllowed="true" >
       
   583 			</band>
       
   584 			</groupHeader>
       
   585 			<groupFooter>
       
   586 			<band height="20"  isSplitAllowed="true" >
       
   587 				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None"  hyperlinkTarget="Self" >
       
   588 					<reportElement
       
   589 						style="Total_Field"
       
   590 						x="307"
       
   591 						y="1"
       
   592 						width="83"
       
   593 						height="18"
       
   594 						key="textField-36"/>
       
   595 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
   596 					<textElement textAlignment="Right">
       
   597 						<font/>
       
   598 					</textElement>
       
   599 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{AMOUNT_TOTAL}!=null)?$P{NUMBERFORMAT}.format($V{AMOUNT_TOTAL}):new String(" ")]]></textFieldExpression>
       
   600 				</textField>
       
   601 				<staticText>
       
   602 					<reportElement
       
   603 						style="Report_Data_Label"
       
   604 						x="255"
       
   605 						y="1"
       
   606 						width="52"
       
   607 						height="18"
       
   608 						key="staticText-18"/>
       
   609 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
   610 					<textElement textAlignment="Right" verticalAlignment="Middle">
       
   611 						<font/>
       
   612 					</textElement>
       
   613 				<text><![CDATA[Total:]]></text>
       
   614 				</staticText>
       
   615 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None"  hyperlinkTarget="Self" >
       
   616 					<reportElement
       
   617 						style="Total_Field"
       
   618 						x="390"
       
   619 						y="1"
       
   620 						width="80"
       
   621 						height="18"
       
   622 						key="textField-37"/>
       
   623 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
   624 					<textElement textAlignment="Right">
       
   625 						<font/>
       
   626 					</textElement>
       
   627 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{AMOUNTREF_TOTAL}!=null)?$P{NUMBERFORMAT}.format($V{AMOUNTREF_TOTAL}):new String(" ")]]></textFieldExpression>
       
   628 				</textField>
       
   629 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None"  hyperlinkTarget="Self" >
       
   630 					<reportElement
       
   631 						style="Total_Field"
       
   632 						x="470"
       
   633 						y="1"
       
   634 						width="50"
       
   635 						height="18"
       
   636 						key="textField-38"/>
       
   637 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
   638 					<textElement textAlignment="Right">
       
   639 						<font/>
       
   640 					</textElement>
       
   641 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{AMT_PCT_T}!=null)?$P{NUMBERFORMAT}.format($V{AMT_PCT_T}):new String(" ")]]></textFieldExpression>
       
   642 				</textField>
       
   643 				<line direction="TopDown">
       
   644 					<reportElement
       
   645 						x="0"
       
   646 						y="0"
       
   647 						width="730"
       
   648 						height="0"
       
   649 						key="line-5"/>
       
   650 					<graphicElement stretchType="NoStretch"/>
       
   651 				</line>
       
   652 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
   653 					<reportElement
       
   654 						style="Detail_Header"
       
   655 						mode="Opaque"
       
   656 						x="15"
       
   657 						y="0"
       
   658 						width="15"
       
   659 						height="18"
       
   660 						key="textField-39">
       
   661 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=2)]]></printWhenExpression>
       
   662 						</reportElement>
       
   663 					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#FFFFFF" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
   664 					<textElement rotation="None">
       
   665 						<font/>
       
   666 					</textElement>
       
   667 				<textFieldExpression   class="java.lang.String"><![CDATA[(($P{DIMENSIONS}.compareTo(new Integer(2))>=0)?"2":"")]]></textFieldExpression>
       
   668 				</textField>
       
   669 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
   670 					<reportElement
       
   671 						style="Detail_Header"
       
   672 						mode="Opaque"
       
   673 						x="0"
       
   674 						y="0"
       
   675 						width="15"
       
   676 						height="18"
       
   677 						key="textField-40">
       
   678 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=1)]]></printWhenExpression>
       
   679 						</reportElement>
       
   680 					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#FFFFFF" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
   681 					<textElement rotation="None">
       
   682 						<font/>
       
   683 					</textElement>
       
   684 				<textFieldExpression   class="java.lang.String"><![CDATA[(($P{DIMENSIONS}.compareTo(new Integer(1))>=0)?"1":"")]]></textFieldExpression>
       
   685 				</textField>
       
   686 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
   687 					<reportElement
       
   688 						style="Detail_Header"
       
   689 						mode="Opaque"
       
   690 						x="30"
       
   691 						y="0"
       
   692 						width="15"
       
   693 						height="18"
       
   694 						key="textField-41">
       
   695 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=3)]]></printWhenExpression>
       
   696 						</reportElement>
       
   697 					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#FFFFFF" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
   698 					<textElement rotation="None">
       
   699 						<font/>
       
   700 					</textElement>
       
   701 				<textFieldExpression   class="java.lang.String"><![CDATA[(($P{DIMENSIONS}.compareTo(new Integer(3))>=0)?"3":"")]]></textFieldExpression>
       
   702 				</textField>
       
   703 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
   704 					<reportElement
       
   705 						style="Detail_Header"
       
   706 						mode="Opaque"
       
   707 						x="45"
       
   708 						y="0"
       
   709 						width="15"
       
   710 						height="18"
       
   711 						key="textField-42">
       
   712 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=4)]]></printWhenExpression>
       
   713 						</reportElement>
       
   714 					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#FFFFFF" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
   715 					<textElement rotation="None">
       
   716 						<font/>
       
   717 					</textElement>
       
   718 				<textFieldExpression   class="java.lang.String"><![CDATA[(($P{DIMENSIONS}.compareTo(new Integer(4))>=0)?"4":"")]]></textFieldExpression>
       
   719 				</textField>
       
   720 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
   721 					<reportElement
       
   722 						style="Detail_Header"
       
   723 						mode="Opaque"
       
   724 						x="60"
       
   725 						y="0"
       
   726 						width="15"
       
   727 						height="18"
       
   728 						key="textField-43">
       
   729 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=5)]]></printWhenExpression>
       
   730 						</reportElement>
       
   731 					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#FFFFFF" rightBorder="Thin" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
       
   732 					<textElement rotation="None">
       
   733 						<font/>
       
   734 					</textElement>
       
   735 				<textFieldExpression   class="java.lang.String"><![CDATA[(($P{DIMENSIONS}.compareTo(new Integer(5))>=0)?"5":" ")]]></textFieldExpression>
       
   736 				</textField>
       
   737 			</band>
       
   738 			</groupFooter>
       
   739 		</group>
       
   740 		<group  name="NIVEL1" >
       
   741 			<groupExpression><![CDATA[$F{NIVEL1}]]></groupExpression>
       
   742 			<groupHeader>
       
   743 			<band height="18"  isSplitAllowed="true" >
       
   744 				<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=1)]]></printWhenExpression>
       
   745 				<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
   746 					<reportElement
       
   747 						style="Level1_Line"
       
   748 						x="0"
       
   749 						y="0"
       
   750 						width="307"
       
   751 						height="18"
       
   752 						key="textField"
       
   753 						stretchType="RelativeToBandHeight"/>
       
   754 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
   755 					<textElement>
       
   756 						<font isBold="true"/>
       
   757 					</textElement>
       
   758 				<textFieldExpression   class="java.lang.String"><![CDATA[$F{NIVEL1}]]></textFieldExpression>
       
   759 				</textField>
       
   760 				<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Group" evaluationGroup="NIVEL1"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
   761 					<reportElement
       
   762 						style="Level1_Line"
       
   763 						x="580"
       
   764 						y="0"
       
   765 						width="20"
       
   766 						height="18"
       
   767 						key="textField"
       
   768 						stretchType="RelativeToBandHeight">
       
   769 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=1)]]></printWhenExpression>
       
   770 						</reportElement>
       
   771 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
   772 					<textElement>
       
   773 						<font/>
       
   774 					</textElement>
       
   775 				<textFieldExpression   class="java.lang.String"><![CDATA[$F{UOMSYMBOL}]]></textFieldExpression>
       
   776 				</textField>
       
   777 				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL1"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
   778 					<reportElement
       
   779 						style="Level1_Line"
       
   780 						x="520"
       
   781 						y="0"
       
   782 						width="60"
       
   783 						height="18"
       
   784 						key="textField"
       
   785 						stretchType="RelativeToBandHeight">
       
   786 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=1)]]></printWhenExpression>
       
   787 						</reportElement>
       
   788 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
   789 					<textElement textAlignment="Right">
       
   790 						<font/>
       
   791 					</textElement>
       
   792 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{QTY_SUM1}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM1}):new String(" ")]]></textFieldExpression>
       
   793 				</textField>
       
   794 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL1"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
   795 					<reportElement
       
   796 						style="Level1_Line"
       
   797 						x="307"
       
   798 						y="0"
       
   799 						width="83"
       
   800 						height="18"
       
   801 						key="textField"
       
   802 						stretchType="RelativeToBandHeight"/>
       
   803 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
   804 					<textElement textAlignment="Right">
       
   805 						<font/>
       
   806 					</textElement>
       
   807 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{AMOUNT_SUM1}!=null)?$P{NUMBERFORMAT}.format($V{AMOUNT_SUM1}):new String(" ")]]></textFieldExpression>
       
   808 				</textField>
       
   809 				<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Group" evaluationGroup="NIVEL1"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
   810 					<reportElement
       
   811 						style="Level1_Line"
       
   812 						x="660"
       
   813 						y="0"
       
   814 						width="20"
       
   815 						height="18"
       
   816 						key="textField-2"
       
   817 						stretchType="RelativeToBandHeight">
       
   818 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=1)]]></printWhenExpression>
       
   819 						</reportElement>
       
   820 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
   821 					<textElement>
       
   822 						<font/>
       
   823 					</textElement>
       
   824 				<textFieldExpression   class="java.lang.String"><![CDATA[$F{UOMSYMBOL}]]></textFieldExpression>
       
   825 				</textField>
       
   826 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL1"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
   827 					<reportElement
       
   828 						style="Level1_Line"
       
   829 						x="390"
       
   830 						y="0"
       
   831 						width="80"
       
   832 						height="18"
       
   833 						key="textField"
       
   834 						stretchType="RelativeToBandHeight"/>
       
   835 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
   836 					<textElement textAlignment="Right">
       
   837 						<font/>
       
   838 					</textElement>
       
   839 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{AMOUNTREF_SUM1}!=null)?$P{NUMBERFORMAT}.format($V{AMOUNTREF_SUM1}):new String(" ")]]></textFieldExpression>
       
   840 				</textField>
       
   841 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL1"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
   842 					<reportElement
       
   843 						style="Level1_Line"
       
   844 						x="600"
       
   845 						y="0"
       
   846 						width="60"
       
   847 						height="18"
       
   848 						key="textField"
       
   849 						stretchType="RelativeToBandHeight">
       
   850 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=1)]]></printWhenExpression>
       
   851 						</reportElement>
       
   852 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
   853 					<textElement textAlignment="Right">
       
   854 						<font/>
       
   855 					</textElement>
       
   856 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{QTYREF_SUM1}!=null)?$P{NUMBERFORMAT}.format($V{QTYREF_SUM1}):new String(" ")]]></textFieldExpression>
       
   857 				</textField>
       
   858 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL1"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
   859 					<reportElement
       
   860 						style="Level1_Line"
       
   861 						x="470"
       
   862 						y="0"
       
   863 						width="50"
       
   864 						height="18"
       
   865 						key="textField-9"
       
   866 						stretchType="RelativeToBandHeight"/>
       
   867 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
   868 					<textElement textAlignment="Right">
       
   869 						<font/>
       
   870 					</textElement>
       
   871 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{AMT_PCT_1}!=null)?$P{NUMBERFORMAT}.format($V{AMT_PCT_1}):new String(" ")]]></textFieldExpression>
       
   872 				</textField>
       
   873 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL1"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
   874 					<reportElement
       
   875 						style="Level1_Line"
       
   876 						x="680"
       
   877 						y="0"
       
   878 						width="50"
       
   879 						height="18"
       
   880 						key="textField"
       
   881 						stretchType="RelativeToBandHeight">
       
   882 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=1)]]></printWhenExpression>
       
   883 						</reportElement>
       
   884 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
   885 					<textElement textAlignment="Right">
       
   886 						<font/>
       
   887 					</textElement>
       
   888 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{QTY_PCT_1}!=null)?$P{NUMBERFORMAT}.format($V{QTY_PCT_1}):new String(" ")]]></textFieldExpression>
       
   889 				</textField>
       
   890 			</band>
       
   891 			</groupHeader>
       
   892 			<groupFooter>
       
   893 			<band height="5"  isSplitAllowed="true" >
       
   894 				<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()==2)]]></printWhenExpression>
       
   895 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
   896 					<reportElement
       
   897 						style="Level1_Line"
       
   898 						mode="Opaque"
       
   899 						x="0"
       
   900 						y="0"
       
   901 						width="15"
       
   902 						height="5"
       
   903 						key="textField-60"
       
   904 						stretchType="RelativeToBandHeight">
       
   905 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=2)]]></printWhenExpression>
       
   906 						</reportElement>
       
   907 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
   908 					<textElement rotation="None">
       
   909 						<font/>
       
   910 					</textElement>
       
   911 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
   912 				</textField>
       
   913 				<line direction="TopDown">
       
   914 					<reportElement
       
   915 						style="Detail_Border"
       
   916 						x="15"
       
   917 						y="0"
       
   918 						width="715"
       
   919 						height="0"
       
   920 						key="line-6">
       
   921 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()==2)]]></printWhenExpression>
       
   922 						</reportElement>
       
   923 					<graphicElement stretchType="NoStretch"/>
       
   924 				</line>
       
   925 			</band>
       
   926 			</groupFooter>
       
   927 		</group>
       
   928 		<group  name="NIVEL2" >
       
   929 			<groupExpression><![CDATA[$F{NIVEL2}]]></groupExpression>
       
   930 			<groupHeader>
       
   931 			<band height="18"  isSplitAllowed="true" >
       
   932 				<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=2)]]></printWhenExpression>
       
   933 				<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
   934 					<reportElement
       
   935 						style="Level2_Line"
       
   936 						x="15"
       
   937 						y="0"
       
   938 						width="292"
       
   939 						height="18"
       
   940 						key="textField"
       
   941 						stretchType="RelativeToBandHeight"/>
       
   942 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
   943 					<textElement>
       
   944 						<font/>
       
   945 					</textElement>
       
   946 				<textFieldExpression   class="java.lang.String"><![CDATA[$F{NIVEL2}]]></textFieldExpression>
       
   947 				</textField>
       
   948 				<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Group" evaluationGroup="NIVEL2"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
   949 					<reportElement
       
   950 						style="Level2_Line"
       
   951 						x="580"
       
   952 						y="0"
       
   953 						width="20"
       
   954 						height="18"
       
   955 						key="textField"
       
   956 						stretchType="RelativeToBandHeight">
       
   957 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=2)]]></printWhenExpression>
       
   958 						</reportElement>
       
   959 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
   960 					<textElement>
       
   961 						<font/>
       
   962 					</textElement>
       
   963 				<textFieldExpression   class="java.lang.String"><![CDATA[$F{UOMSYMBOL}]]></textFieldExpression>
       
   964 				</textField>
       
   965 				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL2"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
   966 					<reportElement
       
   967 						style="Level2_Line"
       
   968 						x="520"
       
   969 						y="0"
       
   970 						width="60"
       
   971 						height="18"
       
   972 						key="textField"
       
   973 						stretchType="RelativeToBandHeight">
       
   974 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=2)]]></printWhenExpression>
       
   975 						</reportElement>
       
   976 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
   977 					<textElement textAlignment="Right">
       
   978 						<font/>
       
   979 					</textElement>
       
   980 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{QTY_SUM2}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM2}):new String(" ")]]></textFieldExpression>
       
   981 				</textField>
       
   982 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL2"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
   983 					<reportElement
       
   984 						style="Level2_Line"
       
   985 						x="307"
       
   986 						y="0"
       
   987 						width="83"
       
   988 						height="18"
       
   989 						key="textField"
       
   990 						stretchType="RelativeToBandHeight"/>
       
   991 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
   992 					<textElement textAlignment="Right">
       
   993 						<font/>
       
   994 					</textElement>
       
   995 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{AMOUNT_SUM2}!=null)?$P{NUMBERFORMAT}.format($V{AMOUNT_SUM2}):new String(" ")]]></textFieldExpression>
       
   996 				</textField>
       
   997 				<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Group" evaluationGroup="NIVEL2"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
   998 					<reportElement
       
   999 						style="Level2_Line"
       
  1000 						x="660"
       
  1001 						y="0"
       
  1002 						width="20"
       
  1003 						height="18"
       
  1004 						key="textField-3"
       
  1005 						stretchType="RelativeToBandHeight">
       
  1006 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=2)]]></printWhenExpression>
       
  1007 						</reportElement>
       
  1008 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1009 					<textElement>
       
  1010 						<font/>
       
  1011 					</textElement>
       
  1012 				<textFieldExpression   class="java.lang.String"><![CDATA[$F{UOMSYMBOL}]]></textFieldExpression>
       
  1013 				</textField>
       
  1014 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL2"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1015 					<reportElement
       
  1016 						style="Level2_Line"
       
  1017 						x="390"
       
  1018 						y="0"
       
  1019 						width="80"
       
  1020 						height="18"
       
  1021 						key="textField"
       
  1022 						stretchType="RelativeToBandHeight"/>
       
  1023 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1024 					<textElement textAlignment="Right">
       
  1025 						<font/>
       
  1026 					</textElement>
       
  1027 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{AMOUNTREF_SUM2}!=null)?$P{NUMBERFORMAT}.format($V{AMOUNTREF_SUM2}):new String(" ")]]></textFieldExpression>
       
  1028 				</textField>
       
  1029 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL2"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1030 					<reportElement
       
  1031 						style="Level2_Line"
       
  1032 						x="600"
       
  1033 						y="0"
       
  1034 						width="60"
       
  1035 						height="18"
       
  1036 						key="textField"
       
  1037 						stretchType="RelativeToBandHeight">
       
  1038 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=2)]]></printWhenExpression>
       
  1039 						</reportElement>
       
  1040 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1041 					<textElement textAlignment="Right">
       
  1042 						<font/>
       
  1043 					</textElement>
       
  1044 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{QTYREF_SUM2}!=null)?$P{NUMBERFORMAT}.format($V{QTYREF_SUM2}):new String(" ")]]></textFieldExpression>
       
  1045 				</textField>
       
  1046 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL2"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1047 					<reportElement
       
  1048 						style="Level2_Line"
       
  1049 						x="470"
       
  1050 						y="0"
       
  1051 						width="50"
       
  1052 						height="18"
       
  1053 						key="textField-8"
       
  1054 						stretchType="RelativeToBandHeight"/>
       
  1055 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1056 					<textElement textAlignment="Right">
       
  1057 						<font/>
       
  1058 					</textElement>
       
  1059 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{AMT_PCT_2}!=null)?$P{NUMBERFORMAT}.format($V{AMT_PCT_2}):new String(" ")]]></textFieldExpression>
       
  1060 				</textField>
       
  1061 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL2"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1062 					<reportElement
       
  1063 						style="Level2_Line"
       
  1064 						x="680"
       
  1065 						y="0"
       
  1066 						width="50"
       
  1067 						height="18"
       
  1068 						key="textField"
       
  1069 						stretchType="RelativeToBandHeight">
       
  1070 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=2)]]></printWhenExpression>
       
  1071 						</reportElement>
       
  1072 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1073 					<textElement textAlignment="Right">
       
  1074 						<font/>
       
  1075 					</textElement>
       
  1076 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{QTY_PCT_2}!=null)?$P{NUMBERFORMAT}.format($V{QTY_PCT_2}):new String(" ")]]></textFieldExpression>
       
  1077 				</textField>
       
  1078 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1079 					<reportElement
       
  1080 						style="Level1_Line"
       
  1081 						x="0"
       
  1082 						y="0"
       
  1083 						width="15"
       
  1084 						height="18"
       
  1085 						key="textField-26"
       
  1086 						stretchType="RelativeToBandHeight"/>
       
  1087 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1088 					<textElement rotation="None">
       
  1089 						<font/>
       
  1090 					</textElement>
       
  1091 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
  1092 				</textField>
       
  1093 			</band>
       
  1094 			</groupHeader>
       
  1095 			<groupFooter>
       
  1096 			<band height="5"  isSplitAllowed="true" >
       
  1097 				<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()==3)]]></printWhenExpression>
       
  1098 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1099 					<reportElement
       
  1100 						style="Level1_Line"
       
  1101 						mode="Opaque"
       
  1102 						x="0"
       
  1103 						y="0"
       
  1104 						width="15"
       
  1105 						height="5"
       
  1106 						key="textField-56"
       
  1107 						stretchType="RelativeToBandHeight">
       
  1108 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=2)]]></printWhenExpression>
       
  1109 						</reportElement>
       
  1110 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1111 					<textElement rotation="None">
       
  1112 						<font/>
       
  1113 					</textElement>
       
  1114 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
  1115 				</textField>
       
  1116 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1117 					<reportElement
       
  1118 						style="Level2_Line"
       
  1119 						mode="Opaque"
       
  1120 						x="15"
       
  1121 						y="0"
       
  1122 						width="15"
       
  1123 						height="5"
       
  1124 						key="textField-58"
       
  1125 						stretchType="RelativeToBandHeight">
       
  1126 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=3)]]></printWhenExpression>
       
  1127 						</reportElement>
       
  1128 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1129 					<textElement rotation="None">
       
  1130 						<font/>
       
  1131 					</textElement>
       
  1132 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
  1133 				</textField>
       
  1134 				<line direction="TopDown">
       
  1135 					<reportElement
       
  1136 						style="Detail_Border"
       
  1137 						x="30"
       
  1138 						y="0"
       
  1139 						width="700"
       
  1140 						height="0"
       
  1141 						key="line-7">
       
  1142 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()==3)]]></printWhenExpression>
       
  1143 						</reportElement>
       
  1144 					<graphicElement stretchType="NoStretch"/>
       
  1145 				</line>
       
  1146 			</band>
       
  1147 			</groupFooter>
       
  1148 		</group>
       
  1149 		<group  name="NIVEL3" >
       
  1150 			<groupExpression><![CDATA[$F{NIVEL3}]]></groupExpression>
       
  1151 			<groupHeader>
       
  1152 			<band height="18"  isSplitAllowed="true" >
       
  1153 				<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=3)]]></printWhenExpression>
       
  1154 				<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1155 					<reportElement
       
  1156 						style="Level3_Line"
       
  1157 						x="30"
       
  1158 						y="0"
       
  1159 						width="277"
       
  1160 						height="18"
       
  1161 						key="textField"
       
  1162 						stretchType="RelativeToBandHeight"/>
       
  1163 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1164 					<textElement>
       
  1165 						<font/>
       
  1166 					</textElement>
       
  1167 				<textFieldExpression   class="java.lang.String"><![CDATA[$F{NIVEL3}]]></textFieldExpression>
       
  1168 				</textField>
       
  1169 				<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1170 					<reportElement
       
  1171 						style="Level3_Line"
       
  1172 						x="580"
       
  1173 						y="0"
       
  1174 						width="20"
       
  1175 						height="18"
       
  1176 						key="textField"
       
  1177 						stretchType="RelativeToBandHeight">
       
  1178 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=3)]]></printWhenExpression>
       
  1179 						</reportElement>
       
  1180 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1181 					<textElement>
       
  1182 						<font/>
       
  1183 					</textElement>
       
  1184 				<textFieldExpression   class="java.lang.String"><![CDATA[$F{UOMSYMBOL}]]></textFieldExpression>
       
  1185 				</textField>
       
  1186 				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL3"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1187 					<reportElement
       
  1188 						style="Level3_Line"
       
  1189 						x="520"
       
  1190 						y="0"
       
  1191 						width="60"
       
  1192 						height="18"
       
  1193 						key="textField"
       
  1194 						stretchType="RelativeToBandHeight">
       
  1195 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=3)]]></printWhenExpression>
       
  1196 						</reportElement>
       
  1197 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1198 					<textElement textAlignment="Right">
       
  1199 						<font/>
       
  1200 					</textElement>
       
  1201 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{QTY_SUM3}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM3}):new String(" ")]]></textFieldExpression>
       
  1202 				</textField>
       
  1203 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL3"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1204 					<reportElement
       
  1205 						style="Level3_Line"
       
  1206 						x="307"
       
  1207 						y="0"
       
  1208 						width="83"
       
  1209 						height="18"
       
  1210 						key="textField"
       
  1211 						stretchType="RelativeToBandHeight"/>
       
  1212 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1213 					<textElement textAlignment="Right">
       
  1214 						<font/>
       
  1215 					</textElement>
       
  1216 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{AMOUNT_SUM3}!=null)?$P{NUMBERFORMAT}.format($V{AMOUNT_SUM3}):new String(" ")]]></textFieldExpression>
       
  1217 				</textField>
       
  1218 				<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Group" evaluationGroup="NIVEL3"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1219 					<reportElement
       
  1220 						style="Level3_Line"
       
  1221 						x="660"
       
  1222 						y="0"
       
  1223 						width="20"
       
  1224 						height="18"
       
  1225 						key="textField-4"
       
  1226 						stretchType="RelativeToBandHeight">
       
  1227 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=3)]]></printWhenExpression>
       
  1228 						</reportElement>
       
  1229 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1230 					<textElement>
       
  1231 						<font/>
       
  1232 					</textElement>
       
  1233 				<textFieldExpression   class="java.lang.String"><![CDATA[$F{UOMSYMBOL}]]></textFieldExpression>
       
  1234 				</textField>
       
  1235 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL3"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1236 					<reportElement
       
  1237 						style="Level3_Line"
       
  1238 						x="390"
       
  1239 						y="0"
       
  1240 						width="80"
       
  1241 						height="18"
       
  1242 						key="textField"
       
  1243 						stretchType="RelativeToBandHeight"/>
       
  1244 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1245 					<textElement textAlignment="Right">
       
  1246 						<font/>
       
  1247 					</textElement>
       
  1248 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{AMOUNTREF_SUM3}!=null)?$P{NUMBERFORMAT}.format($V{AMOUNTREF_SUM3}):new String(" ")]]></textFieldExpression>
       
  1249 				</textField>
       
  1250 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL3"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1251 					<reportElement
       
  1252 						style="Level3_Line"
       
  1253 						x="600"
       
  1254 						y="0"
       
  1255 						width="60"
       
  1256 						height="18"
       
  1257 						key="textField"
       
  1258 						stretchType="RelativeToBandHeight">
       
  1259 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=3)]]></printWhenExpression>
       
  1260 						</reportElement>
       
  1261 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1262 					<textElement textAlignment="Right">
       
  1263 						<font/>
       
  1264 					</textElement>
       
  1265 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{QTYREF_SUM3}!=null)?$P{NUMBERFORMAT}.format($V{QTYREF_SUM3}):new String(" ")]]></textFieldExpression>
       
  1266 				</textField>
       
  1267 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL3"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1268 					<reportElement
       
  1269 						style="Level3_Line"
       
  1270 						x="470"
       
  1271 						y="0"
       
  1272 						width="50"
       
  1273 						height="18"
       
  1274 						key="textField-7"
       
  1275 						stretchType="RelativeToBandHeight"/>
       
  1276 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1277 					<textElement textAlignment="Right">
       
  1278 						<font/>
       
  1279 					</textElement>
       
  1280 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{AMT_PCT_3}!=null)?$P{NUMBERFORMAT}.format($V{AMT_PCT_3}):new String(" ")]]></textFieldExpression>
       
  1281 				</textField>
       
  1282 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL3"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1283 					<reportElement
       
  1284 						style="Level3_Line"
       
  1285 						x="680"
       
  1286 						y="0"
       
  1287 						width="50"
       
  1288 						height="18"
       
  1289 						key="textField"
       
  1290 						stretchType="RelativeToBandHeight">
       
  1291 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=3)]]></printWhenExpression>
       
  1292 						</reportElement>
       
  1293 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1294 					<textElement textAlignment="Right">
       
  1295 						<font/>
       
  1296 					</textElement>
       
  1297 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{QTY_PCT_3}!=null)?$P{NUMBERFORMAT}.format($V{QTY_PCT_3}):new String(" ")]]></textFieldExpression>
       
  1298 				</textField>
       
  1299 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1300 					<reportElement
       
  1301 						style="Level1_Line"
       
  1302 						x="0"
       
  1303 						y="0"
       
  1304 						width="15"
       
  1305 						height="18"
       
  1306 						key="textField-27"
       
  1307 						stretchType="RelativeToBandHeight"/>
       
  1308 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1309 					<textElement rotation="None">
       
  1310 						<font/>
       
  1311 					</textElement>
       
  1312 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
  1313 				</textField>
       
  1314 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1315 					<reportElement
       
  1316 						style="Level2_Line"
       
  1317 						x="15"
       
  1318 						y="0"
       
  1319 						width="15"
       
  1320 						height="18"
       
  1321 						key="textField-32"
       
  1322 						stretchType="RelativeToBandHeight"/>
       
  1323 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1324 					<textElement rotation="None">
       
  1325 						<font/>
       
  1326 					</textElement>
       
  1327 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
  1328 				</textField>
       
  1329 			</band>
       
  1330 			</groupHeader>
       
  1331 			<groupFooter>
       
  1332 			<band height="5"  isSplitAllowed="true" >
       
  1333 				<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()==4)]]></printWhenExpression>
       
  1334 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1335 					<reportElement
       
  1336 						style="Level1_Line"
       
  1337 						mode="Opaque"
       
  1338 						x="0"
       
  1339 						y="0"
       
  1340 						width="15"
       
  1341 						height="5"
       
  1342 						key="textField-52"
       
  1343 						stretchType="RelativeToBandHeight">
       
  1344 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=2)]]></printWhenExpression>
       
  1345 						</reportElement>
       
  1346 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1347 					<textElement rotation="None">
       
  1348 						<font/>
       
  1349 					</textElement>
       
  1350 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
  1351 				</textField>
       
  1352 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1353 					<reportElement
       
  1354 						style="Level3_Line"
       
  1355 						mode="Opaque"
       
  1356 						x="30"
       
  1357 						y="0"
       
  1358 						width="15"
       
  1359 						height="5"
       
  1360 						key="textField-53"
       
  1361 						stretchType="RelativeToBandHeight">
       
  1362 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=4)]]></printWhenExpression>
       
  1363 						</reportElement>
       
  1364 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1365 					<textElement rotation="None">
       
  1366 						<font/>
       
  1367 					</textElement>
       
  1368 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
  1369 				</textField>
       
  1370 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1371 					<reportElement
       
  1372 						style="Level2_Line"
       
  1373 						mode="Opaque"
       
  1374 						x="15"
       
  1375 						y="0"
       
  1376 						width="15"
       
  1377 						height="5"
       
  1378 						key="textField-54"
       
  1379 						stretchType="RelativeToBandHeight">
       
  1380 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=3)]]></printWhenExpression>
       
  1381 						</reportElement>
       
  1382 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1383 					<textElement rotation="None">
       
  1384 						<font/>
       
  1385 					</textElement>
       
  1386 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
  1387 				</textField>
       
  1388 				<line direction="TopDown">
       
  1389 					<reportElement
       
  1390 						style="Detail_Border"
       
  1391 						x="45"
       
  1392 						y="0"
       
  1393 						width="685"
       
  1394 						height="0"
       
  1395 						key="line-8">
       
  1396 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()==4)]]></printWhenExpression>
       
  1397 						</reportElement>
       
  1398 					<graphicElement stretchType="NoStretch"/>
       
  1399 				</line>
       
  1400 			</band>
       
  1401 			</groupFooter>
       
  1402 		</group>
       
  1403 		<group  name="NIVEL4" >
       
  1404 			<groupExpression><![CDATA[$F{NIVEL4}]]></groupExpression>
       
  1405 			<groupHeader>
       
  1406 			<band height="18"  isSplitAllowed="true" >
       
  1407 				<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=4)]]></printWhenExpression>
       
  1408 				<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1409 					<reportElement
       
  1410 						style="Level4_Line"
       
  1411 						x="45"
       
  1412 						y="0"
       
  1413 						width="262"
       
  1414 						height="18"
       
  1415 						key="textField"
       
  1416 						stretchType="RelativeToBandHeight"/>
       
  1417 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1418 					<textElement>
       
  1419 						<font/>
       
  1420 					</textElement>
       
  1421 				<textFieldExpression   class="java.lang.String"><![CDATA[$F{NIVEL4}]]></textFieldExpression>
       
  1422 				</textField>
       
  1423 				<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Group" evaluationGroup="NIVEL4"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1424 					<reportElement
       
  1425 						style="Level4_Line"
       
  1426 						x="580"
       
  1427 						y="0"
       
  1428 						width="20"
       
  1429 						height="18"
       
  1430 						key="textField"
       
  1431 						stretchType="RelativeToBandHeight">
       
  1432 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=4)]]></printWhenExpression>
       
  1433 						</reportElement>
       
  1434 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1435 					<textElement>
       
  1436 						<font/>
       
  1437 					</textElement>
       
  1438 				<textFieldExpression   class="java.lang.String"><![CDATA[$F{UOMSYMBOL}]]></textFieldExpression>
       
  1439 				</textField>
       
  1440 				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL4"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1441 					<reportElement
       
  1442 						style="Level4_Line"
       
  1443 						x="520"
       
  1444 						y="0"
       
  1445 						width="60"
       
  1446 						height="18"
       
  1447 						key="textField"
       
  1448 						stretchType="RelativeToBandHeight">
       
  1449 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=4)]]></printWhenExpression>
       
  1450 						</reportElement>
       
  1451 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1452 					<textElement textAlignment="Right">
       
  1453 						<font/>
       
  1454 					</textElement>
       
  1455 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{QTY_SUM4}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM4}):new String(" ")]]></textFieldExpression>
       
  1456 				</textField>
       
  1457 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL4"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1458 					<reportElement
       
  1459 						style="Level4_Line"
       
  1460 						x="307"
       
  1461 						y="0"
       
  1462 						width="83"
       
  1463 						height="18"
       
  1464 						key="textField"
       
  1465 						stretchType="RelativeToBandHeight"/>
       
  1466 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1467 					<textElement textAlignment="Right">
       
  1468 						<font/>
       
  1469 					</textElement>
       
  1470 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{AMOUNT_SUM4}!=null)?$P{NUMBERFORMAT}.format($V{AMOUNT_SUM4}):new String(" ")]]></textFieldExpression>
       
  1471 				</textField>
       
  1472 				<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Group" evaluationGroup="NIVEL4"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1473 					<reportElement
       
  1474 						style="Level4_Line"
       
  1475 						x="660"
       
  1476 						y="0"
       
  1477 						width="20"
       
  1478 						height="18"
       
  1479 						key="textField-5"
       
  1480 						stretchType="RelativeToBandHeight">
       
  1481 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=4)]]></printWhenExpression>
       
  1482 						</reportElement>
       
  1483 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1484 					<textElement>
       
  1485 						<font/>
       
  1486 					</textElement>
       
  1487 				<textFieldExpression   class="java.lang.String"><![CDATA[$F{UOMSYMBOL}]]></textFieldExpression>
       
  1488 				</textField>
       
  1489 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL4"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1490 					<reportElement
       
  1491 						style="Level4_Line"
       
  1492 						x="390"
       
  1493 						y="0"
       
  1494 						width="80"
       
  1495 						height="18"
       
  1496 						key="textField"
       
  1497 						stretchType="RelativeToBandHeight"/>
       
  1498 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1499 					<textElement textAlignment="Right">
       
  1500 						<font/>
       
  1501 					</textElement>
       
  1502 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{AMOUNTREF_SUM4}!=null)?$P{NUMBERFORMAT}.format($V{AMOUNTREF_SUM4}):new String(" ")]]></textFieldExpression>
       
  1503 				</textField>
       
  1504 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL4"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1505 					<reportElement
       
  1506 						style="Level4_Line"
       
  1507 						x="600"
       
  1508 						y="0"
       
  1509 						width="60"
       
  1510 						height="18"
       
  1511 						key="textField"
       
  1512 						stretchType="RelativeToBandHeight">
       
  1513 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=4)]]></printWhenExpression>
       
  1514 						</reportElement>
       
  1515 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1516 					<textElement textAlignment="Right">
       
  1517 						<font/>
       
  1518 					</textElement>
       
  1519 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{QTYREF_SUM4}!=null)?$P{NUMBERFORMAT}.format($V{QTYREF_SUM4}):new String(" ")]]></textFieldExpression>
       
  1520 				</textField>
       
  1521 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL4"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1522 					<reportElement
       
  1523 						style="Level4_Line"
       
  1524 						x="470"
       
  1525 						y="0"
       
  1526 						width="50"
       
  1527 						height="18"
       
  1528 						key="textField-10"
       
  1529 						stretchType="RelativeToBandHeight"/>
       
  1530 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1531 					<textElement textAlignment="Right">
       
  1532 						<font/>
       
  1533 					</textElement>
       
  1534 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{AMT_PCT_4}!=null)?$P{NUMBERFORMAT}.format($V{AMT_PCT_4}):new String(" ")]]></textFieldExpression>
       
  1535 				</textField>
       
  1536 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="NIVEL4"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1537 					<reportElement
       
  1538 						style="Level4_Line"
       
  1539 						x="680"
       
  1540 						y="0"
       
  1541 						width="50"
       
  1542 						height="18"
       
  1543 						key="textField"
       
  1544 						stretchType="RelativeToBandHeight">
       
  1545 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=4)]]></printWhenExpression>
       
  1546 						</reportElement>
       
  1547 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1548 					<textElement textAlignment="Right">
       
  1549 						<font/>
       
  1550 					</textElement>
       
  1551 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{QTY_PCT_4}!=null)?$P{NUMBERFORMAT}.format($V{QTY_PCT_4}):new String(" ")]]></textFieldExpression>
       
  1552 				</textField>
       
  1553 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1554 					<reportElement
       
  1555 						style="Level1_Line"
       
  1556 						x="0"
       
  1557 						y="0"
       
  1558 						width="15"
       
  1559 						height="18"
       
  1560 						key="textField-28"
       
  1561 						stretchType="RelativeToBandHeight"/>
       
  1562 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1563 					<textElement rotation="None">
       
  1564 						<font/>
       
  1565 					</textElement>
       
  1566 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
  1567 				</textField>
       
  1568 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1569 					<reportElement
       
  1570 						style="Level3_Line"
       
  1571 						x="30"
       
  1572 						y="0"
       
  1573 						width="15"
       
  1574 						height="18"
       
  1575 						key="textField-30"
       
  1576 						stretchType="RelativeToBandHeight"/>
       
  1577 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1578 					<textElement rotation="None">
       
  1579 						<font/>
       
  1580 					</textElement>
       
  1581 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
  1582 				</textField>
       
  1583 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1584 					<reportElement
       
  1585 						style="Level2_Line"
       
  1586 						x="15"
       
  1587 						y="0"
       
  1588 						width="15"
       
  1589 						height="18"
       
  1590 						key="textField-33"
       
  1591 						stretchType="RelativeToBandHeight"/>
       
  1592 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1593 					<textElement rotation="None">
       
  1594 						<font/>
       
  1595 					</textElement>
       
  1596 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
  1597 				</textField>
       
  1598 			</band>
       
  1599 			</groupHeader>
       
  1600 			<groupFooter>
       
  1601 			<band height="5"  isSplitAllowed="true" >
       
  1602 				<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()==5)]]></printWhenExpression>
       
  1603 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1604 					<reportElement
       
  1605 						style="Level1_Line"
       
  1606 						mode="Opaque"
       
  1607 						x="0"
       
  1608 						y="0"
       
  1609 						width="15"
       
  1610 						height="5"
       
  1611 						key="textField-48"
       
  1612 						stretchType="RelativeToBandHeight">
       
  1613 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=2)]]></printWhenExpression>
       
  1614 						</reportElement>
       
  1615 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1616 					<textElement rotation="None">
       
  1617 						<font/>
       
  1618 					</textElement>
       
  1619 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
  1620 				</textField>
       
  1621 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1622 					<reportElement
       
  1623 						style="Level3_Line"
       
  1624 						mode="Opaque"
       
  1625 						x="30"
       
  1626 						y="0"
       
  1627 						width="15"
       
  1628 						height="5"
       
  1629 						key="textField-49"
       
  1630 						stretchType="RelativeToBandHeight">
       
  1631 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=4)]]></printWhenExpression>
       
  1632 						</reportElement>
       
  1633 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1634 					<textElement rotation="None">
       
  1635 						<font/>
       
  1636 					</textElement>
       
  1637 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
  1638 				</textField>
       
  1639 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1640 					<reportElement
       
  1641 						style="Level2_Line"
       
  1642 						mode="Opaque"
       
  1643 						x="15"
       
  1644 						y="0"
       
  1645 						width="15"
       
  1646 						height="5"
       
  1647 						key="textField-50"
       
  1648 						stretchType="RelativeToBandHeight">
       
  1649 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=3)]]></printWhenExpression>
       
  1650 						</reportElement>
       
  1651 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1652 					<textElement rotation="None">
       
  1653 						<font/>
       
  1654 					</textElement>
       
  1655 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
  1656 				</textField>
       
  1657 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1658 					<reportElement
       
  1659 						style="Level4_Line"
       
  1660 						mode="Opaque"
       
  1661 						x="45"
       
  1662 						y="0"
       
  1663 						width="15"
       
  1664 						height="5"
       
  1665 						key="textField-51"
       
  1666 						stretchType="RelativeToBandHeight">
       
  1667 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=5)]]></printWhenExpression>
       
  1668 						</reportElement>
       
  1669 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1670 					<textElement rotation="None">
       
  1671 						<font/>
       
  1672 					</textElement>
       
  1673 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
  1674 				</textField>
       
  1675 				<line direction="TopDown">
       
  1676 					<reportElement
       
  1677 						style="Detail_Border"
       
  1678 						x="60"
       
  1679 						y="0"
       
  1680 						width="670"
       
  1681 						height="0"
       
  1682 						key="line-9">
       
  1683 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()==4)]]></printWhenExpression>
       
  1684 						</reportElement>
       
  1685 					<graphicElement stretchType="NoStretch"/>
       
  1686 				</line>
       
  1687 			</band>
       
  1688 			</groupFooter>
       
  1689 		</group>
       
  1690 		<group  name="LEVEL5" >
       
  1691 			<groupExpression><![CDATA[$F{NIVEL5}]]></groupExpression>
       
  1692 			<groupHeader>
       
  1693 			<band height="18"  isSplitAllowed="true" >
       
  1694 				<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=5)]]></printWhenExpression>
       
  1695 				<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1696 					<reportElement
       
  1697 						style="Level5_Line"
       
  1698 						x="60"
       
  1699 						y="0"
       
  1700 						width="247"
       
  1701 						height="18"
       
  1702 						key="textField"
       
  1703 						stretchType="RelativeToBandHeight"/>
       
  1704 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1705 					<textElement>
       
  1706 						<font/>
       
  1707 					</textElement>
       
  1708 				<textFieldExpression   class="java.lang.String"><![CDATA[$F{NIVEL5}]]></textFieldExpression>
       
  1709 				</textField>
       
  1710 				<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Group" evaluationGroup="LEVEL5"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1711 					<reportElement
       
  1712 						style="Level5_Line"
       
  1713 						x="580"
       
  1714 						y="0"
       
  1715 						width="20"
       
  1716 						height="18"
       
  1717 						key="textField"
       
  1718 						stretchType="RelativeToBandHeight">
       
  1719 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=5)]]></printWhenExpression>
       
  1720 						</reportElement>
       
  1721 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1722 					<textElement>
       
  1723 						<font/>
       
  1724 					</textElement>
       
  1725 				<textFieldExpression   class="java.lang.String"><![CDATA[$F{UOMSYMBOL}]]></textFieldExpression>
       
  1726 				</textField>
       
  1727 				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="LEVEL5"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1728 					<reportElement
       
  1729 						style="Level5_Line"
       
  1730 						x="520"
       
  1731 						y="0"
       
  1732 						width="60"
       
  1733 						height="18"
       
  1734 						key="textField"
       
  1735 						stretchType="RelativeToBandHeight">
       
  1736 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=5)]]></printWhenExpression>
       
  1737 						</reportElement>
       
  1738 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1739 					<textElement textAlignment="Right">
       
  1740 						<font/>
       
  1741 					</textElement>
       
  1742 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{QTY_SUM5}!=null)?$P{NUMBERFORMAT}.format($V{QTY_SUM5}):new String(" ")]]></textFieldExpression>
       
  1743 				</textField>
       
  1744 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="LEVEL5"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1745 					<reportElement
       
  1746 						style="Level5_Line"
       
  1747 						x="307"
       
  1748 						y="0"
       
  1749 						width="83"
       
  1750 						height="18"
       
  1751 						key="textField"
       
  1752 						stretchType="RelativeToBandHeight"/>
       
  1753 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1754 					<textElement textAlignment="Right">
       
  1755 						<font/>
       
  1756 					</textElement>
       
  1757 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{AMOUNT_SUM5}!=null)?$P{NUMBERFORMAT}.format($V{AMOUNT_SUM5}):new String(" ")]]></textFieldExpression>
       
  1758 				</textField>
       
  1759 				<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Group" evaluationGroup="LEVEL5"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1760 					<reportElement
       
  1761 						style="Level5_Line"
       
  1762 						x="660"
       
  1763 						y="0"
       
  1764 						width="20"
       
  1765 						height="18"
       
  1766 						key="textField-6"
       
  1767 						stretchType="RelativeToBandHeight">
       
  1768 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=5)]]></printWhenExpression>
       
  1769 						</reportElement>
       
  1770 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1771 					<textElement>
       
  1772 						<font/>
       
  1773 					</textElement>
       
  1774 				<textFieldExpression   class="java.lang.String"><![CDATA[$F{UOMSYMBOL}]]></textFieldExpression>
       
  1775 				</textField>
       
  1776 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="LEVEL5"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1777 					<reportElement
       
  1778 						style="Level5_Line"
       
  1779 						x="390"
       
  1780 						y="0"
       
  1781 						width="80"
       
  1782 						height="18"
       
  1783 						key="textField"
       
  1784 						stretchType="RelativeToBandHeight"/>
       
  1785 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1786 					<textElement textAlignment="Right">
       
  1787 						<font/>
       
  1788 					</textElement>
       
  1789 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{AMOUNTREF_SUM5}!=null)?$P{NUMBERFORMAT}.format($V{AMOUNTREF_SUM5}):new String(" ")]]></textFieldExpression>
       
  1790 				</textField>
       
  1791 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="LEVEL5"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1792 					<reportElement
       
  1793 						style="Level5_Line"
       
  1794 						x="600"
       
  1795 						y="0"
       
  1796 						width="60"
       
  1797 						height="18"
       
  1798 						key="textField"
       
  1799 						stretchType="RelativeToBandHeight">
       
  1800 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=5)]]></printWhenExpression>
       
  1801 						</reportElement>
       
  1802 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1803 					<textElement textAlignment="Right">
       
  1804 						<font/>
       
  1805 					</textElement>
       
  1806 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{QTYREF_SUM5}!=null)?$P{NUMBERFORMAT}.format($V{QTYREF_SUM5}):new String(" ")]]></textFieldExpression>
       
  1807 				</textField>
       
  1808 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="LEVEL5"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1809 					<reportElement
       
  1810 						style="Level5_Line"
       
  1811 						x="470"
       
  1812 						y="0"
       
  1813 						width="50"
       
  1814 						height="18"
       
  1815 						key="textField"
       
  1816 						stretchType="RelativeToBandHeight"/>
       
  1817 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1818 					<textElement textAlignment="Right">
       
  1819 						<font/>
       
  1820 					</textElement>
       
  1821 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{AMT_PCT_5}!=null)?$P{NUMBERFORMAT}.format($V{AMT_PCT_5}):new String(" ")]]></textFieldExpression>
       
  1822 				</textField>
       
  1823 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Group" evaluationGroup="LEVEL5"  hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1824 					<reportElement
       
  1825 						style="Level5_Line"
       
  1826 						x="680"
       
  1827 						y="0"
       
  1828 						width="50"
       
  1829 						height="18"
       
  1830 						key="textField"
       
  1831 						stretchType="RelativeToBandHeight">
       
  1832 							<printWhenExpression><![CDATA[new Boolean($P{PRODUCT_LEVEL}.intValue()<=5)]]></printWhenExpression>
       
  1833 						</reportElement>
       
  1834 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="Thin" rightBorderColor="#999999" rightPadding="2" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1835 					<textElement textAlignment="Right">
       
  1836 						<font/>
       
  1837 					</textElement>
       
  1838 				<textFieldExpression   class="java.lang.String"><![CDATA[($V{QTY_PCT_5}!=null)?$P{NUMBERFORMAT}.format($V{QTY_PCT_5}):new String(" ")]]></textFieldExpression>
       
  1839 				</textField>
       
  1840 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1841 					<reportElement
       
  1842 						style="Level1_Line"
       
  1843 						x="0"
       
  1844 						y="0"
       
  1845 						width="15"
       
  1846 						height="18"
       
  1847 						key="textField-29"
       
  1848 						stretchType="RelativeToBandHeight"/>
       
  1849 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1850 					<textElement rotation="None">
       
  1851 						<font/>
       
  1852 					</textElement>
       
  1853 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
  1854 				</textField>
       
  1855 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1856 					<reportElement
       
  1857 						style="Level3_Line"
       
  1858 						x="30"
       
  1859 						y="0"
       
  1860 						width="15"
       
  1861 						height="18"
       
  1862 						key="textField-31"
       
  1863 						stretchType="RelativeToBandHeight"/>
       
  1864 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1865 					<textElement rotation="None">
       
  1866 						<font/>
       
  1867 					</textElement>
       
  1868 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
  1869 				</textField>
       
  1870 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1871 					<reportElement
       
  1872 						style="Level2_Line"
       
  1873 						x="15"
       
  1874 						y="0"
       
  1875 						width="15"
       
  1876 						height="18"
       
  1877 						key="textField-34"
       
  1878 						stretchType="RelativeToBandHeight"/>
       
  1879 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1880 					<textElement rotation="None">
       
  1881 						<font/>
       
  1882 					</textElement>
       
  1883 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
  1884 				</textField>
       
  1885 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1886 					<reportElement
       
  1887 						style="Level4_Line"
       
  1888 						x="45"
       
  1889 						y="0"
       
  1890 						width="15"
       
  1891 						height="18"
       
  1892 						key="textField-35"
       
  1893 						stretchType="RelativeToBandHeight"/>
       
  1894 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1895 					<textElement rotation="None">
       
  1896 						<font/>
       
  1897 					</textElement>
       
  1898 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
  1899 				</textField>
       
  1900 			</band>
       
  1901 			</groupHeader>
       
  1902 			<groupFooter>
       
  1903 			<band height="5"  isSplitAllowed="true" >
       
  1904 				<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()==6)]]></printWhenExpression>
       
  1905 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1906 					<reportElement
       
  1907 						style="Level1_Line"
       
  1908 						mode="Opaque"
       
  1909 						x="0"
       
  1910 						y="0"
       
  1911 						width="15"
       
  1912 						height="5"
       
  1913 						key="textField-44"
       
  1914 						stretchType="RelativeToBandHeight">
       
  1915 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=2)]]></printWhenExpression>
       
  1916 						</reportElement>
       
  1917 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1918 					<textElement rotation="None">
       
  1919 						<font/>
       
  1920 					</textElement>
       
  1921 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
  1922 				</textField>
       
  1923 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1924 					<reportElement
       
  1925 						style="Level3_Line"
       
  1926 						mode="Opaque"
       
  1927 						x="30"
       
  1928 						y="0"
       
  1929 						width="15"
       
  1930 						height="5"
       
  1931 						key="textField-45"
       
  1932 						stretchType="RelativeToBandHeight">
       
  1933 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=4)]]></printWhenExpression>
       
  1934 						</reportElement>
       
  1935 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1936 					<textElement rotation="None">
       
  1937 						<font/>
       
  1938 					</textElement>
       
  1939 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
  1940 				</textField>
       
  1941 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1942 					<reportElement
       
  1943 						style="Level2_Line"
       
  1944 						mode="Opaque"
       
  1945 						x="15"
       
  1946 						y="0"
       
  1947 						width="15"
       
  1948 						height="5"
       
  1949 						key="textField-46"
       
  1950 						stretchType="RelativeToBandHeight">
       
  1951 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=3)]]></printWhenExpression>
       
  1952 						</reportElement>
       
  1953 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1954 					<textElement rotation="None">
       
  1955 						<font/>
       
  1956 					</textElement>
       
  1957 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
  1958 				</textField>
       
  1959 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  1960 					<reportElement
       
  1961 						style="Level4_Line"
       
  1962 						mode="Opaque"
       
  1963 						x="45"
       
  1964 						y="0"
       
  1965 						width="15"
       
  1966 						height="5"
       
  1967 						key="textField-47"
       
  1968 						stretchType="RelativeToBandHeight">
       
  1969 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()>=5)]]></printWhenExpression>
       
  1970 						</reportElement>
       
  1971 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  1972 					<textElement rotation="None">
       
  1973 						<font/>
       
  1974 					</textElement>
       
  1975 				<textFieldExpression   class="java.lang.String"><![CDATA[]]></textFieldExpression>
       
  1976 				</textField>
       
  1977 				<line direction="TopDown">
       
  1978 					<reportElement
       
  1979 						style="Detail_Border"
       
  1980 						x="75"
       
  1981 						y="0"
       
  1982 						width="655"
       
  1983 						height="0"
       
  1984 						key="line-10">
       
  1985 							<printWhenExpression><![CDATA[new Boolean($P{DIMENSIONS}.intValue()==4)]]></printWhenExpression>
       
  1986 						</reportElement>
       
  1987 					<graphicElement stretchType="NoStretch"/>
       
  1988 				</line>
       
  1989 			</band>
       
  1990 			</groupFooter>
       
  1991 		</group>
       
  1992 		<background>
       
  1993 			<band height="11"  isSplitAllowed="true" >
       
  1994 			</band>
       
  1995 		</background>
       
  1996 		<title>
       
  1997 			<band height="109"  isSplitAllowed="true" >
       
  1998 				<frame>					<reportElement
       
  1999 						mode="Opaque"
       
  2000 						x="0"
       
  2001 						y="90"
       
  2002 						width="730"
       
  2003 						height="19"
       
  2004 						backcolor="#5D5D5D"
       
  2005 						key="frame-1"/>
       
  2006 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  2007 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  2008 					<reportElement
       
  2009 						style="Detail_Header"
       
  2010 						mode="Transparent"
       
  2011 						x="0"
       
  2012 						y="0"
       
  2013 						width="15"
       
  2014 						height="19"
       
  2015 						key="textField-18"/>
       
  2016 					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#FFFFFF" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  2017 					<textElement rotation="None">
       
  2018 						<font/>
       
  2019 					</textElement>
       
  2020 				<textFieldExpression   class="java.lang.String"><![CDATA[(($P{DIMENSIONS}.compareTo(new Integer(1))>=0)?"1":"")]]></textFieldExpression>
       
  2021 				</textField>
       
  2022 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  2023 					<reportElement
       
  2024 						style="Detail_Header"
       
  2025 						mode="Transparent"
       
  2026 						x="15"
       
  2027 						y="0"
       
  2028 						width="15"
       
  2029 						height="19"
       
  2030 						key="textField-19"/>
       
  2031 					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#FFFFFF" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  2032 					<textElement rotation="None">
       
  2033 						<font/>
       
  2034 					</textElement>
       
  2035 				<textFieldExpression   class="java.lang.String"><![CDATA[(($P{DIMENSIONS}.compareTo(new Integer(2))>=0)?"2":"")]]></textFieldExpression>
       
  2036 				</textField>
       
  2037 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  2038 					<reportElement
       
  2039 						style="Detail_Header"
       
  2040 						mode="Transparent"
       
  2041 						x="30"
       
  2042 						y="0"
       
  2043 						width="15"
       
  2044 						height="19"
       
  2045 						key="textField-20"/>
       
  2046 					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#FFFFFF" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  2047 					<textElement rotation="None">
       
  2048 						<font/>
       
  2049 					</textElement>
       
  2050 				<textFieldExpression   class="java.lang.String"><![CDATA[(($P{DIMENSIONS}.compareTo(new Integer(3))>=0)?"3":"")]]></textFieldExpression>
       
  2051 				</textField>
       
  2052 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  2053 					<reportElement
       
  2054 						style="Detail_Header"
       
  2055 						mode="Transparent"
       
  2056 						x="45"
       
  2057 						y="0"
       
  2058 						width="15"
       
  2059 						height="19"
       
  2060 						key="textField-21"/>
       
  2061 					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#FFFFFF" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  2062 					<textElement rotation="None">
       
  2063 						<font/>
       
  2064 					</textElement>
       
  2065 				<textFieldExpression   class="java.lang.String"><![CDATA[(($P{DIMENSIONS}.compareTo(new Integer(4))>=0)?"4":"")]]></textFieldExpression>
       
  2066 				</textField>
       
  2067 				<textField isStretchWithOverflow="false" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  2068 					<reportElement
       
  2069 						style="Detail_Header"
       
  2070 						mode="Transparent"
       
  2071 						x="60"
       
  2072 						y="0"
       
  2073 						width="15"
       
  2074 						height="19"
       
  2075 						key="textField-22"/>
       
  2076 					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#FFFFFF" rightBorder="Thin" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
       
  2077 					<textElement rotation="None">
       
  2078 						<font/>
       
  2079 					</textElement>
       
  2080 				<textFieldExpression   class="java.lang.String"><![CDATA[(($P{DIMENSIONS}.compareTo(new Integer(5))>=0)?"5":"")]]></textFieldExpression>
       
  2081 				</textField>
       
  2082 				<staticText>
       
  2083 					<reportElement
       
  2084 						style="Detail_Header"
       
  2085 						mode="Opaque"
       
  2086 						x="307"
       
  2087 						y="0"
       
  2088 						width="83"
       
  2089 						height="19"
       
  2090 						key="staticText-10"/>
       
  2091 					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#FFFFFF" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  2092 					<textElement textAlignment="Right">
       
  2093 						<font pdfFontName="Helvetica-Bold"/>
       
  2094 					</textElement>
       
  2095 				<text><![CDATA[Amount]]></text>
       
  2096 				</staticText>
       
  2097 				<staticText>
       
  2098 					<reportElement
       
  2099 						style="Detail_Header"
       
  2100 						mode="Opaque"
       
  2101 						x="390"
       
  2102 						y="0"
       
  2103 						width="80"
       
  2104 						height="19"
       
  2105 						key="staticText-11"/>
       
  2106 					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#FFFFFF" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  2107 					<textElement textAlignment="Right">
       
  2108 						<font pdfFontName="Helvetica-Bold"/>
       
  2109 					</textElement>
       
  2110 				<text><![CDATA[Amt. Ref.]]></text>
       
  2111 				</staticText>
       
  2112 				<staticText>
       
  2113 					<reportElement
       
  2114 						style="Detail_Header"
       
  2115 						mode="Opaque"
       
  2116 						x="470"
       
  2117 						y="0"
       
  2118 						width="50"
       
  2119 						height="19"
       
  2120 						key="staticText-12"/>
       
  2121 					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#FFFFFF" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  2122 					<textElement textAlignment="Right">
       
  2123 						<font pdfFontName="Helvetica-Bold"/>
       
  2124 					</textElement>
       
  2125 				<text><![CDATA[A %]]></text>
       
  2126 				</staticText>
       
  2127 				<staticText>
       
  2128 					<reportElement
       
  2129 						style="Detail_Header"
       
  2130 						mode="Opaque"
       
  2131 						x="520"
       
  2132 						y="0"
       
  2133 						width="80"
       
  2134 						height="19"
       
  2135 						key="staticText-13"/>
       
  2136 					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#FFFFFF" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  2137 					<textElement textAlignment="Right">
       
  2138 						<font pdfFontName="Helvetica-Bold"/>
       
  2139 					</textElement>
       
  2140 				<text><![CDATA[Quantity]]></text>
       
  2141 				</staticText>
       
  2142 				<staticText>
       
  2143 					<reportElement
       
  2144 						style="Detail_Header"
       
  2145 						mode="Opaque"
       
  2146 						x="600"
       
  2147 						y="0"
       
  2148 						width="80"
       
  2149 						height="19"
       
  2150 						key="staticText-14"/>
       
  2151 					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#FFFFFF" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  2152 					<textElement textAlignment="Right">
       
  2153 						<font pdfFontName="Helvetica-Bold"/>
       
  2154 					</textElement>
       
  2155 				<text><![CDATA[Qty. Ref.]]></text>
       
  2156 				</staticText>
       
  2157 				<staticText>
       
  2158 					<reportElement
       
  2159 						style="Detail_Header"
       
  2160 						mode="Opaque"
       
  2161 						x="680"
       
  2162 						y="0"
       
  2163 						width="50"
       
  2164 						height="19"
       
  2165 						key="staticText-15"/>
       
  2166 					<box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#FFFFFF" rightBorder="Thin" rightBorderColor="#FFFFFF" bottomBorder="None" bottomBorderColor="#000000"/>
       
  2167 					<textElement textAlignment="Right">
       
  2168 						<font pdfFontName="Helvetica-Bold"/>
       
  2169 					</textElement>
       
  2170 				<text><![CDATA[Q %]]></text>
       
  2171 				</staticText>
       
  2172 				</frame>				<textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  2173 					<reportElement
       
  2174 						style="Report_Title"
       
  2175 						x="0"
       
  2176 						y="0"
       
  2177 						width="730"
       
  2178 						height="26"
       
  2179 						key="textField"/>
       
  2180 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  2181 					<textElement>
       
  2182 						<font/>
       
  2183 					</textElement>
       
  2184 				<textFieldExpression   class="java.lang.String"><![CDATA[$P{REPORT_TITLE}]]></textFieldExpression>
       
  2185 				</textField>
       
  2186 				<textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  2187 					<reportElement
       
  2188 						style="Report_Subtitle"
       
  2189 						x="0"
       
  2190 						y="31"
       
  2191 						width="730"
       
  2192 						height="18"
       
  2193 						key="textField"/>
       
  2194 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  2195 					<textElement>
       
  2196 						<font/>
       
  2197 					</textElement>
       
  2198 				<textFieldExpression   class="java.lang.String"><![CDATA[$P{REPORT_SUBTITLE}]]></textFieldExpression>
       
  2199 				</textField>
       
  2200 				<line direction="TopDown">
       
  2201 					<reportElement
       
  2202 						x="0"
       
  2203 						y="26"
       
  2204 						width="730"
       
  2205 						height="0"
       
  2206 						key="line-1"/>
       
  2207 					<graphicElement stretchType="NoStretch"/>
       
  2208 				</line>
       
  2209 				<line direction="TopDown">
       
  2210 					<reportElement
       
  2211 						x="0"
       
  2212 						y="49"
       
  2213 						width="730"
       
  2214 						height="0"
       
  2215 						key="line-2"/>
       
  2216 					<graphicElement stretchType="NoStretch"/>
       
  2217 				</line>
       
  2218 				<staticText>
       
  2219 					<reportElement
       
  2220 						style="Report_Data_Label"
       
  2221 						x="0"
       
  2222 						y="54"
       
  2223 						width="114"
       
  2224 						height="16"
       
  2225 						key="staticText-9"/>
       
  2226 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  2227 					<textElement>
       
  2228 						<font/>
       
  2229 					</textElement>
       
  2230 				<text><![CDATA[Grouping Levels:]]></text>
       
  2231 				</staticText>
       
  2232 				<textField isStretchWithOverflow="true" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  2233 					<reportElement
       
  2234 						style="Report_Data_Field"
       
  2235 						x="114"
       
  2236 						y="54"
       
  2237 						width="616"
       
  2238 						height="16"
       
  2239 						key="textField-12"/>
       
  2240 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  2241 					<textElement>
       
  2242 						<font/>
       
  2243 					</textElement>
       
  2244 				<textFieldExpression   class="java.lang.String"><![CDATA[$P{LEVEL_LABEL}]]></textFieldExpression>
       
  2245 				</textField>
       
  2246 			</band>
       
  2247 		</title>
       
  2248 		<pageHeader>
       
  2249 			<band height="0"  isSplitAllowed="true" >
       
  2250 			</band>
       
  2251 		</pageHeader>
       
  2252 		<columnHeader>
       
  2253 			<band height="0"  isSplitAllowed="true" >
       
  2254 			</band>
       
  2255 		</columnHeader>
       
  2256 		<detail>
       
  2257 			<band height="0"  isSplitAllowed="true" >
       
  2258 			</band>
       
  2259 		</detail>
       
  2260 		<columnFooter>
       
  2261 			<band height="1"  isSplitAllowed="true" >
       
  2262 			</band>
       
  2263 		</columnFooter>
       
  2264 		<pageFooter>
       
  2265 			<band height="20"  isSplitAllowed="true" >
       
  2266 				<staticText>
       
  2267 					<reportElement
       
  2268 						style="Report_Footer"
       
  2269 						x="295"
       
  2270 						y="3"
       
  2271 						width="76"
       
  2272 						height="16"
       
  2273 						key="staticText-17"/>
       
  2274 					<box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  2275 					<textElement textAlignment="Right">
       
  2276 						<font/>
       
  2277 					</textElement>
       
  2278 				<text><![CDATA[Printed on ]]></text>
       
  2279 				</staticText>
       
  2280 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  2281 					<reportElement
       
  2282 						style="Report_Footer"
       
  2283 						x="597"
       
  2284 						y="4"
       
  2285 						width="95"
       
  2286 						height="16"
       
  2287 						key="textField-23"/>
       
  2288 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  2289 					<textElement textAlignment="Right" verticalAlignment="Middle">
       
  2290 						<font fontName="Helvetica" size="10"/>
       
  2291 					</textElement>
       
  2292 				<textFieldExpression   class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression>
       
  2293 				</textField>
       
  2294 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Report" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  2295 					<reportElement
       
  2296 						style="Report_Footer"
       
  2297 						x="694"
       
  2298 						y="4"
       
  2299 						width="36"
       
  2300 						height="16"
       
  2301 						forecolor="#000000"
       
  2302 						backcolor="#FFFFFF"
       
  2303 						key="textField-24"/>
       
  2304 					<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  2305 					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" lineSpacing="Single">
       
  2306 						<font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded ="false" pdfEncoding ="CP1252" isStrikeThrough="false" />
       
  2307 					</textElement>
       
  2308 				<textFieldExpression   class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>
       
  2309 				</textField>
       
  2310 				<textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None"  hyperlinkTarget="Self" >
       
  2311 					<reportElement
       
  2312 						style="Report_Footer"
       
  2313 						x="371"
       
  2314 						y="3"
       
  2315 						width="90"
       
  2316 						height="16"
       
  2317 						key="textField-25"/>
       
  2318 					<box topBorder="None" topBorderColor="#000000" topPadding="2" leftBorder="None" leftBorderColor="#000000" leftPadding="5" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
       
  2319 					<textElement>
       
  2320 						<font/>
       
  2321 					</textElement>
       
  2322 				<textFieldExpression   class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>
       
  2323 				</textField>
       
  2324 				<line direction="TopDown">
       
  2325 					<reportElement
       
  2326 						x="0"
       
  2327 						y="1"
       
  2328 						width="730"
       
  2329 						height="0"
       
  2330 						key="line-4"/>
       
  2331 					<graphicElement stretchType="NoStretch"/>
       
  2332 				</line>
       
  2333 			</band>
       
  2334 		</pageFooter>
       
  2335 		<summary>
       
  2336 			<band height="0"  isSplitAllowed="true" >
       
  2337 			</band>
       
  2338 		</summary>
       
  2339 </jasperReport>