<?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="Consultar_documentos_doc" language="groovy" pageWidth="1060" pageHeight="572" orientation="Landscape" columnWidth="1060" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
	<property name="ireport.zoom" value="1.948717100000002"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="nom_corto" class="java.lang.String"/>
	<parameter name="id_cad" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_cia" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_cen_op" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_vigencia" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["/home/lavila/reports-dev/Consultar Documentos/"]]></defaultValueExpression>
	</parameter>
	<parameter name="haveDoc" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT
tab0.id_documento as id_documento,
tab0.id_cad as id_cad,
tab0.id_vigencia as id_vigencia,
tab0.id_cen_op as id_cen_op,
tab0.id_cia as id_cia,
tab0.id_td as id_td, tab0.id_mae_ter as id_mae_ter,
tab0.descr_mto as descr_mto,
tab0.doc_soporte as doc_soporte,
to_char(tab0.fecha_soporte, 'YYYY-MM-DD') as fecha_soporte,
tab0.tot_debito as tot_debito,
tab0.tot_credito as tot_credito,
tab1.nombre as nom_td,
to_char(tab2.fecha_cad, 'YYYY-MM-DD') as fecha_cad,
tab3.nitocc as nitocc, tab3.nombre as tercero,
--campos log_documento
logdoc.nitocc as nitocc_log,
logdoc.nombre as nombre_log,
logdoc.nitocc || ' - ' || logdoc.nombre as completo_log,
logdoc.id_ope_bd

FROM CN_DOCUMENTO_TOT tab0  JOIN CN_TD tab1
ON tab0.id_td = tab1.id_td

JOIN CN_CONTROL_CAD tab2 ON tab0.id_cia = tab2.id_cia
AND tab0.id_cad = tab2.id_cad
AND tab0.id_cen_op = tab2.id_cen_op
AND tab0.id_vigencia = tab2.id_vigencia

LEFT JOIN CN_MAE_TER tab3 ON
tab0.id_mae_ter = tab3.id_mae_ter



left join (
  SELECT
   aut.*,
   ROW_NUMBER() OVER (
    partition by aut.id_tabla, aut.id_vigencia, aut.id_mae_bd, aut.id_ope_bd
    ORDER BY aut.id_tabla DESC, aut.id_vigencia desc, aut.id_mae_bd desc, aut.id_ope_bd DESC
   ) AS rn
  from cn_log_documento aut
)logdoc
on logdoc.id_tabla = tab0.id_documento
and logdoc.id_cad = tab0.id_cad
and logdoc.id_vigencia = tab0.id_vigencia
and logdoc.id_cen_op = tab0.id_cen_op
and logdoc.id_cia = tab0.id_cia
and logdoc.id_ope_bd = 2
and logdoc.rn = 1


/* se cambia para que solo sea, para un registro del log - 20151021
left join  cn_log_documento logdoc
on logdoc.id_tabla = tab0.id_documento
and logdoc.id_cad = tab0.id_cad
and logdoc.id_vigencia = tab0.id_vigencia
and logdoc.id_cen_op = tab0.id_cen_op
and logdoc.id_cia = tab0.id_cia
and logdoc.id_ope_bd = 2
*/


