<?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_funciones_sgc" language="groovy" pageWidth="612" pageHeight="792" whenNoDataType="NoDataSection" columnWidth="468" leftMargin="72" rightMargin="72" topMargin="72" bottomMargin="72">
	<property name="ireport.zoom" value="1.2100000000000006"/>
	<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="sexo" class="java.math.BigDecimal"/>
	<parameter name="fecha_manual" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT distinct
--rhdpmf.id_mf,
--rhmfmf.id_mf_mf,

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 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(lower(TO_CHAR(sysdate,'MONTH','nls_date_language=spanish'))) as MES_actual,
lower(Numero_a_Texto ( to_char(sysdate,'yyyy'), 2, 'ESP' )) as anho_actual_letra,
TO_CHAR(sysdate,'yyyy') as anho_actual,
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, TAB0.NOMBRE_COMPLETO as NOMBRE_COMPLETO,
tab0.nombre_apellido as nombre_apellido,

tab0.cargo as cargo,
jer.nivel,
jer.nivel || tab0.codigo_comp 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 'encargo' else lower(tipnom1.nombre) end as tipo_nombramiento,
tab0.sexo,
--rownum || '. ' as rn,
REPLACE(REPLACE(REPLACE(rhmffed.funcion,CHR(10),' ') ,CHR(13),' ') ,'  ',' ')as funcion,
rhmffed.codigo,

nor.codigo as codigo_mf,
nor.fecha as fecha_mf,
LPAD(to_char(nor.fecha,'dd'),2,'0') as dia_mf,
trim(lower(to_char(nor.fecha,'MONTH','nls_date_language=spanish'))) as mes_mf,
TO_CHAR(nor.fecha,'yyyy') as anho_mf,

tab1.doc_nombra as codigo_nombra,
tab1.fecha_nombra as fecha_nombra,
LPAD(to_char(tab1.fecha_nombra,'dd'),2,'0') as dia_nombra,
trim(lower(to_char(tab1.fecha_nombra,'MONTH','nls_date_language=spanish'))) as mes_nombra,
TO_CHAR(tab1.fecha_nombra,'yyyy') as anho_nombra,

lower(nat.nombre) as naturaleza,

case when novnom.ID_SA_NIV2_OLD != novnom.ID_SA_NIV2_NEW then 'Que por Resolución No.'
||novnom.numero_doc||' del '||LPAD(to_char(novnom.fecha_doc,'dd'),2,'0')||' de '||trim(lower(to_char(novnom.fecha_doc,'MONTH','nls_date_language=spanish')))||' de '||TO_CHAR(novnom.fecha_doc,'yyyy')||', el nombramiento ha mutado su naturaleza a '
||lower(tipnom1nov.nombre)||', a partir del '||LPAD(to_char(novnom.fecha,'dd'),2,'0')||' de '||trim(lower(to_char(novnom.fecha,'MONTH','nls_date_language=spanish')))||' de '||TO_CHAR(novnom.fecha,'yyyy')||'."' else ' ' end as text_nov_nom,


cargoant.codigo_comp as codigo_comp_cargoant,
cargoant.GRADO_COMP as GRADO_COMP_cargoant,
initcap_sofhouse(initcap(cargoant.DENOMINACION_COMP)) as DENOMINACION_COMP_cargoant,
initcap_sofhouse(initcap(cargoant.naturaleza)) as naturaleza_cargoant,
initcap_sofhouse(initcap(CARGOANT.area)) as DEPENDENCIA_CARGOANT,

tab1.no_acta,
tab1.fecha_acta,
LPAD(TO_CHAR(tab1.fecha_acta,'dd'),2,'0') as DIA_acta,
lower(Numero_a_Texto ( to_char(tab1.fecha_acta,'dd'), 2, 'ESP' )) as dia_acta_letra,
trim(lower(TO_CHAR(tab1.fecha_acta,'MONTH','nls_date_language=spanish'))) as MES_acta,
lower(Numero_a_Texto ( to_char(tab1.fecha_acta,'yyyy'), 2, 'ESP' )) as anho_acta_letra,
TO_CHAR(tab1.fecha_acta,'yyyy') as anho_acta

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 no_nov_tip_nombra_v novnom
on novnom.id_nombramiento = tab1.id_nombramiento

