<?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="est_com_bene" language="groovy" pageWidth="1295" pageHeight="792" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="1255" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.5"/>
	<property name="ireport.x" value="884"/>
	<property name="ireport.y" value="0"/>
	<parameter name="fechainicio" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="fechafin" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="idvigencia" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="vigencia" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="where2" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="wherep" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="wherea" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="where" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="where_estado" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="periodo" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT ID_PR_RP_COMIS,
  COMISION,
  FECHA_REGISTRO,
  FECHA_PAGO,
  DESCOMI,
  NITOCC,
  BENEFICIARIO,
  TIPO_TER,
  FEC_FUN,
  FEC_COM,
  RESOLU,
  VALOR,
  TIPO,
  CPO,
  PAGOS,
  REINT,
  AREA,
  DIASC,
  FEC_SAL_C,
  LEGALIZADO,
  LEGALIZADO_VIA,
  INTERR,
  FECHA_RAD,
  FECHA_REGRESO,
  FECHA_LIMITE,
  TOTAL_DIAS,
  ESTADO,
  TO_CHAR(FECHA_ESTADO,'dd-mm-yyyy') AS FECHA_ESTADO,
  DIAS_RESOL,
  TIPO_COMISIONADO,
  REPLACE_ENTITIES(OBJETO_COMISION) as OBJETO_COMISION,
  DESTINOS_COMISION
