<?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="certif_ingre_reten_res" language="groovy" pageWidth="2300" pageHeight="612" orientation="Landscape" columnWidth="2260" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.5000000000000029"/>
	<property name="ireport.x" value="2328"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/nomina/consol_ingre_reten_func_res"/>
	<property name="ireport.jasperserver.url" value="http://192.168.2.43:8090/jasperserver/services/repository"/>
	<parameter name="fecha_ini" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="fecha_fin" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereFuncionarioNumDoc" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereFuncionarioTipoDoc" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="id_anhos" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select distinct
tab0.*,
tab1.agrup1,
tab1.agrup2,
tab1.agrup3,
tab1.agrup4,
tab1.agrup5,
tab1.agrup6,
tab1.ces,
tab1.cesconsig,
tab1.viaticos,
tab1.otros,
tab1.apovol,
tab1.apoafc,
tab1.prsetsoc,
tab1.apoyedu,
tab1.covidvol,
tab1.covidobl,
tab1.promedio

from(

    select distinct

    (
        select max(cert.secuencia) from no_consecutivo_certif cert
        where cert.id_anhos = tab0.id_anhos
        and  cert.id_tipo_doc = tab0.id_tipo_doc
        and  cert.num_doc = tab0.num_doc
    ) as secuencia,
    case when nomb.fecha_termina between  to_date( $P{fecha_ini}, 'dd/mm/yyyy') and to_date( $P{fecha_fin}, 'dd/mm/yyyy')
    then 1 else 0 end as retiro,

    to_char(
    case when nomb.fecha_ingreso > to_date( $P{fecha_ini}, 'dd/mm/yyyy') then nomb.fecha_ingreso else to_date( $P{fecha_ini}, 'dd/mm/yyyy') end
    , 'yyyy-mm-dd') as fecha_ingreso,
    to_char(
    case when nomb.fecha_termina < to_date( $P{fecha_fin}, 'dd/mm/yyyy') then nomb.fecha_termina else to_date( $P{fecha_fin}, 'dd/mm/yyyy') end
    , 'yyyy-mm-dd') as fecha_termina,
    tipdoc.abreviacion,
    datcom.nit,
    digito_verificacion(datcom.nit) as dv,
    datcom.nombre_empresa,

    tab0.id_tipo_doc as id_tipo_doc,
    tab0.num_doc as num_doc,
    tab0.id_anhos as id_anhos,

    tab1.tipo_documento as tipo_documento, tab1.primer_nombre as primer_nombre,
    tab1.segundo_nombre as segundo_nombre, tab1.primer_apellido as primer_apellido, tab1.segundo_apellido as segundo_apellido, tab1.nombre_completo as nombre_completo,
    tab1.nombre_apellido as nombre_apellido, to_char(tab1.fecha_nace, 'YYYY-MM-DD') as fecha_nace,
    tab1.email as email, tab1.tel as telefono, tab1.direccion as direccion, tab1.pais_nace as pais_nace,
    tab1.depto_nace as depto_nace, tab1.muni_nace as muni_nace, tab1.genero as genero, tab1.estado_civil as estado_civil, tab1.tipo_sangre as tipo_sangre

    from no_certif_ingre_reten tab0

    JOIN NO_DATOS_FUNCIONARIO_V tab1 ON tab0.id_tipo_doc = tab1.id_tipo_doc AND tab0.num_doc = tab1.num_doc

    left join (
      SELECT
       aut.*,
       ROW_NUMBER() OVER (
        partition by aut.num_doc
        ORDER BY aut.id_anhos desc, aut.id_meses desc
       ) AS rn
      from no_estado_func aut
    )tab5
    on tab0.id_tipo_doc = tab5.id_tipo_doc and tab0.num_doc = tab5.num_doc
    and tab5.rn = 1

    left join no_dp_v dp
    on tab5.id_dp = dp.id_dp

    left join (
        select
        aut.id_tipo_doc,
        aut.num_doc,
        min(aut.fecha_ingreso) as fecha_ingreso,
        max( case when aut.fecha_termina is not null then aut.fecha_termina else to_date( $P{fecha_fin}, 'dd/mm/yyyy') end ) as fecha_termina,
        1 as rn
        from(
             SELECT
             aut.*,
             ROW_NUMBER() OVER (
              partition by aut.num_doc
              ORDER BY aut.fecha_ingreso
             ) AS rn
            from no_nombramiento aut
            where
            (
            aut.fecha_ingreso between  to_date( $P{fecha_ini}, 'dd/mm/yyyy') and to_date( $P{fecha_fin}, 'dd/mm/yyyy')
                or
            nvl(aut.fecha_termina,sysdate) between  to_date( $P{fecha_ini}, 'dd/mm/yyyy') and to_date( $P{fecha_fin}, 'dd/mm/yyyy')
            )
        )aut
        group by
        aut.id_tipo_doc,
        aut.num_doc
    )nomb
    on tab0.id_tipo_doc = nomb.id_tipo_doc and tab0.num_doc = nomb.num_doc
    and nomb.rn = 1

    LEFT JOIN datos_compania dat on dat.id = 1
    LEFT JOIN CENTRO_OPERACION tab7 ON tab7.id_cen_op = dat.id_cen_op AND tab7.id_cia = 1
    LEFT JOIN DEPARTAMENTO tab8 ON tab7.id_depto = tab8.id_depto
    LEFT JOIN MUNICIPIOS tab9 ON tab7.codmun = tab9.codmun

    left join datos_compania datcom
    on datcom.id = 1

    left join ciudad ciu
    on datcom.ciudad = ciu.id

    left join tipo_documento tipdoc
    on tipdoc.id_tipo_doc = tab1.id_tipo_doc

    where
    tab0.id_certif_ingre_reten != '-1'
    and tab0.id_anhos = $P{id_anhos}

)tab0

