<?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="report1" language="groovy" pageWidth="1836" pageHeight="612" orientation="Landscape" columnWidth="1796" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.464100000000001"/>
	<property name="ireport.x" value="799"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/presupuesto/informe_disponiblidad_cpo_detallado"/>
	<property name="ireport.jasperserver.url" value="http://soporte14.sofhouse.net:8090/jasperserver/services/repository"/>
	<parameter name="fechaf" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="fechafinal" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="fechai" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="fechainicial" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="mescorte" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="vigencia" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereOpciones" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTipoCDP" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select id_cpo,codigo, descripcion, id_area_lider, id_obj_gasto, id_asign, id_cdp, fecha_cdp, NVL(valor_cdp,0) as valor_cdp, NVL(c1,0) as c1, NVL(c2,0) as c2,NVL(c3,0) as c3,NVL(c4,0) as c4,c5, recurso,id_clase_presup,
		  objeto, id_rp, NVL(valor_rp,0) as valor_rp, NVL(pagos,0) as pagos, NVL(reintegros,0) as reintegros, id_vigencia, ano_fiscal, id_rubro, cdp_obj, fecha_rp, NVL(obliga,0) as obliga, tercero,
                  obj_cod, objeto_rp, num_doc, tip_doc,ob_pag--***************AGREGADOS**********************************
		from(
		    select proy.codigo, proy.descripcion, proy.id_area_lider, pca.id_obj_gasto, pca.id_asign, proy.id as id_cpo,cod.id_clase_presup,
	    	    cdps.id as id_cdp, cdps.fecha as fecha_cdp, valcdp.valor as valor_cdp,cdps.objeto as cdp_obj,
		    gen.codigo as c1, cod.cod_rub2 as c2, cod.cod_rub3 as c3, cod.cod_rub4 as c4, cod.cod_rub5 as c5, rec.codigo as recurso, obj.descripcion as objeto,
		    rps.id_rp, rps.fecha as fecha_rp, valrps.valor as valor_rp, pagos.valor as pagos, reint.valor as reintegros,
                    rps.objeto_rp, obj.codigo as obj_cod,rps.num_doc,rps.tip_doc,--Agregada!!!!*****^^^^^******
		    pca.id_vigencia, pca.ano_fiscal, aprop.id_rubro, obliga.suma as obliga, terc.benef as tercero, ob_pag.suma as ob_pag
		    from PROYECTOS proy--86 Proyectos
		    left join PR_CPO_ASIGN pca ON proy.id = pca.id_cpo--10216 Registros

		    left join PR_CDP_CPO cdpcpo ON cdpcpo.id = pca.id_pr_cdp_cpo
			and pca.ano_fiscal = cdpcpo.ano_fiscal
			and pca.id_vigencia = cdpcpo.id_vigencia
		    left join(
		      select c.id, c.valor, c.fecha, c.ano_fiscal, c.id_vigencia, c.objeto,'1' AS TIPO
		      from PR_CDP c
		      union
		      select b.id, b.valor, b.fecha, b.ano_fiscal, b.id_vigencia, b.objeto,'2' AS TIPO
		      from PR_CDP_COMIS b
		    )cdps ON cdpcpo.id_cdp = cdps.id
			and cdpcpo.id_vigencia = cdps.id_vigencia
			and cdpcpo.ano_fiscal = cdps.ano_fiscal $P!{whereTipoCDP}
		    --10447 reg En 0.078 seg, agregando fecha y id 10447 reg en 0.694 seg
		    left join (
			select a.id_cdp,
			  case when h.valor is null then b.valor else nvl(h.valor,0)+nvl(noved.valor,0) end as valor,
			  b.id_asign, b.id_obj_gasto, a.id_vigencia, a.ano_fiscal
			from PR_CDP_CPO a
			join PR_CPO_ASIGN b ON a.id = b.id_pr_cdp_cpo
			left join PR_HISTORIAL_CDP h ON a.id_cdp = h.id_cdp
			    and b.id_asign = h.id_asign
			    and b.id_obj_gasto = h.id_obj_gasto
			    and b.id_vigencia = a.id_vigencia
			    and b.ano_fiscal = a.ano_fiscal
			    and b.id_cpo = h.id_cpo
			left join (
			    select sum(nvl(cval.debito,0) - nvl(cval.credito,0)) as valor, nov.id_cdp,  nov.id_vigencia, nov.vigencia, cval.id_asign, cval.id_obj_gasto
			    from PR_NOVEDAD_CDP_VAL cval
			    join PR_NOVEDAD_CDP nov ON cval.id_novedad_cdp = nov.id_novedad_cdp
			    where nov.fecha >= to_date($P{fechai}, 'DD-MM-YYYY')
			      and nov.fecha <= to_date($P{fechaf}, 'DD-MM-YYYY')
			    group by nov.id_cdp, nov.id_vigencia, nov.vigencia, cval.id_asign, cval.id_obj_gasto
			)noved on a.id_cdp = noved.id_cdp
			    and noved.id_vigencia = a.id_vigencia
			    and noved.vigencia = a.ano_fiscal
			    and b.id_asign = noved.id_asign
			    and b.id_obj_gasto = noved.id_obj_gasto
		    )valcdp ON cdps.id = valcdp.id_cdp
			and pca.id_vigencia = valcdp.id_vigencia
			and pca.ano_fiscal = valcdp.ano_fiscal
			and pca.id_asign = valcdp.id_asign
			and pca.id_obj_gasto = valcdp.id_obj_gasto
		    --Con la consulta para el valor a la fecha: 10457 regs en 2.373 seg
		    left join PR_ASIG_PRESUP asip ON pca.id_asign = asip.id
			and asip.id_vigencia = pca.id_vigencia
			and asip.vigencia = pca.ano_fiscal
		     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_CODIF_PRESUP cod ON aprop.id_rubro = cod.id_rubro
		     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
		    --Agregado Rubro 10457 Reg en 2.432 seg
		     left join OBJETOS_GASTO obj ON obj.id =  pca.id_obj_gasto
		    --Agregado objeto de gasto, 10457 reg en 2.584 seg
		    left join(
                        --******************MODIFICADA!!!!!
            		select a.id_rp, a.id_obj_gasto, a.id_asign, a.id_vigencia, a.vigencia,
                              case when b.id is null then c.fecha_proceso else b.fecha_proceso end as fecha,
                              case when b.id is null then c.id_cdp else b.id_cdp end as id_cdp, a.id_cpo,
                              d.descripcion as tip_doc,
                              case when b.id is null then c.objeto else b.objeto end as objeto_rp,
                              case when b.id is null then e.resolucion else ''||pg.no_acto_admin end as num_doc
                         from PR_RP_COMPROMISO a
                         left join PR_RP b ON a.id_rp = b.id
                             and a.id_vigencia = b.id_vigencia
                             and a.vigencia = b.vigencia
			     and b.fecha_proceso >= to_date($P{fechai}, 'DD-MM-YYYY')
			     and b.fecha_proceso <= to_date($P{fechaf}, 'DD-MM-YYYY')
                         left join PR_RP_COMIS c ON a.id_rp = c.id
                             and a.id_vigencia = c.id_vigencia
                             and a.vigencia = c.vigencia
			     --Anhadido filtro de fechas a los rps 29-07-2011 luism
			     and c.fecha_proceso >= to_date($P{fechai}, 'DD-MM-YYYY')
			     and c.fecha_proceso <= to_date($P{fechaf}, 'DD-MM-YYYY')
                         left join PR_PG pg on pg.id_rp = b.id
                             and pg.vigencia = b.vigencia
                             and pg.id_vigencia = b.id_vigencia
                         left join PR_CLASE_ACT_ADMIN d on c.id_clase_admin = d.id
                             or pg.id_clase_admin = d.id
			left join PR_RESOL_COMIS e on c.no_acto_admin = e.id
		    )rps ON cdpcpo.id_cdp = rps.id_cdp
			and pca.id_asign = rps.id_asign
			and pca.id_obj_gasto = rps.id_obj_gasto
			and pca.id_vigencia = rps.id_vigencia
			and pca.ano_fiscal = rps.vigencia
			and pca.id_cpo = rps.id_cpo
		    --Consulta hasta RPS trae 22347 Reg en 4.509 seg
		    left join (
			select benef, id, id_vigencia, vigencia
			from(
			select case when ter.razon_soc is null then  ter.papellido||' '|| ter.sapellido||' '||ter.pnombre||' '||ter.snombre else ter.razon_soc end as benef,
			       rp.id, rp.id_vigencia, rp.vigencia, 'General' as des
			from PR_RP rp
			join INTERCEROS ter on ter.id_mae_ter = rp.id_tercero
			union
			select case when ter.razon_soc is null then  ter.papellido||' '|| ter.sapellido||' '||ter.pnombre||' '||ter.snombre else ter.razon_soc end as benef,
			       rp.id, rp.id_vigencia, rp.vigencia, 'Comisiones' as des
			from PR_RP_COMIS rp
			join INTERCEROS ter on ter.id_mae_ter = rp.id_mae_ter
			)
		   )terc ON terc.id = rps.id_rp
			and terc.id_vigencia = rps.id_vigencia
			and terc.vigencia = rps.vigencia
		    left join (
			select c.id_rp, c.id_asign, c.id_obj_gasto, c.id_cpo, c.id_vigencia, c.vigencia,
			case when h.valor is null then  nvl(c.valor,0) else nvl(h.valor,0)+nvl(noved.valor,0) end as valor
			from PR_RP_COMPROMISO c
			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{fechai}, 'DD-MM-YYYY')
			      and nov.fecha <= to_date($P{fechaf}, '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
		    )valrps ON rps.id_rp = valrps.id_rp
		      and pca.id_asign = valrps.id_asign
		      and pca.id_obj_gasto = valrps.id_obj_gasto
		      and pca.id_vigencia = valrps.id_vigencia
		      and pca.ano_fiscal = valrps.vigencia
		      and pca.id_cpo = valrps.id_cpo
		    --Consulta hasta aka trae 22373 Reg en 4.174 seg
		    left join (
		--Pagos
			select id_asign, id_cpo, id_obj_gasto, id_vigencia, ano_fiscal, sum(valor) as valor, id_rp
			from(
			    select ob.id_asign, ob.id_cpo, ob.id_obj_gasto, ob.id_vigencia, ob.ano_fiscal, sum(NVL(ob.valor_obligacion,0)) as valor, p.id_rp
			    from TS_OBLIGACION_VAL ob
			    left 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 TS_EMISION_PAGO e ON p.id_emision_pago = e.id_emision_pago
				and e.fecha_proc >= to_date($P{fechai}, 'DD-MM-YYYY')
				and e.fecha_proc <= to_date($P{fechaf}, 'DD-MM-YYYY')
			    group by ob.id_asign, ob.id_cpo, ob.id_obj_gasto, ob.id_vigencia, ob.ano_fiscal, p.id_rp

			    union

			    select ob.id_asign, ob.id_cpo, ob.id_obj_gasto, ob.id_vigencia, ob.ano_fiscal, sum(NVL(ob.valor_obligacion,0))*(-1) as valor, p.id_rp
			    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 TS_ANUL_PAGOS an ON p.id_pago_obl = an.id_pago_obl
				and an.fecha_anul >= to_date($P{fechai}, 'DD-MM-YYYY')
				and an.fecha_anul <= to_date($P{fechaf}, 'DD-MM-YYYY')
			    group by ob.id_asign, ob.id_cpo, ob.id_obj_gasto, ob.id_vigencia, ob.ano_fiscal, p.id_rp
			) group by id_asign, id_cpo, id_obj_gasto, id_vigencia, ano_fiscal, id_rp
		--RR
		    )pagos ON rps.id_rp = pagos.id_rp
			and pca.id_asign = pagos.id_asign
			and pca.id_cpo = pagos.id_cpo
			and pca.id_obj_gasto = pagos.id_obj_gasto
			and pca.id_vigencia = pagos.id_vigencia
			and pca.ano_fiscal = pagos.ano_fiscal
               --Obligaciones
                    left join(
                        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, anu.id_anul_obligacion
                        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
                        left join TS_ANUL_OBLIGACION anu ON anu.id_obligacion=obl.id_obligacion
                            and anu.secuencia = obl.secuencia
                            and anu.fecha_proceso >= to_date($P{fechai}, 'DD-MM-YYYY')
                            and anu.fecha_proceso <= to_date($P{fechaf}, 'DD-MM-YYYY')
                        where anu.id_anul_obligacion is null
                        group by obl.id_rp, tov.id_obj_gasto, tov.id_cpo, tov.id_asign, anu.id_anul_obligacion
                        order by obl.id_rp
                    )obliga ON obliga.id_rp = rps.id_rp
                        and obliga.id_asign = pca.id_asign
                        and pca.id_cpo = obliga.id_cpo
                        and pca.id_obj_gasto = obliga.id_obg

		    left join(
			    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
			    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.estado=1
			    group by obl.id_rp, tov.id_obj_gasto, tov.id_cpo, tov.id_asign
			    order by obl.id_rp
		    )ob_pag ON ob_pag.id_rp = rps.id_rp
			and ob_pag.id_asign = pca.id_asign
			and pca.id_cpo = ob_pag.id_cpo
			and pca.id_obj_gasto = ob_pag.id_obg

               --Fin obligaciones
		    --Trayendo 22408 Reg en 3.684 Seg
		    left join(
		--Inicio Reintegros
			select id_asign, id_cpo, id_obj_gasto, id_vigencia, vigencia, id_rp, sum(valor) as valor
			from(
			      select r.id_rp, d.id_cpo, d.id_asig AS ID_ASIGN, d.id_obj_gasto,r.id_vigencia,r.vigencia, sum(d.valor) as valor
			      from PR_REINTEGRO r
			      left join
				(
				select d.id_reintegro,d.id_asig,d.id_cpo,d.id_obj_gasto,sum(NVL(d.valor,0)) as valor
				FROM PR_DETA_REIN d
				GROUP BY d.id_reintegro,d.id_asig,d.id_cpo,d.id_obj_gasto
				) d ON r.id_reintegro = d.id_reintegro

			      where r.fecha_proceso >= to_date($P{fechai}, 'DD-MM-YYYY')
			      and r.fecha_proceso <= to_date($P{fechaf}, 'DD-MM-YYYY')
			      group by r.id_rp, d.id_cpo, d.id_asig, d.id_obj_gasto,r.id_vigencia,r.vigencia


			    union

			    select pr.id_rp,pdr.id_cpo,pdr.id_asig AS ID_ASIGN,pdr.id_obj_gasto,pr.id_vigencia,pr.vigencia,sum(pdr.valor)*(-1) as valor
			    FROM PR_REINTEGRO pr
    			    left join
				(
				select d.id_reintegro,d.id_asig,d.id_cpo,d.id_obj_gasto,sum(NVL(d.valor,0)) as valor
				FROM PR_DETA_REIN d
				GROUP BY d.id_reintegro,d.id_asig,d.id_cpo,d.id_obj_gasto
			    )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{fechai}, 'DD-MM-YYYY')
				  and anul.fecha_anul <= to_date($P{fechaf}, 'DD-MM-YYYY')
			    group by pr.id_rp,pdr.id_cpo,pdr.id_asig,pdr.id_obj_gasto,pr.id_vigencia,pr.vigencia

			    union

			    select pr.id_rp,pdr.id_cpo,pdr.id_asig AS ID_ASIGN,pdr.id_obj_gasto,pr.id_vigencia,pr.vigencia,sum(pdr.valor)*(-1) as valor
			    FROM PR_REINTEGRO pr
			    left join
				(
				select d.id_reintegro,d.id_asig,d.id_cpo,d.id_obj_gasto,sum(NVL(d.valor,0)) as valor
				FROM PR_DETA_REIN d
				GROUP BY d.id_reintegro,d.id_asig,d.id_cpo,d.id_obj_gasto
			    )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{fechai}, 'DD-MM-YYYY')
				and anul.fecha_anul <= to_date($P{fechaf}, 'DD-MM-YYYY')
			    group by pr.id_rp,pdr.id_cpo,pdr.id_asig,pdr.id_obj_gasto,pr.id_vigencia,pr.vigencia
			) group by id_asign, id_cpo, id_obj_gasto, id_vigencia, vigencia, id_rp
		-- RR
		    )reint ON reint.id_rp = rps.id_rp
			and pca.id_asign = reint.id_asign
			and pca.id_cpo = reint.id_cpo
			and pca.id_obj_gasto = reint.id_obj_gasto
			and pca.id_vigencia = reint.id_vigencia
			and pca.ano_fiscal = reint.vigencia
		    --Con reintegros trae 22483 Reg en 8366 seg

		)where id_cdp is not null
		    and valor_cdp is not null
		    and fecha_cdp >= to_date($P{fechai}, 'DD-MM-YYYY')
		    and fecha_cdp <= to_date($P{fechaf}, 'DD-MM-YYYY')
	           and ano_fiscal=$P{vigencia} $P!{whereOpciones}
		order by codigo, id_cdp, c1,c2,c3,c4,c5,recurso,objeto]]>
	</queryString>
	<field name="ID_CPO" class="java.math.BigDecimal"/>
	<field name="CODIGO" class="java.lang.String"/>
	<field name="DESCRIPCION" class="java.lang.String"/>
	<field name="ID_AREA_LIDER" class="java.math.BigDecimal"/>
	<field name="ID_OBJ_GASTO" class="java.math.BigDecimal"/>
	<field name="ID_ASIGN" class="java.math.BigDecimal"/>
	<field name="ID_CDP" class="java.math.BigDecimal"/>
	<field name="FECHA_CDP" class="java.sql.Timestamp"/>
	<field name="VALOR_CDP" class="java.math.BigDecimal"/>
	<field name="C1" class="java.math.BigDecimal"/>
	<field name="C2" class="java.math.BigDecimal"/>
	<field name="C3" class="java.math.BigDecimal"/>
	<field name="C4" class="java.math.BigDecimal"/>
	<field name="C5" class="java.math.BigDecimal"/>
	<field name="RECURSO" class="java.lang.String"/>
	<field name="ID_CLASE_PRESUP" class="java.math.BigDecimal"/>
	<field name="OBJETO" class="java.lang.String"/>
	<field name="ID_RP" class="java.math.BigDecimal"/>
	<field name="VALOR_RP" class="java.math.BigDecimal"/>
	<field name="PAGOS" class="java.math.BigDecimal"/>
	<field name="REINTEGROS" class="java.math.BigDecimal"/>
	<field name="ID_VIGENCIA" class="java.math.BigDecimal"/>
	<field name="ANO_FISCAL" class="java.lang.String"/>
	<field name="ID_RUBRO" class="java.math.BigDecimal"/>
	<field name="CDP_OBJ" class="java.lang.String"/>
	<field name="FECHA_RP" class="java.sql.Timestamp"/>
	<field name="OBLIGA" class="java.math.BigDecimal"/>
	<field name="TERCERO" class="java.lang.String"/>
	<field name="OBJ_COD" class="java.lang.String"/>
	<field name="OBJETO_RP" class="java.lang.String"/>
	<field name="NUM_DOC" class="java.lang.String"/>
	<field name="TIP_DOC" class="java.lang.String"/>
	<field name="OB_PAG" class="java.math.BigDecimal"/>
	<variable name="VALOR_CDP_1" class="java.math.BigDecimal" resetType="Group" resetGroup="CPO" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_CDP}]]></variableExpression>
	</variable>
	<variable name="VALOR_RP_1" class="java.math.BigDecimal" resetType="Group" resetGroup="CPO" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_RP}]]></variableExpression>
	</variable>
	<variable name="VALOR_CDP_2" class="java.math.BigDecimal" resetType="Group" resetGroup="CPO" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_CDP}-$F{VALOR_RP}]]></variableExpression>
	</variable>
	<variable name="PAGOS_1" class="java.math.BigDecimal" resetType="Group" resetGroup="CPO" calculation="Sum">
		<variableExpression><![CDATA[$F{PAGOS}-$F{REINTEGROS}]]></variableExpression>
	</variable>
	<variable name="SUMA_PARCIAL" class="java.math.BigDecimal" resetType="Group" resetGroup="CPO" calculation="Sum">
		<variableExpression><![CDATA[$F{OBLIGA}-$F{PAGOS}]]></variableExpression>
	</variable>
	<variable name="VALOR_CDP_3" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_CDP}]]></variableExpression>
	</variable>
	<variable name="VALOR_RP_2" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_RP}]]></variableExpression>
	</variable>
	<variable name="SALDO_CDP_TOTAL" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_CDP}-$F{VALOR_RP}]]></variableExpression>
	</variable>
	<variable name="PAGOS_TOTAL" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{PAGOS}-$F{REINTEGROS}]]></variableExpression>
	</variable>
	<variable name="SUMA_TOTAL" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{OBLIGA}-$F{PAGOS}]]></variableExpression>
	</variable>
	<group name="CPO">
		<groupExpression><![CDATA[$F{CODIGO}]]></groupExpression>
		<groupHeader>
			<band height="20">
				<textField>
					<reportElement x="0" y="0" width="1795" height="20"/>
					<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>
						<font isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{CODIGO}+" - "+$F{DESCRIPCION}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="20">
				<staticText>
					<reportElement x="0" y="0" width="714" height="20"/>
					<box topPadding="2" leftPadding="2" 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>
						<font isBold="true"/>
					</textElement>
					<text><![CDATA[Subtotal]]></text>
				</staticText>
				<textField pattern="¤ #,##0.00">
					<reportElement x="714" y="0" width="143" height="20"/>
					<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">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{VALOR_CDP_1}]]></textFieldExpression>
				</textField>
				<textField pattern="¤ #,##0.00">
					<reportElement x="1231" y="0" width="141" height="20"/>
					<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">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{VALOR_RP_1}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="857" y="0" width="374" height="20"/>
					<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/>
					<text><![CDATA[]]></text>
				</staticText>
				<textField pattern="¤ #,##0.00">
					<reportElement x="1372" y="0" width="147" height="20"/>
					<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">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{VALOR_CDP_2}]]></textFieldExpression>
				</textField>
				<textField pattern="¤ #,##0.00">
					<reportElement x="1519" y="0" width="132" height="20"/>
					<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">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PAGOS_1}]]></textFieldExpression>
				</textField>
				<textField pattern="¤ #,##0.00">
					<reportElement x="1651" y="0" width="144" height="20"/>
					<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">
						<font isBold="true"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{SUMA_PARCIAL}]]></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="1565" y="22" width="150" 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 mode="Opaque" x="1565" 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 Impresion:]]></text>
			</staticText>
			<textField>
				<reportElement x="664" y="0" 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["Informe Disponibilidad por CPO Detallada A "+$P{mescorte}+" de "+$P{vigencia}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="664" y="20" 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["Presupuesto de Gastos"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="664" y="39" 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["De "+$P{fechainicial}+" a "+$P{fechafinal}]]></textFieldExpression>
			</textField>
			<image>
				<reportElement x="0" y="0" width="167" height="59"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:ANMLogoEmpresa003.png"]]></imageExpression>
			</image>
		</band>
	</title>
	<pageHeader>
		<band height="20" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="40" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="60" height="39" 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="166" y="14" width="55" height="26" 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[CTA PROG]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1031" y="0" width="200" height="39" 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[BENEFICIARIO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1651" y="0" width="144" height="39" 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[CTAS X PAGAR]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="713" y="0" width="144" height="39" 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 CDP]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1372" y="0" width="147" height="39" 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[SALDO CDP]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="460" y="0" width="51" height="39" 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[RECURSO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="857" y="0" width="81" height="39" 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="166" y="0" width="294" height="14" forecolor="#000000" backcolor="#64B0F7"/>
				<box topPadding="1" leftPadding="3">
					<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[RUBRO PRESUPUESTAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="100" y="0" width="66" height="39" 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 CDP]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="409" y="14" width="51" height="26" 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[SUBORD]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1231" y="0" width="141" height="39" 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[COMPROMISO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1519" y="0" width="132" height="39" 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[PAGOS]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="221" y="14" width="51" height="26" 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[SUBC SUBP]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="511" y="0" width="202" height="39" 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 GASTO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="272" y="14" width="86" height="26" 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[OBJG PROY]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="938" y="0" width="93" height="39" 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="358" y="14" width="51" height="26" 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[ORD SPROY]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="60" y="0" width="41" height="39" 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[CDP]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="16" splitType="Stretch">
			<textField pattern="¤ #,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="714" y="0" width="143" height="16"/>
				<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">
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_CDP}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00">
				<reportElement stretchType="RelativeToTallestObject" x="1231" y="0" width="141" height="16"/>
				<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">
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_RP}]]></textFieldExpression>
			</textField>
			<textField pattern="yyyy-MM-dd" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="938" y="0" width="93" height="16"/>
				<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">
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_RP}]]></textFieldExpression>
			</textField>
			<textField pattern="yyyy-MM-dd">
				<reportElement stretchType="RelativeToTallestObject" x="101" y="0" width="66" height="16"/>
				<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">
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_CDP}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00">
				<reportElement stretchType="RelativeToTallestObject" x="1372" y="0" width="147" height="16"/>
				<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">
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_CDP}-$F{VALOR_RP}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement stretchType="RelativeToTallestObject" x="512" y="0" width="202" height="16"/>
				<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>
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{OBJETO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="60" height="16"/>
				<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>
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CODIGO}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement stretchType="RelativeToTallestObject" x="60" y="0" width="41" height="16"/>
				<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">
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{ID_CPO}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00">
				<reportElement stretchType="RelativeToTallestObject" x="1519" y="0" width="132" height="16"/>
				<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">
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{PAGOS}-$F{REINTEGROS}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement stretchType="RelativeToTallestObject" x="274" y="0" width="86" height="16"/>
				<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>
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{C3}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement stretchType="RelativeToTallestObject" x="462" y="0" width="50" height="16"/>
				<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>
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RECURSO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1031" y="0" width="200" height="16"/>
				<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>
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TERCERO}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="411" y="0" width="51" height="16"/>
				<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>
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{C5}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement stretchType="RelativeToTallestObject" x="167" y="0" width="54" height="16"/>
				<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>
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{C1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement stretchType="RelativeToTallestObject" x="360" y="0" width="51" height="16"/>
				<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>
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{C4}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement stretchType="RelativeToTallestObject" x="221" y="0" width="53" height="16"/>
				<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>
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{C2}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="857" y="0" width="81" height="16"/>
				<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>
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{ID_RP}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00">
				<reportElement stretchType="RelativeToTallestObject" x="1651" y="0" width="144" height="16"/>
				<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">
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{OBLIGA}-$F{PAGOS}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="23" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="24" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="815" 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="908" 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="815" y="0" width="150" height="12" forecolor="#575757"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<text><![CDATA[Websafi - Contabilidad]]></text>
			</staticText>
		</band>
	</pageFooter>
	<summary>
		<band height="20" splitType="Stretch">
			<staticText>
				<reportElement x="0" y="0" width="714" height="20"/>
				<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>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[TOTAL]]></text>
			</staticText>
			<staticText>
				<reportElement x="857" y="0" width="374" height="20"/>
				<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/>
				<text><![CDATA[]]></text>
			</staticText>
			<textField pattern="¤ #,##0.00">
				<reportElement x="715" y="0" width="142" height="20"/>
				<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">
					<font isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{VALOR_CDP_3}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00">
				<reportElement x="1231" y="0" width="141" height="20"/>
				<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">
					<font isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{VALOR_RP_2}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00">
				<reportElement x="1372" y="0" width="147" height="20"/>
				<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">
					<font isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{SALDO_CDP_TOTAL}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00">
				<reportElement x="1519" y="0" width="132" height="20"/>
				<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">
					<font isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PAGOS_TOTAL}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00">
				<reportElement x="1651" y="0" width="144" height="20"/>
				<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">
					<font isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{SUMA_TOTAL}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="526" 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>