FROM
  ( SELECT DISTINCT prrpc.ID                              AS ID_PR_RP_COMIS,
    prrpc.id_comision                                     AS COMISION,
    prrpc.FECHA_PROCESO                                   AS FECHA_REGISTRO,
    algo.FECHA_PROC                                       AS FECHA_PAGO,
    tipco.DESCOMI                                         AS DESCOMI,
    ter.NITOCC                                            AS NITOCC ,
    ter.RAZSOC                                            AS BENEFICIARIO,
    ter.TIPTER                                            AS TIPO_TER,
    prresol.FECHA_FUNCIONARIO                             AS FEC_FUN,
    prresol.FECHA_COMISIONADO                             AS FEC_COM,
    prresol.RESOLUCION                                    AS RESOLU,
    val_sum                                               AS VALOR,
    DECODE(pro.func_inv,1,'INVERSION',0,'FUNCIONAMIENTO') AS TIPO,
    pro.codigo                                            AS CPO,
    algo.pagos                                            AS pagos,
    reint.reint                                           AS REINT,
    area.descripcion                                      AS area,
    avan.dias_comi                                        AS DIASC,
    avan.fecha_ini_comi                                   AS FEC_SAL_C,
    legal.valor                                           AS legalizado,
    legal_via.valor                                       AS legalizado_via,
    CASE
      WHEN com.interrupcion=1
      THEN 'I'
      ELSE ''
    END                                                         AS interr,
    rad.fecha_proceso                                           AS FECHA_RAD,
    TO_CHAR(avan.fecha_fin_comi,'yyyy-mm-dd')                   AS FECHA_REGRESO,
    TO_CHAR(dias_habiles(avan.fecha_fin_comi , 5 ),'yyyy-mm-dd')AS fecha_limite,
    dias.total_dias,
    NVL(
    (SELECT tab0.id_tipo_nov_comis
    FROM pr_cierre_comision tab0
    WHERE tab0.id_rp_comis      = prrpc.id
    AND tab0.id_vigencia        = prrpc.id_vigencia
    AND prrpc.vigencia          = tab0.vigencia
    AND tab0.id_cierre_comision =
      (SELECT MAX(tab1.id_cierre_comision)
      FROM pr_cierre_comision tab1
      WHERE tab1.id_rp_comis = prrpc.id
      AND tab1.id_vigencia   = prrpc.id_vigencia
      AND prrpc.vigencia     = tab1.vigencia
      )
    ),31) AS ESTADO,
    (SELECT tab0.fecha_proceso
    FROM pr_cierre_comision tab0
    WHERE tab0.id_rp_comis      = prrpc.id
    AND tab0.id_vigencia        = prrpc.id_vigencia
    AND prrpc.vigencia          = tab0.vigencia
    AND tab0.id_cierre_comision =
      (SELECT MAX(tab1.id_cierre_comision)
      FROM pr_cierre_comision tab1
      WHERE tab1.id_rp_comis = prrpc.id
      AND tab1.id_vigencia   = prrpc.id_vigencia
      AND prrpc.vigencia     = tab1.vigencia
      )
    )                                       AS FECHA_ESTADO,
    NVL(contrato.dias,0)+NVL(planta.dias,0) AS DIAS_RESOL,
    CASE
      WHEN contrato.nitocc IS NOT NULL
      THEN 'CONTRATISTA'
      ELSE 'FUNCIONARIO'
    END            AS tipo_comisionado,
    com.objetivo   AS objeto_comision,
    dest.municipio AS destinos_comision
  FROM PR_RP_COMIS prrpc
  LEFT JOIN
    (SELECT prrpc.ID,
      prrpc.id_vigencia,
      prrpc.vigencia,
      MAX(tspag.FECHA_PROC) AS FECHA_PROC,
      SUM(prcom.valor)      AS pagos
    FROM PR_RP_COMIS prrpc
    JOIN
      (SELECT tab0.id,
        tab0.id_vigencia,
        tab0.vigencia,
        CASE
          WHEN NVL(tab1.debito,0) + NVL(tab1.credito,0) = 0
          THEN tab3.valor
          WHEN tab4.cantidad IS NOT NULL
          THEN tab2.valor + NVL(tab5.debito,0) - NVL(tab5.credito,0)
          ELSE tab2.valor + NVL(tab5.debito,0) - NVL(tab5.credito,0)
        END AS VALOR
      FROM pr_rp_comis tab0
      LEFT JOIN
        (SELECT nov.id_rp,
          nov.id_vigencia,
          nov.vigencia,
          SUM(NVL(val.debito,0))  AS DEBITO,
          SUM(NVL(val.credito,0)) AS CREDITO
        FROM pr_novedad_rp_val val
        LEFT JOIN pr_novedad_rp nov
        ON val.id_novedad_rp = nov.id_novedad_rp
        GROUP BY nov.id_rp,
          nov.id_vigencia,
          nov.vigencia
        )tab1 ON tab1.id_rp = tab0.id
      AND tab1.id_vigencia  = tab0.id_vigencia
      AND tab1.vigencia     = tab0.vigencia
      LEFT JOIN
        (SELECT hist.id_rp,
          hist.id_vigencia,
          hist.vigencia,
          SUM(NVL(hist.valor,0)) AS VALOR
        FROM pr_historial_rp hist
        GROUP BY hist.id_rp,
          hist.id_vigencia,
          hist.vigencia
        )tab2
      ON tab2.id_rp        = tab0.id
      AND tab2.id_vigencia = tab0.id_vigencia
      AND tab2.vigencia    = tab0.vigencia
      LEFT JOIN
        (SELECT prcom.id_rp,
          prcom.id_vigencia,
          prcom.vigencia,
          SUM(NVL(prcom.valor,0)) AS VALOR
        FROM pr_rp_compromiso prcom
        GROUP BY prcom.id_rp,
          prcom.id_vigencia,
          prcom.vigencia
        )tab3
      ON tab3.id_rp        = tab0.id
      AND tab3.id_vigencia = tab0.id_vigencia
      AND tab3.vigencia    = tab0.vigencia
      LEFT JOIN
        (SELECT rp.id,
          rp.id_vigencia,
          rp.vigencia,
          nov.id_novedad_rp AS CANTIDAD
        FROM pr_rp_comis rp
        LEFT JOIN pr_novedad_rp nov
        ON rp.id                 = nov.id_rp
        AND rp.id_vigencia       = nov.id_vigencia
        AND rp.vigencia          = nov.vigencia
        AND nov.id_tipo_novedad != 7
        )tab4 ON tab4.id         = tab0.id
      AND tab4.id_vigencia       = tab0.id_vigencia
      AND tab4.vigencia          = tab0.vigencia
      LEFT JOIN
        (SELECT nov.id_rp,
          nov.id_vigencia,
          nov.vigencia,
          SUM(NVL(val.debito,0))  AS DEBITO,
          SUM(NVL(val.credito,0)) AS CREDITO
        FROM pr_novedad_rp_val val
        LEFT JOIN pr_novedad_rp nov
        ON val.id_novedad_rp    = nov.id_novedad_rp
        AND nov.id_tipo_novedad = 7
        GROUP BY nov.id_rp,
          nov.id_vigencia,
          nov.vigencia
        )tab5 ON tab5.id_rp = tab0.id
      AND tab5.id_vigencia  = tab0.id_vigencia
      AND tab5.vigencia     = tab0.vigencia
      )prcom ON prcom.id    = prrpc.id
    AND prcom.id_vigencia   = prrpc.id_vigencia
    AND prcom.vigencia      = prrpc.vigencia
    LEFT JOIN
      ( SELECT DISTINCT tspag.ID_RP,
        tspag.ID_VIGENCIA,
        tspag.VIGENCIA,
        tspag.id_clase_pago,
        MAX(tsemi.fecha_proc) AS FECHA_PROC
      FROM TS_PAGO_OBL tspag
      JOIN TS_EMISION_PAGO tsemi
      ON tspag.ID_EMISION_PAGO = tsemi.ID_EMISION_PAGO
      AND tsemi.fecha_proc    >= to_date($P{fechainicio}, 'DD-MM-YYYY')
      AND tsemi.fecha_proc    <= to_date($P{fechafin}, 'DD-MM-YYYY')
      AND tspag.estado        IS NULL
      GROUP BY tspag.ID_RP,
        tspag.ID_VIGENCIA,
        tspag.VIGENCIA,
        tspag.id_clase_pago
      )tspag ON prrpc.ID     = tspag.ID_RP
    AND prrpc.ID_VIGENCIA    = tspag.ID_VIGENCIA
    AND prrpc.VIGENCIA       = tspag.VIGENCIA
    AND tspag.id_clase_pago IS NULL
    WHERE prrpc.ESTADO       =1
    GROUP BY prrpc.ID,
      prrpc.id_vigencia,
      prrpc.vigencia
    )algo ON prrpc.id   =algo.id
  AND prrpc.id_vigencia = algo.id_vigencia
  AND prrpc.vigencia    = algo.vigencia
  LEFT JOIN
    (SELECT contrato.vigencia,
      contrato.id_comision,
      contrato.nitocc,
      NVL(SUM(contrato.dias),0) AS dias
    FROM comisionados_contrato contrato
    GROUP BY contrato.vigencia,
      contrato.id_comision,
      contrato.nitocc
    )contrato
  ON contrato.id_comision=prrpc.id_comision
  AND contrato.vigencia  =prrpc.vigencia
  AND contrato.nitocc    =prrpc.id_tercero
  LEFT JOIN
    (SELECT planta.vigencia,
      planta.id_comision,
      planta.nitocc,
      NVL(SUM(planta.dias),0) AS dias
    FROM comisionados_planta planta
    GROUP BY planta.vigencia,
      planta.id_comision,
      planta.nitocc
    )planta
  ON planta.id_comision=prrpc.id_comision
  AND planta.vigencia  =prrpc.vigencia
  AND planta.nitocc    =prrpc.id_tercero
  LEFT JOIN
    (SELECT rp.id_vigencia,
      rp.vigencia,
      rp.id_tercero,
      SUM(rp.TOTAL_DIAS) TOTAL_DIAS
    FROM
      (SELECT ava.dias_comi TOTAL_DIAS,
        rp.id,
        rp.id_vigencia,
        rp.vigencia,
        rp.id_tercero,
        rp.fecha_proceso,
        NVL(
        (SELECT tab0.id_tipo_nov_comis
        FROM pr_cierre_comision tab0
        WHERE tab0.id_rp_comis      = rp.id
        AND tab0.id_vigencia        = rp.id_vigencia
        AND rp.vigencia             = tab0.vigencia
        AND tab0.id_cierre_comision =
          (SELECT MAX(tab1.id_cierre_comision)
          FROM pr_cierre_comision tab1
          WHERE tab1.id_rp_comis = rp.id
          AND tab1.id_vigencia   = rp.id_vigencia
          AND rp.vigencia        = tab1.vigencia
          )
        ),31) AS ESTADO
      FROM PR_AVANCES_COMISIONES ava
      JOIN pr_rp_comis rp
      ON rp.id           = ava.id_rp_comis
      AND rp.id_vigencia = ava.id_vigencia
      AND rp.vigencia    = ava.vigencia
      )rp
    WHERE rp.estado      != -1
    AND rp.fecha_proceso >= to_date($P{fechainicio}, 'DD-MM-YYYY')
    AND rp.fecha_proceso <= to_date($P{fechafin}, 'DD-MM-YYYY')
    AND rp.id_vigencia    = $P{idvigencia}
    AND rp.vigencia       = $P{vigencia}
    $P!{where2}
    GROUP BY rp.id_vigencia,
      rp.vigencia,
      rp.id_tercero
    )dias ON dias.id_vigencia = prrpc.id_vigencia
  AND dias.vigencia           = prrpc.vigencia
  AND dias.id_tercero         = prrpc.id_tercero
  JOIN
    ( SELECT NITOCC, RAZSOC, DECODE (TIPTER,1,2,2,1) AS TIPTER FROM TERCEROS
    ) ter
  ON prrpc.ID_TERCERO = ter.NITOCC
  JOIN COMISIONES com
  ON prrpc.vigencia     = com.vigencia
  AND prrpc.id_comision = com.id
  JOIN TIPOS_COMISION tipco
  ON com.TIPCOMI = tipco.TIPCOMI
  LEFT JOIN
    (SELECT aut.*,
      ROW_NUMBER() OVER ( partition BY aut.vigencia, aut.id_comision, aut.nitocc ORDER BY aut.vigencia DESC, aut.id_comision DESC, aut.nitocc ) AS rn
    FROM comisionados_objs aut
    )com_objs
  ON com.vigencia      = com_objs.vigencia
  AND com.id           = com_objs.id_comision
  AND prrpc.ID_TERCERO = com_objs.nitocc
  AND com_objs.rn      = 1
  LEFT JOIN objetos_gasto obj_gas
  ON obj_gas.ano_fiscal = com_objs.vigencia
  AND obj_gas.codigo    = com_objs.codobj
  LEFT JOIN
    (SELECT aut.NITOCC,
      aut.ID_COMISION,
      TO_CHAR(wm_concat(aut.CODMUN)) AS CODMUN,
      TO_CHAR(wm_concat(mun.depto))  AS coddepto,
      TO_CHAR(wm_concat(mun.municipio
      || ' - '
      || dep.descripcion)) AS municipio,
      aut.ESTADO,
      aut.VIGENCIA
    FROM destinos_comisionados aut
    LEFT JOIN municipios mun
    ON aut.codmun = mun.codmun
    LEFT JOIN departamento dep
    ON dep.id_depto  = mun.depto
    WHERE aut.estado = 1
    GROUP BY aut.NITOCC,
      aut.ID_COMISION,
      aut.ESTADO,
      aut.VIGENCIA
    )dest ON com.vigencia = dest.vigencia
  AND com.id              = dest.id_comision
  AND prrpc.ID_TERCERO    = dest.nitocc
  LEFT JOIN PR_RESOL_COMIS prresol
  ON prresol.id = prrpc.no_acto_admin
  JOIN PR_RP_COMPROMISO prrpcomp
  ON prrpc.ID           = prrpcomp.ID_RP
  AND prrpc.ID_VIGENCIA = prrpcomp.ID_VIGENCIA
  AND prrpc.VIGENCIA    = prrpcomp.VIGENCIA
  AND prrpcomp.valor   IS NOT NULL
  JOIN PROYECTOS pro
  ON prrpcomp.id_cpo = pro.id
  $P!{wherep} $P!{wherea}
  JOIN AREAS area
  ON pro.id_area_lider = area.id_area
  LEFT JOIN PR_AVANCES_COMISIONES avan
  ON prrpc.id           = avan.id_rp_comis
  AND prrpc.id_vigencia = avan.id_vigencia
  AND prrpc.vigencia    = avan.vigencia
  LEFT JOIN PR_RADICADO_COMIS rad
  ON rad.id_rp_comis    =prrpc.id
  AND prrpc.id_vigencia = rad.id_vigencia
  AND prrpc.vigencia    = rad.vigencia
  LEFT JOIN
    (SELECT legal.id_rp_comis AS id,
      legal.id_vigencia,
      legal.vigencia,
      NVL(SUM(legal.v_bruto),0)+NVL(SUM(legal.v_iva),0) AS valor
    FROM PR_LEGALIZACION_COMIS legal
    JOIN PR_RP_COMIS rpc
    ON legal.id_rp_comis  = rpc.id
    AND legal.id_vigencia = rpc.id_vigencia
    AND legal.vigencia    = rpc.vigencia
    GROUP BY legal.id_rp_comis,
      legal.id_vigencia,
      legal.vigencia
    )legal ON prrpc.id  = legal.id
  AND legal.id_vigencia = prrpc.id_vigencia
  AND prrpc.vigencia    = legal.vigencia
  LEFT JOIN
    (SELECT legal.id_rp_comis AS id,
      legal.id_vigencia,
      legal.vigencia,
      NVL(SUM(legal.v_bruto),0)+NVL(SUM(legal.v_iva),0) AS valor
    FROM PR_LEGALIZACION_COMIS legal
    JOIN PR_RP_COMIS rpc
    ON legal.id_rp_comis           = rpc.id
    AND legal.id_vigencia          = rpc.id_vigencia
    AND legal.vigencia             = rpc.vigencia
    WHERE legal.id_elementos_gasto = 32
    GROUP BY legal.id_rp_comis,
      legal.id_vigencia,
      legal.vigencia
    )legal_via ON prrpc.id  = legal_via.id
  AND legal_via.id_vigencia = prrpc.id_vigencia
  AND prrpc.vigencia        = legal_via.vigencia
  LEFT JOIN
    (SELECT prrpc.id AS ID_RP,
      prrpc.id_vigencia,
      prrpc.vigencia,
      SUM(NVL(prdeta.valor,0)) AS reint
    FROM PR_RP_COMIS prrpc
    LEFT JOIN PR_REINTEGRO prein
    ON prrpc.id           = prein.id_rp
    AND prrpc.id_vigencia = prein.id_vigencia
    AND prrpc.vigencia    = prein.vigencia
    AND prein.estado     IS NULL
    LEFT JOIN PR_DETA_REIN prdeta
    ON prein.id_reintegro = prdeta.id_reintegro
    GROUP BY prrpc.id,
      prrpc.id_vigencia,
      prrpc.vigencia
    )reint ON prrpc.id  = reint.id_rp
  AND prrpc.id_vigencia = reint.id_vigencia
  AND prrpc.vigencia    = reint.vigencia
  LEFT JOIN
    (SELECT prrpc.ID,
      SUM(prrpcomp.VALOR) AS val_sum
    FROM PR_RP_COMIS prrpc
    JOIN PR_RP_COMPROMISO prrpcomp
    ON prrpc.ID           = prrpcomp.ID_RP
    AND prrpc.ID_VIGENCIA = prrpcomp.ID_VIGENCIA
    AND prrpc.VIGENCIA    = prrpcomp.VIGENCIA
    GROUP BY prrpc.ID
    ) prrpc2 ON prrpc.ID   = prrpc2.ID
  WHERE prrpc.ESTADO       =1
  AND prrpc.fecha_proceso >= to_date($P{fechainicio}, 'DD-MM-YYYY')
  AND prrpc.fecha_proceso <= to_date($P{fechafin}, 'DD-MM-YYYY')
  AND prrpc.id_vigencia    = $P{idvigencia}
  AND prrpc.vigencia       = $P{vigencia}
  $P!{where}
  ) $P!{where_estado}
