<?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="1256" pageHeight="540" orientation="Landscape" columnWidth="1216" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.4641000000000013"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/presupuesto/informe_mensual_cdp"/>
	<property name="ireport.jasperserver.url" value="http://soporte14.sofhouse.net:8090/jasperserver/services/repository"/>
	<subDataset name="Query">
		<queryString language="SQL">
			<![CDATA[select id, fecha, objeto, descripcion, id_vigencia, vigencia, fecha_nov, adicion, reduccion, valor_ini
from(
select cdp.id, cdp.fecha as fecha, cdp.objeto, nov.fecha as fecha_nov,
                  tip.descripcion, cdp.id_vigencia, cdp.ano_fiscal as vigencia,
                  0 as valor_ini,
                  case
                    when tip.descripcion ='Adición'
                      then val.valor
                    else 0
                  end as Adicion,
                  case
                    when tip.descripcion ='Reducción' OR tip.descripcion='Anulación' OR tip.descripcion='Cierre'
                      then val.valor*(-1)
                    else 0
                  end as Reduccion
              from  PR_CDP cdp
              join PR_NOVEDAD_CDP nov ON nov.id_cdp = cdp.id
                  and nov.id_vigencia = cdp.id_vigencia
                  and nov.vigencia = cdp.ano_fiscal
              join (select cval.id_novedad_cdp, sum(nvl(cval.debito,0) - nvl(cval.credito,0)) as valor
                    from PR_NOVEDAD_CDP_VAL cval group by cval.id_novedad_cdp
              )val ON nov.id_novedad_cdp= val.id_novedad_cdp
              join PR_TIPO_NOVEDAD_CDP tip ON nov.id_tipo_novedad = tip.id_tipo_novedad_cdp
              union
                select cdp.id, cdp.fecha as fecha, cdp.objeto, nov.fecha as fecha_nov,
                  tip.descripcion, cdp.id_vigencia, cdp.ano_fiscal as vigencia,
                  0 as valor_ini,
                  case
                    when tip.descripcion ='Adición'
                      then val.valor
                    else 0
                  end as Adicion,
                  case
                    when tip.descripcion ='Reducción' OR tip.descripcion='Anulación' OR tip.descripcion='Cierre'
                      then val.valor*(-1)
                    else 0
                  end as Reduccion
              from  PR_CDP cdp
              join PR_NOVEDAD_CDP nov ON nov.id_cdp = cdp.id
                  and nov.id_vigencia = cdp.id_vigencia
                  and nov.vigencia = cdp.ano_fiscal
	            join (select cval.id_novedad_cdp, sum(nvl(cval.debito,0) - nvl(cval.credito,0)) as valor
                    from PR_NOVEDAD_CDP_VAL cval group by cval.id_novedad_cdp
              )val ON nov.id_novedad_cdp= val.id_novedad_cdp
              join PR_TIPO_NOVEDAD_CDP tip ON nov.id_tipo_novedad = tip.id_tipo_novedad_cdp
              union
              --CDPS de comisiones
              select cdp.id, cdp.fecha as fecha, cdp.objeto, nov.fecha as fecha_nov,
                  tip.descripcion, cdp.id_vigencia, cdp.ano_fiscal as vigencia,
                  0 as valor_ini,
                  case
                    when tip.descripcion ='Adición'
                      then val.valor
                    else 0
                  end as Adicion,
                  case
                    when tip.descripcion ='Reducción' OR tip.descripcion='Anulación' OR tip.descripcion='Cierre'
                      then val.valor*(-1)
                    else 0
                  end as Reduccion
              from  PR_CDP cdp
              join PR_NOVEDAD_CDP nov ON nov.id_cdp = cdp.id
                  and nov.id_vigencia = cdp.id_vigencia
                  and nov.vigencia = cdp.ano_fiscal
              join (select cval.id_novedad_cdp, sum(nvl(cval.debito,0) - nvl(cval.credito,0)) as valor
                    from PR_NOVEDAD_CDP_VAL cval group by cval.id_novedad_cdp
              )val ON nov.id_novedad_cdp= val.id_novedad_cdp
              join PR_TIPO_NOVEDAD_CDP tip ON nov.id_tipo_novedad = tip.id_tipo_novedad_cdp
              union
                select cdp.id, cdp.fecha as fecha, cdp.objeto, nov.fecha as fecha_nov,
                  tip.descripcion, cdp.id_vigencia, cdp.ano_fiscal as vigencia,
                  0 as valor_ini,
                  case
                    when tip.descripcion ='Adición'
                      then val.valor
                    else 0
                  end as Adicion,
                  case
                    when tip.descripcion ='Reducción' OR tip.descripcion='Anulación' OR tip.descripcion='Cierre'
                      then val.valor*(-1)
                    else 0
                  end as Reduccion
              from  PR_CDP_COMIS cdp
              join PR_NOVEDAD_CDP nov ON nov.id_cdp = cdp.id
                  and nov.id_vigencia = cdp.id_vigencia
                  and nov.vigencia = cdp.ano_fiscal
	            join (select cval.id_novedad_cdp, sum(nvl(cval.debito,0) - nvl(cval.credito,0)) as valor
                    from PR_NOVEDAD_CDP_VAL cval group by cval.id_novedad_cdp
              )val ON nov.id_novedad_cdp= val.id_novedad_cdp
              join PR_TIPO_NOVEDAD_CDP tip ON nov.id_tipo_novedad = tip.id_tipo_novedad_cdp
 )
 order by id]]>
		</queryString>
	</subDataset>
	<parameter name="whereOpciones" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="corte" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="vigencia" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereOpciones2" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["/home/egiraldo/Templates/Presupuesto/Informe Mensual de CDPS/"]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select id, fecha, objeto, valor_ini, id_vigencia, vigencia, fecha_nov, descripcion, adicion, reduccion
