<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="inf_devolutivo_individual_ter" pageWidth="1610" pageHeight="802" columnWidth="1610" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
	<property name="ireport.zoom" value="1.363636363636365"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/inventario/inf_devolutivo_individual"/>
	<property name="ireport.jasperserver.url" value="http://erp.comisiondelaverdad.co:8090/jasperserver/services/repository"/>
	<parameter name="vigencia" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_meses" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_mae_ter" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereCenOp" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTercero" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereEstructura" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereEspacio" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTipoAlmacenamiento" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereLinea" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereClase" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereCatalogo" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereCostoInicial" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="username" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select
*
from (

    select
    tab1.ID_VIGENCIA
    ,tab1.ID_MESES
    ,mes.descripcion as mes
    ,tab1.ID_INVENTARIO_DV
    ,tab1.ID_CEN_OP
    ,tab1.ID_ESPACIO
    ,tab1.ID_MAE_TER
    ,tab1.ID_TIPO_ALMACENAMIENTO
    ,tab1.ESTADO
    ,tab1.COSTO_ACTUAL
    ,tab0.FECHA_INGRESO
    ,tab0.ID_LINEA
    ,tab0.ID_CLASE
    ,tab0.ID_CATALOGO
    ,tab0.DESCRIPCION as desc_inv
    ,tab0.ESTADO as estado_inventario
    ,tab0.VIDA_UTIL as vida_util_inv
    ,tab0.DIAS_DEPRECIADOS
    ,tab0.FECHA_MOD
    ,tab2.CODIGO_ELEMENTO
    ,tab2.ID_CODIGO_ELEMENTO
    ,tab2.DIGITOS_CATALOGO
    ,tab2.DESC_CATALOGO
    ,tab2.DESC_CORTA_CATALOGO
    ,tab2.VIDA_UTIL_CATALOG
    ,tab2.STOCK_MIN
    ,tab2.STOCK_MAX
    ,tab2.VALOR_IVA
    ,tab2.TIENE_IVA
    ,tab2.ID_UNIDAD_MEDIDA
    ,tab2.ID_AGRUP_COMERCIAL
    ,tab2.ESTADO_CATALOGO
    ,tab2.MARCA
    ,tab2.MODELO
    ,tab2.CARACTERES
    ,tab2.DESC_CLASE
    ,tab2.DESC_CORTA_CLASE
    ,tab2.VIDA_UTIL_CLASE
    ,tab2.TIPO_INVENTARIO
    ,tab2.ID_TIPO_SEGURO
    ,tab2.ESTADO_CLASE
    ,tab2.DIGITOS_LINEA
    ,tab2.DESC_LINEA
    ,tab2.DESC_CORTA_LINEA
    ,tab2.ESTADO_LINEA
    ,tab3.DESCRIPCION as desc_espacio
    ,tab3.NIVEL
    ,tab3.COORDENADA_X as cood_x_espacio
    ,tab3.COORDENADA_Y as cood_y_espacio
    ,tab4.NOMBRE as nombre_estructura
    ,tab4.DIRECCION
    ,tab4.id_estructura
    ,tab5.PREFIJO
    ,tab6.NUM_DOC
    ,tab6.RAZON_SOC
    ,tab7.DESCRIPCION as desc_tipo_almacenamiento
    ,tab8.ID_PARTES_INVENTARIO
    ,tab8.SERIE
    ,tab8.PLAQUETA
    ,tab8.PLACA
    ,tab8.codigo_bar
    ,case when tab8.OBSERVACIONES is null then null else 'Observación: '||tab8.OBSERVACIONES end  as OBSERVACIONES
    ,tab9.NOMBRE
    ,tab9.DESCRIPCION as desc_partes_clase
    ,tab8.estado as estado_partes
    ,tab10.descripcion as desc_unidad_med
    ,tab10.desc_corta as desc_corta_unida_med
    , /*se toma nuevo costo inicial - 20191101*/ case
    when tab8.rn=1 or tab8.rn is null then tab0.nuevo_costo_inicial else 0
    end as costo_inicial
    ,tab11.fecha_reporte

    from in_saldo_inventario_dv tab1

    join meses mes on mes.id_meses = tab1.id_meses
    join in_inventario_dv tab0 on tab1.id_inventario_dv = tab0.id_inventario_dv
    join in_codigo_elemento_v tab2 on tab2.id_catalogo = tab0.id_catalogo and tab2.id_clase = tab0.id_clase and tab0.id_linea  = tab2.id_linea
    join in_espacio tab3 on tab3.id_espacio = tab1.id_espacio
    join in_estructura tab4 on tab4.id_estructura = tab3.id_estructura
    join centro_operacion tab5 on tab5.id_cen_op = tab1.id_cen_op
    join interceros_v tab6 on tab6.id_mae_ter = tab1.id_mae_ter
    join in_tipo_almacenamiento tab7 on tab7.id_tipo_almacenamiento  = tab1.id_tipo_almacenamiento
    join in_unidad_medida tab10 on tab10.id_unidad_medida = tab2.id_unidad_medida
    left join (
      SELECT
       tab2.*,
       row_number() over (
        partition by tab2.id_inventario_dv
        ORDER BY tab2.id_partes_inventario asc
       ) as rn
      from in_partes_inventario tab2
    )tab8 on tab8.id_inventario_dv = tab1.id_inventario_dv

    left join in_partes_clase tab9 on tab9.id_partes_clase = tab8.id_partes_clase and tab0.id_clase = tab9.id_clase and tab9.id_linea = tab0.id_linea
    left join (
      SELECT
       tab2.*,
       row_number() over (
        partition by tab2.id_partes_inventario
        ORDER BY tab2.fecha_reporte desc
       ) as rn
      from in_detalle_asignacion tab2
    )tab11 on tab11.id_partes_inventario = tab8.id_partes_inventario and tab11.rn=1

    where
    tab1.id_meses = $P{id_meses}
    and tab1.id_vigencia = $P{vigencia}
    and tab1.id_mae_ter = $P{id_mae_ter}
    and tab1.estado=1

    order by
    tab1.id_tipo_almacenamiento,
    tab1.id_mae_ter, tab0.id_clase,
    tab0.id_inventario_dv,
    tab8.id_partes_inventario

)tab0

