<?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="report name" pageWidth="1000" pageHeight="595" orientation="Landscape" columnWidth="960" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.5"/>
	<property name="ireport.x" value="783"/>
	<property name="ireport.y" value="105"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/inventario/inf_devolutivos_codigo"/>
	<property name="ireport.jasperserver.url" value="http://192.168.2.43: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="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>
	<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.COSTO_INICIAL
,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.OBSERVACIONES
,tab9.NOMBRE
,tab9.DESCRIPCION as desc_partes_clase
,tab10.descripcion as desc_unidad_med
,tab10.desc_corta as desc_corta_unida_med
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 in_partes_inventario 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
where tab1.id_meses = $P{id_meses} and tab1.id_vigencia = $P{vigencia} and tab1.estado=1
order by tab2.codigo_elemento, tab1.id_mae_ter, tab0.id_inventario_dv, tab8.id_partes_inventario
)tab0
-- full join dual d on 1 = 1
where 1 = 1
$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="COSTO_INICIAL" class="java.math.BigDecimal"/>
	<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="OBSERVACIONES" class="java.lang.String"/>
	<field name="NOMBRE" class="java.lang.String"/>
	<field name="DESC_PARTES_CLASE" class="java.lang.String"/>
	<field name="DESC_UNIDAD_MED" class="java.lang.String"/>
	<field name="DESC_CORTA_UNIDA_MED" class="java.lang.String"/>
	<variable name="total_clase" class="java.math.BigDecimal" resetType="Group" resetGroup="Catalogo" incrementType="Group" incrementGroup="Inventario" calculation="Sum">
		<variableExpression><![CDATA[$F{COSTO_INICIAL}]]></variableExpression>
	</variable>
	<variable name="total_ter" class="java.math.BigDecimal" resetType="Group" resetGroup="Mae_Ter" incrementType="Group" incrementGroup="Inventario" calculation="Sum">
		<variableExpression><![CDATA[$F{COSTO_INICIAL}]]></variableExpression>
	</variable>
	<variable name="total_clase_item" class="java.math.BigDecimal" resetType="Group" resetGroup="Catalogo" incrementType="Group" incrementGroup="Inventario" calculation="Count">
		<variableExpression><![CDATA[$F{COSTO_INICIAL}]]></variableExpression>
	</variable>
	<variable name="total_ter_item" class="java.math.BigDecimal" resetType="Group" resetGroup="Mae_Ter" incrementType="Group" incrementGroup="Inventario" calculation="Count">
		<variableExpression><![CDATA[$F{COSTO_INICIAL}]]></variableExpression>
	</variable>
	<variable name="tot_conunt" class="java.math.BigDecimal" incrementType="Group" incrementGroup="Inventario" calculation="Count">
		<variableExpression><![CDATA[$F{ID_INVENTARIO_DV}]]></variableExpression>
	</variable>
	<variable name="sum_costini" class="java.math.BigDecimal" incrementType="Group" incrementGroup="Inventario" calculation="Sum">
		<variableExpression><![CDATA[$F{COSTO_INICIAL}]]></variableExpression>
	</variable>
	<group name="Catalogo">
		<groupExpression><![CDATA[$F{CODIGO_ELEMENTO}]]></groupExpression>
		<groupHeader>
			<band height="62">
				<printWhenExpression><![CDATA[$F{ID_VIGENCIA}!=null]]></printWhenExpression>
				<staticText>
					<reportElement mode="Opaque" x="0" y="26" width="190" 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 textAlignment="Right" verticalAlignment="Middle">
						<font size="15" isBold="true"/>
					</textElement>
					<text><![CDATA[Código Elemento  :]]></text>
				</staticText>
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="190" y="26" width="770" 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="12"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{CODIGO_ELEMENTO} + ($F{DESC_CATALOGO}!= null? " - "+$F{DESC_CATALOGO} : " ")]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="12">
				<printWhenExpression><![CDATA[$F{ID_VIGENCIA}!=null]]></printWhenExpression>
				<staticText>
					<reportElement mode="Opaque" x="190" y="0" width="695" height="12" 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="8" isBold="true"/>
					</textElement>
					<text><![CDATA[TOTAL]]></text>
				</staticText>
				<textField pattern="$ #,##0.000;$ -#,##0.000">
					<reportElement mode="Opaque" x="885" y="0" width="75" height="12" forecolor="#000000" backcolor="#BCBABA"/>
					<box leftPadding="1" rightPadding="3">
						<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_clase}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="84" height="12" forecolor="#000000" backcolor="#BCBABA"/>
					<box rightPadding="5">
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[ELEMENTOS]]></text>
				</staticText>
				<textField pattern="###0">
					<reportElement mode="Opaque" x="84" y="0" width="106" height="12" forecolor="#000000" backcolor="#BCBABA"/>
					<box leftPadding="1" rightPadding="3">
						<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_clase_item}]]></textFieldExpression>
				</textField>
			</band>
		</groupFooter>
	</group>
	<group name="Mae_Ter">
		<groupExpression><![CDATA[$F{ID_MAE_TER}]]></groupExpression>
		<groupHeader>
			<band height="32">
				<printWhenExpression><![CDATA[$F{ID_VIGENCIA}!=null]]></printWhenExpression>
				<staticText>
					<reportElement mode="Opaque" x="0" y="13" width="190" height="18" backcolor="#88C2F9"/>
					<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="12" isBold="true"/>
					</textElement>
					<text><![CDATA[Responsable  :]]></text>
				</staticText>
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="190" y="13" width="770" 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>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="26">
				<staticText>
					<reportElement mode="Opaque" x="190" y="13" width="695" height="12" 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="8" isBold="true"/>
					</textElement>
					<text><![CDATA[TOTAL]]></text>
				</staticText>
				<textField pattern="$ #,##0.000;$ -#,##0.000">
					<reportElement mode="Opaque" x="885" y="13" width="75" height="12" forecolor="#000000" backcolor="#BCBABA"/>
					<box leftPadding="1" rightPadding="3">
						<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_ter}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="0" y="13" width="84" height="12" forecolor="#000000" backcolor="#BCBABA"/>
					<box rightPadding="5">
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[ELEMENTOS]]></text>
				</staticText>
				<textField pattern="###0">
					<reportElement mode="Opaque" x="84" y="13" width="106" height="12" forecolor="#000000" backcolor="#BCBABA"/>
					<box leftPadding="1" rightPadding="3">
						<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_ter_item}]]></textFieldExpression>
				</textField>
			</band>
		</groupFooter>
	</group>
	<group name="Inventario">
		<groupExpression><![CDATA[$F{ID_INVENTARIO_DV}]]></groupExpression>
		<groupHeader>
			<band height="81">
				<printWhenExpression><![CDATA[$F{ID_VIGENCIA}!=null]]></printWhenExpression>
				<staticText>
					<reportElement mode="Opaque" x="0" y="17" width="84" 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[Centro Operación]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="84" y="17" width="106" 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[Secuencia]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="279" y="17" width="358" 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="190" y="17" width="89" 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="637" y="17" 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="762" y="17" width="123" 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="190" y="63" width="89" 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[Serie]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="0" y="63" width="190" 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[Tipo Partes]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="434" y="63" width="203" 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[Plaqueta]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="279" y="63" width="155" 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[Placa]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="885" y="17" width="75" 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 Inicial]]></text>
				</staticText>
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="0" y="35" width="84" height="18"/>
					<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="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{PREFIJO}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" pattern="###0" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="84" y="35" width="106" height="18"/>
					<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="7"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{ID_INVENTARIO_DV}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="279" y="35" width="358" height="18"/>
					<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="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{DESC_CATALOGO}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="190" y="35" width="89" height="18"/>
					<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="7"/>
					</textElement>
					<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_INGRESO}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="637" y="35" width="125" height="18"/>
					<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="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{NOMBRE_ESTRUCTURA}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="762" y="35" width="123" height="18"/>
					<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="7"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{DESC_ESPACIO}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" pattern="$ #,##0.00" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" x="885" y="35" width="75" height="18"/>
					<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="7"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{COSTO_INICIAL}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="118" splitType="Stretch">
			<textField pattern="dd/MM/yyyy h.mm a">
				<reportElement x="756" y="49" width="204" height="16"/>
				<box rightPadding="3"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="231" y="21" width="509" height="59"/>
				<textElement textAlignment="Center" verticalAlignment="Bottom" markup="none">
					<font fontName="SansSerif" size="24" isBold="true"/>
				</textElement>
				<text><![CDATA[Control De Recursos Físicos
Informe de Devolutivos por Elemento]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="756" y="33" width="204" height="16" forecolor="#000000" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Fecha de Impresión:]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="231" y="80" width="509" height="18">
					<printWhenExpression><![CDATA[$F{ID_VIGENCIA}!=null]]></printWhenExpression>
				</reportElement>
				<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="14" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Periodo de "+$F{MES}+" del "+$F{ID_VIGENCIA}]]></textFieldExpression>
			</textField>
			<image>
				<reportElement x="0" y="18" width="231" height="62"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
		</band>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="1" splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="18" splitType="Stretch">
			<printWhenExpression><![CDATA[$F{ID_VIGENCIA}!=null]]></printWhenExpression>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="434" y="0" width="203" height="18"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{PLAQUETA}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="279" y="0" width="155" height="18"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PLACA}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="190" y="0" width="89" height="18"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SERIE}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="190" height="18"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESC_PARTES_CLASE}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch">
			<printWhenExpression><![CDATA[$F{ID_VIGENCIA}!=null]]></printWhenExpression>
		</band>
	</columnFooter>
	<pageFooter>
		<band height="63" splitType="Stretch">
			<printWhenExpression><![CDATA[$F{ID_VIGENCIA}!=null]]></printWhenExpression>
			<staticText>
				<reportElement mode="Opaque" x="529" y="8" width="198" height="12" forecolor="#575757"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<text><![CDATA[Websafi - Control De Recursos Físicos
]]></text>
			</staticText>
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement mode="Opaque" x="632" y="26" width="95" height="12" forecolor="#575757" backcolor="#FFFFFF"/>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Opaque" x="529" y="26" width="103" height="12" forecolor="#575757" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Página "+$V{PAGE_NUMBER}+" de "]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band height="12" splitType="Stretch">
			<textField pattern="###0">
				<reportElement mode="Opaque" x="84" y="0" width="445" height="12" forecolor="#000000" backcolor="#BCBABA"/>
				<box leftPadding="2" rightPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{tot_conunt}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00">
				<reportElement mode="Opaque" x="885" y="0" width="75" height="12" forecolor="#000000" backcolor="#BCBABA"/>
				<box leftPadding="0" 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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{sum_costini}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="529" y="0" width="356" height="12" 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="7" isBold="true"/>
				</textElement>
				<text><![CDATA[TOTAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="84" height="12" forecolor="#000000" backcolor="#BCBABA"/>
				<box rightPadding="5">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Total Items:]]></text>
			</staticText>
		</band>
	</summary>
</jasperReport>
