<?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.3579476910000103"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="110"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/canon/repo_excel_por_pago"/>
	<property name="ireport.jasperserver.url" value="http://soporte6.sofhouse.net: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>
	<queryString>
		<![CDATA[SELECT tab0.*
,(SELECT NOMBRE FROM RMN_COMPETENCIA WHERE ID_COMPETENCIA = tab0.ID_COMPETENCIA ) AS COMPETENCIA,
(SELECT DESCRIPCION FROM CA_NORMA_CANON WHERE ID_NORMA = TAB0.ID_NORMA) AS LEY,
(SELECT NOMBRE FROM RMN_MODALIDAD WHERE ID_MODALIDAD = TAB0.ID_MODALIDAD) AS NOMBRE_MODALIDAD
FROM
(SELECT
(SELECT ID_NORMA FROM CA_TITULO_NORMA WHERE ID_TITULO = tab1.ID_TITULO AND ACTUAL = 1) AS ID_NORMA,
(SELECT ID_MODALIDAD FROM RMN_TITULO_MODALIDAD WHERE ID_TITULO = tab1.ID_TITULO  AND ACTUAL = 1 AND ROWNUM = 1) AS ID_MODALIDAD,
(SELECT ABREVIACION FROM CA_ETAPA WHERE tab1.ID_ETAPA = ID_ETAPA) AS NOMBRE_ETAPA,
(SELECT VALOR_MENSUAL FROM CA_SMDLV WHERE ID_SMDLV = tab1.ID_SMDLV) AS SALARIO_MENSUAL,
(SELECT LI.ID_COMPETENCIA  FROM IN_TITULO_COMPETENCIA LI WHERE ACTUAL = 1 AND LI.ID_TITULO = tab1.ID_TITULO ) AS ID_COMPETENCIA,
tab1.ID_DET_LIQ_CANON,
tab1.VIGENCIA AS VIGECIA_DET,
tab1.ID_LIQ_CANON,
CASE WHEN tab1.VALOR = -1 THEN 0 ELSE tab1.VALOR END  AS VALOR,
tab1.ANUALIDAD,
tab3.ID_PAGO_HISTORICO,
tab3.ID_RECIBO,
tab3.VIGENCIA AS VIGENCIA_RECIBO_HIST,
tab3.VALOR_REQUERIDO,
tab3.FECHA_REQUERIDO,
tab3.VALOR_PAGO,
(SELECT
CASE WHEN
DESCRIPCION  = 'N.A' THEN ' ' ELSE DESCRIPCION END
FROM CA_FECHA_PAGO_HIST WHERE tab3.ID_PAGO_HISTORICO = ID_PAGO_HISTORICO) AS FECHA_PAGO,
tab3.FECHA_ANUALIDAD,
tab2.VIGENCIA AS VIGENCIA_RECIBO,
tab2.VIG_LIQ,
tab2.NUM_RECIBO,
tab2.FECHA_EXPED_REC,
tab2.FECHA_VENCE_REC,
tab2.FECHA_PAGO_OPORTUNO,
(tab3.AREA_LIQUIDADA/10000) as area,
(tab1.AREA/10000) as AREA_LIQUIDADA,
tab1.VIGENCIA,
tab1.ID_ANUAL_ETAPA,
tab1.ANULADO,
tab2.PAGO,
tab4.COD_TITULO AS PLACA,
(SELECT FECHA_INICIO FROM CA_ANUAL_ETAPA WHERE ID_ANUAL_ETAPA = tab1.ID_ANUAL_ETAPA) AS INICIA,
(SELECT FECHA_FIN FROM CA_ANUAL_ETAPA WHERE ID_ANUAL_ETAPA = tab1.ID_ANUAL_ETAPA) AS VENCE,
tab4.FECHA_INSCRIPCION_RMN AS FECHA_RMN,
tab4.FECHA_CONTRATO AS FECHA_INSC,
tab1.ID_TITULO
FROM CA_DET_LIQ_CANON tab1
LEFT JOIN ca_recibo tab2 ON
tab2.ID_DET_LIQ_CANON = tab1.ID_DET_LIQ_CANON
AND tab1.ANULADO = 0
AND tab2.VIG_LIQ = tab1.VIGENCIA
LEFT JOIN ca_pago_historico tab3 ON
tab3.ID_RECIBO = tab2.ID_RECIBO
AND tab3.VIGENCIA = tab2.VIGENCIA
JOIN RMN_TITULO tab4
ON tab4.ID_TITULO = tab1.ID_TITULO
WHERE 1 = 1
AND tab1.ANULADO = 0
)tab0
WHERE 1 = 1
AND FECHA_RMN >  (SELECT MIN(C.FECHA_VIGENCIA) FROM CA_NORMA_CANON C WHERE  C.ESTADO = 1)
AND ANULADO = 0
$P!{whereCompetencia}$P!{whereTitulo}
order by id_titulo , vigencia]]>
	</queryString>
	<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="SALARIO_MENSUAL" class="java.math.BigDecimal"/>
	<field name="ID_COMPETENCIA" class="java.math.BigDecimal"/>
	<field name="ID_DET_LIQ_CANON" class="java.math.BigDecimal"/>
	<field name="VIGECIA_DET" class="java.math.BigDecimal"/>
	<field name="ID_LIQ_CANON" class="java.math.BigDecimal"/>
	<field name="VALOR" class="java.math.BigDecimal"/>
	<field name="ANUALIDAD" class="java.math.BigDecimal"/>
	<field name="ID_PAGO_HISTORICO" class="java.math.BigDecimal"/>
	<field name="ID_RECIBO" class="java.math.BigDecimal"/>
	<field name="VIGENCIA_RECIBO_HIST" class="java.math.BigDecimal"/>
	<field name="VALOR_REQUERIDO" class="java.math.BigDecimal"/>
	<field name="FECHA_REQUERIDO" class="java.sql.Timestamp"/>
	<field name="VALOR_PAGO" class="java.math.BigDecimal"/>
	<field name="FECHA_PAGO" class="java.lang.String"/>
	<field name="FECHA_ANUALIDAD" class="java.sql.Timestamp"/>
	<field name="VIGENCIA_RECIBO" class="java.math.BigDecimal"/>
	<field name="VIG_LIQ" class="java.math.BigDecimal"/>
	<field name="NUM_RECIBO" class="java.math.BigDecimal"/>
	<field name="FECHA_EXPED_REC" class="java.sql.Timestamp"/>
	<field name="FECHA_VENCE_REC" class="java.sql.Timestamp"/>
	<field name="FECHA_PAGO_OPORTUNO" class="java.sql.Timestamp"/>
	<field name="AREA_LIQUIDADA" class="java.math.BigDecimal"/>
	<field name="VIGENCIA" class="java.math.BigDecimal"/>
	<field name="ID_ANUAL_ETAPA" class="java.math.BigDecimal"/>
	<field name="ANULADO" class="java.math.BigDecimal"/>
	<field name="PAGO" class="java.math.BigDecimal"/>
	<field name="PLACA" class="java.lang.String"/>
	<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_TITULO" class="java.math.BigDecimal"/>
	<field name="COMPETENCIA" class="java.lang.String"/>
	<field name="LEY" class="java.lang.String"/>
	<field name="NOMBRE_MODALIDAD" class="java.lang.String"/>
	<variable name="SUM_REQUERIDO" class="java.math.BigDecimal" resetType="Group" resetGroup="TITULO" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_REQUERIDO}]]></variableExpression>
	</variable>
	<variable name="SUM_CANON" class="java.math.BigDecimal" resetType="Group" resetGroup="TITULO" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR}]]></variableExpression>
	</variable>
	<variable name="SUM_PAGO" class="java.math.BigDecimal" resetType="Group" resetGroup="TITULO" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR_PAGO}]]></variableExpression>
	</variable>
	<variable name="totales" class="java.math.BigDecimal" resetType="Group" resetGroup="TITULO">
		<variableExpression><![CDATA[$V{SUM_PAGO}-$V{SUM_CANON}]]></variableExpression>
	</variable>
	<group name="TITULO">
		<groupExpression><![CDATA[$F{ID_TITULO}]]></groupExpression>
		<groupHeader>
			<band height="35">
				<staticText>
					<reportElement mode="Opaque" x="241" y="11" width="126" height="12" 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="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[FECHA RMN]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="482" y="11" width="129" height="12" 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="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[FECHA CONTRATO]]></text>
				</staticText>
				<textField pattern="dd/MM/yyyy">
					<reportElement x="131" y="11" width="110" 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{PLACA}]]></textFieldExpression>
				</textField>
				<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
					<reportElement x="367" y="11" width="115" 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_RMN}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="0" y="11" width="131" height="12" 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="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[PLACA TITULO]]></text>
				</staticText>
				<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
					<reportElement x="611" y="11" width="140" 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_INSC}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="367" y="23" width="46" height="12" 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="5" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[FECHA ANUALIDAD]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="413" y="23" width="35" height="12" 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="5" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[FECHA PAGO]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="662" y="23" width="43" height="12" 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="5" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[VALOR PAGO]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="281" y="23" width="41" height="12" 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="5" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[FECHA VENCIMIENTO]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="322" y="23" width="45" height="12" 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="5" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[FECHA PAGO OPORTUNO]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="241" y="23" width="40" height="12" 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="5" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[FECHA EXPEDICION]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="705" y="23" width="46" height="12" 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="5" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[PAGO]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="88" y="23" width="123" height="12" 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="5" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[MODALIDAD]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="0" y="23" width="48" height="12" 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="5" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[ETAPA]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="48" y="23" width="40" height="12" 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="5" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[NORMA]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="611" y="23" width="51" height="12" 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="5" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[VALOR CANON]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="537" y="23" width="33" height="12" 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="5" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[AREA]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="482" y="23" width="31" height="12" 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="5" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[VIGENCIA]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="513" y="23" width="24" height="12" 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="5" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[ANUALIDAD]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="570" y="23" width="41" height="12" 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="5" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[VALOR REQUERIDO]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="448" y="23" width="34" height="12" 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="5" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[FECHA REQUERIDO]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="211" y="23" width="30" height="12" 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="5" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[NUM RECIBO]]></text>
				</staticText>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="21">
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="611" height="10" 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="5" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[TOTAL]]></text>
				</staticText>
				<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
					<reportElement positionType="FixRelativeToBottom" x="611" y="0" width="51" height="10"/>
					<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="5"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{SUM_CANON}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0;(#,##0)" isBlankWhenNull="true">
					<reportElement positionType="FixRelativeToBottom" x="662" y="0" width="43" height="10"/>
					<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="5"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{SUM_PAGO}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0;(#,##0)" isBlankWhenNull="true">
					<reportElement positionType="FixRelativeToBottom" x="705" y="0" width="46" height="10"/>
					<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="5"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{totales}]]></textFieldExpression>
				</textField>
			</band>
		</groupFooter>
	</group>
	<group name="DET">
		<groupExpression><![CDATA[$F{ID_DET_LIQ_CANON}]]></groupExpression>
		<groupHeader>
			<band/>
		</groupHeader>
		<groupFooter>
			<band/>
		</groupFooter>
	</group>
	<group name="RECIBO">
		<groupExpression><![CDATA[$F{ID_RECIBO}]]></groupExpression>
		<groupHeader>
			<band/>
		</groupHeader>
		<groupFooter>
			<band/>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="60" splitType="Stretch">
			<image>
				<reportElement x="0" y="10" width="131" height="40"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:logo_entidad_2.png"]]></imageExpression>
			</image>
			<staticText>
				<reportElement mode="Opaque" x="611" y="10" width="140" 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>
			<staticText>
				<reportElement x="131" y="10" width="480" height="40"/>
				<textElement textAlignment="Center" verticalAlignment="Bottom" markup="none">
					<font fontName="SansSerif" size="16" isBold="true"/>
				</textElement>
				<text><![CDATA[SISTEMA GENERAL DE CANON SUPERFICIARIO
HISTORIAL DE PAGO POR TITULO]]></text>
			</staticText>
			<textField pattern="dd/MM/yyyy h.mm a">
				<reportElement mode="Opaque" x="611" y="22" width="140" 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="8" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="15" splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="10" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement x="0" y="0" width="48" height="10"/>
				<box leftPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="5"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NOMBRE_ETAPA}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="48" y="0" width="40" height="10"/>
				<box leftPadding="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="5"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{LEY}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="88" y="0" width="123" height="10"/>
				<box leftPadding="2">
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="5"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NOMBRE_MODALIDAD}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="241" y="0" width="40" height="10"/>
				<box leftPadding="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="5"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_EXPED_REC}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="281" y="0" width="41" height="10"/>
				<box leftPadding="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="5"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_VENCE_REC}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="322" y="0" width="45" height="10"/>
				<box leftPadding="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="5"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_PAGO_OPORTUNO}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="367" y="0" width="46" height="10"/>
				<box leftPadding="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="5"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_ANUALIDAD}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="413" y="0" width="35" height="10"/>
				<box leftPadding="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="5"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{FECHA_PAGO}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement x="448" y="0" width="34" height="10"/>
				<box leftPadding="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="5"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{FECHA_REQUERIDO}]]></textFieldExpression>
			</textField>
			<textField pattern="###0" isBlankWhenNull="true">
				<reportElement x="482" y="0" width="31" height="10"/>
				<box leftPadding="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="5"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VIGENCIA_RECIBO}]]></textFieldExpression>
			</textField>
			<textField pattern="###0" isBlankWhenNull="true">
				<reportElement x="513" y="0" width="24" height="10"/>
				<box leftPadding="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="5"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{ANUALIDAD}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.0000;(-#,##0.0000)" isBlankWhenNull="true">
				<reportElement x="537" y="0" width="33" height="10"/>
				<box leftPadding="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="5"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{AREA_LIQUIDADA}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement x="570" y="0" width="41" height="10"/>
				<box leftPadding="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="5"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_REQUERIDO}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement x="611" y="0" width="51" height="10"/>
				<box leftPadding="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="5"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR} == -1 ? 0 : $F{VALOR}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement x="662" y="0" width="43" height="10"/>
				<box leftPadding="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="5"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR_PAGO} == -1 ? 0 : $F{VALOR_PAGO}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement x="705" y="0" width="46" height="10"/>
				<box leftPadding="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="5"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PAGO}==1 ? "X" : " "]]></textFieldExpression>
			</textField>
			<textField pattern="###0" isBlankWhenNull="true">
				<reportElement x="211" y="0" width="30" height="10"/>
				<box leftPadding="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="5"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{NUM_RECIBO}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="24" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="299" 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="389" y="12" 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="299" 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="25" splitType="Stretch"/>
	</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>