--full join dual d on 1 = 1

where
1 = 1
$P!{whereCostoInicial}
$P!{whereCatalogo}
$P!{whereCenOp}
$P!{whereClase}
$P!{whereEspacio}
$P!{whereEstructura}
$P!{whereLinea}
$P!{whereTercero}
$P!{whereTipoAlmacenamiento}]]>
	</queryString>
	<field name="ID_VIGENCIA" class="java.math.BigDecimal"/>
	<field name="ID_MESES" class="java.math.BigDecimal"/>
	<field name="MES" class="java.lang.String"/>
	<field name="ID_INVENTARIO_DV" class="java.math.BigDecimal"/>
	<field name="ID_CEN_OP" class="java.math.BigDecimal"/>
	<field name="ID_ESPACIO" class="java.math.BigDecimal"/>
	<field name="ID_MAE_TER" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_ALMACENAMIENTO" class="java.math.BigDecimal"/>
	<field name="ESTADO" class="java.math.BigDecimal"/>
	<field name="COSTO_ACTUAL" class="java.math.BigDecimal"/>
	<field name="FECHA_INGRESO" class="java.sql.Timestamp"/>
	<field name="ID_LINEA" class="java.math.BigDecimal"/>
	<field name="ID_CLASE" class="java.math.BigDecimal"/>
	<field name="ID_CATALOGO" class="java.math.BigDecimal"/>
	<field name="DESC_INV" class="java.lang.String"/>
	<field name="ESTADO_INVENTARIO" class="java.math.BigDecimal"/>
	<field name="VIDA_UTIL_INV" class="java.math.BigDecimal"/>
	<field name="DIAS_DEPRECIADOS" class="java.math.BigDecimal"/>
	<field name="FECHA_MOD" class="java.sql.Timestamp"/>
	<field name="CODIGO_ELEMENTO" class="java.lang.String"/>
	<field name="ID_CODIGO_ELEMENTO" class="java.lang.String"/>
	<field name="DIGITOS_CATALOGO" class="java.lang.String"/>
	<field name="DESC_CATALOGO" class="java.lang.String"/>
	<field name="DESC_CORTA_CATALOGO" class="java.lang.String"/>
	<field name="VIDA_UTIL_CATALOG" class="java.math.BigDecimal"/>
	<field name="STOCK_MIN" class="java.math.BigDecimal"/>
	<field name="STOCK_MAX" class="java.math.BigDecimal"/>
	<field name="VALOR_IVA" class="java.math.BigDecimal"/>
	<field name="TIENE_IVA" class="java.math.BigDecimal"/>
	<field name="ID_UNIDAD_MEDIDA" class="java.math.BigDecimal"/>
	<field name="ID_AGRUP_COMERCIAL" class="java.math.BigDecimal"/>
	<field name="ESTADO_CATALOGO" class="java.math.BigDecimal"/>
	<field name="MARCA" class="java.lang.String"/>
	<field name="MODELO" class="java.lang.String"/>
	<field name="CARACTERES" class="java.lang.String"/>
	<field name="DESC_CLASE" class="java.lang.String"/>
	<field name="DESC_CORTA_CLASE" class="java.lang.String"/>
	<field name="VIDA_UTIL_CLASE" class="java.math.BigDecimal"/>
	<field name="TIPO_INVENTARIO" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_SEGURO" class="java.math.BigDecimal"/>
	<field name="ESTADO_CLASE" class="java.math.BigDecimal"/>
	<field name="DIGITOS_LINEA" class="java.lang.String"/>
	<field name="DESC_LINEA" class="java.lang.String"/>
	<field name="DESC_CORTA_LINEA" class="java.lang.String"/>
	<field name="ESTADO_LINEA" class="java.math.BigDecimal"/>
	<field name="DESC_ESPACIO" class="java.lang.String"/>
	<field name="NIVEL" class="java.lang.String"/>
	<field name="COOD_X_ESPACIO" class="java.math.BigDecimal"/>
	<field name="COOD_Y_ESPACIO" class="java.math.BigDecimal"/>
	<field name="NOMBRE_ESTRUCTURA" class="java.lang.String"/>
	<field name="DIRECCION" class="java.lang.String"/>
	<field name="ID_ESTRUCTURA" class="java.math.BigDecimal"/>
	<field name="PREFIJO" class="java.lang.String"/>
	<field name="NUM_DOC" class="java.lang.String"/>
	<field name="RAZON_SOC" class="java.lang.String"/>
	<field name="DESC_TIPO_ALMACENAMIENTO" class="java.lang.String"/>
	<field name="ID_PARTES_INVENTARIO" class="java.math.BigDecimal"/>
	<field name="SERIE" class="java.lang.String"/>
	<field name="PLAQUETA" class="java.math.BigDecimal"/>
	<field name="PLACA" class="java.lang.String"/>
	<field name="CODIGO_BAR" class="java.lang.String"/>
	<field name="OBSERVACIONES" class="java.lang.String"/>
	<field name="NOMBRE" class="java.lang.String"/>
	<field name="DESC_PARTES_CLASE" class="java.lang.String"/>
	<field name="ESTADO_PARTES" class="java.math.BigDecimal"/>
	<field name="DESC_UNIDAD_MED" class="java.lang.String"/>
	<field name="DESC_CORTA_UNIDA_MED" class="java.lang.String"/>
	<field name="COSTO_INICIAL" class="java.math.BigDecimal"/>
	<field name="FECHA_REPORTE" class="java.sql.Timestamp"/>
	<variable name="total_clase" class="java.math.BigDecimal" resetType="Group" resetGroup="Clase" calculation="Sum">
		<variableExpression><![CDATA[$F{COSTO_INICIAL}]]></variableExpression>
	</variable>
	<variable name="total_item" class="java.math.BigDecimal" resetType="Group" resetGroup="Clase" calculation="Count">
		<variableExpression><![CDATA[$F{ID_INVENTARIO_DV}]]></variableExpression>
	</variable>
	<variable name="total_tercero" class="java.math.BigDecimal" resetType="Group" resetGroup="Mae_Ter" calculation="Sum">
		<variableExpression><![CDATA[$F{COSTO_INICIAL}]]></variableExpression>
	</variable>
	<variable name="total_item_tercero" class="java.math.BigDecimal" resetType="Group" resetGroup="Mae_Ter" calculation="Count">
		<variableExpression><![CDATA[$F{ID_INVENTARIO_DV}]]></variableExpression>
	</variable>
	<variable name="tot_count" class="java.math.BigDecimal" calculation="Count">
		<variableExpression><![CDATA[$F{ID_INVENTARIO_DV}]]></variableExpression>
	</variable>
	<variable name="tot_costini" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{COSTO_INICIAL}]]></variableExpression>
	</variable>
	<group name="Tipo_Almacenamiento">
		<groupExpression><![CDATA[$F{ID_TIPO_ALMACENAMIENTO}]]></groupExpression>
		<groupHeader>
			<band height="50">
				<printWhenExpression><![CDATA[$F{ID_VIGENCIA}!=null]]></printWhenExpression>
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="209" y="0" width="1401" height="36"/>
					<box leftPadding="2" rightPadding="2">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0"/>
						<leftPen lineWidth="0.0"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.0"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font size="14"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{DESC_TIPO_ALMACENAMIENTO}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="209" height="36" backcolor="#FFFFFF"/>
					<box leftPadding="2" rightPadding="2">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.0"/>
						<leftPen lineWidth="0.0"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.0"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="15" isBold="true"/>
					</textElement>
					<text><![CDATA[Tipo Almacenamiento  :]]></text>
				</staticText>
			</band>
		</groupHeader>
	</group>
	<group name="Mae_Ter">
		<groupExpression><![CDATA[$F{ID_MAE_TER}]]></groupExpression>
		<groupHeader>
			<band height="28">
				<printWhenExpression><![CDATA[$F{ID_VIGENCIA}!=null]]></printWhenExpression>
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="140" y="0" width="1470" height="18"/>
					<box leftPadding="4" rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font size="12"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_DOC}+" - "+$F{RAZON_SOC}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="140" height="18" backcolor="#88C2F9"/>
					<box leftPadding="2" rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font size="12" isBold="true"/>
					</textElement>
					<text><![CDATA[Responsable  : ]]></text>
				</staticText>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="43">
				<printWhenExpression><![CDATA[$F{ID_VIGENCIA}!=null]]></printWhenExpression>
				<staticText>
					<reportElement mode="Opaque" x="209" y="11" width="578" height="20" backcolor="#BCBABA"/>
					<box leftPadding="3" rightPadding="7">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.0"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="10" isBold="true"/>
					</textElement>
					<text><![CDATA[TOTAL]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="877" y="11" width="733" height="20" backcolor="#BCBABA"/>
					<box leftPadding="3">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.0"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="10" isBold="true"/>
					</textElement>
					<text><![CDATA[]]></text>
				</staticText>
				<textField pattern="#,##0.00;-#,##0.00">
					<reportElement mode="Opaque" x="787" y="11" width="90" height="20" forecolor="#000000" backcolor="#BCBABA"/>
					<box rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_tercero}]]></textFieldExpression>
				</textField>
				<textField pattern="###0">
					<reportElement mode="Opaque" x="140" y="11" width="69" height="20" forecolor="#000000" backcolor="#BCBABA"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_item_tercero}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="0" y="11" width="140" height="20" backcolor="#BCBABA"/>
					<box leftPadding="3" rightPadding="7">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.0"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="10" isBold="true"/>
					</textElement>
					<text><![CDATA[Total Items Respons.]]></text>
				</staticText>
			</band>
		</groupFooter>
	</group>
	<group name="Clase" isReprintHeaderOnEachPage="true">
		<groupExpression><![CDATA[$F{ID_CLASE}]]></groupExpression>
		<groupHeader>
			<band height="47" splitType="Prevent">
				<printWhenExpression><![CDATA[$F{ID_VIGENCIA}!=null]]></printWhenExpression>
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="140" height="18" backcolor="#88C2F9"/>
					<box leftPadding="2" rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font size="12" isBold="true"/>
					</textElement>
					<text><![CDATA[Clase               :]]></text>
				</staticText>
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="140" y="0" width="1470" height="18"/>
					<box leftPadding="4" rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font size="12"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{DIGITOS_LINEA}+$F{CARACTERES}+" - "+$F{DESC_CLASE}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="407" y="29" width="85" height="18" backcolor="#88C2F9"/>
					<box leftPadding="2" rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Fecha de Ingreso]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="550" y="29" width="125" height="18" backcolor="#88C2F9"/>
					<box leftPadding="2" rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Estructura]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="675" y="29" width="112" height="18" backcolor="#88C2F9"/>
					<box leftPadding="2" rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Espacio]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="209" y="29" width="198" height="18" backcolor="#88C2F9"/>
					<box leftPadding="2" rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Descripción Código]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="88" y="29" width="52" height="18" backcolor="#88C2F9"/>
					<box leftPadding="2" rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Num Sec]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="492" y="29" width="58" height="18" backcolor="#88C2F9"/>
					<box leftPadding="2" rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Medida]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="140" y="29" width="69" height="18" backcolor="#88C2F9"/>
					<box leftPadding="2" rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Código Elemento]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="0" y="29" width="88" height="18" backcolor="#88C2F9"/>
					<box leftPadding="2" rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Cen. Operación]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="787" y="29" width="90" height="18" backcolor="#88C2F9"/>
					<box leftPadding="2" rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Costo Histórico]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="1237" y="29" width="80" height="18" isRemoveLineWhenBlank="true" backcolor="#88C2F9"/>
					<box leftPadding="2" rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Código Barras]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="1087" y="29" width="75" height="18" isRemoveLineWhenBlank="true" backcolor="#88C2F9"/>
					<box leftPadding="2" rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Plaqueta]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="877" y="29" width="110" height="18" isRemoveLineWhenBlank="true" backcolor="#88C2F9"/>
					<box leftPadding="2" rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Tipo Partes]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="987" y="29" width="100" height="18" isRemoveLineWhenBlank="true" backcolor="#88C2F9"/>
					<box leftPadding="2" rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Serie]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="1317" y="29" width="293" height="18" isRemoveLineWhenBlank="true" backcolor="#88C2F9"/>
					<box leftPadding="2" rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Observaciones]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="1162" y="29" width="75" height="18" isRemoveLineWhenBlank="true" backcolor="#88C2F9"/>
					<box leftPadding="2" rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Placa]]></text>
				</staticText>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="27">
				<printWhenExpression><![CDATA[$F{ID_VIGENCIA}!=null]]></printWhenExpression>
				<staticText>
					<reportElement mode="Opaque" x="209" y="0" width="578" height="21" backcolor="#BCBABA"/>
					<box leftPadding="3" rightPadding="7">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.0"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.0"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="10" isBold="true"/>
					</textElement>
					<text><![CDATA[TOTAL]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="877" y="0" width="733" height="21" backcolor="#BCBABA"/>
					<box leftPadding="3">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.0"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle">
						<font size="10" isBold="true"/>
					</textElement>
					<text><![CDATA[]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="140" height="21" backcolor="#BCBABA"/>
					<box leftPadding="3" rightPadding="7">
						<pen lineWidth="0.0"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.0"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="10" isBold="true"/>
					</textElement>
					<text><![CDATA[Total Items Clase]]></text>
				</staticText>
				<textField pattern="#,##0.00;-#,##0.00">
					<reportElement mode="Opaque" x="787" y="0" width="90" height="21" forecolor="#000000" backcolor="#BCBABA"/>
					<box rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_clase}]]></textFieldExpression>
				</textField>
				<textField pattern="###0">
					<reportElement mode="Opaque" x="140" y="0" width="69" height="21" forecolor="#000000" backcolor="#BCBABA"/>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_item}]]></textFieldExpression>
				</textField>
			</band>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<pageHeader>
		<band height="21" splitType="Stretch"/>
	</pageHeader>
	<detail>
		<band height="20" splitType="Stretch">
			<printWhenExpression><![CDATA[$F{ID_VIGENCIA}!=null]]></printWhenExpression>
			<textField pattern="$ #,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="787" y="0" width="90" height="20"/>
				<box leftPadding="2" rightPadding="4">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{COSTO_INICIAL}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="550" y="0" width="125" height="20"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NOMBRE_ESTRUCTURA}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="675" y="0" width="112" height="20"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESC_ESPACIO}]]></textFieldExpression>
			</textField>
			<textField pattern="###0" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="88" y="0" width="52" height="20"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{ID_INVENTARIO_DV}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="88" height="20"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PREFIJO}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="140" y="0" width="69" height="20"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CODIGO_ELEMENTO}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="492" y="0" width="58" height="20"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESC_CORTA_UNIDA_MED}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="209" y="0" width="198" height="20"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESC_CATALOGO}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="407" y="0" width="85" height="20"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_INGRESO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1317" y="0" width="293" height="20"/>
				<box topPadding="0" leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{OBSERVACIONES}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="877" y="0" width="110" height="20"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESC_PARTES_CLASE}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1087" y="0" width="75" height="20"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{DESC_PARTES_CLASE} != null ?$F{PLAQUETA}:null]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1237" y="0" width="80" height="20"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CODIGO_BAR}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="987" y="0" width="100" height="20"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESC_PARTES_CLASE} != null ?$F{SERIE}: null]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1162" y="0" width="75" height="20"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PLACA}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="10" splitType="Stretch">
			<printWhenExpression><![CDATA[$F{ID_VIGENCIA}!=null]]></printWhenExpression>
		</band>
	</columnFooter>
	<lastPageFooter>
		<band height="83">
			<printWhenExpression><![CDATA[$F{ID_VIGENCIA}!=null]]></printWhenExpression>
			<textField>
				<reportElement x="1142" y="40" width="468" height="20"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="false" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["CC/NIT "+$F{NUM_DOC}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="428" y="0" width="159" height="20"/>
				<textElement>
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[Observaciones :]]></text>
			</staticText>
			<staticText>
				<reportElement x="587" y="40" width="400" height="20"/>
				<box>
					<bottomPen lineWidth="0.75"/>
				</box>
				<textElement/>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement x="587" y="20" width="400" height="20"/>
				<box>
					<bottomPen lineWidth="0.75"/>
				</box>
				<textElement/>
				<text><![CDATA[]]></text>
			</staticText>
			<textField>
				<reportElement x="1142" y="20" width="468" height="20"/>
				<box>
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="false" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOC}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="140" y="0" width="288" height="60"/>
				<box topPadding="3" leftPadding="3">
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Top">
					<font size="11" isBold="false" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOC}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="0" width="140" height="20"/>
				<textElement>
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[Responsable :]]></text>
			</staticText>
			<staticText>
				<reportElement x="587" y="0" width="400" height="20"/>
				<box>
					<bottomPen lineWidth="0.75"/>
				</box>
				<textElement/>
				<text><![CDATA[]]></text>
			</staticText>
		</band>
	</lastPageFooter>
	<summary>
		<band height="26" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="209" y="8" width="578" height="18" backcolor="#BCBABA"/>
				<box leftPadding="3" rightPadding="7">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[TOTAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="8" width="140" height="18" backcolor="#BCBABA"/>
				<box leftPadding="3" rightPadding="7">
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[Total Items General]]></text>
			</staticText>
			<textField pattern="###0">
				<reportElement mode="Opaque" x="140" y="8" width="69" height="18" forecolor="#000000" backcolor="#BCBABA"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{tot_count}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="877" y="8" width="733" height="18" backcolor="#BCBABA"/>
				<box leftPadding="3">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[]]></text>
			</staticText>
			<textField pattern="#,##0.00;-#,##0.00">
				<reportElement mode="Opaque" x="787" y="8" width="90" height="18" forecolor="#000000" backcolor="#BCBABA"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{tot_costini}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
</jasperReport>