left join(

    select
    --tab.agrupacion_orden,
    tab.id_tipo_doc,
    tab.num_doc,
    /**
    Solicitud GA-#31530: Se retira valor absoluto ABS() para el certificado, conceptos devengados, antes todas - 20220822::LAVILA
    Se quita valor absoluto para agrupaciones de ingreso. para presentar negativo cuando realmente el valor es negativo
    Las agrupaciones de deducciones si conservan valor absoluto
    Incidente #37819: para salud y pension se valdia que si el valor es solo de devoluciones, no ponga el valor - 20240321:LAVILA
    */
    round(/*ABS*/(nvl( sum( case when tab.agrupacion_orden = 1  then tab.valor_total else 0 end) ,0 )),-3) as agrup1,
    round(ABS(nvl( case when sum( case when tab.agrupacion_orden = 2  then tab.valor_total else 0 end) > 0 then 0 else sum( case when tab.agrupacion_orden = 2  then tab.valor_total else 0 end) end ,0 )),-3) as agrup2,
    round(ABS(nvl( case when sum( case when tab.agrupacion_orden = 3  then tab.valor_total else 0 end) > 0 then 0 else sum( case when tab.agrupacion_orden = 3  then tab.valor_total else 0 end) end ,0 )),-3) as agrup3,
    round(/*ABS*/(nvl( sum( case when tab.agrupacion_orden = 4  then tab.valor_total else 0 end) ,0 )),-3) as agrup4,
    round(ABS(nvl( sum( case when tab.agrupacion_orden = 5  then tab.valor_total else 0 end) ,0 )),-3) as agrup5,
    round(/*ABS*/(nvl( sum( case when tab.agrupacion_orden = 6  then tab.valor_total else 0 end) ,0 )),-3) as agrup6,
    round(/*ABS*/(nvl( sum( case when tab.agrupacion_orden = 7  then tab.valor_total else 0 end) ,0 )),-3) as  ces,
    round(/*ABS*/(nvl( sum( case when tab.agrupacion_orden = 8  then tab.valor_total else 0 end) ,0 )),-3) as  otros,
    round(/*ABS*/(nvl( sum( case when tab.agrupacion_orden = 24  then tab.valor_total else 0 end) ,0 )),-3) as  viaticos,
    round(ABS(nvl( sum( case when tab.agrupacion_orden = 21 then tab.valor_total else 0 end) ,0 )),-3) as  apovol,
    round(ABS(nvl( sum( case when tab.agrupacion_orden = 22 then tab.valor_total else 0 end) ,0 )),-3) as  apoafc,
    round(/*ABS*/(nvl( sum( case when tab.agrupacion_orden = 23 then tab.valor_total else 0 end) ,0 )),-3) as  prsetsoc,
    round(/*ABS*/(nvl( sum( case when tab.agrupacion_orden = 25  then tab.valor_total else 0 end) ,0 )),-3) as  apoyedu,
    round(/*ABS*/(nvl( sum( case when tab.agrupacion_orden = 30 then tab.valor_total else 0 end) ,0 )),-3) as  covidvol,
    round(/*ABS*/(nvl( sum( case when tab.agrupacion_orden = 31 then tab.valor_total else 0 end) ,0 )),-3) as  covidobl,
    round(/*ABS*/(nvl( sum( case when tab.agrupacion_orden = 32 then tab.valor_total else 0 end) ,0 )),-3) as  cesconsig,

    round( nvl( (select sum(pr.valor_promedio)
    from no_promedio_ciyr pr
    where
    tab.id_tipo_doc = pr.id_tipo_doc
    and tab.num_doc = pr.num_doc
    and pr.id_anhos = $P{id_anhos}
    and pr.id_concep_nomina = 1
    ) , (
        select
        /*tab0.id_tipo_doc, tab0.num_doc,*/
        NVL(round(sum(tab0.valor_pro_mes)/count(tab0.valor_pro_mes) ) ,0) as valor

        from(

            select
            sum(tab.valor) as valor_pro_mes,
            case when sum(NUM_DIAS) != 0 then sum(NUM_DIAS) else 30 end as NUM_DIAS,
            tab.id_anhos,
            tab.id_meses,
            tab.id_tipo_doc,
            tab.num_doc

            from (
                    select
                    1 as dif,
                    tab0.id_cesantia,
                    NVL(tab0.valor_base,0) as valor,
                    case when  tab0.NUM_DIAS > 0 and tab0.NUM_DIAS < 30 then 30 else tab0.NUM_DIAS end as NUM_DIAS,
                    per.id_anhos, per.id_meses,
                    tab0.id_tipo_doc,
                    tab0.num_doc
                    from no_cesantia tab0 join no_periodo per on per.id_periodo = tab0.id_periodo
                    where
                    1 = 1 and per.id_anhos || lpad(per.id_meses, 2, '0')
                    between $P{id_anhos} || lpad( 7, 2, '0')  and $P{id_anhos} || lpad( 12, 2, '0')
                    $P!{whereFuncionarioNumDoc} $P!{whereFuncionarioTipoDoc}
                    and tab0.consolidado = 0
                    and per.id_tipo_periodo = 1

            )tab group by tab.id_anhos, tab.id_meses,
            tab.id_tipo_doc,
            tab.num_doc

        )tab0
        where
        tab0.id_tipo_doc = tab.id_tipo_doc
        and tab0.num_doc = tab.num_doc
        group by tab0.id_tipo_doc, tab0.num_doc
    ) ) ,-3) as promedio


    from (

        SELECT DISTINCT
        tab0.agrupacion_orden,
        tab0.id_certif_ingre_reten as id_certif_ingre_reten, tab0.id_tipo_doc as id_tipo_doc, tab0.num_doc as num_doc, tab0.id_anhos as id_anhos,
        tab0.id_concep_nomina as id_concep_nomina, tab0.valor_enero as valor_enero, tab0.valor_febrero as valor_febrero, tab0.valor_marzo as valor_marzo,
        tab0.valor_abril as valor_abril, tab0.valor_mayo as valor_mayo, tab0.valor_junio as valor_junio, tab0.valor_julio as valor_julio,
        tab0.valor_agosto as valor_agosto, tab0.valor_septiembre as valor_septiembre, tab0.valor_octubre as valor_octubre, tab0.valor_noviembre as valor_noviembre,
        tab0.valor_diciembre as valor_diciembre,

        --tab0.valor_total as valor_total,
        case when tab2.operador = 1 then tab0.valor_total else tab0.valor_total * (-1) end as valor_total,

        tab1.tipo_documento as tipo_documento, tab1.primer_nombre as primer_nombre,
        tab1.segundo_nombre as segundo_nombre, tab1.primer_apellido as primer_apellido, tab1.segundo_apellido as segundo_apellido, tab1.nombre_completo as nombre_completo,
        tab1.nombre_apellido as nombre_apellido, to_char(tab1.fecha_nace, 'YYYY-MM-DD') as fecha_nace,
        tab1.email as email, tab1.tel as telefono, tab1.direccion as direccion, tab1.pais_nace as pais_nace,
        tab1.depto_nace as depto_nace, tab1.muni_nace as muni_nace, tab1.genero as genero, tab1.estado_civil as estado_civil, tab1.tipo_sangre as
        tipo_sangre, tab2.codigo as codigo, tab2.descripcion as descripcion, tab2.codigo||' - '||tab2.descripcion as completo,
        tab2.id_tipo_concepto as id_tipo_concepto, tab2.abreviatura as abreviatura, tab2.operador as operador, tab2.operadoropcional as operadoropcional,
        tab2.cod2 as cod2, tab2.cod3 as cod3, tab2.id_concep_ajuste as id_concep_ajuste, tab2.id_concep_rein as id_concep_rein, tab2.id_acreedor as id_acreedor,
        tab2.id_rubro as id_rubro, tab2.id_cpo as id_cpo, tab2.estado as estado, tab2.aplica_descuento as aplica_descuento, tab2.id_clase_fondo as id_clase_fondo,
        tab2.usa_dias_calen as usa_dias_calen, tab3.id_consecutivo_certif as id_consecutivo_certif, tab3.secuencia as secuencia, tab4.codigo as codigo_tipcon,
        tab4.descripcion as descripcion_tipcon, tab4.orden as orden_tipcon, tab4.codigo||' - '||tab4.descripcion as completo_tipcon

        FROM NO_CERTIF_INGRE_RETEN tab0
        JOIN NO_DATOS_FUNCIONARIO_V tab1 ON tab0.id_tipo_doc = tab1.id_tipo_doc AND tab0.num_doc = tab1.num_doc
        JOIN NO_CONCEPTOS_V tab2 ON tab0.id_concep_nomina = tab2.id_concep_nomina
        LEFT JOIN NO_CONSECUTIVO_CERTIF tab3 ON tab0.id_tipo_doc = tab3.id_tipo_doc AND tab0.num_doc = tab3.num_doc AND tab0.id_anhos = tab3.id_anhos
        JOIN NO_TIPO_CONCEPTO tab4 ON tab2.id_tipo_concepto = tab4.id_tipo_concepto


        WHERE
        tab0.id_certif_ingre_reten != '-1'
        --and tab0.agrupacion_orden >= 2
        AND tab0.id_anhos = $P{id_anhos}
        $P!{whereFuncionarioNumDoc}
        $P!{whereFuncionarioTipoDoc}
    )tab

    group by
    --tab.agrupacion_orden,
    tab.id_tipo_doc,
    tab.num_doc

)tab1
on tab0.id_tipo_doc = tab1.id_tipo_doc
and tab0.num_doc = tab1.num_doc

