<?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_anual_titulo" language="groovy" pageWidth="830" pageHeight="792" columnWidth="790" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.948717100000005"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/canon/inf_anual_titulo"/>
	<property name="ireport.jasperserver.url" value="http://localhost:18080/jasperserver/services/repository"/>
	<parameter name="whereCompetencia" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTitulo" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereLiquidado" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select

noveta.fecha_inicio as fecha_inicio_noveta,

to_char(tab0.fecha_inicio_t,'yyyy') as vigencia,
case
when to_char(trunc(tab0.fecha_inicio_t),'mm') = '02' and to_char(trunc(tab0.fecha_inicio_t),'dd') = '29' and (nvl(noveta.fecha_inicio,tab0.fecha_fin_t) - tab0.fecha_inicio_t) <= 366 then nvl(noveta.fecha_inicio,tab0.fecha_fin_t) - tab0.fecha_inicio_t
when ((tab0.fecha_inicio_t + interval '1' year) - 1) = nvl(noveta.fecha_inicio,tab0.fecha_fin_t) then 365 else nvl(noveta.fecha_inicio,tab0.fecha_fin_t) - tab0.fecha_inicio_t + 1 end as dias,

tab5.num_doc as num_doc_titular,
tab5.raz_soc as raz_soc_titular,

tab0.*
,sysdate
,(select a.area/10000 from in_titulo_area a where a.id_titulo = tab0.id_titulo and a.actual = 1 and rownum =1 ) as area_actual
,

case when tab0.num_doc_profesional is null then 'Sin Profesional Económico Asignado.' else 'Profesional Económico: ' || tab0.num_doc_profesional || '-' || tab0.razon_soc_profesional end as profesional,
nov.nombre as novedad,
nov.documento_usuario,
nov.nombre_usuario,
case when nov.nombre is null then 'Sin registro de Novedad.' else 'Ultima Novedad: ' || nov.nombre || ', Fecha: ' || to_char(nov.fecha_registro,'dd/mm/yyyy') end as tipo_nov,
case when nov.documento_usuario is null then 'Sin registro de Usuario.' else 'Usuario Novedad: ' || nov.documento_usuario || '-' || nov.nombre_usuario end as usu_nov

