<?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="New Template Cartera H " language="groovy" pageWidth="792" pageHeight="612" orientation="Landscape" columnWidth="752" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="2.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/canon/informe_planilla_de_liquidacion"/>
	<property name="ireport.jasperserver.url" value="http://localhost:18080/jasperserver/services/repository"/>
	<parameter name="id_vigencia" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_liq_canon" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT
(SELECT DESCRIPCION FROM CA_NORMA_CANON WHERE ID_NORMA = TAB.ID_NORMA) AS LEY,
SYSDATE,
(SELECT USERNAME FROM CA_USUARIO WHERE ID_USUARIO = tab.ID_UDUARIO_ANULA) AS NOMBRE_USUARIO_ANULA,
(SELECT USERNAME FROM CA_USUARIO WHERE ID_USUARIO = tab.ID_UDUARIO_CIERRA) AS NOMBRE_USUARIO_CIERRA,
(SELECT NOMBRE FROM RMN_MODALIDAD WHERE ID_MODALIDAD = TAB.ID_MODALIDAD) AS NOMBRE_MODALIDAD,
tab.* from (  SELECT
(SELECT FECHA FROM CA_LIQ_CANON WHERE ID_LIQ_CANON  = DLC.ID_LIQ_CANON AND VIGENCIA = $P{id_vigencia}) AS FECHA_CREACION,
(SELECT ESTADO FROM CA_LIQ_CANON WHERE ID_LIQ_CANON  = DLC.ID_LIQ_CANON AND VIGENCIA = $P{id_vigencia})AS ESTADO,
--Abierta / Cerrada / Anulada
(SELECT (CASE WHEN ANULADO =1 THEN 'ANULADA' WHEN ESTADO = 0 THEN 'CERRADA' ELSE 'ABIERTA' END) FROM CA_LIQ_CANON WHERE ID_LIQ_CANON  = DLC.ID_LIQ_CANON AND VIGENCIA = $P{id_vigencia})AS ESTADOTXT,
(SELECT ESTADO FROM CA_LIQ_CANON WHERE ID_LIQ_CANON  = DLC.ID_LIQ_CANON AND VIGENCIA = $P{id_vigencia}) AS ESLIQCANON,
(SELECT (case when automatico  = 1 then 'AUTOMATICO' else 'POR DEMANDA' end ) FROM CA_LIQ_CANON WHERE ID_LIQ_CANON  = DLC.ID_LIQ_CANON AND VIGENCIA = $P{id_vigencia}) AS TIPO,
(SELECT ID_USUARIO_ANULA FROM CA_LIQ_CANON WHERE ID_LIQ_CANON  = DLC.ID_LIQ_CANON AND VIGENCIA = $P{id_vigencia}) AS ID_UDUARIO_ANULA,
(SELECT MOTIVO_ANU FROM CA_LIQ_CANON WHERE ID_LIQ_CANON  = DLC.ID_LIQ_CANON AND VIGENCIA = $P{id_vigencia}) AS MOTIVO_ANULA,
(SELECT TO_CHAR(FECHA_ANULA, 'DD/MM/YYYY')  FROM CA_LIQ_CANON WHERE ID_LIQ_CANON  = DLC.ID_LIQ_CANON AND VIGENCIA = $P{id_vigencia}) AS FECHA_ANULA,
(SELECT ID_USUARIO_CIERRE  FROM CA_LIQ_CANON WHERE ID_LIQ_CANON  = DLC.ID_LIQ_CANON AND VIGENCIA = $P{id_vigencia}) AS ID_UDUARIO_CIERRA,
(SELECT MOTIVO_CIERRE  FROM CA_LIQ_CANON WHERE ID_LIQ_CANON  = DLC.ID_LIQ_CANON AND VIGENCIA = $P{id_vigencia})  AS MOTIVO_CIERRA,
(SELECT TO_CHAR(FECHA_CIERRE, 'DD/MM/YYYY')  FROM CA_LIQ_CANON WHERE ID_LIQ_CANON  = DLC.ID_LIQ_CANON AND VIGENCIA = $P{id_vigencia}) AS FECHA_CIERRA,
ID_LIQ_CANON,
ID_DET_LIQ_CANON,
(SELECT COD_TITULO FROM RMN_TITULO WHERE ID_TITULO  = DLC.ID_TITULO) AS COD_RMN,
(SELECT FECHA_CONTRATO FROM RMN_TITULO WHERE ID_TITULO  = DLC.ID_TITULO) AS FECHA_CONTRATO,
(SELECT FECHA_INSCRIPCION_RMN FROM RMN_TITULO WHERE ID_TITULO  = DLC.ID_TITULO) AS FECHA_RMN,
(SELECT ID_NORMA FROM CA_TITULO_NORMA WHERE ID_TITULO = DLC.ID_TITULO AND ACTUAL = 1) AS ID_NORMA,
(SELECT ID_MODALIDAD FROM RMN_TITULO_MODALIDAD WHERE ID_TITULO = DLC.ID_TITULO and ACTUAL = 1) AS ID_MODALIDAD,
(SELECT NOMBRE FROM CA_ETAPA WHERE ID_ETAPA = DLC.ID_ETAPA) AS NOMBRE_ETAPA,
 ANUALIDAD ,
(SELECT
(CASE
WHEN sumaAprueba = contador THEN 'SI, TODOS APROBADOS'
WHEN CONTADOR = sumAnula THEN 'SI, TODOS ANULADOS'
ELSE 'NO, AUN EXISTEN ELEMENTOS SIN APROBAR / ANULAR'
END) AS ESTADO
FROM
(
select
count(id_det_liq_canon) as contador ,
SUM(aprobado) as sumaAprueba,
SUM(anulado) as sumAnula
FROM CA_DET_LIQ_CANON
WHERE 1 =1
AND ID_LIQ_CANON = (SELECT ID_LIQ_CANON FROM CA_LIQ_CANON TAB0 WHERE VIGENCIA = $P{id_vigencia}  AND ID_LIQ_CANON  = $P{id_liq_canon})
AND VIGENCIA=$P{id_vigencia}
)) AS ENCABEZADO,
 (AREA/10000) AS AREA,
(SELECT VALOR_MENSUAL FROM CA_SMDLV WHERE ID_SMDLV = DLC.ID_SMDLV) AS SMV,
(SELECT FECHA_INICIO FROM CA_ANUAL_ETAPA WHERE ID_ANUAL_ETAPA = DLC.ID_ANUAL_ETAPA) AS INICIA,
(SELECT FECHA_FIN FROM CA_ANUAL_ETAPA WHERE ID_ANUAL_ETAPA = DLC.ID_ANUAL_ETAPA) AS VENCE,
(CASE WHEN ANULADO = 1 THEN 'ANULADA' WHEN APROBADO = 1 THEN 'APROBADO' ELSE 'SIN APROBAR'  END) AS ESTADO_LIQ_CANON,
(CASE WHEN ANULADO = 1 THEN  1 WHEN APROBADO = 1 THEN 2 ELSE 3  END) AS ESTADO_LIQ_CANON_NUM,
VALOR,
(SELECT ANULADO FROM CA_LIQ_CANON WHERE ID_LIQ_CANON = DLC.ID_LIQ_CANON AND VIGENCIA = DLC.VIGENCIA) AS ANULADO
FROM CA_DET_LIQ_CANON DLC
WHERE 1 =1
AND DLC.ID_LIQ_CANON = (
SELECT ID_LIQ_CANON FROM CA_LIQ_CANON TAB0
WHERE VIGENCIA = $P{id_vigencia}
AND ID_LIQ_CANON  = $P{id_liq_canon}
)
AND VIGENCIA=$P{id_vigencia}
) tab ORDER BY ID_DET_LIQ_CANON]]>
	</queryString>
	<field name="LEY" class="java.lang.String"/>
	<field name="SYSDATE" class="java.sql.Timestamp"/>
	<field name="NOMBRE_USUARIO_ANULA" class="java.lang.String"/>
	<field name="NOMBRE_USUARIO_CIERRA" class="java.lang.String"/>
	<field name="NOMBRE_MODALIDAD" class="java.lang.String"/>
	<field name="FECHA_CREACION" class="java.sql.Timestamp"/>
	<field name="ESTADO" class="java.math.BigDecimal"/>
	<field name="ESTADOTXT" class="java.lang.String"/>
	<field name="ESLIQCANON" class="java.math.BigDecimal"/>
	<field name="TIPO" class="java.lang.String"/>
	<field name="ID_UDUARIO_ANULA" class="java.math.BigDecimal"/>
	<field name="MOTIVO_ANULA" class="java.lang.String"/>
	<field name="FECHA_ANULA" class="java.lang.String"/>
	<field name="ID_UDUARIO_CIERRA" class="java.math.BigDecimal"/>
	<field name="MOTIVO_CIERRA" class="java.lang.String"/>
	<field name="FECHA_CIERRA" class="java.lang.String"/>
	<field name="ID_LIQ_CANON" class="java.math.BigDecimal"/>
	<field name="ID_DET_LIQ_CANON" class="java.math.BigDecimal"/>
	<field name="COD_RMN" class="java.lang.String"/>
	<field name="FECHA_CONTRATO" class="java.sql.Timestamp"/>
	<field name="FECHA_RMN" class="java.sql.Timestamp"/>
	<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="ANUALIDAD" class="java.math.BigDecimal"/>
	<field name="ENCABEZADO" class="java.lang.String"/>
	<field name="AREA" class="java.math.BigDecimal"/>
	<field name="SMV" class="java.math.BigDecimal"/>
	<field name="INICIA" class="java.sql.Timestamp"/>
	<field name="VENCE" class="java.sql.Timestamp"/>
	<field name="ESTADO_LIQ_CANON" class="java.lang.String"/>
	<field name="ESTADO_LIQ_CANON_NUM" class="java.math.BigDecimal"/>
	<field name="VALOR" class="java.math.BigDecimal"/>
	<field name="ANULADO" class="java.math.BigDecimal"/>
	<variable name="num_item" class="java.math.BigDecimal" calculation="Count">
		<variableExpression><![CDATA[$F{ID_DET_LIQ_CANON}]]></variableExpression>
	</variable>
	<variable name="sum_valores" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR}]]></variableExpression>
	</variable>
	<group name="ESTADO">
		<groupExpression><![CDATA[$F{ESTADO}==1]]></groupExpression>
	</group>
	<group name="DET_LIQ_CANON">
		<groupExpression><![CDATA[$F{ID_DET_LIQ_CANON}]]></groupExpression>
	</group>
	<group name="DET_LIQ">
		<groupExpression><![CDATA[$F{ID_DET_LIQ_CANON}]]></groupExpression>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="83" splitType="Stretch">
			<image>
				<reportElement x="14" y="22" width="140" height="40"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:logo_entidad_2.png"]]></imageExpression>
			</image>
			<staticText>
				<reportElement mode="Opaque" x="600" y="10" width="151" height="12" 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 por Internet:]]></text>
			</staticText>
			<textField pattern="dd/MM/yyyy h.mm a">
				<reportElement x="600" y="22" width="150" height="12"/>
				<box rightPadding="3"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{SYSDATE}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="154" y="10" width="446" height="73"/>
				<textElement textAlignment="Center">
					<font size="20" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Sistema General de Canon Superficiario \n"+