ORDER BY TOTAL_DIAS DESC,
  NITOCC,
  CPO,
  ID_PR_RP_COMIS]]>
	</queryString>
	<field name="ID_PR_RP_COMIS" class="java.math.BigDecimal"/>
	<field name="COMISION" class="java.math.BigDecimal"/>
	<field name="FECHA_REGISTRO" class="java.sql.Timestamp"/>
	<field name="FECHA_PAGO" class="java.sql.Timestamp"/>
	<field name="DESCOMI" class="java.lang.String"/>
	<field name="NITOCC" class="java.math.BigDecimal"/>
	<field name="BENEFICIARIO" class="java.lang.String"/>
	<field name="TIPO_TER" class="java.math.BigDecimal"/>
	<field name="FEC_FUN" class="java.sql.Timestamp"/>
	<field name="FEC_COM" class="java.sql.Timestamp"/>
	<field name="RESOLU" class="java.lang.String"/>
	<field name="VALOR" class="java.math.BigDecimal"/>
	<field name="TIPO" class="java.lang.String"/>
	<field name="CPO" class="java.lang.String"/>
	<field name="PAGOS" class="java.math.BigDecimal"/>
	<field name="REINT" class="java.math.BigDecimal"/>
	<field name="AREA" class="java.lang.String"/>
	<field name="DIASC" class="java.lang.Double"/>
	<field name="FEC_SAL_C" class="java.sql.Timestamp"/>
	<field name="LEGALIZADO" class="java.math.BigDecimal"/>
	<field name="LEGALIZADO_VIA" class="java.math.BigDecimal"/>
	<field name="INTERR" class="java.lang.String"/>
	<field name="FECHA_RAD" class="java.sql.Timestamp"/>
	<field name="FECHA_REGRESO" class="java.lang.String"/>
	<field name="FECHA_LIMITE" class="java.lang.String"/>
	<field name="TOTAL_DIAS" class="java.math.BigDecimal"/>
	<field name="ESTADO" class="java.math.BigDecimal"/>
	<field name="FECHA_ESTADO" class="java.lang.String"/>
	<field name="DIAS_RESOL" class="java.math.BigDecimal"/>
	<field name="TIPO_COMISIONADO" class="java.lang.String"/>
	<field name="OBJETO_COMISION" class="java.lang.String"/>
	<field name="DESTINOS_COMISION" class="java.lang.String"/>
	<variable name="COUNT_NITOCC_GROUP" class="java.math.BigDecimal" resetType="Group" resetGroup="Comisiones" calculation="Count">
		<variableExpression><![CDATA[$F{NITOCC}]]></variableExpression>
	</variable>
	<variable name="SUM_DIASLEG" class="java.math.BigDecimal" resetType="Group" resetGroup="Comisiones" calculation="Sum">
		<variableExpression><![CDATA[$F{DIASC}]]></variableExpression>
		<initialValueExpression><![CDATA[0]]></initialValueExpression>
	</variable>
	<variable name="SUM_VALORPAGOS" class="java.math.BigDecimal" resetType="Group" resetGroup="Comisiones" calculation="Sum">
		<variableExpression><![CDATA[$F{PAGOS}]]></variableExpression>
	</variable>
	<variable name="SUM_VAL_LEG_SOP" class="java.math.BigDecimal" resetType="Group" resetGroup="Comisiones" calculation="Sum">
		<variableExpression><![CDATA[$F{LEGALIZADO}]]></variableExpression>
	</variable>
	<variable name="SUM_VAL_LEG_VIA" class="java.math.BigDecimal" resetType="Group" resetGroup="Comisiones" calculation="Sum">
		<variableExpression><![CDATA[$F{LEGALIZADO_VIA}]]></variableExpression>
	</variable>
	<variable name="SUM_REINT" class="java.math.BigDecimal" resetType="Group" resetGroup="Comisiones" calculation="Sum">
		<variableExpression><![CDATA[$F{REINT}]]></variableExpression>
	</variable>
	<variable name="COUNT_TCOMISIONES" class="java.lang.Integer" calculation="Count">
		<variableExpression><![CDATA[$F{NITOCC}]]></variableExpression>
	</variable>
	<variable name="SUM_TDIASLEG" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{DIASC}]]></variableExpression>
	</variable>
	<variable name="SUM_TPAGOS" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{PAGOS}]]></variableExpression>
	</variable>
	<variable name="SUM_TVAL_LEG_SOP" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{LEGALIZADO}]]></variableExpression>
	</variable>
	<variable name="SUM_TVAL_LEG_VIA" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{LEGALIZADO_VIA}]]></variableExpression>
	</variable>
	<variable name="SUM_TREINT" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{REINT}]]></variableExpression>
	</variable>
	<group name="Comisiones">
		<groupExpression><![CDATA[$F{NITOCC}]]></groupExpression>
		<groupFooter>
			<band height="10" splitType="Prevent">
				<textField evaluationTime="Group" evaluationGroup="Comisiones">
					<reportElement x="0" y="0" width="603" height="10"/>
					<textElement>
						<font size="6" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA["Total de: "+$V{COUNT_NITOCC_GROUP}+" comisiones"]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="603" y="0" width="26" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
					<box rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA["0.00"]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="629" y="0" width="27" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
					<box rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.lang.Double"><![CDATA[$V{SUM_DIASLEG}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="826" y="0" width="55" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
					<box rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{SUM_VALORPAGOS}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="881" y="0" width="55" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
					<box rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{SUM_VAL_LEG_SOP}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="936" y="0" width="55" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
					<box rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{SUM_VAL_LEG_VIA}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="991" y="0" width="50" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
					<box rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{SUM_REINT}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1041" y="0" width="55" height="10" isPrintWhenDetailOverflows="true" forecolor="#000000" backcolor="#FFFFFF"/>
					<box rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{SUM_VALORPAGOS}-$V{SUM_REINT}]]></textFieldExpression>
				</textField>
			</band>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="108" splitType="Stretch">
			<staticText>
				<reportElement x="373" y="12" width="508" height="35"/>
				<textElement textAlignment="Center" verticalAlignment="Bottom" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Sistema General de Presupuesto
