<?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_sin_presta" language="groovy" pageWidth="612" pageHeight="792" whenNoDataType="NoDataSection" columnWidth="480" leftMargin="72" rightMargin="60" topMargin="30" bottomMargin="30">
	<property name="ireport.zoom" value="1.7715610000000015"/>
	<property name="ireport.x" value="88"/>
	<property name="ireport.y" value="244"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/nomina/certif_sin_presta"/>
	<property name="ireport.jasperserver.url" value="http://192.168.2.43:8090/jasperserver/services/repository"/>
	<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="estado_pervac" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="estado_tipcont" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="estado_hortra" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="tag" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[1]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT

(select hora_entrada from no_param_gen where id_param_gen = 1) as hora_entrada,
(select hora_salida from no_param_gen where id_param_gen = 1) as hora_salida,

null as estado_pervac,
LPAD(to_char(cauvac.fecha_ini,'dd'),2,'0') as dia_causa_ini,
trim(initcap(to_char(cauvac.fecha_ini,'MONTH','nls_date_language=spanish'))) as mes_causa_ini,
TO_CHAR(cauvac.FECHA_ini,'yyyy') as anho_causa_ini,

LPAD(to_char(cauvac.fecha_fin,'dd'),2,'0') as dia_causa_,
trim(initcap(to_char(cauvac.fecha_fin,'MONTH','nls_date_language=spanish'))) as mes_causa_fin,
TO_CHAR(cauvac.FECHA_fin,'yyyy') as anho_causa_fin,

UPPER(( select firma_inf.encabezado as des from no_inf_firma firma_inf
left join no_firma firma ON firma.id_firma = firma_inf.id_firma
where firma_inf.comando = $P{comando} )) as encabezado,


(( select firma_inf.pie_pagina as des from no_inf_firma firma_inf
left join no_firma firma ON firma.id_firma = firma_inf.id_firma
where firma_inf.comando = $P{comando} )) as pie_pagina,


(( select firma_inf.pie_pagina_extra as des from no_inf_firma firma_inf
left join no_firma firma ON firma.id_firma = firma_inf.id_firma
where firma_inf.comando = $P{comando} )) as pie_pagina_extra,

case when (select min(sexo) as sexo from datos_funcionario where num_doc in (
select firma.documento from no_inf_firma firma_inf
left join no_firma firma ON firma.id_firma = firma_inf.id_firma
where firma_inf.comando = $P{comando}
)) = 1 then 'LA' else 'EL' end as letra_el_titulo,
UPPER(( select firma.cargo as des from no_inf_firma firma_inf
left join no_firma firma ON firma.id_firma = firma_inf.id_firma
where firma_inf.comando = $P{comando} )) as firma,
(select DATOS_COMPANIA.NOMBRE_EMPRESA from DATOS_COMPANIA) as empresa,

case when $P{destino} = 'null' or $P{destino} = '' then '.' else (' con destino a ' || $P{destino} || '.' ) end as destino,

case when tab0.sexo = 1 then 'a' else 'o' end as letra_a,
case when tab0.sexo = 1 then 'de la' else 'del' end as letra_del,
case when tab0.sexo = 1 then 'a' else ' ' end as letra_a_sin,
case when tab0.sexo = 1 then 'la' else 'el' end as letra_el,

case when area2.descripcion is null then ' ' else initcap(area2.descripcion) ||', ' end as DEPENDENCIA_niv,
initcap(area1.descripcion) as area1,
initcap(area2.descripcion) as area2,