"Planilla de Liquidación No. "+$F{ID_LIQ_CANON} +" de "+$P{id_vigencia}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="128" splitType="Stretch">
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="0" y="95" width="114" height="10" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{ESTADO}==0]]></printWhenExpression>
				</reportElement>
				<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{FECHA_CIERRA}.equals( null )? "NO HAY REGISTRO" :$F{FECHA_CIERRA}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="277" y="83" width="351" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#5C999C">
					<printWhenExpression><![CDATA[$F{ESTADO}==0]]></printWhenExpression>
				</reportElement>
				<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[MOTIVO]]></text>
			</staticText>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="277" y="95" width="351" height="10" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{ESTADO}==0]]></printWhenExpression>
				</reportElement>
				<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{MOTIVO_CIERRA}.equals( null ) ? "NO HAY REGISTRO": $F{MOTIVO_CIERRA}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="114" y="83" width="163" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#5C999C">
					<printWhenExpression><![CDATA[$F{ESTADO}==0]]></printWhenExpression>
				</reportElement>
				<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CERRADO POR]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="83" width="114" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#5C999C">
					<printWhenExpression><![CDATA[$F{ESTADO}==0]]></printWhenExpression>
				</reportElement>
				<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[FECHA DE CIERRE]]></text>
			</staticText>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="114" y="95" width="163" height="10" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{ESTADO}==0]]></printWhenExpression>
				</reportElement>
				<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_USUARIO_CIERRA}.equals( null ) ? "NO HAY REGISTRO" : $F{NOMBRE_USUARIO_CIERRA}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="114" y="50" width="163" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#5C999C">
					<printWhenExpression><![CDATA[$F{ANULADO}==1]]></printWhenExpression>
				</reportElement>
				<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[ANULADO POR]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="50" width="114" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#5C999C">
					<printWhenExpression><![CDATA[$F{ANULADO}==1]]></printWhenExpression>
				</reportElement>
				<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[FECHA DE ANULACION]]></text>
			</staticText>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="114" y="62" width="163" height="10" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{ANULADO}==1]]></printWhenExpression>
				</reportElement>
				<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_USUARIO_ANULA}.equals( null ) ? "NO HAY REGISTRO" : $F{NOMBRE_USUARIO_ANULA}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="277" y="50" width="351" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#5C999C">
					<printWhenExpression><![CDATA[$F{ANULADO}==1]]></printWhenExpression>
				</reportElement>
				<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[MOTIVO]]></text>
			</staticText>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="0" y="62" width="114" height="10" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{ANULADO}==1]]></printWhenExpression>
				</reportElement>
				<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{FECHA_ANULA}.equals( null )? "NO HAY REGISTRO " : $F{FECHA_ANULA}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="277" y="62" width="351" height="10" isRemoveLineWhenBlank="true">
					<printWhenExpression><![CDATA[$F{ANULADO}==1]]></printWhenExpression>
				</reportElement>
				<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{MOTIVO_ANULA}.equals( null ) ? "NO HAY REGISTRO": $F{MOTIVO_ANULA}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="391" y="116" width="43" height="12" forecolor="#000000" backcolor="#5C999C"/>
				<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="36" y="116" width="60" height="12" forecolor="#000000" backcolor="#5C999C"/>
				<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[COD.EXPEDIENTE]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="182" y="116" width="60" height="12" forecolor="#000000" backcolor="#5C999C"/>
				<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[NORMA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="139" y="116" width="43" height="12" forecolor="#000000" backcolor="#5C999C"/>
				<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 REGISTRO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="242" y="116" width="89" height="12" forecolor="#000000" backcolor="#5C999C"/>
				<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[MODALIDAD]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="96" y="116" width="43" height="12" forecolor="#000000" backcolor="#5C999C"/>
				<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 CONTRATO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="520" y="116" width="51" height="12" forecolor="#000000" backcolor="#5C999C"/>
				<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="571" y="116" width="60" height="12" forecolor="#000000" backcolor="#5C999C"/>
				<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[SMMLV]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="692" y="116" width="60" height="12" forecolor="#000000" backcolor="#5C999C"/>
				<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[ESTADO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="477" y="116" width="43" height="12" forecolor="#000000" backcolor="#5C999C"/>
				<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="631" y="116" width="61" height="12" forecolor="#000000" backcolor="#5C999C"/>
				<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="331" y="116" width="60" height="12" forecolor="#000000" backcolor="#5C999C"/>
				<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="116" width="36" height="12" forecolor="#000000" backcolor="#5C999C"/>
				<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 DETALLE]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="15" width="139" height="12" forecolor="#000000" backcolor="#5C999C"/>
				<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[FECHA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="27" width="139" height="12" forecolor="#000000" backcolor="#5C999C"/>
				<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[ESTADO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="293" y="27" width="166" height="12" forecolor="#000000" backcolor="#5C999C">
					<printWhenExpression><![CDATA[$F{ENCABEZADO}.equals( "SI, TODOS APROBADOS") || $F{ENCABEZADO}.equals( "SI, TODOS ANULADOS" )]]></printWhenExpression>
				</reportElement>
				<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[PUEDE SER CERRADA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="293" y="15" width="166" height="12" forecolor="#000000" backcolor="#5C999C"/>
				<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[TIPO]]></text>
			</staticText>
			<textField pattern="dd/MM/yyyy">
				<reportElement x="459" y="15" width="169" 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{TIPO}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy">
				<reportElement x="139" y="15" width="154" 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.sql.Timestamp"><![CDATA[$F{FECHA_CREACION}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy">
				<reportElement x="139" y="27" width="154" 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{ESTADOTXT}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy">
				<reportElement x="459" y="27" width="169" height="12">
					<printWhenExpression><![CDATA[$F{ENCABEZADO}.equals( "SI, TODOS APROBADOS") ||
$F{ENCABEZADO}.equals( "SI, TODOS ANULADOS" )]]></printWhenExpression>
				</reportElement>
				<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{ENCABEZADO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="434" y="116" width="43" height="12" forecolor="#000000" backcolor="#5C999C"/>
				<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 x="0" y="108" width="752" height="8"/>
				<textElement/>
				<text><![CDATA[]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="21">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="182" y="0" width="60" height="21"/>
				<box leftPadding="2" rightPadding="0">
					<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{LEY}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="391" y="0" width="43" height="21"/>
				<box leftPadding="2" rightPadding="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.lang.String"><![CDATA[$F{ANUALIDAD}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00 /ha ;(#,##0.00)/ha" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="520" y="0" width="51" height="21"/>
				<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="Right" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{AREA}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="36" height="21"/>
				<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{ID_DET_LIQ_CANON}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="242" y="0" width="89" height="21"/>
				<box leftPadding="2" rightPadding="0">
					<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{NOMBRE_MODALIDAD}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="96" y="0" width="43" height="21"/>
				<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_CONTRATO}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="139" y="0" width="43" height="21"/>
				<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_RMN}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="36" y="0" width="60" height="21"/>
				<box leftPadding="2" rightPadding="0">
					<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="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="477" y="0" width="43" height="21"/>
				<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{VENCE}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="331" y="0" width="60" height="21"/>
				<box leftPadding="2" rightPadding="0">
					<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{NOMBRE_ETAPA}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="571" y="0" width="60" height="21"/>
				<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="Right" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{SMV}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="631" y="0" width="61" height="21"/>
				<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="Right" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="434" y="0" width="43" height="21"/>
				<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{INICIA}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
				<reportElement x="702" y="3" width="8" height="5"/>
				<box topPadding="0" 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 textAlignment="Center" verticalAlignment="Middle">
					<font size="4" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ESTADO_LIQ_CANON_NUM}==1 ? "X": " "]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="710" y="3" width="35" height="5"/>
				<box leftPadding="3"/>
				<textElement>
					<font size="4"/>
				</textElement>
				<text><![CDATA[ANULADO]]></text>
			</staticText>
			<staticText>
				<reportElement x="710" y="13" width="34" height="5"/>
				<box leftPadding="3"/>
				<textElement>
					<font size="4"/>
				</textElement>
				<text><![CDATA[APROBADO]]></text>
			</staticText>
			<textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
				<reportElement x="702" y="13" width="8" height="5"/>
				<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 textAlignment="Center" verticalAlignment="Middle">
					<font size="4" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ESTADO_LIQ_CANON_NUM}==2 ? "X": " "]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="692" y="0" width="60" height="21"/>
				<box leftPadding="2" rightPadding="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="4"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[" "]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="24" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="277" y="10" 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="367" y="10" width="60" 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="277" y="0" width="150" height="12" forecolor="#575757"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<text><![CDATA[Websafi - Canon Superficiario]]></text>
			</staticText>
		</band>
	</pageFooter>
	<summary>
		<band height="40" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="96" y="0" width="475" height="8" forecolor="#000000" backcolor="#5C999C"/>
				<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="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[TOTALES]]></text>
			</staticText>
			<textField>
				<reportElement x="0" y="0" width="96" height="8"/>
				<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="Left" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Total Items: "+$V{num_item}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
				<reportElement x="571" y="0" width="121" height="8"/>
				<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 textAlignment="Right" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{sum_valores}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="752" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
