<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="inf_car_clasif_concil1" language="groovy" pageWidth="752" pageHeight="572" orientation="Landscape" columnWidth="752" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
	<property name="ireport.zoom" value="1.3310000000000095"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="NomPuntoVenta" class="java.lang.String"/>
	<parameter name="nom_periodo" class="java.lang.String"/>
	<parameter name="wherePuntoVenta" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="NomPuntoVentaFiltro" class="java.lang.String"/>
	<parameter name="fecha_fin" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="fecha_ini" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTipoNovedad" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTercero" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereConceptoCredito" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select tabla.* ,rownum from(

    select

    tab0.*

    from (

        SELECT
        nvl(sum (tab0.cuarto), 0) as tipo4,
        nvl(sum (tab0.cuarto_ia), 0) as tipo4_ia,
        nvl(sum (tab0.cuarto_cg), 0) as tipo4_cg,
        nvl(sum (tab0.cuarto_gen), 0) as tipo4_gen,
        nvl(sum (tab0.quinto), 0) as tipo5 ,
        nvl(sum (tab0.septimo), 0) as tipo7 ,
        razon_soc as nombre,
        tab0.num_doc as nitcc,
        tab0.id_mae_ter as tercero ,
         (sum (tab0.cuarto) + sum (tab0.quinto) + sum (tab0.septimo)) as saldo_actual
        FROM(

            select tab0.* from (

                Select

                tab0.valor_abono as vl,

                nvl(( case when gi.id_pr_tipo_ingre = 4 and Tab6.aplica_intereses = 1 then tab0.valor_abono else 0 end  ) ,  0) as cuarto_ia,
                nvl(( case when gi.id_pr_tipo_ingre = 4 and nvl(tab13.tag_cg,0) > 0 then tab0.valor_abono else 0 end  ) ,  0) as cuarto_cg,
                nvl(( case when gi.id_pr_tipo_ingre = 4 and Tab6.aplica_intereses = 0 and nvl(tab13.tag_cg,0) = 0 then tab0.valor_abono else 0 end  ) ,  0) as cuarto_gen,
                nvl(( case when gi.id_pr_tipo_ingre = 4 then tab0.valor_abono else 0 end  ) ,  0) as cuarto,

                nvl(( case when gi.id_pr_tipo_ingre = 5 then tab0.valor_abono else 0 end  ) ,  0) as quinto,
                nvl(( case when gi.id_pr_tipo_ingre = 7 then tab0.valor_abono else 0 end  ) ,  0) as septimo,
                gi.id_pr_tipo_ingre,

                2 as Orden,
                Tab0.*,
                Tab1.id_mae_ter,
                Tab1.Sec_Debito,
                Tab1.Id_Tipo_Debito,
                Tab1.fecha_proceso as fecha_debito,
                substr(Tab2.Desc_Corta,0,2) As Desc_Corta_Tipdeb,
                Tab2.Descripcion As Descripcion_Tipdeb,
                Ter.Num_Doc As Nitocc,
                Ter.Razon_Soc,
                Ter.Num_Doc || ' - ' || Ter.Razon_Soc AS tercero,
                tab4.direccion,
                Tab4.Tel,
                Tab4.Ciudad,
                tab5.nombre||' '||tab5.apellido AS USUARIO_NAME
                ,Tab6.codigo AS COD_PRO
                ,Tab6.descripcion AS DES_PRO
                ,NVL(Tab7.valor,0) AS EXCEDENTE
                ,Tab9.descripcion as CLASE
                ,Tab10.id_referencia2 AS TITULO,
                case when tab0.id_credito_detalle = (select min(cred.id_credito_detalle) from ca_credito_detalle cred where cred.id_credito = tab0.id_credito) then nvl(Tab7.valor,0) else 0 end AS EXCEDENTE2,

                tab13.id_tipo_novedad,
                tab13.DESCRIPCION as DESCRIPCION_tipnov,
                tab13.DESC_CORTA as DESC_CORTA_tipnov,

                td.DOCUMENTO as DOCUMENTO_td,
                td.DESCRIPCION as DESCRIPCION_td,
                td.DESCCORTA as DESCCORTA_td,

                case when tab0.nombre is null then tab0.Usuariolog else tab0.nombre || ' ' || tab0.apellido end as usuario

                From Ca_Credito_Vencimientos tab0

                Join ts_td td
                On td.id = Tab0.id_ts_td

                Join Ca_Debito Tab1
                On Tab1.Id_Debito = Tab0.Id_Debito

                Join Ca_Tipo_Debito Tab2
                on Tab2.Id_Tipo_Debito = Tab1.Id_Tipo_Debito

                Join Interceros_v Ter
                on Ter.Id_Mae_Ter = Tab1.Id_Mae_Ter

                --LEFT JOIN INTERCER_DU tab3 ON tab3.id_mae_ter = Tab1.id_mae_ter
                --LEFT JOIN INTERCER_DU_DIR tab4 ON tab4.ID_MT_UBI = tab3.ID_MT_UBI
                LEFT JOIN interceros_du_dir_v tab4 ON tab4.Id_Mae_Ter = Tab1.Id_Mae_Ter

                LEFT JOIN USUARIO tab5 ON tab5.username = Tab0.Usuariolog

                --Join Ca_Debito_Detalle Tab5 ON Tab5.id_debito = Tab1.id_debito
                --20170203 se comenta el join superior y se agrega un  JOIN con una query de la
                -- tabla agrupando los debitos y los productos
                --para evitar registros duplicados cuando hay un debito con varios productos iguales
                Join (select id_debito,id_producto from ca_debito_detalle group by id_debito,id_producto) Tab5 ON Tab5.id_debito = Tab1.id_debito

                Join Ca_Producto Tab6 ON Tab6.id_producto = Tab5.id_producto

                Join ts_gi gi ON Tab6.ID_GRUPO = gi.id

                left join(
                select id_credito,sum(nvl(valor,0)) AS VALOR
                FROM ca_excedentes
                group by id_credito
                )Tab7 ON Tab7.id_credito = tab0.id_credito

                Left Join Ts_Gi Tab8 ON Tab8.id = Tab6.id_grupo
                Left Join Pr_Tipo_Ingre Tab9 ON Tab9.id = Tab8.id_pr_tipo_ingre
                Left Join ca_debito_ref Tab10 ON Tab10.id_debito = Tab1.id_debito



                left join (
                  select
                   tab0.id_debito,
                   tab0.id_vencimiento,
                   to_char(wm_concat(distinct tab0.id_tipo_novedad)) as id_tipo_novedad,
                   to_char(wm_concat(distinct tip.descripcion)) as descripcion,
                   to_char(wm_concat(distinct tip.desc_corta)) as desc_corta,
                  sum(case when tip.desc_corta = 'CG' then 1 else 0 end) as tag_cg
                   from ca_novedad_cartera tab0
                   left join ca_tipo_novedad tip
                   on tip.id_tipo_novedad = tab0.id_tipo_novedad
                   where
                   tab0.anulado = 0
                   $P!{whereTipoNovedad}
                   group by
                   tab0.id_debito,
                   tab0.id_vencimiento
                )tab13
                on tab13.id_debito = tab1.id_debito
                and tab13.id_vencimiento = tab0.id_vencimiento

                Where

                Tab0.Fecha_Proceso_cre BETWEEN to_date($P{fecha_ini}, 'dd/mm/yyyy') AND to_date($P{fecha_fin}, 'dd/mm/yyyy')
                and (case when Tab0.fecha_anu_cre<=last_day(to_date($P{fecha_fin}, 'dd/mm/yyyy')) then 0 else 1 END  = 1)

                $P!{whereConceptoCredito}

            )tab0

            where  1 = 1
            $P!{whereTercero}
            $P!{whereTipoNovedad}
            $P!{wherePuntoVenta}

        )tab0
        where 1 = 1

        group by
        tab0.razon_soc, tab0.num_doc ,tab0.id_mae_ter

    )tab0
    where
    1 = 1

    order by to_number(nitcc)

)tabla]]>
	</queryString>
	<field name="TIPO4" class="java.math.BigDecimal"/>
	<field name="TIPO4_IA" class="java.math.BigDecimal"/>
	<field name="TIPO4_CG" class="java.math.BigDecimal"/>
	<field name="TIPO4_GEN" class="java.math.BigDecimal"/>
	<field name="TIPO5" class="java.math.BigDecimal"/>
	<field name="TIPO7" class="java.math.BigDecimal"/>
	<field name="NOMBRE" class="java.lang.String"/>
	<field name="NITCC" class="java.math.BigDecimal"/>
	<field name="TERCERO" class="java.math.BigDecimal"/>
	<field name="SALDO_ACTUAL" class="java.math.BigDecimal"/>
	<field name="ROWNUM" class="java.math.BigDecimal"/>
	<variable name="Suma_T4" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{TIPO4}]]></variableExpression>
	</variable>
	<variable name="Suma_Totales" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{SALDO_ACTUAL}]]></variableExpression>
	</variable>
	<variable name="Suma_T5" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{TIPO5}]]></variableExpression>
	</variable>
	<variable name="Suma_T7" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{TIPO7}]]></variableExpression>
	</variable>
	<variable name="variable1" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{ROWNUM}]]></variableExpression>
		<initialValueExpression><![CDATA[0]]></initialValueExpression>
	</variable>
	<variable name="Suma_T4_ia" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{TIPO4_IA}]]></variableExpression>
	</variable>
	<variable name="Suma_T4_cg" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{TIPO4_CG}]]></variableExpression>
	</variable>
	<variable name="Suma_T4_gen" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{TIPO4_GEN}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<columnHeader>
		<band height="32" splitType="Prevent">
			<staticText>
				<reportElement mode="Opaque" x="572" y="12" width="90" height="20" forecolor="#000000" backcolor="#88C2F9">
					<printWhenExpression><![CDATA[$V{variable1} == 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[Recursos para Distribuir]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="482" y="12" width="90" height="20" forecolor="#000000" backcolor="#88C2F9">
					<printWhenExpression><![CDATA[$V{variable1} == 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[Cartera General]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="80" y="12" width="312" height="20" forecolor="#000000" backcolor="#88C2F9">
					<printWhenExpression><![CDATA[$V{variable1} == 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[Razón Social/Titular]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="662" y="12" width="90" height="20" forecolor="#000000" backcolor="#88C2F9">
					<printWhenExpression><![CDATA[$V{variable1} == 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[Total]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="12" width="80" height="20" forecolor="#000000" backcolor="#88C2F9">
					<printWhenExpression><![CDATA[$V{variable1} == 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[Nit/CC]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="392" y="12" width="90" height="20" forecolor="#000000" backcolor="#88C2F9">
					<printWhenExpression><![CDATA[$V{variable1} == 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[Cartera Castigada]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="10" splitType="Stretch">
			<textField pattern="#,##0.00;(#,##0.00)">
				<reportElement x="662" y="0" width="90" 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="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{SALDO_ACTUAL}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="0" width="80" 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="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NITCC}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="80" y="0" width="312" 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 verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NOMBRE}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)">
				<reportElement x="482" y="0" width="90" 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="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{TIPO4_GEN}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)">
				<reportElement x="572" y="0" width="90" 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="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{TIPO7}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)">
				<reportElement x="392" y="0" width="90" 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="6"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{TIPO4_IA}+$F{TIPO4_CG}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<summary>
		<band height="24">
			<textField pattern="#,##0.00;(#,##0.00)">
				<reportElement mode="Opaque" x="482" y="0" width="90" height="12" backcolor="#BDC0C3"/>
				<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" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{Suma_T4_gen}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)">
				<reportElement mode="Opaque" x="662" y="0" width="90" height="12" backcolor="#BDC0C3"/>
				<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" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{Suma_Totales}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)">
				<reportElement mode="Opaque" x="572" y="0" width="90" height="12" backcolor="#BDC0C3"/>
				<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" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{Suma_T7}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Opaque" x="0" y="0" width="392" height="12" forecolor="#000000" backcolor="#BDC0C3"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[" Total " + $F{ROWNUM}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)">
				<reportElement mode="Opaque" x="392" y="0" width="90" height="12" backcolor="#BDC0C3"/>
				<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" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{Suma_T4_ia}+$V{Suma_T4_cg}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="0" y="12" width="752" height="12" forecolor="#000000" backcolor="#88C2F9"/>
				<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[]]></text>
			</staticText>
		</band>
	</summary>
</jasperReport>
