<?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="no_certif_cesantias" language="groovy" pageWidth="612" pageHeight="792" whenNoDataType="NoDataSection" columnWidth="468" leftMargin="72" rightMargin="72" topMargin="50" bottomMargin="50">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="whereFuncionarioNumDoc" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereFuncionarioTipoDoc" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="periodo" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="id_periodo" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="fecha_corte" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="numero_letras" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="destino" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="comando" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_periodo_filtro" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select

min((select min(encabezado) from no_inf_firma where comando = 'no_certif_cesantias')) as encabezado,

max(id_anhos) as id_anhos,
max(id_meses) as id_meses,
initcap(max(mes)) as mes,

max((select digito_verificacion(DATOS_COMPANIA.nit) as dv from DATOS_COMPANIA)) as dv,
max((select DATOS_COMPANIA.nit from DATOS_COMPANIA)) as nit,
max((select DATOS_COMPANIA.NOMBRE_EMPRESA from DATOS_COMPANIA)) as empresa,

LPAD(TO_CHAR(sysdate,'dd'),2,'0') as DIA_actual,
lower(numero_a_Texto ( to_char(sysdate,'dd'), 2, 'ESP' )) as dia_ACTUAL_letra,
trim(INITCAP(TO_CHAR(sysdate,'MONTH','nls_date_language=spanish'))) as MES_actual,
TO_CHAR(sysdate,'yyyy') as anho_actual,

count(*) as cant,
sum(activo) as activo,
lower(Numero_a_Texto(count(*))) as cant_letras,
sum(valor_liquidado) as valor_tot,
lower(Numero_a_Texto(sum(valor_liquidado)+sum(activo_valor2)+sum(valor_ajuste))) as numeros_letras,
'$ ' || TO_CHAR(sum(valor_liquidado)+sum(activo_valor2)+sum(valor_ajuste), 'FM9,999,999,999') as valor,
sum(activo_valor) as activo_valor,
'$ ' || TO_CHAR(sum(activo_valor), 'FM9,999,999,999') as activo_valor_txt,
'$ ' || TO_CHAR(sum(valor_liquidado) - sum(activo_valor) + sum(activo_valor2) +sum(valor_ajuste), 'FM9,999,999,999') as inactivo_valor_txt,


'$ ' || TO_CHAR(sum(VALOR_BASE)+sum(valor_ajuste*12)-min(valor_base_resta), 'FM9,999,999,999') as valor_base,
lower(Numero_a_Texto(sum(VALOR_BASE)+sum(valor_ajuste*12)-min(valor_base_resta))) as numeros_letras_base

