<?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="titulo_liq" language="groovy" pageWidth="670" pageHeight="612" orientation="Landscape" columnWidth="630" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.6105100000000043"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/canon/titulo_liq"/>
	<property name="ireport.jasperserver.url" value="http://192.168.2.43:8090/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="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["/home/lavila/Reportes Jasper/Reportes Jasper Canon-Notif/Informe liquidacion por titulo/"]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select

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

(select nombre from rmn_modalidad where id_modalidad = tab0.id_modalidad) as nombre_modalidad,
(select nombre from rmn_competencia where id_competencia = tab0.id_competencia) as competencia,
(select nombre from ca_etapa where id_etapa = tab0.id_etapa ) as NOMBRE_ETAPA,
(select descripcion from ca_norma_canon where id_norma = tab0.id_norma ) as ley,
(select valor_mensual from CA_SMDLV where ID_SMDLV = tab0.ID_SMDLV) as SALARIO_MENSUAL,
tab0.*,

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

    t.id_profesional,
    prof.documento as num_doc_profesional,
    prof.nombre as razon_soc_profesional,
    prof.email_usuario as email_profesional,
    t.activo_pin,

    d.vigencia as VIGENCIA, d.id_liq_canon ,d.ID_SMDLV , sml.vigencia as vigencia_sml,
    ta.area/10000 as area_actual , t.cod_titulo as placa, id_competencia, t.id_titulo, d.valor, anc.id_etapa, anc.anualidad , d.area/10000 as area
    , anc.fecha_inicio as INICIA, anc.fecha_fin as vence
    , t.FECHA_INSCRIPCION_RMN as FECHA_RMN, FECHA_CONTRATO as FECHA_INSC, tn.id_norma, d.id_det_liq_canon, tm.id_modalidad
    , to_char(anc.fecha_inicio, 'yyyy') as vigencia_anu, d.aprobado AS aprob_liq
    -- 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
    from
    rmn_titulo t
    join ca_det_liq_canon d on d.id_titulo  = t.id_titulo and d.anulado  = 0
    left join ca_smdlv sml on sml.ID_SMDLV = d.ID_SMDLV
    join ca_anual_consolidado_v anc on anc.id_titulo = t.id_titulo and anc.anualidad = d.anualidad AND anc.id_anual_etapa = d.id_anual_etapa
    join in_titulo_area ta on ta.id_titulo = t.id_titulo and ta.actual = 1
    join in_titulo_competencia tc on tc.id_titulo = t.id_titulo and tc.actual  = 1
    join ca_titulo_norma tn on tn.id_titulo = t.id_titulo and tn.actual  = 1
    join rmn_titulo_modalidad tm on tm.id_titulo = t.id_titulo and tm.actual = 1
    left join ca_titulo_tasa tt on tt.id_titulo = d.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

    ) 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 (

        select

        tab0.id_novedad,
        tab0.id_titulo,
        tab0.id_tipo_novedad,
        tab0.fecha_registro,
        tab0.id_anotacion,
        tab0.id_tipo_anotacion,
        tab0.doc_soporte,
        tab0.fecha_doc_sop,
        tab0.id_tipo_doc,
        tab0.observaciones,
        tab0.aprobada,
        tab0.nombre,
        tab0.descripcion,
        tab0.usa_anotacion,
        tab0.id_usuario,
        tab0.FECHA_INICIO,
        tab0.FECHA_FIN,
        tab0.ANHOS_NOV,
        tab0.APLICA_CONTINUAR,
        tab0.nombre_doc,
        tab0.descripcion_doc,
        tab0.nombre_anot,
        tab0.modifica_anot,
        tab0.fecha_inscripcion,
        tab0.documento_usuario,
        tab0.nombre_usuario,
        tab0.email_usuario

        from ca_novedad_v tab0

        union

        select

        det.id_det_liq_canon as ID_NOVEDAD,
        det.ID_TITULO,
        tipnov.ID_TIPO_NOVEDAD,
        nvl(liq.fecha_cierre,det.fecha_aprueba) as FECHA_REGISTRO,
        null as ID_ANOTACION,
        null as ID_TIPO_ANOTACION,
        null as DOC_SOPORTE,
        null as FECHA_DOC_SOP,
        null as ID_TIPO_DOC,
        liq.motivo_cierre as OBSERVACIONES,
        det.APROBADO AS APROBADA,
        tipnov.NOMBRE,
        null as DESCRIPCION,
        null as USA_ANOTACION,
        liq.id_usuario_cierre as ID_USUARIO,
        null as FECHA_INICIO,
        null as FECHA_FIN,
        null as ANHOS_NOV,
        0 as APLICA_CONTINUAR,
        null as NOMBRE_DOC,
        null as DESCRIPCION_DOC,
        null as NOMBRE_ANOT,
        null as MODIFICA_ANOT,
        null as FECHA_INSCRIPCION,
        nvl(usu.documento,usuapru.documento) as documento_usuario,
        nvl(usu.nombre,usuapru.nombre) as nombre_usuario,
        nvl(usu.email,usuapru.email) AS email_usuario

        from ca_det_liq_canon det

        join ca_liq_canon liq
        on det.id_liq_canon = liq.id_liq_canon
        and det.vigencia = liq.vigencia

        LEFT JOIN CA_TIPO_NOVEDAD tipnov
        ON tipnov.id_tipo_novedad = 14

        LEFT JOIN ca_usuario usu
        ON usu.id_usuario = liq.id_usuario_cierre

        LEFT JOIN ca_usuario usuapru
        ON usuapru.id_usuario = det.id_usuario_aprueba

        where
        (liq.estado = 0 or det.aprobado = 1)

      ) aut
)nov
on nov.id_titulo = tab0.id_titulo
and nov.rn = 1

