<?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="inf_costo_totalizado_agrup" language="groovy" pageWidth="1460" pageHeight="612" orientation="Landscape" columnWidth="1420" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.2100000000000026"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/nomina/estado_planta_func"/>
	<property name="ireport.jasperserver.url" value="http://192.168.2.43:8090/jasperserver/services/repository"/>
	<parameter name="whereArea" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereCenOp" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereCargo" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereNaturaleza" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="wherePlanta" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="id_anhos" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereComponenteEscala" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereClasePlanta" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="desc_clase" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select
case when tab1.cant < tab0.cargo_aprobado1 then tab1.cant else tab0.cargo_aprobado1 end as cargo_aprobado,
case when tab1.cant < tab0.cargo_provisto1 then tab1.cant else tab0.cargo_provisto1 end as cargo_provisto,
tab0.*

from(

select
tab0.codigo_concepto,
tab0.denominacion_comp,
tab0.grado_comp,
sum(tab0.cargo_aprobado) as cargo_aprobado1,
sum(tab0.cargo_provisto) as cargo_provisto1,
tab0.codigo_tipo_vinc,
tab0.id_planta_p,

sum(tab0.val_concep_basica) as val_concep_basica,
sum(tab0.val_concep_gasto_repre) as val_concep_gasto_repre,
max(tab0.factor_concep_gasto_repre) as factor_concep_gasto_repre,
sum(tab0.val_concep_primtec_sal) as val_concep_primtec_sal,
max(tab0.factor_concep_primtec_sal) as factor_concep_primtec_sal,
sum(tab0.val_concep_primgest) as val_concep_primgest,
max(tab0.factor_concep_primgest) as factor_concep_primgest,
sum(tab0.val_concep_primloc) as val_concep_primloc,
max(tab0.factor_concep_primloc) as factor_concep_primloc,
sum(tab0.val_concep_primcoor) as val_concep_primcoor,
max(tab0.factor_concep_primcoor) as factor_concep_primcoor,
sum(tab0.val_concep_primries) as val_concep_primries,
max(tab0.factor_concep_primries) as factor_concep_primries,
sum(tab0.val_concep_primaextra) as val_concep_primaextra,
max(tab0.factor_concep_primaextra) as factor_concep_primaextra,
sum(tab0.val_concep_primalt) as val_concep_primalt,
max(tab0.factor_concep_primalt) as factor_concep_primalt,
sum(tab0.val_concep_subalim) as val_concep_subalim,
max(tab0.factor_concep_subalim) as factor_concep_subalim,
sum(tab0.val_concep_auxtrans) as val_concep_auxtrans,
max(tab0.factor_concep_auxtrans) as factor_concep_auxtrans,
sum(tab0.val_concep_primant) as val_concep_primant,
max(tab0.factor_concep_primant) as factor_concep_primant,
sum(tab0.val_concep_primserv) as val_concep_primserv,
max(tab0.factor_concep_primserv) as factor_concep_primserv,
sum(tab0.val_concep_primnav) as val_concep_primnav,
max(tab0.factor_concep_primnav) as factor_concep_primnav,
sum(tab0.val_concep_bonif) as val_concep_bonif,
max(tab0.factor_concep_bonif) as factor_concep_bonif,
sum(tab0.val_concep_bonfrec) as val_concep_bonfrec,
max(tab0.factor_concep_bonfrec) as factor_concep_bonfrec,
sum(tab0.val_concep_primvac) as val_concep_primvac,
max(tab0.factor_concep_primvac) as factor_concep_primvac,
sum(tab0.val_concep_primact) as val_concep_primact,
max(tab0.factor_concep_primact) as factor_concep_primact,
sum(tab0.val_concep_otraprim_sal) as val_concep_otraprim_sal,
sum(tab0.val_concep_otraprim_no_sal) as val_concep_otraprim_no_sal,
sum(tab0.val_concep_cesanu) as val_concep_cesanu,
sum(tab0.val_concep_vacac) as val_concep_vacac,
sum(tab0.val_concep_compvacac) as val_concep_compvacac,
sum(tab0.val_concep_horas_extras) as val_concep_horas_extras,
0 as val_int_cesanu,

nvl(max(tab0.VAL_SALUD),0) as VAL_SALUD,
nvl(max(tab0.VAL_PENSION),0) as VAL_PENSION,
nvl(max(tab0.VAL_RIESGO),0) as VAL_RIESGO,
nvl(max(tab0.VAL_SENA),0) as VAL_SENA,
nvl(max(tab0.VAL_ICBF),0) as VAL_ICBF,
nvl(max(tab0.VAL_CCF),0) as VAL_CCF

from(

    select
    tab0.id_dp,
    tab0.codigo,
    tab0.id_comp_es,
    tab0.id_planta_p,
    tab0.codigo_concepto,
    tab0.denominacion_comp,
    tab0.grado_comp,
    1 as cargo_aprobado,
    nvl2(tab0.num_doc,1,0) as cargo_provisto,
    tab0.codigo_tipo_vinc,
    tab0.num_doc,
    tab0.nombre_apellido,

    max(tab1.VAL_SALUD) as VAL_SALUD,
    max(tab1.VAL_PENSION) as VAL_PENSION,
    max(tab1.VAL_RIESGO) as VAL_RIESGO,
    max(tab1.VAL_SENA) as VAL_SENA,
    max(tab1.VAL_ICBF) as VAL_ICBF,
    max(tab1.VAL_CCF) as VAL_CCF,

    sum(case when tab0.id_concep_basica = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_basica,
    sum(case when tab0.id_concep_gasto_repre = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_gasto_repre,
    max(case when tab0.id_concep_gasto_repre = tab0.id_concep_nomina and tab0.valor>0 then tab0.factor_salarial else 0 end) as factor_concep_gasto_repre,
    sum(case when tab0.id_concep_primtec_sal = tab0.id_concep_nomina or tab0.id_concep_primtec_nosal = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primtec_sal,
    max(case when tab0.id_concep_primtec_sal = tab0.id_concep_nomina and tab0.valor>0  then tab0.factor_salarial
             when tab0.id_concep_primtec_nosal = tab0.id_concep_nomina and tab0.valor>0 then tab0.factor_salarial else 0 end) as factor_concep_primtec_sal,
    sum(case when tab0.id_concep_primgest = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primgest,
    max(case when tab0.id_concep_primgest = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primgest,
    sum(case when tab0.id_concep_primloc = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primloc,
    max(case when tab0.id_concep_primloc = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primloc,
    sum(case when tab0.id_concep_primcoor = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primcoor,
    max(case when tab0.id_concep_primcoor = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primcoor,
    sum(case when tab0.id_concep_primries = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primries,
    max(case when tab0.id_concep_primries = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primries,
    sum(case when tab0.id_concep_primaextra = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primaextra,
    max(case when tab0.id_concep_primaextra = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primaextra,
    sum(case when tab0.id_concep_primalt = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primalt,
    max(case when tab0.id_concep_primalt = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primalt,
    sum(case when tab0.id_concep_subalim = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_subalim,
    max(case when tab0.id_concep_subalim = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_subalim,
    sum(case when tab0.id_concep_auxtrans = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_auxtrans,
    max(case when tab0.id_concep_auxtrans = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_auxtrans,
    sum(case when tab0.id_concep_primant = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primant,
    max(case when tab0.id_concep_primant = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primant,
    sum(case when tab0.id_concep_primserv = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primserv,
    max(case when tab0.id_concep_primserv = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primserv,
    sum(case when tab0.id_concep_primnav = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primnav,
    max(case when tab0.id_concep_primnav = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primnav,
    sum(case when tab0.id_concep_bonif = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_bonif,
    max(case when tab0.id_concep_bonif = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_bonif,
    sum(case when tab0.id_concep_bonfrec = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_bonfrec,
    max(case when tab0.id_concep_bonfrec = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_bonfrec,
    sum(case when tab0.id_concep_primvac = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primvac,
    max(case when tab0.id_concep_primvac = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primvac,
    sum(case when tab0.id_concep_primact = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primact,
    max(case when tab0.id_concep_primact = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primact,
    sum(case when tab0.id_concep_cesanu = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_cesanu,

    sum(case when tab0.id_concep_vacac = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_vacac,
    sum(case when tab0.id_concep_compvacac = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_compvacac,
    sum(case when tab0.id_concep_nomina in (select distinct id_concep_nomina from no_tipo_hr_extra) then tab0.valor else 0 end) as val_concep_horas_extras,

    --0 as val_concep_cesanu,
    sum(case when tab0.id_concep_nomina not in (tab0.id_concep_basica,tab0.id_concep_gasto_repre,tab0.id_concep_primtec_sal,tab0.id_concep_primtec_nosal,tab0.id_concep_primgest,
                                      tab0.id_concep_primloc,tab0.id_concep_primcoor,tab0.id_concep_primries,tab0.id_concep_primaextra,tab0.id_concep_primalt,tab0.id_concep_subalim,tab0.id_concep_auxtrans,
                                      tab0.id_concep_primant,tab0.id_concep_primserv,tab0.id_concep_primnav,tab0.id_concep_bonfrec,tab0.id_concep_primvac,tab0.id_concep_primact,tab0.id_concep_bonif
                                     ,tab0.id_concep_cesanu, tab0.id_concep_vacac, tab0.id_concep_compvacac, (select distinct id_concep_nomina from no_tipo_hr_extra)
                                     ) and tab0.factor_salarial=1 then tab0.valor else 0 end) as val_concep_otraprim_sal,
    sum(case when tab0.id_concep_nomina not in (tab0.id_concep_basica,tab0.id_concep_gasto_repre,tab0.id_concep_primtec_sal,tab0.id_concep_primtec_nosal,tab0.id_concep_primgest,
                                      tab0.id_concep_primloc,tab0.id_concep_primcoor,tab0.id_concep_primries,tab0.id_concep_primaextra,tab0.id_concep_primalt,tab0.id_concep_subalim,tab0.id_concep_auxtrans,
                                      tab0.id_concep_primant,tab0.id_concep_primserv,tab0.id_concep_primnav,tab0.id_concep_bonfrec,tab0.id_concep_primvac,tab0.id_concep_primact,tab0.id_concep_bonif
                                     ,tab0.id_concep_cesanu, tab0.id_concep_vacac, tab0.id_concep_compvacac, (select distinct id_concep_nomina from no_tipo_hr_extra)
                                     ) and tab0.factor_salarial=0 then tab0.valor else 0 end) as val_concep_otraprim_no_sal

    from(
        select
        nodp.id_dp,
        nodp.codigo,
        nodp.id_comp_es,
        nodp.id_planta_p,
        nodp.codigo_concepto,
        nodp.denominacion_comp,
        nodp.grado_comp,
        nodp.codigo_tipo_vinc,

        tab1.num_doc as num_doc,
        tab1.nombre_apellido,
        case
            when ajus.id_concep_nomina is not null then ajus.id_concep_nomina
            when rein.id_concep_nomina is not null then rein.id_concep_nomina
            else tab1.id_concep_nomina end as id_concep_nomina,
        tab1.valor_liquidado as valor,

        tab3.factor_salarial,
        nvl(tab4.id_concep_basica,0) as id_concep_basica,
        nvl(tab4.id_concep_gasto_repre,0) as id_concep_gasto_repre,
        nvl(tab4.id_concep_primtec_sal,0) as id_concep_primtec_sal,
        nvl(tab4.id_concep_primtec_nosal,0) as id_concep_primtec_nosal,
        nvl(tab4.id_concep_primgest,0) as id_concep_primgest,
        nvl(tab4.id_concep_primloc,0) as id_concep_primloc,
        nvl(tab4.id_concep_primcoor,0) as id_concep_primcoor,
        nvl(tab4.id_concep_primries,0) as id_concep_primries,
        nvl(tab4.id_concep_primaextra,0) as id_concep_primaextra,
        nvl(tab4.id_concep_primalt,0) as id_concep_primalt,
        nvl(tab4.id_concep_subalim,0) as id_concep_subalim,
        nvl(tab4.id_concep_auxtrans,0) as id_concep_auxtrans,
        nvl(tab4.id_concep_primant,0) as id_concep_primant,
        nvl(tab4.id_concep_primserv,0) as id_concep_primserv,
        nvl(tab4.id_concep_primnav,0) as id_concep_primnav,
        nvl(tab4.id_concep_bonfrec,0) as id_concep_bonfrec,
        nvl(tab4.id_concep_primvac,0) as id_concep_primvac,
        nvl(tab4.id_concep_primact,0) as id_concep_primact,
        nvl(tab4.id_concep_bonif,0) as id_concep_bonif,
        (select
                agrup.id_concep_nomina
                from no_agrup_deta agrup

                where
                agrup.id_agrup_concepto = (select id_agrup_cesanu from no_param_concep where id_param_concep = 1)) as id_concep_cesanu,

        nvl(tab4.id_concep_vacac,0) as id_concep_vacac,
        8 as id_concep_compvacac

        from no_dp_v nodp

        left join(

            select
            liq.id_concep_nomina,
            case when agrup.operador = 1 then (1) else (-1) end * liq.valor_liquidado as valor_liquidado,
            tab1.id_dp,
            tab1.id_tipo_doc,
            tab1.num_doc,
            tab3.nombre_apellido,
            tab1.id_anhos as anho_estado_func,
            tab1.id_meses as meses_estado_func,
            tab1.periodo as id_periodo

            from no_liquida_nomina liq

            join no_estado_func_v tab1
            on  liq.num_doc = tab1.num_doc
            and liq.id_tipo_doc = tab1.id_tipo_doc
            and liq.id_periodo = tab1.periodo

            join no_periodo tab2
            on tab2.id_periodo = tab1.periodo
            and tab2.id_anhos = tab1.id_anhos

            left join no_datos_funcionario_v tab3
            on tab3.num_doc = tab1.num_doc
            and tab3.id_tipo_doc = tab1.id_tipo_doc

            join (

                select
                1 as operador,
                agrup.id_concep_nomina
                from no_agrup_deta agrup

                where
                agrup.id_agrup_concepto = 115

                union

                select
                1 as operador,
                con.id_concep_ajuste
                from no_agrup_deta agrup
                join no_concep_nomina con
                on con.id_concep_nomina = agrup.id_concep_nomina

                where
                agrup.id_agrup_concepto = 115
                and con.id_concep_ajuste is not null

                union

                select
                0 as operador,
                con.id_concep_rein
                from no_agrup_deta agrup
                join no_concep_nomina con
                on con.id_concep_nomina = agrup.id_concep_nomina

                where
                agrup.id_agrup_concepto = 115
                and con.id_concep_rein is not null

            )agrup
            on agrup.id_concep_nomina = liq.id_concep_nomina

            where
            tab1.id_anhos = $P{id_anhos}

            union

            select
            (
                select
                agrup.id_concep_nomina
                from no_agrup_deta agrup

                where
                agrup.id_agrup_concepto = (select id_agrup_cesanu from no_param_concep where id_param_concep = 1)
            ) as id_concep_nomina,
            ces.valor_consolidado as valor_liquidado,
            tab1.id_dp,
            tab1.id_tipo_doc,
            tab1.num_doc,
            tab3.nombre_apellido,
            tab1.id_anhos as anho_estado_func,
            tab1.id_meses as meses_estado_func,
            tab1.periodo as id_periodo

            from no_cesantia ces

            join no_estado_func_v tab1
            on  ces.num_doc = tab1.num_doc
            and ces.id_tipo_doc = tab1.id_tipo_doc
            and ces.id_periodo = tab1.periodo

            join no_periodo tab2
            on tab2.id_periodo = tab1.periodo
            and tab2.id_anhos = tab1.id_anhos

            left join no_datos_funcionario_v tab3
            on tab3.num_doc = tab1.num_doc
            and tab3.id_tipo_doc = tab1.id_tipo_doc

            where
            tab1.id_anhos = $P{id_anhos}
            and ces.valor_consolidado != 0

        )tab1
        on nodp.id_dp = tab1.id_dp

        left join no_concep_nomina tab3
        on tab3.id_concep_nomina = tab1.id_concep_nomina

        left join no_concep_nomina ajus
        on ajus.id_concep_ajuste = tab1.id_concep_nomina

        left join no_concep_nomina rein
        on rein.id_concep_rein = tab1.id_concep_nomina

        left join no_param_concep tab4
        on tab4.id_param_concep = 1

        left join (

              select nom.*
              from no_nombramiento_v nom

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

        where
        1 = 1
        $P!{whereClasePlanta}

    )tab0

    left join(


        select

        tab0.id_tipo_doc,
        tab0.num_doc,

        sum(case when tab0.id_clase_fondo = 2 then tab0.valor_total else 0 end) as VAL_SALUD,
        sum(case when tab0.id_clase_fondo = 1 then tab0.valor_total else 0 end) as VAL_PENSION,
        sum(case when tab0.id_clase_fondo = 3 then tab0.valor_total else 0 end) as VAL_RIESGO,
        sum(case when tab0.id_clase_fondo = 6 then tab0.valor_total else 0 end) as VAL_SENA,
        sum(case when tab0.id_clase_fondo = 5 then tab0.valor_total else 0 end) as VAL_ICBF,
        sum(case when tab0.id_clase_fondo = 4 then tab0.valor_total else 0 end) as VAL_CCF

        from(
                select
                tab1.id_tipo_doc,
                tab1.num_doc,
                tab1.id_anhos,
                --tab1.id_concep_nomina,
                sum( tab1.valor_total) as valor_total,
                tab1.id_clase_fondo as id_clase_fondo

                from (

                    select
                    tab0.id_tipo_doc,
                    tab0.num_doc,
                    $P{id_anhos} as id_anhos,
                    tab0.id_concep_nomina,
                    tab0.tipo_planilla,

                    nvl( tab0.aporte_patrono ,0) as valor_total,

                    tab0.id_clase_fondo

                    from no_liquida_aporte tab0

                    join no_concep_nomina concep
                    on tab0.id_concep_nomina = concep.id_concep_nomina

                    join no_periodo_v per
                    on tab0.id_periodo = per.id_periodo

                    where
                    1 = 1
                    and tab0.tipo_planilla = 'A'
                    and per.id_anhos = $P{id_anhos}


                    union

                    select
                    tab0.id_tipo_doc,
                    tab0.num_doc,
                    2016 as id_anhos,
                    tab0.id_concep_nomina,
                    tab0.tipo_planilla,

                    nvl( tab0.aporte_patrono ,0) * (case when tab0.tipo_planilla = 'A' then -1 else 1 end)  as valor_total,

                    tab0.id_clase_fondo

                    from no_liquida_aporte tab0

                    join no_concep_nomina concep
                    on tab0.id_concep_nomina = concep.id_concep_nomina

                    join no_periodo_v per
                    on tab0.id_periodo = per.id_periodo

                    join (
                      (select distinct num_doc, id_periodo from no_liquida_aporte where tipo_planilla = 'C')
                    )perpla
                    on perpla.num_doc = tab0.num_doc
                    and perpla.id_periodo = tab0.id_periodo

                    where
                    1 = 1
                    and per.id_anhos =  $P{id_anhos}

                )tab1

                left join (

                      select nom.*
                      from no_nombramiento_v nom

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

                where
                1 = 1
                $P!{whereClasePlanta}

                group by
                tab1.id_tipo_doc,
                tab1.num_doc,
                tab1.id_anhos,
                --tab1.id_concep_nomina,
                tab1.id_clase_fondo

        )tab0

        group by
        tab0.id_tipo_doc,
        tab0.num_doc

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

    group by
    tab0.id_dp,
    tab0.codigo,
    tab0.id_comp_es,
    tab0.id_planta_p,
    tab0.codigo_concepto,
    tab0.denominacion_comp,
    tab0.grado_comp,
    tab0.codigo_tipo_vinc,
    tab0.num_doc,
    tab0.nombre_apellido

)tab0

where
1 = 1
$P!{wherePlanta}
$P!{whereComponenteEscala}

group by
tab0.codigo_concepto,
tab0.denominacion_comp,
tab0.grado_comp,
tab0.codigo_tipo_vinc,
tab0.id_planta_p

)tab0

left join (

    SELECT
    tab0.ID_DEN_EMP,
    tab0.denominacion_comp,
    tab0.CODIGO_CONCEPTO,
    tab0.GRADO_COMP,
    tab0.CODIGO_TIPO_VINC,
    tab0.id_planta_p,
    count(tab0.id_dp) as cant
    FROM no_dp_v tab0

    where
    1 = 1
    $P!{wherePlanta}
    $P!{whereComponenteEscala}

    group by
    tab0.ID_DEN_EMP,
    tab0.denominacion_comp,
    tab0.CODIGO_CONCEPTO,
    tab0.GRADO_COMP,
    tab0.CODIGO_TIPO_VINC,
    tab0.id_planta_p

)tab1
on tab1.codigo_concepto = tab0.codigo_concepto
and tab1.grado_comp = tab0.grado_comp
and tab1.codigo_tipo_vinc = tab0.codigo_tipo_vinc
and tab1.denominacion_comp = tab0.denominacion_comp
and tab1.id_planta_p = tab0.id_planta_p

where
1 = 1

order by
tab0.codigo_concepto,
tab0.denominacion_comp,
tab0.grado_comp desc,
tab0.codigo_tipo_vinc]]>
	</queryString>
	<field name="CODIGO_CONCEPTO" class="java.lang.String"/>
	<field name="DENOMINACION_COMP" class="java.lang.String"/>
	<field name="GRADO_COMP" class="java.lang.String"/>
	<field name="CARGO_APROBADO" class="java.math.BigDecimal"/>
	<field name="CARGO_PROVISTO" class="java.math.BigDecimal"/>
	<field name="CODIGO_TIPO_VINC" class="java.lang.String"/>
	<field name="VAL_CONCEP_BASICA" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_GASTO_REPRE" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_GASTO_REPRE" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMTEC_SAL" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMTEC_SAL" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMGEST" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMGEST" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMLOC" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMLOC" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMCOOR" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMCOOR" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMRIES" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMRIES" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMAEXTRA" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMAEXTRA" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMALT" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMALT" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_SUBALIM" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_SUBALIM" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_AUXTRANS" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_AUXTRANS" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMANT" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMANT" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMSERV" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMSERV" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMNAV" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMNAV" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_BONIF" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_BONIF" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_BONFREC" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_BONFREC" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMVAC" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMVAC" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMACT" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMACT" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_OTRAPRIM_SAL" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_OTRAPRIM_NO_SAL" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_CESANU" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_VACAC" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_COMPVACAC" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_HORAS_EXTRAS" class="java.math.BigDecimal"/>
	<field name="VAL_INT_CESANU" class="java.math.BigDecimal"/>
	<field name="VAL_SALUD" class="java.math.BigDecimal"/>
	<field name="VAL_PENSION" class="java.math.BigDecimal"/>
	<field name="VAL_RIESGO" class="java.math.BigDecimal"/>
	<field name="VAL_SENA" class="java.math.BigDecimal"/>
	<field name="VAL_ICBF" class="java.math.BigDecimal"/>
	<field name="VAL_CCF" class="java.math.BigDecimal"/>
	<variable name="consecutivo" class="java.lang.Integer" resetType="None" incrementType="Column" calculation="Count">
		<variableExpression><![CDATA[]]></variableExpression>
	</variable>
	<variable name="tot_val_concep_cesanu" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VAL_CONCEP_CESANU}]]></variableExpression>
	</variable>
	<variable name="tot_total" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VAL_CONCEP_BASICA}+$F{VAL_CONCEP_GASTO_REPRE}+$F{VAL_CONCEP_PRIMTEC_SAL}+$F{VAL_CONCEP_PRIMGEST}+$F{VAL_CONCEP_PRIMLOC}+$F{VAL_CONCEP_PRIMCOOR}+$F{VAL_CONCEP_PRIMRIES}+$F{VAL_CONCEP_PRIMAEXTRA}+$F{VAL_CONCEP_PRIMALT}+$F{VAL_CONCEP_SUBALIM}+$F{VAL_CONCEP_AUXTRANS}+$F{VAL_CONCEP_PRIMANT}+$F{VAL_CONCEP_PRIMSERV}+$F{VAL_CONCEP_PRIMNAV}+$F{VAL_CONCEP_BONIF}+$F{VAL_CONCEP_BONFREC}+$F{VAL_CONCEP_PRIMVAC}+$F{VAL_CONCEP_PRIMACT}+$F{VAL_CONCEP_OTRAPRIM_SAL}+$F{VAL_CONCEP_OTRAPRIM_NO_SAL}+$F{VAL_CONCEP_CESANU}+$F{VAL_INT_CESANU}+$F{VAL_CONCEP_VACAC}+$F{VAL_CONCEP_COMPVACAC}+$F{VAL_CONCEP_HORAS_EXTRAS}+$F{VAL_SALUD}+$F{VAL_PENSION}+$F{VAL_RIESGO}+$F{VAL_SENA}+$F{VAL_ICBF}+$F{VAL_CCF}]]></variableExpression>
	</variable>
	<variable name="tot_deven" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VAL_CONCEP_BASICA}+$F{VAL_CONCEP_GASTO_REPRE}+$F{VAL_CONCEP_PRIMTEC_SAL}+$F{VAL_CONCEP_PRIMGEST}+$F{VAL_CONCEP_PRIMLOC}+$F{VAL_CONCEP_PRIMCOOR}+$F{VAL_CONCEP_PRIMRIES}+$F{VAL_CONCEP_PRIMAEXTRA}+$F{VAL_CONCEP_PRIMALT}+$F{VAL_CONCEP_SUBALIM}+$F{VAL_CONCEP_AUXTRANS}+$F{VAL_CONCEP_PRIMANT}+$F{VAL_CONCEP_PRIMSERV}+$F{VAL_CONCEP_PRIMNAV}+$F{VAL_CONCEP_BONIF}+$F{VAL_CONCEP_BONFREC}+$F{VAL_CONCEP_PRIMVAC}+$F{VAL_CONCEP_PRIMACT}+$F{VAL_CONCEP_OTRAPRIM_SAL}+$F{VAL_CONCEP_OTRAPRIM_NO_SAL}+$F{VAL_CONCEP_VACAC}+$F{VAL_CONCEP_COMPVACAC}+$F{VAL_CONCEP_HORAS_EXTRAS}]]></variableExpression>
	</variable>
	<variable name="tot_salud" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VAL_SALUD}]]></variableExpression>
	</variable>
	<variable name="tot_pension" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VAL_PENSION}]]></variableExpression>
	</variable>
	<variable name="tot_riesgo" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VAL_RIESGO}]]></variableExpression>
	</variable>
	<variable name="tot_sena" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VAL_SENA}]]></variableExpression>
	</variable>
	<variable name="tot_icbf" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VAL_ICBF}]]></variableExpression>
	</variable>
	<variable name="tot_ccf" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VAL_CCF}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="80" splitType="Stretch">
			<staticText>
				<reportElement x="275" y="0" width="925" height="38"/>
				<textElement textAlignment="Center" verticalAlignment="Bottom" markup="none">
					<font fontName="SansSerif" size="14" isBold="true"/>
				</textElement>
				<text><![CDATA[Sistema General de Nómina
Informe Costos Totalizado por Agrupaciones]]></text>
			</staticText>
			<image>
				<reportElement x="0" y="10" width="190" height="40"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
			<staticText>
				<reportElement mode="Opaque" x="1200" y="25" width="220" height="13" 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="1200" y="38" width="220" height="13"/>
				<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="275" y="38" width="925" height="22"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="12" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Vigencia "+$P{id_anhos}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="275" y="60" width="925" height="20" isRemoveLineWhenBlank="true"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="12" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{desc_clase}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="21" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="25" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="20" y="0" width="55" height="25" 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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CONCEPTO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="75" y="0" width="70" height="25" 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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CONSECUTIVO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="145" y="0" width="130" height="25" 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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[DENOMINACION DEL CARGO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="275" y="0" width="40" height="25" 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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[GRADO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="20" height="25" 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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="315" y="0" width="60" height="25" 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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CARGOS APROBADOS]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="375" y="0" width="60" height="25" 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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CARGOS PROVISTOS]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="435" y="0" width="65" height="25" 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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[TIPO DE VINCULACION]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="500" y="0" width="100" height="25" 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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[DEVENGADOS]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="600" y="0" width="100" height="25" 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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[SALUD]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="700" y="0" width="100" height="25" 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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[PENSIÓN]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="800" y="0" width="100" height="25" 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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[RIESGOS PROFESIONALES]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="900" y="0" width="100" height="25" 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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[SENA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1000" y="0" width="100" height="25" 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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[ICBF]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1200" y="0" width="100" height="25" 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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CESANTÍAS]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1100" y="0" width="100" height="25" 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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CAJA DE COMPENSACIÓN]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1300" y="0" width="120" height="25" 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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[TOTAL]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="20" splitType="Stretch">
			<textField>
				<reportElement stretchType="RelativeToTallestObject" x="20" y="0" width="55" height="20"/>
				<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{CODIGO_CONCEPTO}]]></textFieldExpression>
			</textField>
			<textField pattern="000">
				<reportElement stretchType="RelativeToTallestObject" x="75" y="0" width="70" height="20"/>
				<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.Number"><![CDATA[$V{REPORT_COUNT}-1]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="145" y="0" width="130" height="20"/>
				<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{DENOMINACION_COMP}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="275" y="0" width="40" height="20"/>
				<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{GRADO_COMP}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="0" y="0" width="20" height="20" 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="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["D"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="315" y="0" width="60" height="20"/>
				<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.math.BigDecimal"><![CDATA[$F{CARGO_APROBADO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="375" y="0" width="60" height="20"/>
				<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.math.BigDecimal"><![CDATA[$F{CARGO_PROVISTO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="435" y="0" width="65" height="20"/>
				<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{CODIGO_TIPO_VINC}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="500" y="0" width="100" height="20"/>
				<box leftPadding="0" 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{VAL_CONCEP_BASICA}+$F{VAL_CONCEP_GASTO_REPRE}+$F{VAL_CONCEP_PRIMTEC_SAL}+$F{VAL_CONCEP_PRIMGEST}+$F{VAL_CONCEP_PRIMLOC}+$F{VAL_CONCEP_PRIMCOOR}+$F{VAL_CONCEP_PRIMRIES}+$F{VAL_CONCEP_PRIMAEXTRA}+$F{VAL_CONCEP_PRIMALT}+$F{VAL_CONCEP_SUBALIM}+$F{VAL_CONCEP_AUXTRANS}+$F{VAL_CONCEP_PRIMANT}+$F{VAL_CONCEP_PRIMSERV}+$F{VAL_CONCEP_PRIMNAV}+$F{VAL_CONCEP_BONIF}+$F{VAL_CONCEP_BONFREC}+$F{VAL_CONCEP_PRIMVAC}+$F{VAL_CONCEP_PRIMACT}+$F{VAL_CONCEP_OTRAPRIM_SAL}+$F{VAL_CONCEP_OTRAPRIM_NO_SAL}+$F{VAL_CONCEP_VACAC}+$F{VAL_CONCEP_COMPVACAC}+$F{VAL_CONCEP_HORAS_EXTRAS}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="600" y="0" width="100" height="20"/>
				<box leftPadding="0" 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{VAL_SALUD}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="700" y="0" width="100" height="20"/>
				<box leftPadding="0" 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{VAL_PENSION}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="800" y="0" width="100" height="20"/>
				<box leftPadding="0" 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{VAL_RIESGO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="900" y="0" width="100" height="20"/>
				<box leftPadding="0" 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{VAL_SENA}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1000" y="0" width="100" height="20"/>
				<box leftPadding="0" 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{VAL_ICBF}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1100" y="0" width="100" height="20"/>
				<box leftPadding="0" 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{VAL_CCF}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1200" y="0" width="100" height="20"/>
				<box leftPadding="0" 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{VAL_CONCEP_CESANU}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1300" y="0" width="120" height="20"/>
				<box leftPadding="0" 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{VAL_CONCEP_BASICA}+$F{VAL_CONCEP_GASTO_REPRE}+$F{VAL_CONCEP_PRIMTEC_SAL}+$F{VAL_CONCEP_PRIMGEST}+$F{VAL_CONCEP_PRIMLOC}+$F{VAL_CONCEP_PRIMCOOR}+$F{VAL_CONCEP_PRIMRIES}+$F{VAL_CONCEP_PRIMAEXTRA}+$F{VAL_CONCEP_PRIMALT}+$F{VAL_CONCEP_SUBALIM}+$F{VAL_CONCEP_AUXTRANS}+$F{VAL_CONCEP_PRIMANT}+$F{VAL_CONCEP_PRIMSERV}+$F{VAL_CONCEP_PRIMNAV}+$F{VAL_CONCEP_BONIF}+$F{VAL_CONCEP_BONFREC}+$F{VAL_CONCEP_PRIMVAC}+$F{VAL_CONCEP_PRIMACT}+$F{VAL_CONCEP_OTRAPRIM_SAL}+$F{VAL_CONCEP_OTRAPRIM_NO_SAL}+$F{VAL_CONCEP_CESANU}+$F{VAL_INT_CESANU}+$F{VAL_CONCEP_VACAC}+$F{VAL_CONCEP_COMPVACAC}+$F{VAL_CONCEP_HORAS_EXTRAS}+$F{VAL_SALUD}+$F{VAL_PENSION}+$F{VAL_RIESGO}+$F{VAL_SENA}+$F{VAL_ICBF}+$F{VAL_CCF}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="23" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="24" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="637" y="12" width="83" 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="720" y="12" width="57" height="12" forecolor="#575757" backcolor="#FFFFFF"/>
				<box leftPadding="2"/>
				<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="637" y="0" width="140" 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="25" splitType="Stretch">
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="0" y="0" width="500" height="13" forecolor="#000000" backcolor="#B9BEC4"/>
				<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["Totales"]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="500" y="0" width="100" height="13" forecolor="#000000" backcolor="#B9BEC4"/>
				<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{tot_deven}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="600" y="0" width="100" height="13" forecolor="#000000" backcolor="#B9BEC4"/>
				<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{tot_salud}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="700" y="0" width="100" height="13" forecolor="#000000" backcolor="#B9BEC4"/>
				<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{tot_pension}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="800" y="0" width="100" height="13" forecolor="#000000" backcolor="#B9BEC4"/>
				<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{tot_riesgo}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="900" y="0" width="100" height="13" forecolor="#000000" backcolor="#B9BEC4"/>
				<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{tot_sena}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="1000" y="0" width="100" height="13" forecolor="#000000" backcolor="#B9BEC4"/>
				<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{tot_icbf}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="1100" y="0" width="100" height="13" forecolor="#000000" backcolor="#B9BEC4"/>
				<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{tot_ccf}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="1200" y="0" width="100" height="13" forecolor="#000000" backcolor="#B9BEC4"/>
				<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{tot_val_concep_cesanu}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="1300" y="0" width="120" height="13" forecolor="#000000" backcolor="#B9BEC4"/>
				<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{tot_total}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="1420" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
