<?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_res_inv_resp_dv" language="groovy" pageWidth="612" pageHeight="792" whenNoDataType="NoDataSection" columnWidth="572" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.6105100000000045"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/inventario/inf_res_inv_resp_dv"/>
	<property name="ireport.jasperserver.url" value="http://3.22.202.200:8080/jasperserver/services/repository"/>
	<parameter name="whereFuncionario" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<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="whereTercero" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereCenOp" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereLinea" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereCatalogo" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereClase" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereAlmac" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereModelo" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereLink" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select

tab0.num_doc,
tab0.razon_soc,
sum(tab0.costo_inicial) as costo_inicial,
count(tab0.id_inventario_dv) as cant,
tab0.id_vigencia,
tab0.id_meses,
tab0.mes,
tab0.id_mae_ter,
tab0.id_estado_func,
tab0.funcionario,
tab0.tipo_funcionario,
tab0.id_tipo_periodo

from (

    select

    tab0.num_doc,
    tab0.razon_soc,
    tab0.costo_inicial,
    tab0.id_inventario_dv,
    tab0.id_vigencia,
    tab0.id_meses,
    tab0.mes,
    tab0.id_mae_ter,
    estfunc.id_estado_func,
    case when estfunc.id_estado_func is null then 0 else 1 end as funcionario,
    case when estfunc.id_estado_func is null then 'Contratista' else 'Funcionario' end as tipo_funcionario,
    nvl(estfunc.id_tipo_periodo,1) as id_tipo_periodo

    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
        , case
        when tab8.rn=1 or tab8.rn is null then tab0.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.estado=1

    )tab0



    left join (

        select
        estfunc.*,
        perd.id_tipo_periodo

        from no_estado_func_v$P!{whereLink} estfunc
        --and estfunc.periodo in (select id_periodo from no_periodo where id_tipo_periodo=1)

        join no_periodo$P!{whereLink} perd
        on perd.id_periodo = estfunc.periodo
        and perd.id_tipo_periodo = 1

        where
        estfunc.id_anhos = $P{vigencia}
        and estfunc.id_meses = $P{id_meses}


    )estfunc
    on estfunc.num_doc = tab0.num_doc
    and estfunc.id_anhos = $P{vigencia}
    and estfunc.id_meses = $P{id_meses}

    where
    nvl(estfunc.id_tipo_periodo,1) = 1
$P!{whereAlmac}
$P!{whereCatalogo}
$P!{whereCenOp}
$P!{whereClase}
$P!{whereLinea}
$P!{whereModelo}
$P!{whereTercero}

)tab0

where
1 = 1
$P!{whereFuncionario}

group by
tab0.num_doc,
tab0.razon_soc,
tab0.id_vigencia,
tab0.id_meses,
tab0.mes,
tab0.id_mae_ter,
tab0.id_estado_func,
tab0.funcionario,
tab0.tipo_funcionario,
tab0.id_tipo_periodo