WHERE
tab0.id_cia = $P{id_cia}
AND tab0.id_cad = $P{id_cad}
AND tab0.id_cen_op = $P{id_cen_op}
AND tab0.id_vigencia = $P{id_vigencia}
$P!{haveDoc}]]>
	</queryString>
	<field name="ID_DOCUMENTO" class="java.math.BigDecimal"/>
	<field name="ID_CAD" class="java.math.BigDecimal"/>
	<field name="ID_VIGENCIA" class="java.math.BigDecimal"/>
	<field name="ID_CEN_OP" class="java.math.BigDecimal"/>
	<field name="ID_CIA" class="java.math.BigDecimal"/>
	<field name="ID_TD" class="java.math.BigDecimal"/>
	<field name="ID_MAE_TER" class="java.math.BigDecimal"/>
	<field name="DESCR_MTO" class="java.lang.String"/>
	<field name="DOC_SOPORTE" class="java.lang.String"/>
	<field name="FECHA_SOPORTE" class="java.lang.String"/>
	<field name="TOT_DEBITO" class="java.math.BigDecimal"/>
	<field name="TOT_CREDITO" class="java.math.BigDecimal"/>
	<field name="NOM_TD" class="java.lang.String"/>
	<field name="FECHA_CAD" class="java.lang.String"/>
	<field name="NITOCC" class="java.lang.String"/>
	<field name="TERCERO" class="java.lang.String"/>
	<field name="NITOCC_LOG" class="java.lang.String"/>
	<field name="NOMBRE_LOG" class="java.lang.String"/>
	<field name="COMPLETO_LOG" class="java.lang.String"/>
	<field name="ID_OPE_BD" class="java.math.BigDecimal"/>
	<variable name="tot_diferencia" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{TOT_DEBITO}-$F{TOT_CREDITO}]]></variableExpression>
	</variable>
	<variable name="sum_credito" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{TOT_CREDITO}]]></variableExpression>
	</variable>
	<variable name="sum_debito" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{TOT_DEBITO}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<detail>
		<band height="75" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="90" height="12" forecolor="#000000" backcolor="#B1D3F5"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Documento No]]></text>
			</staticText>
			<textField>
				<reportElement x="0" y="12" 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.lang.String"><![CDATA[$F{ID_DOCUMENTO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="850" y="0" width="100" height="12" forecolor="#000000" backcolor="#B1D3F5"/>
				<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[Crédito Doc.]]></text>
			</staticText>
			<textField pattern="#,##0.00;(#,##0.00)">
				<reportElement x="850" y="12" width="100" height="10"/>
				<box 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{TOT_CREDITO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="750" y="0" width="100" height="12" forecolor="#000000" backcolor="#B1D3F5"/>
				<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[Débito Doc.]]></text>
			</staticText>
			<textField pattern="#,##0.00;(#,##0.00)">
				<reportElement x="750" y="12" width="100" height="10"/>
				<box 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{TOT_DEBITO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="950" y="0" width="110" height="12" forecolor="#000000" backcolor="#B1D3F5"/>
				<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[Diferencia]]></text>
			</staticText>
			<textField pattern="#,##0.00;(#,##0.00)">
				<reportElement x="950" y="12" width="110" height="10"/>
				<box 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{TOT_DEBITO}-$F{TOT_CREDITO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="290" y="0" width="150" height="12" forecolor="#000000" backcolor="#B1D3F5"/>
				<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[Doc. Soporte]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="290" y="12" width="150" height="10"/>
				<box 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{DOC_SOPORTE}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="0" y="22" width="90" height="12" forecolor="#000000" backcolor="#B1D3F5"/>
				<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[Descripción]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="90" y="22" width="970" 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{DESCR_MTO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="530" y="0" width="220" height="12" forecolor="#000000" backcolor="#B1D3F5"/>
				<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[Tercero]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="530" y="12" width="220" 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{TERCERO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="90" y="0" width="200" height="12" forecolor="#000000" backcolor="#B1D3F5"/>
				<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 Documento]]></text>
			</staticText>
			<textField>
				<reportElement x="90" y="12" width="200" 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{NOM_TD}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="440" y="0" width="90" height="12" forecolor="#000000" backcolor="#B1D3F5"/>
				<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 Soporte]]></text>
			</staticText>
			<textField pattern="dd/MM/yyyy">
				<reportElement x="440" y="12" width="90" height="10"/>
				<box 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{FECHA_SOPORTE}]]></textFieldExpression>
			</textField>
			<subreport>
				<reportElement x="0" y="55" width="1060" height="12"/>
				<subreportParameter name="id_documento">
					<subreportParameterExpression><![CDATA[$F{ID_DOCUMENTO}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="id_cia">
					<subreportParameterExpression><![CDATA[$P{id_cia}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="id_cad">
					<subreportParameterExpression><![CDATA[$F{ID_CAD}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="id_cen_op">
					<subreportParameterExpression><![CDATA[$P{id_cen_op}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="id_vigencia">
					<subreportParameterExpression><![CDATA[$F{ID_VIGENCIA}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="nom_td">
					<subreportParameterExpression><![CDATA[$F{NOM_TD}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression class="java.lang.String"><![CDATA["repo:consul_docu_mov"]]></subreportExpression>
			</subreport>
			<textField isBlankWhenNull="true">
				<reportElement x="90" y="34" width="970" 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{COMPLETO_LOG}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="0" y="34" width="90" height="12" forecolor="#000000" backcolor="#B1D3F5"/>
				<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[Elaboró:]]></text>
			</staticText>
		</band>
	</detail>
	<summary>
		<band height="17" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="90" y="0" width="200" height="12" forecolor="#000000" backcolor="#D2D0D0"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Left" 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[$P{nom_corto}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="290" y="0" width="150" height="12" forecolor="#000000" backcolor="#D2D0D0"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.25"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<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[CAD: ]]></text>
			</staticText>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="950" y="0" width="110" height="12" forecolor="#000000" backcolor="#D2D0D0"/>
				<box 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" 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.math.BigDecimal"><![CDATA[$V{tot_diferencia}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="false">
				<reportElement mode="Opaque" x="850" y="0" width="100" height="12" forecolor="#000000" backcolor="#D2D0D0"/>
				<box 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" 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.math.BigDecimal"><![CDATA[$V{sum_credito}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="false">
				<reportElement mode="Opaque" x="750" y="0" width="100" height="12" forecolor="#000000" backcolor="#D2D0D0"/>
				<box 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" 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.math.BigDecimal"><![CDATA[$V{sum_debito}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="90" height="12" forecolor="#000000" backcolor="#D2D0D0"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<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[Total Comprobante: ]]></text>
			</staticText>
			<textField>
				<reportElement mode="Opaque" x="440" y="0" width="310" height="12" forecolor="#000000" backcolor="#D2D0D0"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Left" 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[$P{id_cad}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
</jasperReport>