from (

    select tab0.*
    ,(select descripcion from ca_norma_canon where tab0.id_norma = id_norma) as ley
    , (select nombre from rmn_modalidad where id_modalidad = tab0.id_modalidad ) as nom_modalidad
    ,(select nombre from rmn_competencia where id_competencia = t.id_competencia) as competencia
    ,t.id_competencia
    from
    (

        select
        (select id_norma from ca_titulo_norma n where n.id_titulo = e.id_titulo and actual = 1 and rownum = 1) as id_norma,
        (select id_modalidad from rmn_titulo_modalidad n where n.id_titulo = e.id_titulo and actual = 1 and rownum = 1) as id_modalidad,
        (select abreviacion from ca_etapa where id_etapa = e.id_etapa) as nombre_etapa,
        e.id_anual_etapa,
        e.id_titulo_etapa,
        r.num_recibo as num_rec,
        r.pago as pago,
        r.id_recibo as id_recibo,
        e.id_titulo,
        e.anualidad,
        e.fecha_inicio,
        e.fecha_fin,
        e.estado,
        e.liquidado,
        case when r.pago = 1 then 'X' else ' ' end as pago_txt,
        (case when e.liquidado = 1 then 'LIQUIDADO'else 'SIN LIQUIDAR' end )as estado_liq,
        e.impreso,
        t1.cod_titulo  as cod_rmn,
        t1.fecha_inscripcion_rmn as fecha_rmn,
        d.id_det_liq_canon as id_det_liq_canon,
        case when d.valor = -1 then 0 else d.valor end  as valor,
        d.id_liq_canon as id_liq_canon,
        d.vigencia  as vigencia_liq,
        d.fecha_aprueba  as fecha_aprueba,
        e.id_etapa,
        e.fecha_inicio as fecha_inicio_t,
        e.fecha_fin as fecha_fin_t,
        t.fecha_inscripcion_rmn as fecha_inscripcion,
        t.fecha_contrato as fecha_insc,
        t.estado as estado_t,
        d.area / 10000 as area,
        case when p.valor_pago = -1 then 0 else p.valor_pago end as valor_pago_his,
        t.id_profesional,
        prof.documento as num_doc_profesional,
        prof.nombre as razon_soc_profesional,
        prof.email_usuario as email_profesional,
        t.activo_pin,
        -- tasa de interes aplicada
        case
        when tt.aplica_usura=0 then ti.valor
        else tiact.valor
        end as tasa_interes_aplicada,
        case
        when tt.aplica_usura=0 then  ti.valor || ' %'
        else 'Tasa Usura'
        end as tasa_interes_aplicada_text,
        d.ID_SMDLV ,
        sml.valor_mensual as salario_mensual,
        sml.vigencia as vigencia_sml

        from ca_anual_consolidado_v e

        join rmn_titulo t on e.id_titulo = t.id_titulo
        left join ca_det_liq_canon  d on
        d.id_anual_etapa = e.id_anual_etapa
        and d.anulado = 0

        left join ca_smdlv sml on sml.ID_SMDLV = d.ID_SMDLV

        left join ca_recibo r on
        r.id_det_liq_canon = d.id_det_liq_canon
        and r.vigencia = d.vigencia
        left join ca_pago_historico p on
        p.id_recibo = r.id_recibo
        and p.vigencia = r.vigencia
        join rmn_titulo t1
        on t1.id_titulo = t.id_titulo

        left join ca_titulo_tasa tt on tt.id_titulo = t.id_titulo and tt.estado=1
        left join ca_tasa_interes ti on tt.id_tasa_interes = ti.id_tasa_interes
        left join ca_tasa_interes tiact on tiact.vigencia=to_char(sysdate, 'yyyy') and tiact.id_meses=to_char(sysdate, 'mm')

        LEFT JOIN ca_profesional_v prof  ON prof.id_profesional = t.id_profesional

        where 1 = 1
    )tab0
    join in_titulo_competencia t on t.id_titulo = tab0.id_titulo and t.actual =1
    where 1 = 1
    $P!{whereLiquidado} $P!{whereTitulo}

)tab0

left join (
  select
   aut.*,
   row_number() over (
    partition by aut.cod_titulo
    order by aut.cod_titulo, aut.actual desc, aut.fecha_inicial desc
   ) as rn
  from rmn_titulo_persona_mv aut
  where
  aut.actual = 1
)tab5
on tab0.id_titulo = tab5.id_titulo
and tab5.rn = 1

left join (
  SELECT
   aut.*,
   ROW_NUMBER() OVER (
    partition by aut.id_titulo
    ORDER BY aut.fecha_registro desc, aut.aprobada desc, aut.id_novedad desc
   ) AS rn
  from ca_novedad_v aut
)nov
on nov.id_titulo = tab0.id_titulo
and nov.rn = 1

left join(

    select
    noveta.id_titulo,
    noveta.id_anual_etapa,
    min(noveta.fecha_inicio)-1 as fecha_inicio
    from (

        SELECT
        anu.id_anual_etapa,
        to_char(nov.fecha_inicio,'yyyy') as vigencia,
        nov.fecha_fin - nov.fecha_inicio + 1 as dias,
        nov.*

        FROM ca_novedad nov

        left join ca_anual_etapa anu
        on anu.id_titulo = nov.id_titulo

        left join ca_titulo_etapa titeta
        on titeta.id_titulo_etapa = anu.id_titulo_etapa

        where
        nov.fecha_inicio between anu.fecha_inicio and anu.fecha_fin
        and nov.fecha_fin between anu.fecha_inicio and anu.fecha_fin
        and nov.aprobada = 1
        and nov.id_tipo_novedad = 10
        and titeta.actual = 1

    )noveta

    group by
    noveta.id_titulo,
    noveta.id_anual_etapa

)noveta
on noveta.id_titulo = tab0.id_titulo
and noveta.id_anual_etapa = tab0.id_anual_etapa