'$ ' || TO_CHAR(TAB0.ASIGNACION_BASICA, 'FM9,999,999,999') as asig,
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,
lower(Numero_a_Texto (TO_CHAR(sysdate,'yyyy'), 2, 'ESP' )) as anho_actual_letra,
lower($P{numero_letras}) as numeros_letras,
lower(Numero_a_Texto( to_char(tab1.fecha_ingreso,'dd'), 2, 'ESP' )) as dia_ingreso_letra,
LPAD(to_char(tab1.fecha_ingreso,'dd'),2,'0') as dia_ingreso,
trim(initcap(to_char(tab1.fecha_ingreso,'MONTH','nls_date_language=spanish'))) as mes_ingreso,
TO_CHAR(TAB1.FECHA_INGRESO,'yyyy') as anho_INGRESO,
TAB0.ID_TIPO_DOC as ID_TIPO_DOC,
TAB0.NUM_DOC as NUM_DOC,
replace(trim(TO_CHAR(TAB0.NUM_DOC, '9,999,999,999,999')),',','.') as NUM_DOC_puntos,
TAB0.NOMBRE_COMPLETO as NOMBRE_COMPLETO,
tab0.nombre_apellido as nombre_apellido,
tab0.nombres,
tab0.apellidos,

tab0.cargo as cargo,
jer.nivel,
case when $P{tag} = 1 then jer.nivel || tab0.codigo_comp else tab0.codigo_comp end as codigo_comp,
TAB0.GRADO_COMP as GRADO_COMP,
initcap_sofhouse(initcap(TAB0.DENOMINACION_COMP)) as DENOMINACION_COMP,
initcap_sofhouse(initcap(TAB0.DEPENDENCIA)) as DEPENDENCIA,
TAB0.ASIGNACION_BASICA as ASIGNACION_BASICA, TAB0.DEVENGADOS as DEVENGADOS, TAB0.DEDUCIDOS as DEDUCIDOS,
tab0.neto as neto, tab0.id_periodo as id_periodo, tab0.banco as banco, tab0.cuenta as cuenta,
tab0.tipper as tipper, tab0.periodo as periodo, tab0.tipper||'  '||tab0.periodo as periodo_completo,
tab0.email as email, tab0.id_dp as id_dp, to_char(tab1.fecha_ingreso, 'YYYY-MM-DD') as fecha_ingreso,
-- si tiene novedad de encargo poner en tipo_nombramiento - 20131021
--lower(tipnom1.nombre) as tipo_nombramiento
case when (select count(*) from no_novedad_personal
where id_tipo_doc = TAB0.ID_TIPO_DOC and num_doc = TAB0.NUM_DOC and estado = 1 and id_novedad = 3
and sysdate between fecha_inicial and fecha_terminacion) > 0 then 'novedad de encargo' else lower(tipnom1.nombre) end as tipo_nombramiento,
tab0.sexo,
INITCAP(nvl(tab0.lugar_doc , 'Bogotá')) as lugar_doc

FROM NO_LIQUIDA_V tab0

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

left join rh_sa_niv2 tipnom1
on tipnom1.id_sa_niv2 = tab1.id_sa_niv2

join rh_dp rhdp
on tab0.id_dp = rhdp.id_dp

left join area area1
on area1.id_area = rhdp.id_ea

left join area area2
on area2.id_area = area1.id_dependencia

left join rh_ap_den_emp dep
on dep.id_den_emp = rhdp.id_den_emp

left join rh_pn_componente_escala coe
on coe.id_com_esc = dep.id_comp_es

left join rh_pn_jerarquia jer
on jer.id_pn_jer = coe.id_nivel_jerarquico

left join (
  select aut.*,
   ROW_NUMBER() OVER (
    partition by aut.num_doc
    ORDER BY aut.fecha_ini asc
   ) AS rn
  from no_causa_vacac aut
  where aut.saldos_dias > 0
)cauvac
on tab0.num_doc = cauvac.num_doc
and tab0.id_tipo_doc = cauvac.id_tipo_doc
and cauvac.rn = 1

WHERE  tab0.id_periodo != '-1'
AND tab0.id_periodo in (
    select id_periodo from (
        select
        per.*,
        ROW_NUMBER() OVER (
          partition by per.id_tipo_periodo
          ORDER BY per.fecha_fin desc
        ) AS rn
        from no_periodo per
        where
        per.id_tipo_periodo = 1
        and per.id_anhos <= (select id_anhos from no_periodo where id_periodo = $P{id_periodo})
        and per.id_meses <= (select id_meses from no_periodo where id_periodo = $P{id_periodo})
    )
    where
    rn = 1
)
$P!{whereFuncionarioNumDoc} $P!{whereFuncionarioTipoDoc}