where 1=1
--FECHA_RMN > (SELECT MIN(C.FECHA_VIGENCIA) FROM CA_NORMA_CANON C WHERE  C.ESTADO = 1)
$P!{whereTitulo}
$P!{whereCompetencia}

ORDER BY
placa ,
vigencia_anu,
id_competencia]]>
	</queryString>
	<field name="NUM_DOC_TITULAR" class="java.lang.String"/>
	<field name="RAZ_SOC_TITULAR" class="java.lang.String"/>
	<field name="NOMBRE_MODALIDAD" class="java.lang.String"/>
	<field name="COMPETENCIA" class="java.lang.String"/>
	<field name="NOMBRE_ETAPA" class="java.lang.String"/>
	<field name="LEY" class="java.lang.String"/>
	<field name="SALARIO_MENSUAL" 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="VIGENCIA" class="java.math.BigDecimal"/>
	<field name="ID_LIQ_CANON" class="java.math.BigDecimal"/>
	<field name="ID_SMDLV" class="java.math.BigDecimal"/>
	<field name="VIGENCIA_SML" class="java.math.BigDecimal"/>
	<field name="AREA_ACTUAL" class="java.math.BigDecimal"/>
	<field name="PLACA" class="java.lang.String"/>
	<field name="ID_COMPETENCIA" class="java.math.BigDecimal"/>
	<field name="ID_TITULO" class="java.math.BigDecimal"/>
	<field name="VALOR" class="java.math.BigDecimal"/>
	<field name="ID_ETAPA" class="java.math.BigDecimal"/>
	<field name="ANUALIDAD" class="java.math.BigDecimal"/>
	<field name="AREA" class="java.math.BigDecimal"/>
	<field name="INICIA" class="java.sql.Timestamp"/>
	<field name="VENCE" class="java.sql.Timestamp"/>
	<field name="FECHA_RMN" class="java.sql.Timestamp"/>
	<field name="FECHA_INSC" class="java.sql.Timestamp"/>
	<field name="ID_NORMA" class="java.math.BigDecimal"/>
	<field name="ID_DET_LIQ_CANON" class="java.math.BigDecimal"/>
	<field name="ID_MODALIDAD" class="java.math.BigDecimal"/>
	<field name="VIGENCIA_ANU" class="java.lang.String"/>
	<field name="APROB_LIQ" 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="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="75">
				<textField pattern="dd/MM/yyyy">
					<reportElement x="92" y="0" width="159" 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{PLACA}]]></textFieldExpression>
				</textField>
				<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
					<reportElement x="320" y="9" width="71" 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>
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="92" 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>
				<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
					<reportElement x="92" y="9" width="159" 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>
				<staticText>
					<reportElement mode="Opaque" x="0" y="9" width="92" 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>
				<staticText>
					<reportElement mode="Opaque" x="251" y="9" width="69" 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="72" y="55" width="96" 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="408" y="55" width="80" 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="0" y="55" width="42" 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 Planilla]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="304" y="55" width="52" height="20" 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[INICIA]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="168" y="55" width="43" 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="391" y="9" width="92" 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>
				<staticText>
					<reportElement mode="Opaque" x="391" y="18" width="92" 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>
				<staticText>
					<reportElement mode="Opaque" x="356" y="55" width="52" height="20" 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[VENCE]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="211" y="55" 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[VIG. ANUALIDAD]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="251" y="55" 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[AREA]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="0" y="18" width="92" 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>
				<textField pattern="" isBlankWhenNull="true">
					<reportElement mode="Transparent" x="92" y="18" width="159" 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>
				<staticText>
					<reportElement mode="Opaque" x="488" y="55" width="64" 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>
				<textField pattern="" isBlankWhenNull="true">
					<reportElement mode="Transparent" x="483" y="9" width="147" 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{NOMBRE_MODALIDAD}]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="true">
					<reportElement mode="Transparent" x="483" y="18" width="147" 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>
				<textField pattern="#,##0.0000 Ha;(#,##0.0000 Ha)" isBlankWhenNull="true">
					<reportElement mode="Transparent" x="320" y="18" width="71" 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="251" y="18" width="69" 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 x="0" y="50" width="630" height="5"/>
					<textElement/>
					<text><![CDATA[]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="582" y="55" width="48" height="20" 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[LIQUIDADA]]></text>
				</staticText>
				<textField>
					<reportElement mode="Opaque" x="0" y="27" width="92" 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>
				<textField isBlankWhenNull="true">
					<reportElement mode="Transparent" x="92" y="27" width="159" 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>
				<staticText>
					<reportElement mode="Opaque" x="251" y="0" width="69" 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="320" y="0" width="310" 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="251" y="27" width="140" 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>
				<textField pattern="" isBlankWhenNull="true">
					<reportElement mode="Transparent" x="391" y="27" width="92" 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>
				<staticText>
					<reportElement mode="Opaque" x="42" y="55" 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="552" y="55" 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>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="13">
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="630" 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="60" splitType="Stretch">
			<image>
				<reportElement x="0" y="10" width="92" height="40"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:logo_entidad_2.png"]]></imageExpression>
			</image>
			<staticText>
				<reportElement mode="Opaque" x="483" y="20" width="147" 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 Impresión por Internet:]]></text>
			</staticText>
			<staticText>
				<reportElement x="92" y="10" width="391" height="50"/>
				<textElement textAlignment="Center" verticalAlignment="Top" markup="none">
					<font fontName="SansSerif" size="13" isBold="true"/>
				</textElement>
				<text><![CDATA[SISTEMA GENERAL DE CANON SUPERFICIARIO
INFORME LIQUIDACIONES POR TÍTULO]]></text>
			</staticText>
			<textField pattern="dd/MM/yyyy h.mm a">
				<reportElement mode="Opaque" x="483" y="40" width="147" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="9" splitType="Stretch"/>
	</pageHeader>
	<detail>
		<band height="10" splitType="Stretch">
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="72" y="0" width="96" height="10" 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{NOMBRE_ETAPA}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="0" y="0" width="42" height="10" 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.math.BigDecimal"><![CDATA[$F{ID_LIQ_CANON}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="408" y="0" width="80" height="10" 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{VALOR}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="304" y="0" width="52" height="10" 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.sql.Timestamp"><![CDATA[$F{INICIA}]]></textFieldExpression>
			</textField>
			<textField pattern="###0;-###0" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="168" y="0" width="43" height="10" 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{ANUALIDAD}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="356" y="0" width="52" height="10" 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.sql.Timestamp"><![CDATA[$F{VENCE}]]></textFieldExpression>
			</textField>
			<textField pattern="###0;-###0" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="211" y="0" width="40" height="10" 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_ANU}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.0000 Ha;(#,##0.0000 Ha)" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="251" y="0" width="53" height="10" 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{AREA}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="488" y="0" width="64" height="10" 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="" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="582" y="0" width="48" height="10" 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{APROB_LIQ}==1?"X":" "]]></textFieldExpression>
			</textField>
			<textField pattern="###0;-###0" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="42" y="0" width="30" height="10" 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}]]></textFieldExpression>
			</textField>
			<textField pattern="###0;-###0" isBlankWhenNull="true">
				<reportElement mode="Transparent" x="552" y="0" width="30" height="10" 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>
		</band>
	</detail>
	<pageFooter>
		<band height="44" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="239" y="32" width="86" 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="326" y="32" width="63" 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="239" y="20" width="150" height="12" forecolor="#575757"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<text><![CDATA[Websafi - Canon Superficiario]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement mode="Opaque" x="1" y="0" width="629" 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="80" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement mode="Opaque" x="408" y="26" width="222" 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="408" y="38" width="222" 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="60" width="629" 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="630" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