where
tab0.fecha_rmn > (select min(c.fecha_vigencia) from ca_norma_canon c where  c.estado = 1 and rownum = 1)
$P!{whereCompetencia}

order by
tab0.id_titulo,
tab0.id_etapa,
tab0.anualidad]]>
	</queryString>
	<field name="FECHA_INICIO_NOVETA" class="java.sql.Timestamp"/>
	<field name="VIGENCIA" class="java.lang.String"/>
	<field name="DIAS" class="java.math.BigDecimal"/>
	<field name="NUM_DOC_TITULAR" class="java.lang.String"/>
	<field name="RAZ_SOC_TITULAR" class="java.lang.String"/>
	<field name="ID_NORMA" class="java.math.BigDecimal"/>
	<field name="ID_MODALIDAD" class="java.math.BigDecimal"/>
	<field name="NOMBRE_ETAPA" class="java.lang.String"/>
	<field name="ID_ANUAL_ETAPA" class="java.math.BigDecimal"/>
	<field name="ID_TITULO_ETAPA" class="java.math.BigDecimal"/>
	<field name="NUM_REC" class="java.math.BigDecimal"/>
	<field name="PAGO" class="java.math.BigDecimal"/>
	<field name="ID_RECIBO" class="java.math.BigDecimal"/>
	<field name="ID_TITULO" class="java.math.BigDecimal"/>
	<field name="ANUALIDAD" class="java.math.BigDecimal"/>
	<field name="FECHA_INICIO" class="java.sql.Timestamp"/>
	<field name="FECHA_FIN" class="java.sql.Timestamp"/>
	<field name="ESTADO" class="java.math.BigDecimal"/>
	<field name="LIQUIDADO" class="java.math.BigDecimal"/>
	<field name="PAGO_TXT" class="java.lang.String"/>
	<field name="ESTADO_LIQ" class="java.lang.String"/>
	<field name="IMPRESO" class="java.math.BigDecimal"/>
	<field name="COD_RMN" class="java.lang.String"/>
	<field name="FECHA_RMN" class="java.sql.Timestamp"/>
	<field name="ID_DET_LIQ_CANON" class="java.math.BigDecimal"/>
	<field name="VALOR" class="java.math.BigDecimal"/>
	<field name="ID_LIQ_CANON" class="java.math.BigDecimal"/>
	<field name="VIGENCIA_LIQ" class="java.math.BigDecimal"/>
	<field name="FECHA_APRUEBA" class="java.sql.Timestamp"/>
	<field name="ID_ETAPA" class="java.math.BigDecimal"/>
	<field name="FECHA_INICIO_T" class="java.sql.Timestamp"/>
	<field name="FECHA_FIN_T" class="java.sql.Timestamp"/>
	<field name="FECHA_INSCRIPCION" class="java.sql.Timestamp"/>
	<field name="FECHA_INSC" class="java.sql.Timestamp"/>
	<field name="ESTADO_T" class="java.math.BigDecimal"/>
	<field name="AREA" class="java.math.BigDecimal"/>
	<field name="VALOR_PAGO_HIS" class="java.math.BigDecimal"/>
	<field name="ID_PROFESIONAL" class="java.math.BigDecimal"/>
	<field name="NUM_DOC_PROFESIONAL" class="java.lang.String"/>
	<field name="RAZON_SOC_PROFESIONAL" class="java.lang.String"/>
	<field name="EMAIL_PROFESIONAL" class="java.lang.String"/>
	<field name="ACTIVO_PIN" class="java.math.BigDecimal"/>
	<field name="TASA_INTERES_APLICADA" class="java.math.BigDecimal"/>
	<field name="TASA_INTERES_APLICADA_TEXT" class="java.lang.String"/>
	<field name="ID_SMDLV" class="java.math.BigDecimal"/>
	<field name="SALARIO_MENSUAL" class="java.math.BigDecimal"/>
	<field name="VIGENCIA_SML" class="java.math.BigDecimal"/>
	<field name="LEY" class="java.lang.String"/>
	<field name="NOM_MODALIDAD" class="java.lang.String"/>
	<field name="COMPETENCIA" class="java.lang.String"/>
	<field name="ID_COMPETENCIA" class="java.math.BigDecimal"/>
	<field name="SYSDATE" class="java.sql.Timestamp"/>
	<field name="AREA_ACTUAL" class="java.math.BigDecimal"/>
	<field name="PROFESIONAL" class="java.lang.String"/>
	<field name="NOVEDAD" class="java.lang.String"/>
	<field name="DOCUMENTO_USUARIO" class="java.lang.String"/>
	<field name="NOMBRE_USUARIO" class="java.lang.String"/>
	<field name="TIPO_NOV" class="java.lang.String"/>
	<field name="USU_NOV" class="java.lang.String"/>
	<group name="TITULO">
		<groupExpression><![CDATA[$F{ID_TITULO}]]></groupExpression>
		<groupHeader>
			<band height="76">
				<staticText>
					<reportElement mode="Opaque" x="121" y="56" width="48" height="20" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<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="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[ETAPA]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="0" y="56" width="46" height="20" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<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="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[PLANILLA]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="760" y="56" width="30" height="20" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<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="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[PAGO]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="700" y="56" width="60" height="20" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<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="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[VALOR PAGO]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="404" y="56" width="53" height="20" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<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="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[FECHA FIN]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="351" y="56" width="53" height="20" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<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="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[FECHA INICIAL]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="76" y="56" width="45" height="20" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<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="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[ANUALIDAD]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="0" y="9" width="121" height="9" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<box leftPadding="4">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[FECHA REGISTRO]]></text>
				</staticText>
				<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
					<reportElement x="375" y="9" width="82" height="9"/>
					<box leftPadding="4">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font size="6"/>
					</textElement>
					<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_INSC}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement mode="Opaque" x="0" y="27" width="121" height="9" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<box leftPadding="4">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA['TASA INTERÉS']]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="271" y="18" width="104" height="9" forecolor="#000000" backcolor="#87CAD2"/>
					<box leftPadding="4">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[ÁREA ACTUAL]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="271" y="9" width="104" height="9" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<box leftPadding="4">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[FECHA CONTRATO]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="121" height="9" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<box leftPadding="4">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[COD. EXPEDIENTE]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="0" y="18" width="121" height="9" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<box leftPadding="4">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[COMPETENCIA]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="271" y="27" width="186" height="9" forecolor="#000000" backcolor="#87CAD2"/>
					<box leftPadding="4">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[PIN(Proyectos de Interes Nacional)]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="271" y="0" width="104" height="9" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<box leftPadding="4">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[TITULAR]]></text>
				</staticText>
				<textField pattern="dd/MM/yyyy">
					<reportElement x="121" y="0" width="150" height="9"/>
					<box leftPadding="4">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font size="6"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{COD_RMN}]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="true">
					<reportElement mode="Transparent" x="121" y="18" width="150" height="9" forecolor="#000000" backcolor="#FFFFFF"/>
					<box leftPadding="4">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" 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[$F{COMPETENCIA}]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="true">
					<reportElement mode="Transparent" x="457" y="27" width="103" height="9" forecolor="#000000" backcolor="#FFFFFF"/>
					<box leftPadding="4">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" 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[( $F{ACTIVO_PIN} == 1
    ? "Si"
    : "No"
)]]></textFieldExpression>
				</textField>
				<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
					<reportElement x="121" y="9" width="150" height="9"/>
					<box leftPadding="4">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font size="6"/>
					</textElement>
					<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_RMN}]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="true">
					<reportElement mode="Transparent" x="560" y="9" width="140" height="9" forecolor="#000000" backcolor="#FFFFFF"/>
					<box leftPadding="4">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" 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[$F{NOM_MODALIDAD}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.0000 Ha;(#,##0.0000 Ha)" isBlankWhenNull="true">
					<reportElement mode="Transparent" x="375" y="18" width="82" height="9" forecolor="#000000" backcolor="#FFFFFF"/>
					<box leftPadding="4">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" 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.math.BigDecimal"><![CDATA[$F{AREA_ACTUAL}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="457" y="18" width="103" height="9" forecolor="#000000" backcolor="#87CAD2"/>
					<box leftPadding="4">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[NORMA]]></text>
				</staticText>
				<textField isBlankWhenNull="true">
					<reportElement mode="Transparent" x="121" y="27" width="150" height="9" forecolor="#000000" backcolor="#FFFFFF"/>
					<box leftPadding="2" rightPadding="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="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{TASA_INTERES_APLICADA_TEXT}]]></textFieldExpression>
				</textField>
				<textField pattern="dd/MM/yyyy">
					<reportElement x="375" y="0" width="325" height="9"/>
					<box leftPadding="4">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle">
						<font size="6"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZ_SOC_TITULAR}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="457" y="9" width="103" height="9" forecolor="#000000" backcolor="#87CAD2"/>
					<box leftPadding="4">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[MODALIDAD]]></text>
				</staticText>
				<textField pattern="" isBlankWhenNull="true">
					<reportElement mode="Transparent" x="560" y="18" width="140" height="9" forecolor="#000000" backcolor="#FFFFFF"/>
					<box leftPadding="4">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" 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[$F{LEY}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="0" y="48" width="790" height="8"/>
					<textElement/>
					<text><![CDATA[]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="457" y="56" width="68" height="20" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<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="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[DIAS ACTIVIDAD]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="525" y="56" width="35" height="20" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<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="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[VIGENCIA]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="46" y="56" width="30" height="20" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<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="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Vigencia Planilla]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="321" y="56" width="30" height="20" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<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="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Vigencia SMLV]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="271" y="56" width="50" height="20" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<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="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[SALARIO ]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="560" y="56" width="50" height="20" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<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="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[LIQUIDADO]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="610" y="56" width="40" height="20" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<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="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[FECHA APROB]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="650" y="56" width="50" height="20" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<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="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[No RECIBO]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="217" y="56" width="54" height="20" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<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="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[VALOR CANON]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="169" y="56" width="48" height="20" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<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="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[ÁREA LIQ]]></text>
				</staticText>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="14">
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="790" height="5" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
					<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="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[]]></text>
				</staticText>
			</band>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="53" splitType="Stretch">
			<staticText>
				<reportElement x="169" y="0" width="477" height="50"/>
				<textElement textAlignment="Center" verticalAlignment="Bottom" markup="none">
					<font fontName="SansSerif" size="14" isBold="true"/>
				</textElement>
				<text><![CDATA[SISTEMA GENERAL DE CANON SUPERFICIARIO
ESTADO GENERAL POR TITULO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="646" y="18" width="144" height="20" 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 Impresion:]]></text>
			</staticText>
			<textField pattern="dd/MM/yyyy  hh:mm aaa">
				<reportElement x="646" y="38" width="144" height="12"/>
				<box rightPadding="3"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<image>
				<reportElement x="0" y="10" width="121" height="40"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:logo_entidad_2.png"]]></imageExpression>
			</image>
		</band>
	</title>
	<pageHeader>
		<band height="9" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="24" splitType="Stretch">
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="560" y="0" width="50" height="12"/>
				<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="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ESTADO_LIQ}]]></textFieldExpression>
			</textField>
			<textField pattern="###0;-###0" isBlankWhenNull="true">
				<reportElement x="0" y="0" width="46" height="12"/>
				<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="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{ID_LIQ_CANON}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="121" y="0" width="48" height="12"/>
				<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="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NOMBRE_ETAPA}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="760" y="0" width="30" height="12"/>
				<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="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PAGO_TXT}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="610" y="0" width="40" height="12"/>
				<box leftPadding="0">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_APRUEBA}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="650" y="0" width="50" height="12"/>
				<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="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_REC}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="217" y="0" width="54" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<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="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="700" y="0" width="60" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<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="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_PAGO_HIS}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="404" y="0" width="53" height="12"/>
				<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="6"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[( $F{FECHA_INICIO_NOVETA} != null
    ? $F{FECHA_INICIO_NOVETA}
    : $F{FECHA_FIN}
)]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="351" y="0" width="53" height="12"/>
				<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="6"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_INICIO}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="76" y="0" width="45" height="12"/>
				<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="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ANUALIDAD}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.0000 Ha;(-#,##0.0000 Ha)" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="169" y="0" width="48" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<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="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{AREA}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="525" y="0" width="35" height="12"/>
				<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="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{VIGENCIA}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="457" y="0" width="34" height="12" backcolor="#E8E8E8"/>
				<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="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DIAS}]]></textFieldExpression>
			</textField>
			<subreport>
				<reportElement stretchType="RelativeToBandHeight" x="0" y="12" width="790" height="12" isRemoveLineWhenBlank="true"/>
				<subreportParameter name="id_anual_etapa">
					<subreportParameterExpression><![CDATA[$F{ID_ANUAL_ETAPA}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="id_titulo">
					<subreportParameterExpression><![CDATA[$F{ID_TITULO}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="estado_liq">
					<subreportParameterExpression><![CDATA[$F{ESTADO_LIQ}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="dias">
					<subreportParameterExpression><![CDATA[$F{DIAS}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression class="java.lang.String"><![CDATA["repo:novedad_suspencion"]]></subreportExpression>
			</subreport>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="271" y="0" width="50" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<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="Center" 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.math.BigDecimal"><![CDATA[$F{SALARIO_MENSUAL}]]></textFieldExpression>
			</textField>
			<textField pattern="###0;-###0" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="321" y="0" width="30" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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[$F{VIGENCIA_SML}]]></textFieldExpression>
			</textField>
			<textField pattern="###0;-###0" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="46" y="0" width="30" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<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" 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[$F{VIGENCIA_LIQ}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement x="491" y="0" width="34" height="12"/>
				<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="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DIAS}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<pageFooter>
		<band height="44" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="275" y="32" 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="365" y="32" width="70" height="12" forecolor="#575757" backcolor="#FFFFFF"/>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="275" y="20" width="160" height="12" forecolor="#575757"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<text><![CDATA[Websafi - Canon Superficiario]]></text>
			</staticText>
			<textField isBlankWhenNull="false">
				<reportElement mode="Opaque" x="0" y="0" width="790" height="20" isRemoveLineWhenBlank="true" forecolor="#010101"/>
				<textElement verticalAlignment="Top" markup="none">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PROFESIONAL}]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band height="78" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement mode="Opaque" x="545" y="24" width="245" height="12" isRemoveLineWhenBlank="true" forecolor="#010101"/>
				<box rightPadding="0"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" markup="none">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TIPO_NOV}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement mode="Opaque" x="545" y="36" width="245" height="12" isRemoveLineWhenBlank="true" forecolor="#010101"/>
				<box rightPadding="0"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" markup="none">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{USU_NOV}]]></textFieldExpression>
			</textField>
			<subreport>
				<reportElement x="0" y="58" width="790" height="20"/>
				<subreportParameter name="whereTitulo">
					<subreportParameterExpression><![CDATA[$P{whereTitulo}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression class="java.lang.String"><![CDATA["repo:novedad_etapa"]]></subreportExpression>
			</subreport>
		</band>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="790" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