ORDER BY num_doc]]>
	</queryString>
	<field name="HORA_ENTRADA" class="java.lang.String"/>
	<field name="HORA_SALIDA" class="java.lang.String"/>
	<field name="ESTADO_PERVAC" class="java.lang.String"/>
	<field name="DIA_CAUSA_INI" class="java.lang.String"/>
	<field name="MES_CAUSA_INI" class="java.lang.String"/>
	<field name="ANHO_CAUSA_INI" class="java.lang.String"/>
	<field name="DIA_CAUSA_" class="java.lang.String"/>
	<field name="MES_CAUSA_FIN" class="java.lang.String"/>
	<field name="ANHO_CAUSA_FIN" class="java.lang.String"/>
	<field name="ENCABEZADO" class="java.lang.String"/>
	<field name="PIE_PAGINA" class="java.lang.String"/>
	<field name="PIE_PAGINA_EXTRA" class="java.lang.String"/>
	<field name="LETRA_EL_TITULO" class="java.lang.String"/>
	<field name="FIRMA" class="java.lang.String"/>
	<field name="EMPRESA" class="java.lang.String"/>
	<field name="DESTINO" class="java.lang.String"/>
	<field name="LETRA_A" class="java.lang.String"/>
	<field name="LETRA_DEL" class="java.lang.String"/>
	<field name="LETRA_A_SIN" class="java.lang.String"/>
	<field name="LETRA_EL" class="java.lang.String"/>
	<field name="DEPENDENCIA_NIV" class="java.lang.String"/>
	<field name="AREA1" class="java.lang.String"/>
	<field name="AREA2" class="java.lang.String"/>
	<field name="ASIG" 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="ANHO_ACTUAL_LETRA" class="java.lang.String"/>
	<field name="NUMEROS_LETRAS" class="java.lang.String"/>
	<field name="DIA_INGRESO_LETRA" class="java.lang.String"/>
	<field name="DIA_INGRESO" class="java.lang.String"/>
	<field name="MES_INGRESO" class="java.lang.String"/>
	<field name="ANHO_INGRESO" class="java.lang.String"/>
	<field name="ID_TIPO_DOC" class="java.math.BigDecimal"/>
	<field name="NUM_DOC" class="java.lang.String"/>
	<field name="NUM_DOC_PUNTOS" class="java.lang.String"/>
	<field name="NOMBRE_COMPLETO" class="java.lang.String"/>
	<field name="NOMBRE_APELLIDO" class="java.lang.String"/>
	<field name="NOMBRES" class="java.lang.String"/>
	<field name="APELLIDOS" class="java.lang.String"/>
	<field name="CARGO" class="java.lang.String"/>
	<field name="NIVEL" class="java.math.BigDecimal"/>
	<field name="CODIGO_COMP" class="java.lang.String"/>
	<field name="GRADO_COMP" class="java.lang.String"/>
	<field name="DENOMINACION_COMP" class="java.lang.String"/>
	<field name="DEPENDENCIA" class="java.lang.String"/>
	<field name="ASIGNACION_BASICA" class="java.math.BigDecimal"/>
	<field name="DEVENGADOS" class="java.math.BigDecimal"/>
	<field name="DEDUCIDOS" class="java.math.BigDecimal"/>
	<field name="NETO" class="java.math.BigDecimal"/>
	<field name="ID_PERIODO" class="java.math.BigDecimal"/>
	<field name="BANCO" class="java.lang.String"/>
	<field name="CUENTA" class="java.lang.String"/>
	<field name="TIPPER" class="java.lang.String"/>
	<field name="PERIODO" class="java.lang.String"/>
	<field name="PERIODO_COMPLETO" class="java.lang.String"/>
	<field name="EMAIL" class="java.lang.String"/>
	<field name="ID_DP" class="java.math.BigDecimal"/>
	<field name="FECHA_INGRESO" class="java.lang.String"/>
	<field name="TIPO_NOMBRAMIENTO" class="java.lang.String"/>
	<field name="SEXO" class="java.lang.String"/>
	<field name="LUGAR_DOC" class="java.lang.String"/>
	<variable name="letra_a" class="java.lang.String">
		<variableExpression><![CDATA[( '1' == $F{SEXO}
    ? "a"
    : "o"
)]]></variableExpression>
	</variable>
	<variable name="letra_del" class="java.lang.String">
		<variableExpression><![CDATA[( '1' == $F{SEXO}     ? "de la"     : "del" )]]></variableExpression>
	</variable>
	<variable name="letra_a_sin" class="java.lang.String">
		<variableExpression><![CDATA[( '1' == $F{SEXO}     ? "a"     : "" )]]></variableExpression>
	</variable>
	<variable name="letra_el" class="java.lang.String">
		<variableExpression><![CDATA[( '1' == $F{SEXO}     ? "la"     : "el" )]]></variableExpression>
	</variable>
	<group name="num_doc">
		<groupExpression><![CDATA[$F{NUM_DOC}]]></groupExpression>
		<groupHeader>
			<band height="50" splitType="Stretch">
				<textField isStretchWithOverflow="true">
					<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="480" height="50"/>
					<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" markup="styled">
						<font size="12"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA["Que "+$F{LETRA_EL}+ " funcionari"+$F{LETRA_A}+ " " + "<style isBold=\"true\">" + $F{NOMBRE_APELLIDO} + "</style>" + " identificad"+$F{LETRA_A}+ " con la cédula de ciudadanía No. " + $F{NUM_DOC_PUNTOS} + ", presta sus servicios a esta Entidad desde el " + $F{DIA_INGRESO} + " de " + $F{MES_INGRESO} + " de " + $F{ANHO_INGRESO} + " a la fecha, y actualmente desempeña el cargo de " + $F{DENOMINACION_COMP} + ", Código " + $F{CODIGO_COMP} + ", Grado " + $F{GRADO_COMP} + " de la Planta Global."]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="30">
				<printWhenExpression><![CDATA[$P{estado_hortra} == 1]]></printWhenExpression>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="480" height="30" isRemoveLineWhenBlank="true"/>
					<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" markup="styled">
						<font size="12"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA["\nQue "+$F{LETRA_EL}+ " funcionari"+$F{LETRA_A}+ " " + "<style isBold=\"true\">" + $F{APELLIDOS} + "</style>" + " tiene un horario de trabajo de lunes a viernes de " + $F{HORA_ENTRADA} + " a " + $F{HORA_SALIDA}]]></textFieldExpression>
				</textField>
			</band>
			<band height="30">
				<printWhenExpression><![CDATA[$P{estado_pervac} == 1]]></printWhenExpression>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="480" height="30" isRemoveLineWhenBlank="true"/>
					<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" markup="styled">
						<font size="12"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA["\nQue "+$F{LETRA_EL}+ " funcionari"+$F{LETRA_A}+ " " + "<style isBold=\"true\">" + $F{APELLIDOS} + "</style>" + " tiene un período de vacaciones causado por el año de servicios prestados entre el " + $F{DIA_CAUSA_INI} + " de " + $F{MES_CAUSA_INI} + " de " + $F{ANHO_CAUSA_INI} + " al " + $F{DIA_CAUSA_} + " de " + $F{MES_CAUSA_FIN} + " de " + $F{ANHO_CAUSA_FIN} + "."]]></textFieldExpression>
				</textField>
			</band>
			<band height="30">
				<printWhenExpression><![CDATA[$P{estado_tipcont} == 1]]></printWhenExpression>
				<textField isStretchWithOverflow="true" isBlankWhenNull="true">
					<reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="480" height="30" isRemoveLineWhenBlank="true"/>
					<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" markup="styled">
						<font size="12"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA["\nQue "+$F{LETRA_EL}+ " funcionari"+$F{LETRA_A}+ " " + "<style isBold=\"true\">" + $F{APELLIDOS} + "</style>" + " se encuentra inscrit"+$F{LETRA_A}+ " en el escalafón de la " + $F{TIPO_NOMBRAMIENTO} + "."]]></textFieldExpression>
				</textField>
			</band>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="81" splitType="Stretch">
			<image hAlign="Center">
				<reportElement x="0" y="0" width="480" height="81"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:logo_servicio_bicen.jpg"]]></imageExpression>
			</image>
		</band>
	</title>
	<pageHeader>
		<band height="50" splitType="Stretch">
			<textField>
				<reportElement x="0" y="0" width="480" height="50">
					<printWhenExpression><![CDATA[$V{PAGE_NUMBER} == 1]]></printWhenExpression>
				</reportElement>
				<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="12" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{LETRA_EL_TITULO} + " " + $F{ENCABEZADO} + " " + $F{EMPRESA}]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="62" splitType="Stretch">
			<textField>
				<reportElement x="0" y="0" width="480" height="62">
					<printWhenExpression><![CDATA[$V{PAGE_NUMBER} == 1]]></printWhenExpression>
				</reportElement>
				<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="12" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["HACE CONSTAR"]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="30" splitType="Stretch">
			<subreport>
				<reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="350" height="30"/>
				<subreportParameter name="num_doc">
					<subreportParameterExpression><![CDATA[$F{NUM_DOC}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="letra_del">
					<subreportParameterExpression><![CDATA[$V{letra_del}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="letra_a_sin">
					<subreportParameterExpression><![CDATA[$V{letra_a_sin}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="letra_a">
					<subreportParameterExpression><![CDATA[$V{letra_a}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="letra_el">
					<subreportParameterExpression><![CDATA[$V{letra_el}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="id_tipo_doc">
					<subreportParameterExpression><![CDATA[$F{ID_TIPO_DOC}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression class="java.lang.String"><![CDATA["repo:certif_devengados"]]></subreportExpression>
			</subreport>
		</band>
	</detail>
	<pageFooter>
		<band height="40" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="362" y="28" 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="452" y="28" 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>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="0" y="0" width="480" height="28" isRemoveLineWhenBlank="true"/>
				<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="Top" markup="styled">
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PIE_PAGINA_EXTRA}]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band height="178">
			<textField isStretchWithOverflow="true">
				<reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="480" height="55"/>
				<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="12"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["\nLa presente constancia se expide en la ciudad de Bogotá, D. C., a los " + $F{DIA_ACTUAL_LETRA} + " (" + $F{DIA_ACTUAL} + ") días del mes de " + $F{MES_ACTUAL} + " del año " + $F{ANHO_ACTUAL_LETRA} + "(" + $F{ANHO_ACTUAL} + "), a solicitud "+$V{letra_del}+ " interesad" + $V{letra_a} + $F{DESTINO}]]></textFieldExpression>
			</textField>
			<subreport>
				<reportElement stretchType="RelativeToBandHeight" x="0" y="55" width="350" height="90" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[1 == $P{tag}]]></printWhenExpression>
				</reportElement>
				<subreportParameter name="comando">
					<subreportParameterExpression><![CDATA[$P{comando}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression class="java.lang.String"><![CDATA["repo:firma_sin_cargo"]]></subreportExpression>
			</subreport>
			<subreport>
				<reportElement stretchType="RelativeToBandHeight" x="61" y="55" width="350" height="90" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[0 == $P{tag}]]></printWhenExpression>
				</reportElement>
				<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 isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement x="0" y="154" width="480" height="24"/>
				<textElement verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="7" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PIE_PAGINA}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="480" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