Estado Comisiones por Beneficiario
]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="936" y="35" width="160" 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="936" y="47" width="160" 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="373" y="70" width="508" height="20" forecolor="#AACCEE"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font size="12" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{periodo}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="373" y="47" width="508" height="24" forecolor="#AACCEE"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[LEGALIZACIÓN DE COMISIONES]]></text>
			</staticText>
			<textField>
				<reportElement x="0" y="82" width="198" height="13"/>
				<textElement markup="none">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{vigencia}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="95" width="198" height="13"/>
				<textElement markup="none">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Resultados: 1000"]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="36" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="69" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[AREA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="69" y="0" width="39" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="5" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[DOCUMENTO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="108" y="0" width="90" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[BENEFICIARIO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="198" y="0" width="58" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[TIPO COMISIONADO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="256" y="0" width="43" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[TIPO COMISION]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="299" y="0" width="11" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[I]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="310" y="0" width="38" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="5" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[NO RESOLUCION]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="348" y="0" width="25" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[RP]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="373" y="0" width="33" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[FECHA RP]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="406" y="0" width="63" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[OBJETO COMISION]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="656" y="0" width="86" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[DESTINOS COMISION]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="629" y="0" width="27" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[DIAS (LEG)]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="603" y="0" width="26" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[DIAS (RES)]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="555" y="0" width="48" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[FECHA LIMITE RADICADO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="512" y="0" width="43" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[FECHA REGRESO (CUMPLIDO)]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="469" y="0" width="43" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[FECHA SALIDA (RES)]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="782" y="0" width="44" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[TIPO RECURSO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="742" y="0" width="40" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CPO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="826" y="0" width="55" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[VALOR PAGOS]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="881" y="0" width="55" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[VALOR LEGALIZADO EN SOPORTES]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="936" y="0" width="55" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[VALOR LEGALIZADO EN VIATICOS]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="991" y="0" width="50" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[VALOR REINT]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1041" y="0" width="55" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[VALOR FINAL COMISION]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1096" y="0" width="43" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[FECHA SALIDA (CUMPLIDO)]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1139" y="0" width="43" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[FECHA RADICADO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1182" y="0" width="43" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[ESTADO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1225" y="0" width="30" height="35" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[FECHA ESTADO]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="10" splitType="Prevent">
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="0" y="0" width="69" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{AREA}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="108" y="0" width="90" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box 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="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{BENEFICIARIO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="198" y="0" width="58" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box 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="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TIPO_COMISIONADO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="256" y="0" width="43" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESCOMI}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="69" y="0" width="39" height="10" 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="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NITOCC}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="348" y="0" width="25" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ID_PR_RP_COMIS}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="299" y="0" width="11" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{INTERR}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="555" y="0" width="48" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{FECHA_LIMITE}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="512" y="0" width="43" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{FECHA_REGRESO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="469" y="0" width="43" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="406" y="0" width="63" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{OBJETO_COMISION}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="373" y="0" width="33" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{FECHA_REGISTRO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="310" y="0" width="38" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RESOLU}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="603" y="0" width="26" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="629" y="0" width="27" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{DIASC}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="656" y="0" width="86" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESTINOS_COMISION}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="742" y="0" width="40" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CPO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="936" y="0" width="55" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{LEGALIZADO_VIA}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="826" y="0" width="55" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PAGOS}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="782" y="0" width="44" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TIPO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="881" y="0" width="55" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{LEGALIZADO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="991" y="0" width="50" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{REINT}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1139" y="0" width="43" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{FECHA_RAD}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1096" y="0" width="43" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1041" y="0" width="55" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{PAGOS}-$F{REINT}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1182" y="0" width="43" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ESTADO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1225" y="0" width="30" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{FECHA_ESTADO}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="24" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="24" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="552" 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="642" 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="552" 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="10" splitType="Stretch">
			<textField>
				<reportElement x="0" y="0" width="603" height="9"/>
				<textElement>
					<font size="6" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Total: "+$V{COUNT_TCOMISIONES}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="629" y="0" width="27" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{SUM_TDIASLEG}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="826" y="0" width="55" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{SUM_TPAGOS}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="881" y="0" width="55" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{SUM_TVAL_LEG_SOP}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="936" y="0" width="55" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{SUM_TVAL_LEG_VIA}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="991" y="0" width="50" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{SUM_TREINT}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1041" y="0" width="55" height="10" isPrintWhenDetailOverflows="true" forecolor="#000000" backcolor="#FFFFFF"/>
				<box rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{SUM_TPAGOS}-$V{SUM_TREINT}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="252" 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>
