<?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="novedad_rev_tit_gen_plan" language="groovy" pageWidth="1000" pageHeight="792" whenNoDataType="NoDataSection" columnWidth="960" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.3636363636363666"/>
	<property name="ireport.x" value="493"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/canon/alarma1_canones_proxi_vence"/>
	<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="whereLiquidado" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="id_meses" class="java.lang.String">
		<defaultValueExpression><![CDATA[01]]></defaultValueExpression>
	</parameter>
	<parameter name="id_anhos" class="java.lang.String">
		<defaultValueExpression><![CDATA[2016]]></defaultValueExpression>
	</parameter>
	<parameter name="whereAprobadoRev" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereSinGestion" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereFechaAnu" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="fecha_inicio_anu" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="fecha_fin_anu" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereCompetenciaUsuario" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereCodTitulo" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereEstadoRev" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="fecha_ini" class="java.lang.String"/>
	<parameter name="fecha_fin" class="java.lang.String"/>
	<queryString>
		<![CDATA[SELECT

tab0.id_novedad_rev_tit as id_novedad_rev_tit,
tab0.id_titulo as id_titulo,
tab0.id_anual_etapa as id_anual_etapa, tab0.id_estado_rev as id_estado_rev,
tab0.id_usuario_rev as id_usuario_rev,
tab0.fecha_rev as fecha_rev,
tab0.observaciones as observaciones, tab0.id_liq_canon as id_liq_canon, tab0.vigencia as vigencia,
tab0.id_usuario_liq as id_usuario_liq,
tab0.fecha_liq as fecha_liq,
tab0.descripcion as descripcion, tab0.estado as estado, tab0.aplica_liquidacion as aplica_liquidacion,
tab0.solicitud_en_proceso as solicitud_en_proceso,
tab0.cod_titulo as cod_titulo,
tab0.fecha_inscripcion_rmn as fecha_inscripcion_rmn,
tab0.id_competencia as id_competencia,
tab0.desc_competencia as desc_competencia, tab0.id_modalidad as id_modalidad,
tab0.desc_mod as desc_mod,
tab0.id_norma as id_norma,
tab0.desc_norma as desc_norma,
tab0.area_actual as area_actual,
tab0.fecha_inicio as fecha_inicio,
tab0.fecha_fin as fecha_fin,
tab0.fecha_inicio_anu as fecha_inicio_anu,
tab0.fecha_fin_anu as fecha_fin_anu,
tab0.anualidad as anualidad,
tab0.fecha as fecha, tab0.estado_liq as estado_liq, tab0.anulado as anulado,
tab0.motivo_anu as motivo_anu,
tab0.fecha_anula as fecha_anula,
tab0.id_usuario_anula as id_usuario_anula,
tab0.motivo_cierre as motivo_cierre,
tab0.fecha_cierre as fecha_cierre,
tab0.id_usuario_cierre as id_usuario_cierre

FROM CA_NOVEDAD_REV_TIT_V tab0

WHERE
trunc(tab0.fecha_rev) between to_date($P{fecha_ini}, 'dd/mm/yyyy') and to_date($P{fecha_fin},'dd/mm/yyyy')
$P!{whereEstadoRev}
$P!{whereCodTitulo}
$P!{whereTitulo}
$P!{whereCompetencia}

ORDER BY
trunc(tab0.fecha_rev),
tab0.aplica_liquidacion desc,
tab0.descripcion,
tab0.cod_titulo,
tab0.fecha_inicio,
tab0.anualidad]]>
	</queryString>
	<field name="ID_NOVEDAD_REV_TIT" class="java.math.BigDecimal"/>
	<field name="ID_TITULO" class="java.math.BigDecimal"/>
	<field name="ID_ANUAL_ETAPA" class="java.math.BigDecimal"/>
	<field name="ID_ESTADO_REV" class="java.math.BigDecimal"/>
	<field name="ID_USUARIO_REV" class="java.math.BigDecimal"/>
	<field name="FECHA_REV" class="java.sql.Timestamp"/>
	<field name="OBSERVACIONES" class="java.lang.String"/>
	<field name="ID_LIQ_CANON" class="java.math.BigDecimal"/>
	<field name="VIGENCIA" class="java.math.BigDecimal"/>
	<field name="ID_USUARIO_LIQ" class="java.math.BigDecimal"/>
	<field name="FECHA_LIQ" class="java.sql.Timestamp"/>
	<field name="DESCRIPCION" class="java.lang.String"/>
	<field name="ESTADO" class="java.math.BigDecimal"/>
	<field name="APLICA_LIQUIDACION" class="java.math.BigDecimal"/>
	<field name="SOLICITUD_EN_PROCESO" class="java.math.BigDecimal"/>
	<field name="COD_TITULO" class="java.lang.String"/>
	<field name="FECHA_INSCRIPCION_RMN" class="java.sql.Timestamp"/>
	<field name="ID_COMPETENCIA" class="java.math.BigDecimal"/>
	<field name="DESC_COMPETENCIA" class="java.lang.String"/>
	<field name="ID_MODALIDAD" class="java.math.BigDecimal"/>
	<field name="DESC_MOD" class="java.lang.String"/>
	<field name="ID_NORMA" class="java.math.BigDecimal"/>
	<field name="DESC_NORMA" class="java.lang.String"/>
	<field name="AREA_ACTUAL" class="java.math.BigDecimal"/>
	<field name="FECHA_INICIO" class="java.sql.Timestamp"/>
	<field name="FECHA_FIN" class="java.sql.Timestamp"/>
	<field name="FECHA_INICIO_ANU" class="java.lang.String"/>
	<field name="FECHA_FIN_ANU" class="java.lang.String"/>
	<field name="ANUALIDAD" class="java.math.BigDecimal"/>
	<field name="FECHA" class="java.sql.Timestamp"/>
	<field name="ESTADO_LIQ" class="java.math.BigDecimal"/>
	<field name="ANULADO" class="java.math.BigDecimal"/>
	<field name="MOTIVO_ANU" class="java.lang.String"/>
	<field name="FECHA_ANULA" class="java.sql.Timestamp"/>
	<field name="ID_USUARIO_ANULA" class="java.math.BigDecimal"/>
	<field name="MOTIVO_CIERRE" class="java.lang.String"/>
	<field name="FECHA_CIERRE" class="java.sql.Timestamp"/>
	<field name="ID_USUARIO_CIERRE" class="java.math.BigDecimal"/>
	<variable name="total_items" class="java.math.BigDecimal" calculation="Count">
		<variableExpression><![CDATA[$F{ID_NOVEDAD_REV_TIT}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="53" splitType="Stretch">
			<textField>
				<reportElement x="238" y="0" width="542" height="34"/>
				<textElement textAlignment="Center" verticalAlignment="Bottom" markup="none">
					<font fontName="SansSerif" size="14" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["SISTEMA GENERAL DE CANON SUPERFICIARIO \n INFORME DE PLANILLA CANON DE NOVEDADES DE REVISIÓN"]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="780" y="22" width="180" 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 Impresión:]]></text>
			</staticText>
			<textField pattern="dd/MM/yyyy  hh:mm aaa">
				<reportElement x="780" y="34" width="180" height="12"/>
				<box rightPadding="3"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<image>
				<reportElement x="0" y="6" width="120" height="40"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:logo_entidad_2.png"]]></imageExpression>
			</image>
			<textField>
				<reportElement x="238" y="34" width="542" height="19"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Periodo: "+$P{fecha_ini}+" hasta "+$P{fecha_fin}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="15" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="11" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="407" y="0" width="67" height="11" 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[CÓD. EXPEDIENTE]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="100" y="0" width="138" height="11" 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[ESTADO REVISIÓN]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="624" y="0" width="50" height="11" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[FECHA FIN]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="574" y="0" width="50" height="11" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[FECHA INICIO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="674" y="0" width="46" height="11" 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="474" y="0" width="100" height="11" 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[COMPETENCIA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="238" y="0" width="169" height="11" 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[OBSERVACIÓN]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="100" height="11" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[FECHA REVISIÓN]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="720" y="0" width="60" height="11" 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="780" y="0" width="40" height="11" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[VIGENCIA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="820" y="0" width="70" height="11" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[FECHA CREACION]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="890" y="0" width="70" height="11" 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[ESTADO PLANILLA]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="10" splitType="Stretch">
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="407" y="0" width="67" height="10"/>
				<box leftPadding="2" rightPadding="2">
					<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{COD_TITULO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="100" y="0" width="138" height="10"/>
				<box leftPadding="2" rightPadding="2">
					<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{DESCRIPCION}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="674" y="0" width="46" height="10"/>
				<box leftPadding="2" rightPadding="2">
					<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.Integer"><![CDATA[$F{ANUALIDAD}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="474" y="0" width="100" height="10"/>
				<box leftPadding="2" rightPadding="2">
					<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{DESC_COMPETENCIA}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="624" y="0" width="50" height="10"/>
				<box leftPadding="2" rightPadding="2">
					<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_FIN}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="574" y="0" width="50" height="10"/>
				<box leftPadding="2" rightPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_INICIO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="238" y="0" width="169" height="10"/>
				<box leftPadding="2" rightPadding="2">
					<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{OBSERVACIONES}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy h.mm a" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="100" height="10"/>
				<box leftPadding="2" rightPadding="2">
					<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_REV}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="720" y="0" width="60" height="10"/>
				<box leftPadding="0" rightPadding="2">
					<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.lang.Integer"><![CDATA[$F{ID_LIQ_CANON}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="780" y="0" width="40" height="10"/>
				<box leftPadding="2" rightPadding="2">
					<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.Integer"><![CDATA[$F{VIGENCIA}]]></textFieldExpression>
			</textField>
			<textField pattern="d/M/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="820" y="0" width="70" height="10"/>
				<box leftPadding="2" rightPadding="2">
					<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}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="890" y="0" width="70" height="10"/>
				<box leftPadding="2" rightPadding="2">
					<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{ANULADO}.intValue() == 1
    ? "Anulada"
    : ( $F{ESTADO_LIQ}.intValue() == 1
        ? "Abierta"
        : ( $F{ESTADO_LIQ}.intValue() == 0
            ? "Cerrada"
            : ""
          )
      )
)]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="10" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="24" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="400" y="12" 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="490" y="12" width="60" height="12" forecolor="#575757" backcolor="#FFFFFF"/>
				<box leftPadding="2"/>
				<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="400" 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="16" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="0" y="0" width="960" height="10" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#87CAD2"/>
				<box leftPadding="2" rightPadding="2">
					<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="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["TOTAL: "+$V{total_items}+" Items"]]></textFieldExpression>
			</textField>
		</band>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="960" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