from (

      select distinct
      nvl(valsin.valor_base,0) as valor_base_resta,
      per.id_anhos,
      per.id_meses,
      (select meses.descripcion from meses where meses.id_meses = (per.id_meses) ) as mes,
      dep.coddepto || ' ' || mun.codmun_text as depmun,
      dep.coddepto as coddep,
      mun.codmun_text as codmun,
      tab0.*,
      tipdoc.descripcion,
      tipdoc.abreviacion,
      ter.primer_nombre || ' ' || ter.segundo_nombre as nombre,
      ter.primer_apellido,
      ter.segundo_apellido,
      (select distinct periodo.periodo from no_liquida_v periodo where periodo.id_periodo = tab0.id_periodo) AS PERIODO,
      (select distinct periodo.tipper from no_liquida_v periodo where periodo.id_periodo = tab0.id_periodo) AS TIPPER,
      per.id_anhos || lpad(per.id_meses,2,'0') as periodo_mes,
      nvl(dp.asignacion_basica,0) as asignacion_basica,
      (case when tab0.fecha_termina is not null and tab0.fecha_termina <= (select periodo.fecha_fin + 1 from no_periodo periodo where periodo.id_periodo = tab0.id_periodo) then 0 else 1 end) as activo,
      (case when tab0.fecha_termina is not null and tab0.fecha_termina <= (select periodo.fecha_fin + 1 from no_periodo periodo where periodo.id_periodo = tab0.id_periodo) then 0 else tab0.valor_liquidado end) as activo_valor,
      (case when tab0.fecha_termina is not null and tab0.fecha_termina = (select periodo.fecha_ini from no_periodo periodo where periodo.id_periodo = tab0.id_periodo) then tab0.valor_ajuste else 0 end) as activo_valor2

      from no_cesantia tab0

      join tipo_documento  tipdoc
      on tipdoc.id_tipo_doc = tab0.id_tipo_doc

      join no_datos_funcionario_v ter
      on ter.id_tipo_doc = tab0.id_tipo_doc
      and ter.num_doc = tab0.num_doc

      join no_periodo per
      on tab0.id_periodo = per.id_periodo

      left join no_liquida_v liq
      on liq.id_tipo_doc = tab0.id_tipo_doc
      and liq.num_doc = tab0.num_doc
      and liq.id_periodo = tab0.id_periodo

      left join (
        SELECT
         aut.*,
         ROW_NUMBER() OVER (
          partition by aut.num_doc
          ORDER BY aut.actual desc
         ) AS rn
        from no_estado_func aut
        where aut.periodo = $P{id_periodo_filtro}
      )estfun
      on estfun.id_tipo_doc = tab0.id_tipo_doc
      and estfun.num_doc = tab0.num_doc
      and estfun.periodo = tab0.id_periodo
      and estfun.rn = 1
      /*
      left join no_estado_func estfun
      on estfun.id_tipo_doc = tab0.id_tipo_doc
      and estfun.num_doc = tab0.num_doc
      and estfun.periodo = tab0.id_periodo
      --and estfun.actual = 1
      */

      left join no_nombramiento nombra
      on estfun.id_tipo_doc = nombra.id_tipo_doc
      and estfun.num_doc = nombra.num_doc

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

      left join centro_operacion cenop
      on estfun.id_cen_op = cenop.id_cen_op

      left join departamento dep
      on dep.id_depto = cenop.id_depto

      left join municipios mun
      on mun.codmun = cenop.codmun

/*Para ajustar diferencia de los que no aportan valor = 0 - 20240924*/
left join(
    (SELECT
    sum(valor_base) as valor_base,
    sum(valor_liquidado) + sum(valor_ajuste) as valor
    FROM no_cesantia
    where
    consolidado = 0
    and id_periodo = $P{id_periodo_filtro}
    and valor_liquidado = 0 and valor_base >= 1000)
)valsin
on 1 = 1

      where tab0.id_periodo = $P{id_periodo_filtro}
      and tab0.consolidado = 0
      and ( estfun.actual = 1

          or (nombra.estado = 1 or
            ( nombra.estado = 0
              and nombra.fecha_retiro
            between to_date('01/'|| (select lpad(id_meses,2,'0') ||'/'||id_anhos from no_periodo where id_periodo = $P{id_periodo_filtro}) ,'dd/mm/yyyy')
            and trunc(last_day( TO_DATE('01/'|| (SELECT LPAD(ID_MESES,2,'0') ||'/'||ID_ANHOS FROM NO_PERIODO WHERE ID_PERIODO = $P{id_periodo}) ,'dd/mm/yyyy')  )+1)
            )
          )

      )

)]]>
	</queryString>
	<field name="ENCABEZADO" class="java.lang.String"/>
	<field name="ID_ANHOS" class="java.math.BigDecimal"/>
	<field name="ID_MESES" class="java.math.BigDecimal"/>
	<field name="MES" class="java.lang.String"/>
	<field name="DV" class="java.math.BigDecimal"/>
	<field name="NIT" class="java.lang.String"/>
	<field name="EMPRESA" class="java.lang.String"/>
	<field name="DIA_ACTUAL" class="java.lang.String"/>
	<field name="DIA_ACTUAL_LETRA" class="java.lang.String"/>
	<field name="MES_ACTUAL" class="java.lang.String"/>
	<field name="ANHO_ACTUAL" class="java.lang.String"/>
	<field name="CANT" class="java.math.BigDecimal"/>
	<field name="ACTIVO" class="java.math.BigDecimal"/>
	<field name="CANT_LETRAS" class="java.lang.String"/>
	<field name="VALOR_TOT" class="java.math.BigDecimal"/>
	<field name="NUMEROS_LETRAS" class="java.lang.String"/>
	<field name="VALOR" class="java.lang.String"/>
	<field name="ACTIVO_VALOR" class="java.math.BigDecimal"/>
	<field name="ACTIVO_VALOR_TXT" class="java.lang.String"/>
	<field name="INACTIVO_VALOR_TXT" class="java.lang.String"/>
	<field name="VALOR_BASE" class="java.lang.String"/>
	<field name="NUMEROS_LETRAS_BASE" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="50" splitType="Stretch">
			<image>
				<reportElement x="156" y="0" width="162" height="50"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
		</band>
	</title>
	<pageHeader>
		<band height="85" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement x="0" y="0" width="468" height="40"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ENCABEZADO}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="40" width="468" height="25"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{EMPRESA}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="65" width="234" height="20"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["NIT Nro: " + $F{NIT} + "-" + $F{DV}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="234" y="65" width="234" height="20"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Código FNA Nro:            "]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="25" splitType="Stretch">
			<textField>
				<reportElement x="0" y="0" width="468" height="25"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["HACEMOS CONSTAR"]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="380" splitType="Stretch">
			<textField>
				<reportElement x="0" y="0" width="468" height="85"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Top">
					<font size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Que para dar cumplimiento a la Ley 432/98, Articulo 6, que ordena: '... Mensualmente, las entidades públicas empleadoras enviarán al Fondo Nacional de Ahorro una certificación que contenga el valor total de los Factores Salariales que constituyan base para liquidar cesantía, devengados en el mes inmediatamente anterior ....', enviamos la Certificación de las Cesantías de todos nuestros servidores públicos que prestan servicio en esta entidad, adjuntando el medio magnético y el reporte correspondiente."]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="288" width="468" height="30"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Top">
					<font size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["La presente constancia se expide con destino al F.N.A en la ciudad de Bogotá Cundinamarca, a los " + $F{DIA_ACTUAL_LETRA} + " (" + $F{DIA_ACTUAL} + ") días del mes de " + $F{MES_ACTUAL} + " de " + $F{ANHO_ACTUAL} + "."]]></textFieldExpression>
			</textField>
			<subreport>
				<reportElement stretchType="RelativeToBandHeight" x="61" y="318" width="350" height="62"/>
				<subreportParameter name="comando">
					<subreportParameterExpression><![CDATA[$P{comando}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression class="java.lang.String"><![CDATA["repo:firma"]]></subreportExpression>
			</subreport>
			<textField>
				<reportElement x="0" y="85" width="468" height="25"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["ESPECIFICAMOS"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="110" width="468" height="20"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Top">
					<font size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["1. Mes certificado: " + $F{MES} + " de " + $F{ID_ANHOS}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="162" width="468" height="32"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Top">
					<font size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["3. Valor total mensual de las cesantías : " + $F{VALOR} + " - " + $F{NUMEROS_LETRAS} + "pesos M/C."]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement x="0" y="194" width="468" height="20"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Top">
					<font size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["4. Nro. Total de empleados afiliados reportados : " + $F{CANT} + ", " + $F{CANT_LETRAS}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="214" width="468" height="20"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Top">
					<font size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["5. Discriminación de valores por clase de reporte asi : "]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="234" width="100" height="15"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Top">
					<font size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Clase"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="249" width="100" height="15"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Top">
					<font size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["1"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="100" y="234" width="100" height="15"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Top">
					<font size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Cantidad"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="200" y="234" width="118" height="15"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Top">
					<font size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Valor"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="264" width="100" height="15"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Top">
					<font size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["2"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="100" y="249" width="100" height="15"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Top">
					<font size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ACTIVO}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="100" y="264" width="100" height="15"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Top">
					<font size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CANT} - $F{ACTIVO}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="200" y="249" width="118" height="15"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Top">
					<font size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ACTIVO_VALOR_TXT}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="200" y="264" width="118" height="15"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Top">
					<font size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{INACTIVO_VALOR_TXT}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="130" width="468" height="32"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Top">
					<font size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["2. Valor base de las cesantías : " + $F{VALOR_BASE} + " - " + $F{NUMEROS_LETRAS_BASE} + "pesos M/C."]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<pageFooter>
		<band height="12" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="350" y="0" 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="440" y="0" width="28" 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>
		</band>
	</pageFooter>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="468" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