left join rh_sa_niv2 tipnom1nov
on tipnom1nov.id_sa_niv2 = novnom.id_sa_niv2_new

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 rh_ap_naturaleza_em nat
on nat.id_nat_emp = rhdp.id_nat_emp

left join rh_dp_mf rhdpmf
on tab0.id_dp = rhdpmf.id_dp

left join rh_mf_mf rhmfmf
on rhdpmf.id_mf = rhmfmf.id_mf_mf
AND nvl(to_date($P{fecha_manual}, 'yyyy/mm/dd'),sysdate) BETWEEN rhmfmf.fecha_i AND nvl(rhmfmf.fecha_f,sysdate+1)

left join normas nor
on rhmfmf.id_norma = nor.id_normas

left join rh_mf_fe rhmffe
on rhmfmf.id_mf_mf = rhmffe.id_mf

left join rh_mf_fe_d rhmffed
on rhmffe.id_mf_fe = rhmffed.id_fe

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

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

left join no_dp_v cargoant
on cargoant.id_dp = tab1.id_dp

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

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 tab0.num_doc, rhmffed.codigo]]>
	</queryString>
	<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="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_LETRA" class="java.lang.String"/>
	<field name="ANHO_ACTUAL" 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="NOMBRE_COMPLETO" class="java.lang.String"/>
	<field name="NOMBRE_APELLIDO" 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="FUNCION" class="java.lang.String"/>
	<field name="CODIGO" class="java.math.BigDecimal"/>
	<field name="CODIGO_MF" class="java.lang.String"/>
	<field name="FECHA_MF" class="java.sql.Timestamp"/>
	<field name="DIA_MF" class="java.lang.String"/>
	<field name="MES_MF" class="java.lang.String"/>
	<field name="ANHO_MF" class="java.lang.String"/>
	<field name="CODIGO_NOMBRA" class="java.lang.String"/>
	<field name="FECHA_NOMBRA" class="java.sql.Timestamp"/>
	<field name="DIA_NOMBRA" class="java.lang.String"/>
	<field name="MES_NOMBRA" class="java.lang.String"/>
	<field name="ANHO_NOMBRA" class="java.lang.String"/>
	<field name="NATURALEZA" class="java.lang.String"/>
	<field name="TEXT_NOV_NOM" class="java.lang.String"/>
	<field name="CODIGO_COMP_CARGOANT" class="java.lang.String"/>
	<field name="GRADO_COMP_CARGOANT" class="java.lang.String"/>
	<field name="DENOMINACION_COMP_CARGOANT" class="java.lang.String"/>
	<field name="NATURALEZA_CARGOANT" class="java.lang.String"/>
	<field name="DEPENDENCIA_CARGOANT" class="java.lang.String"/>
	<field name="NO_ACTA" class="java.lang.String"/>
	<field name="FECHA_ACTA" class="java.sql.Timestamp"/>
	<field name="DIA_ACTA" class="java.lang.String"/>
	<field name="DIA_ACTA_LETRA" class="java.lang.String"/>
	<field name="MES_ACTA" class="java.lang.String"/>
	<field name="ANHO_ACTA_LETRA" class="java.lang.String"/>
	<field name="ANHO_ACTA" class="java.lang.String"/>
	<variable name="letra_a" class="java.lang.String">
		<variableExpression><![CDATA[( $F{SEXO} == 1 ? "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="218">
				<textField isStretchWithOverflow="true">
					<reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="468" height="80"/>
					<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 de acuerdo con la documentación existente en el Expediente de Historia Laboral "+$F{LETRA_EL}+ " funcionari"+$F{LETRA_A}+ " " + $F{NOMBRE_APELLIDO} +", identificad"+$F{LETRA_A}+ " con cédula de ciudadanía No. " + $F{NUM_DOC} + " de Bogotá, se constató que presta sus servicios al Instituto desde el " + $F{DIA_INGRESO} + " de " + $F{MES_INGRESO} + " de " + $F{ANHO_INGRESO} + " hasta la fecha, y actualmente desempeña el cargo de " + $F{DENOMINACION_COMP} + ", Código " + $F{CODIGO_COMP} + ", Grado " + $F{GRADO_COMP} + ", " + $F{DEPENDENCIA_NIV} + $F{DEPENDENCIA} +" de la Planta global del Instituo, Sede Central."]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true">
					<reportElement stretchType="RelativeToBandHeight" x="0" y="83" width="468" height="75"/>
					<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 mediante Resolución No." + $F{CODIGO_NOMBRA} + " del " + $F{DIA_NOMBRA} + " de " + $F{MES_NOMBRA} + " de " + $F{ANHO_NOMBRA} + ", se nómbro mediante " + $F{TIPO_NOMBRAMIENTO}  + " para desempeñar el cargo de " + $F{NATURALEZA_CARGOANT} + " de " + $F{DENOMINACION_COMP_CARGOANT} + ", Código " + $F{CODIGO_COMP_CARGOANT} + ", Grado " + $F{GRADO_COMP_CARGOANT} + ", " + $F{DEPENDENCIA_CARGOANT} +". Acta de Posesión No."+$F{NO_ACTA}+" de "+$F{DIA_ACTA}+" de "+$F{MES_ACTA}+" de "+$F{ANHO_ACTA}+". " + $F{TEXT_NOV_NOM}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true">
					<reportElement stretchType="RelativeToBandHeight" x="0" y="163" width="468" 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">
						<font size="11"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA["Que mediante Resolución No." + $F{CODIGO_MF} + " de " + $F{DIA_MF} + " de " + $F{MES_MF} + " de " + $F{ANHO_MF} + ", por la cual se adopta la versión No.3 del Manual Específico de Funciones y Competencias Laborales del " + $F{EMPRESA} + ", al Cargo de " + $F{DENOMINACION_COMP} + ", Código " + $F{CODIGO_COMP} + ", Grado " + $F{GRADO_COMP} + ", le corresponden las siguientes funciones:"]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="121">
				<textField>
					<reportElement x="0" y="14" width="468" height="45"/>
					<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 en 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 con destino " + $P{destino} + "."]]></textFieldExpression>
				</textField>
				<subreport>
					<reportElement stretchType="RelativeToBandHeight" x="0" y="59" width="250" 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_sin_cargo"]]></subreportExpression>
				</subreport>
			</band>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<pageHeader>
		<band height="150" splitType="Stretch">
			<textField>
				<reportElement x="0" y="80" width="468" height="30" isRemoveLineWhenBlank="true">
					<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="11" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["LA COORDINADORA DEL GRUPO DE TALENTO HUMANO DEL " + $F{EMPRESA}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="110" width="468" height="40">
					<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="11" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["HACE CONSTAR"]]></textFieldExpression>
			</textField>
			<image hAlign="Center">
				<reportElement x="0" y="0" width="468" height="80"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:logo_servicio_bicen.jpg"]]></imageExpression>
			</image>
		</band>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="18" splitType="Prevent">
			<textField isStretchWithOverflow="true">
				<reportElement x="48" y="0" width="420" height="14" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{CODIGO} != null]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2"/>
				<textElement textAlignment="Justified">
					<font size="11"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{FUNCION}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement stretchType="RelativeToTallestObject" x="24" y="0" width="24" height="14" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{CODIGO} != null]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2"/>
				<textElement>
					<font size="11" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CODIGO} + ". "]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="9" splitType="Stretch"/>
	</columnFooter>
	<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>
