<?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="informe_estadisticas_compromisos_detallado" language="groovy" pageWidth="1416" pageHeight="540" orientation="Landscape" columnWidth="1376" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.4641000000000013"/>
	<property name="ireport.x" value="589"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/presupuesto/informe_estadisticas_compromisos_detallado"/>
	<property name="ireport.jasperserver.url" value="http://soporte14.sofhouse.net:8090/jasperserver/services/repository"/>
	<parameter name="cantidad_dias" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="vigencia" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="mes" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_vigencia" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereOpciones" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="fecha_ejecucion" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select rps.id_rp,rps.fecha,rps.codigo,rps.objeto,rps.inicial,rps.operaciones,rps.actual,rps.obliga,rps.pagos,
            inter.num_doc AS IDENTIFICACION,case when inter.razon_soc IS NULL then inter.pnombre||' '||inter.snombre||' '||inter.papellido||' '||inter.sapellido else inter.razon_soc end AS NOMBRE

            from(

            select valores.*, case when rp.id_tercero IS NULL then rp_com.id_mae_ter else rp.id_tercero end as id_mae_ter,
            case when rp.id_tercero IS NULL then rp_com.fecha_proceso else rp.fecha_proceso end as fecha

            from(

            select c.id_rp,pro.codigo,objetos.codigo||' '||objetos.descripcion AS OBJETO, c.id_asign, c.id_obj_gasto, c.id_cpo,c.id_vigencia,c.vigencia,
            case when h.valor is null then nvl(sum(c.valor),0) else (sum(nvl(h.valor,0))) end as INICIAL,
            case when h.valor is null then nvl(sum(0),0) else (sum(nvl(noved.valor,0))) end as OPERACIONES,
            case when h.valor is null then nvl(sum(c.valor),0) else (sum(nvl(h.valor,0))+nvl(sum(noved.valor),0)) end as ACTUAL,
            nvl((obligaciones.suma),0)-nvl(reintegro.valor,0) AS OBLIGA,
            nvl((pagos.suma),0)-nvl(anulacion.anul,0)-nvl(reintegro.valor,0) AS PAGOS
            from PR_RP_COMPROMISO c

            left join PROYECTOS pro ON c.id_cpo = pro.id
            left join OBJETOS_GASTO objetos ON objetos.id = c.id_obj_gasto
            left join PR_ASIG_PRESUP asip ON c.id_asign = asip.id
            and asip.id_vigencia = c.id_vigencia
            and asip.vigencia = c.vigencia
            left join PR_APROPIACION aprop ON asip.id_apropiacion = aprop.id
            and asip.id_vigencia = aprop.id_vigencia
            and asip.vigencia = aprop.vigencia
            left join PR_SITUA_REC situa ON situa.id=aprop.id_situac_rec
            left join PR_CODIF_PRESUP cod ON aprop.id_rubro = cod.id_rubro
            left join PR_CLASES_PRESUP clase ON cod.id_clase_presup = clase.id
            left join PR_PROG_GEN gen ON cod.cod_rub1 = gen.id
            left join PR_TIPO_REC rec ON aprop.id_tipo_rec = rec.id

            left join PR_HISTORIAL_RP h ON c.id_rp = h.id_rp
            and h.id_asign = c.id_asign
            and h.id_cpo = c.id_cpo
            and h.id_obj_gasto = c.id_obj_gasto
            and h.id_vigencia = c.id_vigencia
            and h.vigencia = c.vigencia

            left join (
            select sum(nvl(cval.debito,0) - nvl(cval.credito,0)) as valor, nov.id_rp, cval.id_asign, cval.id_obj_gasto, cval.id_vigencia, cval.vigencia
            from PR_NOVEDAD_RP_VAL cval
            join PR_NOVEDAD_RP nov ON cval.id_novedad_rp = nov.id_novedad_rp
            where nov.fecha<=to_date($P{fecha_ejecucion},'DD-MM-YYYY')
            group by nov.id_rp, cval.id_asign, cval.id_obj_gasto, cval.id_vigencia, cval.vigencia
            )noved ON c.id_rp = noved.id_rp
            and c.id_asign = noved.id_asign
            and c.id_obj_gasto = noved.id_obj_gasto
            and c.id_vigencia = noved.id_vigencia
            and c.vigencia = noved.vigencia

            left join
                      (
                            select id_rp, sum(suma) as suma, id_obg, id_cpo, id_asign, vig, idvig
                            from(
                            select obl.id_rp as ID_RP, sum (tov.valor_obligacion) as suma,
                                                   tov.id_obj_gasto as ID_OBG, tov.id_cpo as ID_CPO,
                                                   tov.id_asign as ID_ASIGN, obl.ano_fiscal as vig,
                                                   obl.id_vigencia as idvig, 'act' as des
                                            from TS_OBLIGACION obl
                                            join TS_OBLIGACION_VAL tov ON obl.id_obligacion = tov.id_obligacion
                                            and obl.secuencia = tov.secuencia
                                            and obl.ano_fiscal = tov.ano_fiscal
                                            and obl.id_vigencia = tov.id_vigencia
                    where obl.fecha_proceso<=to_date($P{fecha_ejecucion},'DD-MM-YYYY')
                                            group by obl.id_rp, tov.id_obj_gasto, tov.id_cpo, tov.id_asign, obl.ano_fiscal, obl.id_vigencia, 'act'
                            union
                            select obl.id_rp as ID_RP, sum (tov.valor_obligacion)*(-1) as suma,
                                                   tov.id_obj_gasto as ID_OBG, tov.id_cpo as ID_CPO,
                                                   tov.id_asign as ID_ASIGN, obl.ano_fiscal as vig,
                                                   obl.id_vigencia as idvig, 'anul' as des
                                            from TS_OBLIGACION obl
                                            join TS_OBLIGACION_VAL tov ON obl.id_obligacion = tov.id_obligacion
                                              and obl.secuencia = tov.secuencia
                                              and obl.ano_fiscal = tov.ano_fiscal
                                              and obl.id_vigencia = tov.id_vigencia
                                            join TS_ANUL_OBLIGACION anul ON obl.id_obligacion = anul.id_obligacion
                                                and obl.secuencia = anul.secuencia
                                                and obl.ano_fiscal = anul.vigencia
                                                and obl.id_vigencia = anul.id_vigencia
                        where anul.fecha_proceso<=to_date($P{fecha_ejecucion},'DD-MM-YYYY')
                         group by obl.id_rp, tov.id_obj_gasto, tov.id_cpo, tov.id_asign, obl.ano_fiscal, obl.id_vigencia
                            ) group by id_rp, id_obg, id_cpo, id_asign, vig, idvig
                      )obligaciones ON c.id_rp = obligaciones.id_rp
                            and c.id_asign = obligaciones.id_asign
                            and c.id_obj_gasto = obligaciones.id_obg
                            and c.vigencia = obligaciones.vig
                            and c.id_vigencia = obligaciones.idvig
			    and c.id_cpo = obligaciones.id_cpo
                      left join
                      (
                            select sum(oval.valor_obligacion) suma,
                                   oval.id_obj_gasto as id_obg, oval.id_cpo as id_cpo,
                                   oval.id_asign as id_asign, obl.id_rp as id_rp,
                                   obl.id_vigencia as idvig, obl.ano_fiscal as vig
                            from TS_OBLIGACION obl
                            join TS_PAGO_OBL pag ON pag.id_obligacion = obl.id_obligacion
                                and pag.id_clase_pago is null
                                and pag.secuencia = obl.secuencia
                                and pag.vigencia = obl.ano_fiscal
                            join TS_OBLIGACION_VAL oval ON obl.id_obligacion = oval.id_obligacion
                                and oval.secuencia = obl.secuencia
                                and oval.ano_fiscal =obl.ano_fiscal
                                and oval.id_vigencia =obl.id_vigencia
                            join TS_EMISION_PAGO emi ON pag.id_emision_pago = emi.id_emision_pago
			    and emi.fecha_proc<=to_date($P{fecha_ejecucion},'DD-MM-YYYY')
                            where obl.ano_fiscal = $P{vigencia} and obl.id_vigencia =  $P{id_vigencia}
                            group by oval.id_obj_gasto, oval.id_cpo, oval.id_asign, obl.id_rp,obl.id_vigencia, obl.ano_fiscal

                      )pagos ON c.id_rp = pagos.id_rp
                            and c.id_asign = pagos.id_asign
                            and c.id_obj_gasto = pagos.id_obg
                            and c.vigencia = pagos.vig
                            and c.id_vigencia = pagos.idvig
			    and c.id_cpo = pagos.id_cpo
                     left join(
            select id_rp, id_asig,id_obj_gasto, id_vigencia, vigencia, sum(reint) as valor
                            from(
                                select ob.id_obligacion as id_obliga, re.valor as reint, ob.id_asign as id_asig, ob.id_obj_gasto, ob.secuencia, p.id_pago_obl as id_reintegro, p.id_rp, ob.ano_fiscal as vigencia , ob.id_vigencia
                                        from TS_OBLIGACION_VAL ob
                                        join TS_PAGO_OBL p ON ob.id_obligacion = p.id_obligacion
                                            and ob.secuencia = p.secuencia
                                            and ob.id_vigencia = p.id_vigencia
                                            and ob.ano_fiscal = p.vigencia
                                            and p.id_clase_pago is null
                                        join (
                                          select r.id_pago_obl, d.id_cpo, d.id_asig, d.id_obj_gasto, sum(d.valor) as valor
                                          from PR_REINTEGRO r
                                          join PR_DETA_REIN d ON r.id_reintegro = d.id_reintegro
                                          where r.fecha_proceso <= to_date($P{fecha_ejecucion},'DD-MM-YYYY')
                                          group by r.id_pago_obl, d.id_cpo, d.id_asig, d.id_obj_gasto
                                        )re ON p.id_pago_obl = re.id_pago_obl
                                            and ob.id_cpo = re.id_cpo
                                            and ob.id_asign =re.id_asig
                                            and ob.id_obj_gasto = re.id_obj_gasto

                                  union

                                  select obl.id_obligacion as id_obliga, pdr.valor*(-1) as reint, pdr.id_asig, pdr.id_obj_gasto, obl.secuencia,pr.id_reintegro, obl.id_rp, obl.ano_fiscal as vigencia,obl.id_vigencia
                                  from TS_OBLIGACION obl
                                  join TS_PAGO_OBL pag ON obl.id_obligacion = pag.id_obligacion
                                    and obl.ano_fiscal = pag.vigencia
                                    and obl.id_vigencia = pag.id_vigencia
                                    and obl.secuencia = pag.secuencia
                                    and pag.id_clase_pago IS NULL
                                  join PR_REINTEGRO pr ON pag.id_pago_obl = pr.id_pago_obl
                                  join PR_DETA_REIN pdr ON pr.id_reintegro = pdr.id_reintegro
                                  join TS_ANU_MOV_BANC anul ON anul.id_mov_banc = pr.id_mov_ban
                                  and anul.fecha_anul <= to_date($P{fecha_ejecucion},'DD-MM-YYYY')
                                  where obl.ano_fiscal = $P{vigencia}

                                  union

                                  select obl.id_obligacion as id_obliga, sum(pdr.valor)*(-1) as reint, pdr.id_asig, pdr.id_obj_gasto, obl.secuencia, pr.id_reintegro, obl.id_rp, obl.ano_fiscal as vigencia, obl.id_vigencia
                                  from TS_OBLIGACION obl
                                  join TS_PAGO_OBL pag ON obl.id_obligacion = pag.id_obligacion
                                    and obl.ano_fiscal = pag.vigencia
                                    and obl.id_vigencia = pag.id_vigencia
                                    and obl.secuencia = pag.secuencia
                                    and pag.id_clase_pago IS NULL
                                  join PR_REINTEGRO pr ON pag.id_pago_obl = pr.id_pago_obl
                                  join PR_DETA_REIN pdr ON pr.id_reintegro = pdr.id_reintegro
                                  join TS_ANUL_RC anul ON anul.id_rc = pr.id_rc
                                  and anul.fecha_anul <= to_date($P{fecha_ejecucion},'DD-MM-YYYY')
                                  where obl.ano_fiscal = $P{vigencia}
                                 group by obl.id_obligacion, pdr.id_asig, pdr.id_obj_gasto, obl.secuencia,pr.id_reintegro, obl.id_rp, obl.ano_fiscal, obl.id_vigencia
                            ) group by id_rp, id_asig, id_obj_gasto, id_vigencia, vigencia
                     )reintegro ON c.id_rp = reintegro.id_rp
                            and c.id_asign = reintegro.id_asig
                            and c.id_obj_gasto = reintegro.id_obj_gasto
                            and c.vigencia = reintegro.vigencia
                            and c.id_vigencia = reintegro.id_vigencia

                     left join(
                            select sum(tov.valor_obligacion) anul, tov.id_asign as id_asign, tov.ano_fiscal as vig, tov.id_vigencia as idvig, obl.id_rp as id_rp, tov.id_obj_gasto as id_obg
                                from TS_OBLIGACION obl
                                join TS_PAGO_OBL pag ON obl.id_obligacion = pag.id_obligacion
                                    and obl.ano_fiscal = pag.vigencia
                                    and obl.id_vigencia = pag.id_vigencia
                                    and obl.secuencia = pag.secuencia
                                    and pag.id_clase_pago IS NULL
                                join TS_OBLIGACION_VAL tov ON obl.id_obligacion = tov.id_obligacion
                                    and obl.ano_fiscal = tov.ano_fiscal
                                    and obl.id_vigencia = tov.id_vigencia
                                    and obl.secuencia = tov.secuencia
                                join TS_ANUL_PAGOS anul ON pag.id_pago_obl = anul.id_pago_obl
                                      and anul.fecha_anul <= to_date($P{fecha_ejecucion},'DD-MM-YYYY')
                                where obl.ano_fiscal =$P{vigencia}   and obl.id_vigencia=$P{id_vigencia}
                                group by tov.id_asign, tov.ano_fiscal, tov.id_vigencia, obl.id_rp, tov.id_obj_gasto
                    )anulacion ON c.id_rp = anulacion.id_rp
                            and c.id_asign = anulacion.id_asign
                            and c.id_obj_gasto = anulacion.id_obg
                            and c.vigencia = anulacion.vig
                            and c.id_vigencia = anulacion.idvig


            where c.id_vigencia=$P{id_vigencia} and c.vigencia=$P{vigencia}
            group by c.id_rp, pro.codigo,objetos.codigo||' '||objetos.descripcion,c.id_asign, c.id_obj_gasto, c.id_cpo, c.id_vigencia, c.vigencia,h.valor,obligaciones.suma,anulacion.anul,reintegro.valor,pagos.suma

            )valores

            LEFT JOIN PR_RP rp ON rp.id=valores.id_rp and rp.id_vigencia=valores.id_vigencia and rp.vigencia=valores.vigencia
            LEFT JOIN PR_RP_COMIS rp_com ON rp_com.id=valores.id_rp and rp_com.id_vigencia=valores.id_vigencia and rp_com.vigencia=valores.vigencia
            ) rps

            LEFT JOIN INTERCEROS inter ON inter.id_mae_ter=rps.id_mae_ter
            where rps.fecha<=to_date($P{fecha_ejecucion},'DD-MM-YYYY') $P!{whereOpciones}
            order by rps.id_rp,rps.fecha,rps.codigo,rps.objeto]]>
	</queryString>
	<field name="ID_RP" class="java.math.BigDecimal"/>
	<field name="FECHA" class="java.sql.Timestamp"/>
	<field name="CODIGO" class="java.lang.String"/>
	<field name="OBJETO" class="java.lang.String"/>
	<field name="INICIAL" class="java.math.BigDecimal"/>
	<field name="OPERACIONES" class="java.math.BigDecimal"/>
	<field name="ACTUAL" class="java.math.BigDecimal"/>
	<field name="OBLIGA" class="java.math.BigDecimal"/>
	<field name="PAGOS" class="java.math.BigDecimal"/>
	<field name="IDENTIFICACION" class="java.lang.String"/>
	<field name="NOMBRE" class="java.lang.String"/>
	<variable name="INICIAL_1" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{INICIAL}]]></variableExpression>
	</variable>
	<variable name="OPERACIONES_1" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{OPERACIONES}]]></variableExpression>
	</variable>
	<variable name="ACTUAL_1" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{ACTUAL}]]></variableExpression>
	</variable>
	<variable name="OBLIGA_1" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{OBLIGA}]]></variableExpression>
	</variable>
	<variable name="PAGOS_1" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{PAGOS}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="60" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="1218" y="10" width="151" 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 pattern="dd-MMM-yyyy   hh:mm aaa">
				<reportElement x="1219" y="22" width="150" height="12"/>
				<box rightPadding="3"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="461" y="0" width="460" height="40"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Informe Estadisticas de Compromisos Detallado de "+$P{vigencia}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="461" y="40" width="460" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Corte a "+$P{fecha_ejecucion}]]></textFieldExpression>
			</textField>
			<image>
				<reportElement x="0" y="0" width="140" height="60"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:ANMLogoEmpresa003.png"]]></imageExpression>
			</image>
		</band>
	</title>
	<pageHeader>
		<band height="20" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="12" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="56" height="12" forecolor="#000000" backcolor="#64B0F7"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[RP]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="56" y="0" width="112" height="12" forecolor="#000000" backcolor="#64B0F7"/>
				<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" 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 RP]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="168" y="0" width="56" height="12" forecolor="#000000" backcolor="#64B0F7"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CPO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="224" y="0" width="165" height="12" forecolor="#000000" backcolor="#64B0F7"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[OBJETO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="821" y="0" width="144" height="12" forecolor="#000000" backcolor="#64B0F7"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[VALOR OBLIGACIONES]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1109" y="0" width="97" height="12" forecolor="#000000" backcolor="#64B0F7"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[IDENTIFICACION]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1206" y="0" width="169" height="12" forecolor="#000000" backcolor="#64B0F7"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[NOMBRE / RAZON SOCIAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="389" y="0" width="144" height="12" forecolor="#000000" backcolor="#64B0F7"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[VALOR INICIAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="533" y="0" width="144" height="12" forecolor="#000000" backcolor="#64B0F7"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[VALOR OPERACIONES]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="677" y="0" width="144" height="12" forecolor="#000000" backcolor="#64B0F7"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[VALOR ACTUAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="965" y="0" width="144" height="12" forecolor="#000000" backcolor="#64B0F7"/>
				<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" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[VALOR PAGOS]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="21" splitType="Stretch">
			<textField>
				<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="56" height="21"/>
				<box topPadding="2" leftPadding="2" bottomPadding="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.lang.String"><![CDATA[$F{ID_RP}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy HH:mm:ss">
				<reportElement stretchType="RelativeToTallestObject" x="56" y="0" width="112" height="21"/>
				<box topPadding="2" leftPadding="2" bottomPadding="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.lang.String"><![CDATA[$F{FECHA}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement stretchType="RelativeToTallestObject" x="168" y="0" width="56" height="21"/>
				<box topPadding="2" leftPadding="2" bottomPadding="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.lang.String"><![CDATA[$F{CODIGO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement stretchType="RelativeToTallestObject" x="224" y="0" width="164" height="21"/>
				<box topPadding="2" leftPadding="2" bottomPadding="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="Justified" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{OBJETO}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00">
				<reportElement stretchType="RelativeToTallestObject" x="388" y="0" width="145" height="21"/>
				<box topPadding="2" leftPadding="2" bottomPadding="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{INICIAL}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00">
				<reportElement stretchType="RelativeToTallestObject" x="533" y="0" width="144" height="21"/>
				<box topPadding="2" leftPadding="2" bottomPadding="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{OPERACIONES}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00">
				<reportElement stretchType="RelativeToTallestObject" x="677" y="0" width="144" height="21"/>
				<box topPadding="2" leftPadding="2" bottomPadding="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{ACTUAL}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00">
				<reportElement stretchType="RelativeToTallestObject" x="821" y="0" width="144" height="21"/>
				<box topPadding="2" leftPadding="2" bottomPadding="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{OBLIGA}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00">
				<reportElement stretchType="RelativeToTallestObject" x="965" y="0" width="144" height="21"/>
				<box topPadding="2" leftPadding="2" bottomPadding="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{PAGOS}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement stretchType="RelativeToTallestObject" x="1206" y="0" width="170" height="21"/>
				<box topPadding="2" leftPadding="4" bottomPadding="2" rightPadding="6">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NOMBRE}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement stretchType="RelativeToTallestObject" x="1109" y="0" width="97" height="21"/>
				<box topPadding="2" leftPadding="2" bottomPadding="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.lang.String"><![CDATA[$F{IDENTIFICACION}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="30" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="24" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="600" 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="690" 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="600" y="0" width="150" height="12" forecolor="#575757"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<text><![CDATA[Websafi - Presupuesto]]></text>
			</staticText>
		</band>
	</pageFooter>
	<summary>
		<band height="25" splitType="Stretch">
			<textField>
				<reportElement x="0" y="0" width="388" height="25"/>
				<box topPadding="2" leftPadding="4" bottomPadding="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 verticalAlignment="Middle">
					<font size="10" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Totales"]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00">
				<reportElement x="388" y="0" width="145" height="25"/>
				<box topPadding="8" leftPadding="2" bottomPadding="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">
					<font size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{INICIAL_1}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00">
				<reportElement x="533" y="0" width="144" height="25"/>
				<box topPadding="8" leftPadding="2" bottomPadding="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">
					<font size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{OPERACIONES_1}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00">
				<reportElement x="677" y="0" width="144" height="25"/>
				<box topPadding="8" leftPadding="2" bottomPadding="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">
					<font size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_1}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00">
				<reportElement x="821" y="0" width="144" height="25"/>
				<box topPadding="8" leftPadding="2" bottomPadding="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">
					<font size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{OBLIGA_1}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00">
				<reportElement x="965" y="0" width="144" height="25"/>
				<box topPadding="8" leftPadding="2" bottomPadding="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">
					<font size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PAGOS_1}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="1108" y="0" width="97" height="25"/>
				<box topPadding="2" leftPadding="2" bottomPadding="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/>
				<textFieldExpression class="java.lang.String"><![CDATA[" "]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="1206" y="0" width="169" height="25"/>
				<box topPadding="2" leftPadding="2" bottomPadding="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/>
				<textFieldExpression class="java.lang.String"><![CDATA[" "]]></textFieldExpression>
			</textField>
		</band>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="318" y="0" width="752" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