order by
tab0.funcionario,
tab0.num_doc]]>
	</queryString>
	<field name="NUM_DOC" class="java.lang.String"/>
	<field name="RAZON_SOC" class="java.lang.String"/>
	<field name="COSTO_INICIAL" class="java.math.BigDecimal"/>
	<field name="CANT" class="java.math.BigDecimal"/>
	<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_MAE_TER" class="java.math.BigDecimal"/>
	<field name="ID_ESTADO_FUNC" class="java.math.BigDecimal"/>
	<field name="FUNCIONARIO" class="java.math.BigDecimal"/>
	<field name="TIPO_FUNCIONARIO" class="java.lang.String"/>
	<field name="ID_TIPO_PERIODO" class="java.math.BigDecimal"/>
	<variable name="total_costo" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{COSTO_INICIAL}]]></variableExpression>
	</variable>
	<variable name="total_cant" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{CANT}]]></variableExpression>
	</variable>
	<variable name="sum_cant" class="java.math.BigDecimal" resetType="Group" resetGroup="tipo" calculation="Sum">
		<variableExpression><![CDATA[$F{CANT}]]></variableExpression>
	</variable>
	<variable name="sum_costo" class="java.math.BigDecimal" resetType="Group" resetGroup="tipo" calculation="Sum">
		<variableExpression><![CDATA[$F{COSTO_INICIAL}]]></variableExpression>
	</variable>
	<group name="tipo">
		<groupExpression><![CDATA[$F{FUNCIONARIO}]]></groupExpression>
		<groupHeader>
			<band height="20">
				<staticText>
					<reportElement mode="Opaque" x="100" y="0" width="80" height="20" forecolor="#000000" backcolor="#AED6FB"/>
					<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Documento]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="180" y="0" width="192" height="20" forecolor="#000000" backcolor="#AED6FB"/>
					<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Responsable]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="372" y="0" width="90" height="20" forecolor="#000000" backcolor="#AED6FB"/>
					<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Cantidad Items]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="100" height="20" backcolor="#AED6FB"/>
					<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">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Funcionario]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="462" y="0" width="110" height="20" forecolor="#000000" backcolor="#AED6FB"/>
					<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Total Costo Histórico]]></text>
				</staticText>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="21">
				<textField>
					<reportElement mode="Opaque" x="0" y="0" width="372" height="12" backcolor="#DCDCDC"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement verticalAlignment="Middle" markup="none">
						<font size="7" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA["Total " + $F{TIPO_FUNCIONARIO}]]></textFieldExpression>
				</textField>
				<textField pattern="###0;-###0">
					<reportElement mode="Opaque" x="372" y="0" width="90" height="12" forecolor="#000000" backcolor="#DCDCDC"/>
					<box leftPadding="0" rightPadding="0">
						<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{sum_cant}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;-#,##0.00">
					<reportElement mode="Opaque" x="462" y="0" width="110" height="12" forecolor="#000000" backcolor="#DCDCDC"/>
					<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_costo}]]></textFieldExpression>
				</textField>
			</band>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="60" splitType="Stretch">
			<textField pattern="dd-MMM-yyyy   hh:mm aaa">
				<reportElement mode="Opaque" x="462" y="40" width="110" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="140" y="0" width="322" height="40"/>
				<textElement textAlignment="Center" verticalAlignment="Bottom" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Control De Recursos Físicos
Informe Resumido Inventarios por Responsable]]></text>
			</staticText>
			<image>
				<reportElement x="0" y="10" width="140" height="40"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
			<staticText>
				<reportElement mode="Opaque" x="462" y="28" width="110" height="12" 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>
				<reportElement x="140" y="40" width="322" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Periodo: " + $F{MES} + " - " + $F{ID_VIGENCIA}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="20" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="25" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="100" height="14" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<bottomPen 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>
				<text><![CDATA[Tipo Funcionario:]]></text>
			</staticText>
			<textField>
				<reportElement x="100" y="0" width="472" height="14"/>
				<box leftPadding="2">
					<bottomPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle"/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TIPO_FUNCIONARIO}]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="12" splitType="Stretch">
			<textField>
				<reportElement x="0" y="0" width="100" height="12"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TIPO_FUNCIONARIO}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement mode="Transparent" x="100" y="0" width="80" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<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="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_DOC}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement mode="Transparent" x="180" y="0" width="192" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="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" 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[$F{RAZON_SOC}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement mode="Transparent" x="372" y="0" width="90" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<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="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{CANT}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="false">
				<reportElement mode="Transparent" x="462" y="0" width="110" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<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="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{COSTO_INICIAL}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="26" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="28" splitType="Stretch">
			<printWhenExpression><![CDATA[!$P{IS_IGNORE_PAGINATION}]]></printWhenExpression>
			<textField>
				<reportElement mode="Opaque" x="211" y="12" width="89" 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>
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement mode="Opaque" x="301" y="12" width="60" 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.String"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="211" y="0" width="150" height="12" forecolor="#575757"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<text><![CDATA[Websafi - Control De Recursos Físicos
]]></text>
			</staticText>
		</band>
	</pageFooter>
	<summary>
		<band height="25" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="372" 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 verticalAlignment="Middle">
					<font size="7" isBold="true"/>
				</textElement>
				<text><![CDATA[TOTAL]]></text>
			</staticText>
			<textField pattern="#,##0.00;-#,##0.00">
				<reportElement mode="Opaque" x="462" y="0" width="110" 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{total_costo}]]></textFieldExpression>
			</textField>
			<textField pattern="###0;-###0">
				<reportElement mode="Opaque" x="372" y="0" width="90" height="12" forecolor="#000000" backcolor="#BCBABA"/>
				<box leftPadding="0" rightPadding="0">
					<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total_cant}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="572" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