where
1 = 1
$P!{whereFuncionarioNumDoc}
$P!{whereFuncionarioTipoDoc}

order by
tab0.id_anhos,
tab0.secuencia,
tab0.num_doc]]>
	</queryString>
	<field name="SECUENCIA" class="java.math.BigDecimal"/>
	<field name="RETIRO" class="java.math.BigDecimal"/>
	<field name="FECHA_INGRESO" class="java.lang.String"/>
	<field name="FECHA_TERMINA" class="java.lang.String"/>
	<field name="ABREVIACION" class="java.lang.String"/>
	<field name="NIT" class="java.lang.String"/>
	<field name="DV" class="java.math.BigDecimal"/>
	<field name="NOMBRE_EMPRESA" class="java.lang.String"/>
	<field name="ID_TIPO_DOC" class="java.math.BigDecimal"/>
	<field name="NUM_DOC" class="java.lang.String"/>
	<field name="ID_ANHOS" class="java.math.BigDecimal"/>
	<field name="TIPO_DOCUMENTO" class="java.lang.String"/>
	<field name="PRIMER_NOMBRE" class="java.lang.String"/>
	<field name="SEGUNDO_NOMBRE" class="java.lang.String"/>
	<field name="PRIMER_APELLIDO" class="java.lang.String"/>
	<field name="SEGUNDO_APELLIDO" class="java.lang.String"/>
	<field name="NOMBRE_COMPLETO" class="java.lang.String"/>
	<field name="NOMBRE_APELLIDO" class="java.lang.String"/>
	<field name="FECHA_NACE" class="java.lang.String"/>
	<field name="EMAIL" class="java.lang.String"/>
	<field name="TELEFONO" class="java.lang.String"/>
	<field name="DIRECCION" class="java.lang.String"/>
	<field name="PAIS_NACE" class="java.lang.String"/>
	<field name="DEPTO_NACE" class="java.lang.String"/>
	<field name="MUNI_NACE" class="java.lang.String"/>
	<field name="GENERO" class="java.lang.String"/>
	<field name="ESTADO_CIVIL" class="java.lang.String"/>
	<field name="TIPO_SANGRE" class="java.lang.String"/>
	<field name="AGRUP1" class="java.math.BigDecimal"/>
	<field name="AGRUP2" class="java.math.BigDecimal"/>
	<field name="AGRUP3" class="java.math.BigDecimal"/>
	<field name="AGRUP4" class="java.math.BigDecimal"/>
	<field name="AGRUP5" class="java.math.BigDecimal"/>
	<field name="AGRUP6" class="java.math.BigDecimal"/>
	<field name="CES" class="java.math.BigDecimal"/>
	<field name="CESCONSIG" class="java.math.BigDecimal"/>
	<field name="VIATICOS" class="java.math.BigDecimal"/>
	<field name="OTROS" class="java.math.BigDecimal"/>
	<field name="APOVOL" class="java.math.BigDecimal"/>
	<field name="APOAFC" class="java.math.BigDecimal"/>
	<field name="PRSETSOC" class="java.math.BigDecimal"/>
	<field name="APOYEDU" class="java.math.BigDecimal"/>
	<field name="COVIDVOL" class="java.math.BigDecimal"/>
	<field name="COVIDOBL" class="java.math.BigDecimal"/>
	<field name="PROMEDIO" class="java.math.BigDecimal"/>
	<variable name="suma_37" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{AGRUP1}]]></variableExpression>
	</variable>
	<variable name="suma_41" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{PRSETSOC}]]></variableExpression>
	</variable>
	<variable name="suma_43" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{AGRUP6}]]></variableExpression>
	</variable>
	<variable name="suma_45" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{OTROS}]]></variableExpression>
	</variable>
	<variable name="suma_46" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{CES}]]></variableExpression>
	</variable>
	<variable name="suma_49" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{AGRUP2}]]></variableExpression>
	</variable>
	<variable name="suma_50" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{AGRUP3}]]></variableExpression>
	</variable>
	<variable name="suma_51" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{APOVOL}]]></variableExpression>
	</variable>
	<variable name="suma_52" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{APOAFC}]]></variableExpression>
	</variable>
	<variable name="suma_53" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{AGRUP5}]]></variableExpression>
	</variable>
	<variable name="suma_42" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VIATICOS}]]></variableExpression>
	</variable>
	<variable name="suma_covvol" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{COVIDVOL}]]></variableExpression>
	</variable>
	<variable name="suma_covobl" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{COVIDOBL}]]></variableExpression>
	</variable>
	<variable name="suma_cesconsig" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{CESCONSIG}]]></variableExpression>
	</variable>
	<variable name="suma_apoyedu" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{APOYEDU}]]></variableExpression>
	</variable>
	<variable name="suma_promedio" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{PROMEDIO}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="60" splitType="Stretch">
			<staticText>
				<reportElement x="500" y="0" width="760" height="40"/>
				<textElement textAlignment="Center" verticalAlignment="Top" markup="none">
					<font fontName="SansSerif" size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[Sistema General de Nómina
Certificado de Ingresos y Retenciones - Resumido]]></text>
			</staticText>
			<image>
				<reportElement x="0" y="10" width="140" height="40"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
			<staticText>
				<reportElement mode="Opaque" x="1560" y="28" width="200" 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="1560" y="40" width="200" 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="500" y="40" width="760" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Periodo: " + $P{fecha_ini} + " a " +$P{fecha_fin}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="20" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="28" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="284" y="0" width="216" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Funcionario]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="660" y="0" width="100" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Pagos por salarios]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="760" y="0" width="100" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Pagos por prestaciones sociales]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="960" y="0" width="100" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Pagos por gastos de representación]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1060" y="0" width="100" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Otros pagos]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1160" y="0" width="100" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Cesantías e intereses de cesantías efectivamente pagadas al empleado]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="212" y="0" width="72" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Número Documento]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="70" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Vigencia]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="70" y="0" width="70" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Secuencia]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="140" y="0" width="72" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Cód. Tipo Documento]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="500" y="0" width="80" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Periodo de la Certificación Inicial]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="580" y="0" width="80" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Periodo de la Certificación Final]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1360" y="0" width="100" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Aportes obligatorios por salud]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1660" y="0" width="100" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Aportes a cuentas AFC]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1760" y="0" width="100" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Valor de la retención en la fuente por rentas de trabajo y pensiones]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1560" y="0" width="100" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Aportes voluntarios a fondos de pensiones voluntarias]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1460" y="0" width="100" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Aportes obligatorios a fondos de pensiones]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="860" y="0" width="100" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Pagos por viáticos]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1860" y="0" width="100" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Aportes voluntarios al impuesto solidario por COVID 19]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1960" y="0" width="100" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Retenciones por aportes obligatorios al impuesto solidario por COVID 19]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1260" y="0" width="100" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Cesantías consignadas al fondo de cesantias]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="2060" y="0" width="100" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Apoyos económicos educativos financiados]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="2160" y="0" width="100" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Ingreso laboral promedio de los últimos seis meses]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="10" splitType="Stretch">
			<textField isStretchWithOverflow="true">
				<reportElement stretchType="RelativeToTallestObject" x="284" y="0" width="216" height="10"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NOMBRE_APELLIDO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement stretchType="RelativeToTallestObject" x="212" y="0" width="72" height="10"/>
				<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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_DOC}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="660" y="0" width="100" height="10"/>
				<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">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{AGRUP1}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="760" y="0" width="100" height="10"/>
				<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">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{PRSETSOC}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="960" y="0" width="100" height="10"/>
				<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">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{AGRUP6}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1060" y="0" width="100" height="10"/>
				<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">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{OTROS}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1160" y="0" width="100" height="10"/>
				<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">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{CES}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1360" y="0" width="100" height="10"/>
				<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">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{AGRUP2}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1660" y="0" width="100" height="10"/>
				<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">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{APOAFC}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1560" y="0" width="100" height="10"/>
				<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">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{APOVOL}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1760" y="0" width="100" height="10"/>
				<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">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{AGRUP5}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1460" y="0" width="100" height="10"/>
				<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">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{AGRUP3}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement stretchType="RelativeToTallestObject" x="140" y="0" width="72" height="10"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ABREVIACION}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="70" y="0" width="70" height="10"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{SECUENCIA}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="70" height="10"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{ID_ANHOS}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="500" y="0" width="80" height="10"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{FECHA_INGRESO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="580" y="0" width="80" height="10"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{FECHA_TERMINA}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="860" y="0" width="100" height="10"/>
				<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">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VIATICOS}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1860" y="0" width="100" height="10"/>
				<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">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{COVIDVOL}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1960" y="0" width="100" height="10"/>
				<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">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{COVIDOBL}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1260" y="0" width="100" height="10"/>
				<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">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{CESCONSIG}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="2160" y="0" width="100" height="10"/>
				<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">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{PROMEDIO}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="2060" y="0" width="100" height="10"/>
				<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">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{APOYEDU}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="11" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="24" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="747" 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="837" 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="747" y="0" width="150" height="12" forecolor="#575757"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<text><![CDATA[Websafi - Nómina]]></text>
			</staticText>
		</band>
	</pageFooter>
	<summary>
		<band height="13" splitType="Stretch">
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="0" y="0" width="660" height="13" forecolor="#000000" backcolor="#C1C7D1"/>
				<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>
				<textFieldExpression class="java.lang.String"><![CDATA["Total"]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="660" y="0" width="100" height="13" forecolor="#000000" backcolor="#C1C7D1"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_37}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="760" y="0" width="100" height="13" forecolor="#000000" backcolor="#C1C7D1"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_41}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="960" y="0" width="100" height="13" forecolor="#000000" backcolor="#C1C7D1"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_43}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="1060" y="0" width="100" height="13" forecolor="#000000" backcolor="#C1C7D1"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_45}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="1760" y="0" width="100" height="13" forecolor="#000000" backcolor="#C1C7D1"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_53}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="1160" y="0" width="100" height="13" forecolor="#000000" backcolor="#C1C7D1"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_46}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="1660" y="0" width="100" height="13" forecolor="#000000" backcolor="#C1C7D1"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_52}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="1560" y="0" width="100" height="13" forecolor="#000000" backcolor="#C1C7D1"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_51}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="1460" y="0" width="100" height="13" forecolor="#000000" backcolor="#C1C7D1"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_50}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="1360" y="0" width="100" height="13" forecolor="#000000" backcolor="#C1C7D1"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_49}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="860" y="0" width="100" height="13" forecolor="#000000" backcolor="#C1C7D1"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_42}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="1860" y="0" width="100" height="13" forecolor="#000000" backcolor="#C1C7D1"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_covvol}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="1960" y="0" width="100" height="13" forecolor="#000000" backcolor="#C1C7D1"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_covobl}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="1260" y="0" width="100" height="13" forecolor="#000000" backcolor="#C1C7D1"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_cesconsig}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="2060" y="0" width="100" height="13" forecolor="#000000" backcolor="#C1C7D1"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_apoyedu}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="2160" y="0" width="100" height="13" forecolor="#000000" backcolor="#C1C7D1"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_promedio}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
	<noData>
		<band height="19"/>
	</noData>
</jasperReport>