from(
select cdp.id, cdp.fecha as fecha, cdp.objeto,null as fecha_nov,
                  null as descripcion, cdp.id_vigencia, cdp.ano_fiscal as vigencia,
                  case when host.valor is null then inicial.valor else host.valor end as valor_ini,
                  0 as Adicion,
                  0 as Reduccion
              from  PR_CDP cdp
              join(
                select cpo.id_cdp, cpo.id_vigencia, cpo.ano_fiscal as vigencia, sum(asig.valor) as valor
                from PR_CDP_CPO cpo
                join pr_cpo_asign asig ON cpo.id = asig.id_pr_cdp_cpo
                and asig.ano_fiscal = cpo.ano_fiscal
                and asig.id_vigencia = cpo.id_vigencia group by cpo.id_cdp, cpo.id_vigencia, cpo.ano_fiscal
              )inicial ON inicial.id_cdp = cdp.id
                and inicial.id_vigencia = cdp.id_vigencia
                and inicial.vigencia = cdp.ano_fiscal
              left join
              (select  sum(hist.valor) as valor, hist.id_cdp, hist.id_vigencia, hist.vigencia
                from PR_HISTORIAL_CDP hist group by  hist.id_cdp, hist.id_vigencia, hist.vigencia
               )host On host.id_cdp = cdp.id
                and cdp.id_vigencia= host.id_vigencia
                and host.vigencia = cdp.ano_fiscal

            union

             select cdp.id, cdp.fecha as fecha, cdp.objeto, nov.fecha as fecha_nov,
                  tip.descripcion, cdp.id_vigencia, cdp.ano_fiscal as vigencia,
                  0 as valor_ini,
                  case
                    when tip.descripcion ='Adición'
                      then val.valor
                    else 0
                  end as Adicion,
                  case
                    when tip.descripcion ='Reducción' OR tip.descripcion='Anulación' OR tip.descripcion='Cierre'
                      then (val.valor*(-1))
                    else 0
                  end as Reduccion
              from  PR_CDP cdp
              join PR_NOVEDAD_CDP nov ON nov.id_cdp = cdp.id
                  and nov.id_vigencia = cdp.id_vigencia
                  and nov.vigencia = cdp.ano_fiscal
              join (select cval.id_novedad_cdp, sum(nvl(cval.debito,0) - nvl(cval.credito,0)) as valor
                    from PR_NOVEDAD_CDP_VAL cval group by cval.id_novedad_cdp
              )val ON nov.id_novedad_cdp= val.id_novedad_cdp
              join PR_TIPO_NOVEDAD_CDP tip ON nov.id_tipo_novedad = tip.id_tipo_novedad_cdp

              union

                select cdp.id, cdp.fecha as fech_cdp, cdp.objeto, nov.fecha as fecha,
                  tip.descripcion, cdp.id_vigencia, cdp.ano_fiscal as vigencia,
                  0 as valor_ini,
                  case
                    when tip.descripcion ='Adición'
                      then val.valor
                    else 0
                  end as Adicion,
                  case
                    when tip.descripcion ='Reducción' OR tip.descripcion='Anulación' OR tip.descripcion='Cierre'
                      then (val.valor*(-1))
                    else 0
                  end as Reduccion
              from  PR_CDP cdp
              join PR_NOVEDAD_CDP nov ON nov.id_cdp = cdp.id
                  and nov.id_vigencia = cdp.id_vigencia
                  and nov.vigencia = cdp.ano_fiscal
              join PR_TIPO_NOVEDAD_CDP tip ON nov.id_tipo_novedad = tip.id_tipo_novedad_cdp
              join (select cval.id_novedad_cdp, sum(nvl(cval.debito,0) - nvl(cval.credito,0)) as valor
                    from PR_NOVEDAD_CDP_VAL cval group by cval.id_novedad_cdp
              )val ON nov.id_novedad_cdp= val.id_novedad_cdp

              union
              --CDPS de comisiones:

              select cdp.id, cdp.fecha as fecha, cdp.objeto,null as fecha_nov,
                  null as descripcion, cdp.id_vigencia, cdp.ano_fiscal as vigencia,
                  case when host.valor is null then inicial.valor else host.valor end as valor_ini,
                  0 as Adicion,
                  0 as Reduccion
              from  PR_CDP_COMIS cdp
              join(
                select cpo.id_cdp, cpo.id_vigencia, cpo.ano_fiscal as vigencia, sum(asig.valor) as valor
                from PR_CDP_CPO cpo
                join pr_cpo_asign asig ON cpo.id = asig.id_pr_cdp_cpo
                and asig.ano_fiscal = cpo.ano_fiscal
                and asig.id_vigencia = cpo.id_vigencia group by cpo.id_cdp, cpo.id_vigencia, cpo.ano_fiscal
              )inicial ON inicial.id_cdp = cdp.id
                and inicial.id_vigencia = cdp.id_vigencia
                and inicial.vigencia = cdp.ano_fiscal
              left join
              (select  sum(hist.valor) as valor, hist.id_cdp, hist.id_vigencia, hist.vigencia
                from PR_HISTORIAL_CDP hist group by  hist.id_cdp, hist.id_vigencia, hist.vigencia
               )host On host.id_cdp = cdp.id
                and cdp.id_vigencia= host.id_vigencia
                and host.vigencia = cdp.ano_fiscal
            union
             select cdp.id, cdp.fecha as fecha, cdp.objeto, nov.fecha as fecha_nov,
                  tip.descripcion, cdp.id_vigencia, cdp.ano_fiscal as vigencia,
                  0 as valor_ini,
                  case
                    when tip.descripcion ='Adición'
                      then val.valor
                    else 0
                  end as Adicion,
                  case
                    when tip.descripcion ='Reducción' OR tip.descripcion='Anulación' OR tip.descripcion='Cierre'
                      then (val.valor*(-1))
                    else 0
                  end as Reduccion
              from  PR_CDP_COMIS cdp
              join PR_NOVEDAD_CDP nov ON nov.id_cdp = cdp.id
                  and nov.id_vigencia = cdp.id_vigencia
                  and nov.vigencia = cdp.ano_fiscal
              join PR_TIPO_NOVEDAD_CDP tip ON nov.id_tipo_novedad = tip.id_tipo_novedad_cdp
              join (select cval.id_novedad_cdp, sum(nvl(cval.debito,0) - nvl(cval.credito,0)) as valor
                    from PR_NOVEDAD_CDP_VAL cval group by cval.id_novedad_cdp
              )val ON nov.id_novedad_cdp= val.id_novedad_cdp


              union
                select cdp.id, cdp.fecha as fech_cdp, cdp.objeto, nov.fecha as fecha,
                  tip.descripcion, cdp.id_vigencia, cdp.ano_fiscal as vigencia,
                  0 as valor_ini,
                  case
                    when tip.descripcion ='Adición'
                      then val.valor
                    else 0
                  end as Adicion,
                  case
                    when tip.descripcion ='Reducción' OR tip.descripcion='Anulación' OR tip.descripcion='Cierre'
                      then (val.valor*(-1))
                    else 0
                  end as Reduccion
              from  PR_CDP_COMIS cdp
              join PR_NOVEDAD_CDP nov ON nov.id_cdp = cdp.id
                  and nov.id_vigencia = cdp.id_vigencia
                  and nov.vigencia = cdp.ano_fiscal
              join PR_TIPO_NOVEDAD_CDP tip ON nov.id_tipo_novedad = tip.id_tipo_novedad_cdp
              join (select cval.id_novedad_cdp, sum(nvl(cval.debito,0) - nvl(cval.credito,0)) as valor
                    from PR_NOVEDAD_CDP_VAL cval group by cval.id_novedad_cdp
              )val ON nov.id_novedad_cdp= val.id_novedad_cdp
)
where 1=1
$P!{whereOpciones}
order by id, fecha, fecha_nov desc]]>
	</queryString>
	<field name="ID" class="java.math.BigDecimal"/>
	<field name="FECHA" class="java.sql.Timestamp"/>
	<field name="OBJETO" class="java.lang.String"/>
	<field name="VALOR_INI" class="java.math.BigDecimal"/>
	<field name="ID_VIGENCIA" class="java.math.BigDecimal"/>
	<field name="VIGENCIA" class="java.lang.String"/>
	<field name="FECHA_NOV" class="java.sql.Timestamp"/>
	<field name="DESCRIPCION" class="java.lang.String"/>
	<field name="ADICION" class="java.math.BigDecimal"/>
	<field name="REDUCCION" class="java.math.BigDecimal"/>
	<variable name="VALOR_INI_1" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_INI}]]></variableExpression>
	</variable>
	<variable name="ADICION_1" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{ADICION}]]></variableExpression>
	</variable>
	<variable name="REDUCCION_1" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{REDUCCION}]]></variableExpression>
	</variable>
	<variable name="TOTAL_1" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[($F{VALOR_INI}+$F{ADICION})-$F{REDUCCION}]]></variableExpression>
	</variable>
	<variable name="TOTAL_SUBREPORTE" class="java.math.BigDecimal"/>
	<variable name="VALORINICIAL_SUBREPORTE" class="java.math.BigDecimal"/>
	<variable name="ADICION_SUBREPORTE" class="java.math.BigDecimal"/>
	<variable name="REDUCCION_SUBREPORTE" class="java.math.BigDecimal"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="60" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="1055" y="16" 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="1056" y="28" 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="383" y="0" width="460" height="22"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Informe Mensual de CDP"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="384" y="21" width="459" height="20"/>
				<textElement textAlignment="Center">
					<font size="12" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Periodo de: "+$P{corte}+" de "+$P{vigencia}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="384" y="40" width="459" height="20"/>
				<textElement textAlignment="Center">
					<font size="12" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["VIGENCIA ACTUAL"]]></textFieldExpression>
			</textField>
			<image>
				<reportElement x="0" y="0" width="176" 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="27" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="56" height="27" 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 NO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="56" y="0" width="140" height="27" forecolor="#000000" backcolor="#64B0F7"/>
				<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="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[FECHA CDP]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="196" y="0" width="282" height="27" forecolor="#000000" backcolor="#64B0F7"/>
				<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="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[OBJETO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="478" y="0" width="124" height="27" forecolor="#000000" backcolor="#64B0F7"/>
				<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="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[FECHA NOVEDAD		]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="720" y="0" width="121" height="27" forecolor="#000000" backcolor="#64B0F7"/>
				<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="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[VALOR INICIAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="960" y="0" width="126" height="27" forecolor="#000000" backcolor="#64B0F7"/>
				<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="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[REDUCCION]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1086" y="0" width="130" height="27" forecolor="#000000" backcolor="#64B0F7"/>
				<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="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[VALOR TOTAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="602" y="0" width="118" height="27" forecolor="#000000" backcolor="#64B0F7"/>
				<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="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[TIPO NOVEDAD]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="841" y="0" width="119" height="27" forecolor="#000000" backcolor="#64B0F7"/>
				<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="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[ADICION]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="21" splitType="Stretch">
			<textField>
				<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="56" height="21"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{ID}]]></textFieldExpression>
			</textField>
			<textField pattern="yyyy-MM-dd" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="56" y="0" width="140" height="21" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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.sql.Timestamp"><![CDATA[$F{FECHA}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="196" y="0" width="282" height="21" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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.lang.String"><![CDATA[$F{OBJETO}]]></textFieldExpression>
			</textField>
			<textField pattern="yyyy-MM-dd" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="478" y="0" width="124" height="21" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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.sql.Timestamp"><![CDATA[$F{FECHA_NOV}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="602" y="0" width="118" height="21" forecolor="#000000" backcolor="#FFFFFF"/>
				<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="Left" 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.lang.String"><![CDATA[$F{DESCRIPCION}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="720" y="0" width="121" height="21" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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.math.BigDecimal"><![CDATA[$F{VALOR_INI}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="841" y="0" width="119" height="21" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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.math.BigDecimal"><![CDATA[$F{ADICION}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="960" y="0" width="126" height="21" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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.math.BigDecimal"><![CDATA[$F{REDUCCION}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00" isBlankWhenNull="false">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1086" y="0" width="130" height="21" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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.math.BigDecimal"><![CDATA[($F{VALOR_INI}+$F{ADICION})-$F{REDUCCION}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="26"/>
	</columnFooter>
	<pageFooter>
		<band height="26" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="528" 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="618" 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="528" 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="42" splitType="Stretch">
			<staticText>
				<reportElement x="0" y="0" width="720" height="20"/>
				<box topPadding="4" 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="8" isBold="true"/>
				</textElement>
				<text><![CDATA[TOTAL CDPS MES]]></text>
			</staticText>
			<textField pattern="¤ #,##0.00">
				<reportElement x="720" y="0" width="121" height="20"/>
				<box topPadding="6" 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"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{VALOR_INI_1}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00">
				<reportElement x="841" y="0" width="119" height="20"/>
				<box topPadding="6" 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"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ADICION_1}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00">
				<reportElement x="960" y="0" width="126" height="20"/>
				<box topPadding="6" 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"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{REDUCCION_1}]]></textFieldExpression>
			</textField>
			<textField pattern="¤ #,##0.00">
				<reportElement x="1086" y="0" width="130" height="20"/>
				<box topPadding="6" 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"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{TOTAL_1}]]></textFieldExpression>
			</textField>
			<subreport>
				<reportElement x="0" y="20" width="1216" height="22"/>
				<subreportParameter name="TOTAL_ADICION">
					<subreportParameterExpression><![CDATA[$V{ADICION_1}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="TOTAL_REPORTE">
					<subreportParameterExpression><![CDATA[$V{TOTAL_1}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="TOTAL_REDUCCION">
					<subreportParameterExpression><![CDATA[$V{REDUCCION_1}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="TOTAL_VALORINI">
					<subreportParameterExpression><![CDATA[$V{VALOR_INI_1}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="whereOpciones2">
					<subreportParameterExpression><![CDATA[$P{whereOpciones2}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<returnValue subreportVariable="VALOR_INI_2" toVariable="VALORINICIAL_SUBREPORTE"/>
				<returnValue subreportVariable="ADICION_2" toVariable="ADICION_SUBREPORTE"/>
				<returnValue subreportVariable="REDUCCION_2" toVariable="REDUCCION_SUBREPORTE"/>
				<returnValue subreportVariable="SUBTOTAL_SUBREPORTE" toVariable="TOTAL_SUBREPORTE"/>
				<subreportExpression class="java.lang.String"><![CDATA["repo:subreporte_informe_mensual_cdp.jrxml"]]></subreportExpression>
			</subreport>
		</band>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="238" 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>
