<?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="Res_anl_aux" language="groovy" pageWidth="792" pageHeight="612" orientation="Landscape" columnWidth="752" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.5"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="52"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/contab/res_anl_aux"/>
	<property name="ireport.jasperserver.url" value="http://soporte6.sofhouse.net:8090/jasperserver/services/repository"/>
	<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="vigper_Ini" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="vigper_Fin" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="per_fin" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="per_ini" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="vig_fin" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="vig_ini" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereAuxiliar" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="nom_periodo_fin" class="java.lang.String"/>
	<parameter name="nom_periodo_ini" class="java.lang.String"/>
	<parameter name="nom_cen_op" class="java.lang.String"/>
	<parameter name="whereClase" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereGrupo" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereCuenta" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereCatalogo" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTercero" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="haveAuxiliar" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="haveTercero" class="java.lang.String">
		<property name="propiedades" value="$F{ID_MAE_TER}.intValue(). == -1? &quot;&quot;: &quot;and id_mae_ter =  &quot; + $F{ID_MAE_TER}.toString() "/>
		<parameterDescription><![CDATA[]]></parameterDescription>
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select

TAB.*,

NVL ( (
select nom_cen_op
from CN_CENTRO_OPERACION
where ID_CEN_OP = Tab.ID_CEN_OP),'')   as nom_cen_op,

NVL ( (
select NOMBRE
from CN_AUXILIAR
where ID_AUXILIAR = TAB.ID_AUXILIAR
AND ID_CLASE_CUENTA = TAB.ID_CLASE_CUENTA
AND ID_GRUPO_CUENTA = TAB.ID_GRUPO_CUENTA
AND ID_CUENTA_MAYOR = TAB.ID_CUENTA_MAYOR
AND ID_CATALOGO = TAB.ID_CATALOGO
),'')   as NOMBRE_AUX ,

NVL ( (
select COD_AUX
from CN_AUXILIAR
where ID_AUXILIAR = TAB.ID_AUXILIAR
AND ID_CLASE_CUENTA = TAB.ID_CLASE_CUENTA
AND ID_GRUPO_CUENTA = TAB.ID_GRUPO_CUENTA
AND ID_CUENTA_MAYOR = TAB.ID_CUENTA_MAYOR
AND ID_CATALOGO = TAB.ID_CATALOGO
),'')   as COD_AUX  ,

NVL ( (
select NITOCC
from CN_MAE_TER
where ID_MAE_TER = Tab.ID_MAE_TER ),'')   as NITOCC ,

NVL ( (
select NOMBRE
from CN_MAE_TER
where ID_MAE_TER = Tab.ID_MAE_TER ),'')   as NOMBRE_MAE_TER,


NVL ( (
select sum(SALDO_ANTERIOR) as saldo_anterior
from CN_SALDO_VIGPER
WHERE ID_CIA = tab.id_cia
AND ID_CEN_OP = tab.id_cen_op
AND ID_VIGENCIA = $P{vig_ini}
and ID_PERIODO_CONTABLE = $P{per_ini}
and SUBCUENTA = tab.cuenta
and (ID_AUXILIAR = tab.ID_AUXILIAR or ( tab.ID_AUXILIAR = 0 and ID_AUXILIAR is null) )
and (ID_MAE_TER = tab.ID_MAE_TER or (tab.ID_MAE_TER = -1 and ID_MAE_TER is null))
$P!{haveAuxiliar}    $P!{haveTercero}
) , 0 ) AS saldo_anterior1,

NVL ( (
select sum(SALDO_ACTUAL) as saldo_actual
from CN_SALDO_VIGPER
WHERE ID_CIA =tab.id_cia
AND ID_CEN_OP = tab.id_cen_op
AND ID_VIGENCIA = $P{vig_ini}
and ID_PERIODO_CONTABLE = $P{per_ini}
and SUBCUENTA = tab.cuenta
and (ID_AUXILIAR = tab.ID_AUXILIAR or ( tab.ID_AUXILIAR = 0 and ID_AUXILIAR is null) )
and (ID_MAE_TER = tab.ID_MAE_TER or (tab.ID_MAE_TER = -1 and ID_MAE_TER is null))
$P!{haveAuxiliar} $P!{haveTercero}
) , 0 ) AS saldo_actual1,

NVL ( (
select sum(SALDO_ANTERIOR) as saldo_anterior
from CN_SALDO_VIGPER
WHERE  ID_CIA = tab.id_cia
AND ID_CEN_OP = tab.id_cen_op
AND ID_VIGENCIA = $P{vig_fin}
and ID_PERIODO_CONTABLE = $P{per_fin}
and SUBCUENTA = tab.cuenta
and (ID_AUXILIAR = tab.ID_AUXILIAR or ( tab.ID_AUXILIAR = 0 and ID_AUXILIAR is null) )
and (ID_MAE_TER = tab.ID_MAE_TER or (tab.ID_MAE_TER = -1 and ID_MAE_TER is null))
$P!{haveAuxiliar}    $P!{haveTercero}
) , 0 ) AS saldo_anterior2,

NVL ( (
select sum(SALDO_ACTUAL) as saldo_actual
from CN_SALDO_VIGPER
WHERE ID_CIA = tab.id_cia
AND ID_CEN_OP = tab.id_cen_op
AND ID_VIGENCIA = $P{vig_fin}
and ID_PERIODO_CONTABLE = $P{per_fin}
and SUBCUENTA = tab.cuenta
and (ID_AUXILIAR = tab.ID_AUXILIAR or ( tab.ID_AUXILIAR = 0 and ID_AUXILIAR is null) )
and (ID_MAE_TER = tab.ID_MAE_TER or (tab.ID_MAE_TER = -1 and ID_MAE_TER is null))
$P!{haveAuxiliar} $P!{haveTercero}
) , 0 ) AS saldo_actual2


FROM  (

  select
  cla.DIGITO || gru.DIGITO || cue.DIGITOS || cat.DIGITOS as cuenta,
  cla.DIGITO as dig_cla,
  cla.NOMBRE as nom_cla,
  gru.DIGITO AS dig_gru,
  gru.NOMBRE AS nom_gru,
  cue.DIGITOS AS dig_cue,
  cue.NOMBRE AS nom_cue,
  cat.DIGITOS AS dig_cat,
  cat.NOMBRE AS nom_cat,
  lib.ID_CIA,
  lib.ID_CEN_OP,
  lib.ID_VIGENCIA,
  lib.ID_PERIODO_CONTABLE,
  lib.NOM_PERIODO,
  lib.ID_CATALOGO,
  lib.ID_CUENTA_MAYOR,
  lib.ID_GRUPO_CUENTA,
  lib.ID_CLASE_CUENTA,
  NVL(lib.ID_AUXILIAR, 0 ) as ID_AUXILIAR,
  NVL(lib.ID_MAE_TER, -1 ) as ID_MAE_TER,
  lib.ID_AUXILIAR || lib.ID_MAE_TER as AUXTER,
  lib.TIPO_SALDO,
  NVL( lib.DEBITO, 0 ) as DEBITO,
  NVL( lib.CREDITO, 0 ) as CREDITO,
  lib.SALDO,
  lib.VIG_PER
  from CN_AUX_SUBC_TER lib

  JOIN CN_CLASE_CUENTA cla ON
  cla.ID_CIA = lib.ID_CIA
  AND cla.ID_CLASE_CUENTA = lib.ID_CLASE_CUENTA

  JOIN CN_GRUPO_CUENTA gru ON
  gru.ID_CIA = lib.ID_CIA
  AND gru.ID_CLASE_CUENTA = lib.ID_CLASE_CUENTA
  AND gru.ID_GRUPO_CUENTA = lib.ID_GRUPO_CUENTA

  JOIN CN_CUENTA_MAYOR cue ON
  cue.ID_CIA = lib.ID_CIA
  AND cue.ID_CLASE_CUENTA = lib.ID_CLASE_CUENTA
  AND cue.ID_GRUPO_CUENTA = lib.ID_GRUPO_CUENTA
  AND cue.ID_CUENTA_MAYOR = lib.ID_CUENTA_MAYOR

  JOIN CN_CATALOGO cat ON
  cat.ID_CIA = lib.ID_CIA
  AND cat.ID_CLASE_CUENTA = lib.ID_CLASE_CUENTA
  AND cat.ID_GRUPO_CUENTA = lib.ID_GRUPO_CUENTA
  AND cat.ID_CUENTA_MAYOR = lib.ID_CUENTA_MAYOR
  AND cat.ID_CATALOGO = lib.ID_CATALOGO

  WHERE
  lib.ID_CIA = $P{id_cia}
  AND lib.ID_CEN_OP = $P{id_cen_op}
  AND lib.VIG_PER BETWEEN $P{vigper_Ini} AND $P{vigper_Fin}
  $P!{whereClase} $P!{whereGrupo} $P!{whereCuenta}$P!{whereCatalogo} $P!{whereAuxiliar} $P!{whereTercero}
  and cla.DIGITO <> 0

)tab
order by
tab.dig_cla ASC,
tab.dig_gru ASC,
tab.dig_cue ASC,
tab.dig_cat ASC,
tab.ID_AUXILIAR ASC,
tab.ID_MAE_TER ASC,
tab.VIG_PER ASC]]>
	</queryString>
	<field name="CUENTA" class="java.lang.String"/>
	<field name="DIG_CLA" class="java.lang.String"/>
	<field name="NOM_CLA" class="java.lang.String"/>
	<field name="DIG_GRU" class="java.lang.String"/>
	<field name="NOM_GRU" class="java.lang.String"/>
	<field name="DIG_CUE" class="java.lang.String"/>
	<field name="NOM_CUE" class="java.lang.String"/>
	<field name="DIG_CAT" class="java.lang.String"/>
	<field name="NOM_CAT" class="java.lang.String"/>
	<field name="ID_CIA" class="java.math.BigDecimal"/>
	<field name="ID_CEN_OP" class="java.math.BigDecimal"/>
	<field name="ID_VIGENCIA" class="java.math.BigDecimal"/>
	<field name="ID_PERIODO_CONTABLE" class="java.math.BigDecimal"/>
	<field name="NOM_PERIODO" class="java.lang.String"/>
	<field name="ID_CATALOGO" class="java.math.BigDecimal"/>
	<field name="ID_CUENTA_MAYOR" class="java.math.BigDecimal"/>
	<field name="ID_GRUPO_CUENTA" class="java.math.BigDecimal"/>
	<field name="ID_CLASE_CUENTA" class="java.math.BigDecimal"/>
	<field name="ID_AUXILIAR" class="java.math.BigDecimal"/>
	<field name="ID_MAE_TER" class="java.math.BigDecimal"/>
	<field name="AUXTER" class="java.lang.String"/>
	<field name="TIPO_SALDO" class="java.lang.String"/>
	<field name="DEBITO" class="java.math.BigDecimal"/>
	<field name="CREDITO" class="java.math.BigDecimal"/>
	<field name="SALDO" class="java.lang.String"/>
	<field name="VIG_PER" class="java.lang.String"/>
	<field name="NOM_CEN_OP" class="java.lang.String"/>
	<field name="NOMBRE_AUX" class="java.lang.String"/>
	<field name="COD_AUX" class="java.lang.String"/>
	<field name="NITOCC" class="java.lang.String"/>
	<field name="NOMBRE_MAE_TER" class="java.lang.String"/>
	<field name="SALDO_ANTERIOR1" class="java.math.BigDecimal"/>
	<field name="SALDO_ACTUAL1" class="java.math.BigDecimal"/>
	<field name="SALDO_ANTERIOR2" class="java.math.BigDecimal"/>
	<field name="SALDO_ACTUAL2" class="java.math.BigDecimal"/>
	<variable name="sum_aux_deb" class="java.math.BigDecimal" resetType="Group" resetGroup="Auxiliar - Tercero" calculation="Sum">
		<variableExpression><![CDATA[$F{DEBITO}]]></variableExpression>
	</variable>
	<variable name="sum_aux_cre" class="java.math.BigDecimal" resetType="Group" resetGroup="Auxiliar - Tercero" calculation="Sum">
		<variableExpression><![CDATA[$F{CREDITO}]]></variableExpression>
	</variable>
	<group name="Clase" isReprintHeaderOnEachPage="true">
		<groupExpression><![CDATA[$F{DIG_CLA}]]></groupExpression>
		<groupHeader>
			<band height="26">
				<staticText>
					<reportElement mode="Opaque" x="0" y="4" width="100" 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[Cuenta]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="100" y="4" width="652" 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[Nombre cuenta]]></text>
				</staticText>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement mode="Transparent" x="100" y="16" width="652" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" 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[$F{NOM_CLA}]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement mode="Transparent" x="0" y="16" width="100" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" 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[$F{DIG_CLA}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
	</group>
	<group name="Grupo" isReprintHeaderOnEachPage="true">
		<groupExpression><![CDATA[$F{DIG_GRU}]]></groupExpression>
		<groupHeader>
			<band height="10">
				<textField pattern="" isBlankWhenNull="false">
					<reportElement mode="Transparent" x="0" y="0" width="100" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" 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[$F{DIG_CLA}+$F{DIG_GRU}]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement mode="Transparent" x="100" y="0" width="652" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" 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[$F{NOM_GRU}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
	</group>
	<group name="Cuenta" isReprintHeaderOnEachPage="true">
		<groupExpression><![CDATA[$F{DIG_CUE}]]></groupExpression>
		<groupHeader>
			<band height="10">
				<textField pattern="" isBlankWhenNull="false">
					<reportElement mode="Transparent" x="100" y="0" width="652" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" 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[$F{NOM_CUE}]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement mode="Transparent" x="0" y="0" width="100" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" 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[$F{DIG_CLA}+$F{DIG_GRU}+$F{DIG_CUE}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
	</group>
	<group name="Catalogo" isReprintHeaderOnEachPage="true">
		<groupExpression><![CDATA[$F{DIG_CAT}]]></groupExpression>
		<groupHeader>
			<band height="17">
				<textField pattern="" isBlankWhenNull="false">
					<reportElement mode="Transparent" x="0" y="0" width="100" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" 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[$F{CUENTA}]]></textFieldExpression>
				</textField>
				<textField pattern="" isBlankWhenNull="false">
					<reportElement mode="Transparent" x="100" y="0" width="652" height="10" forecolor="#000000" backcolor="#FFFFFF"/>
					<box leftPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Left" verticalAlignment="Middle" 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[$F{NOM_CAT}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
	</group>
	<group name="Auxiliar - Tercero" isReprintHeaderOnEachPage="true">
		<groupExpression><![CDATA[$F{AUXTER}]]></groupExpression>
		<groupHeader>
			<band height="55">
				<staticText>
					<reportElement mode="Opaque" x="511" y="31" width="120" height="12" forecolor="#000000" backcolor="#D4E8FA"/>
					<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]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="391" y="31" width="120" height="12" forecolor="#000000" backcolor="#D4E8FA"/>
					<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]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="631" y="31" width="121" height="12" forecolor="#000000" backcolor="#D4E8FA"/>
					<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[Saldo]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="391" y="43" width="240" height="12" backcolor="#E5E3E3"/>
					<box rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.0"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="6"/>
					</textElement>
					<text><![CDATA[]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="0" y="31" width="100" height="12" forecolor="#000000" backcolor="#D4E8FA"/>
					<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[Vigencia]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="100" y="31" width="76" height="12" forecolor="#000000" backcolor="#D4E8FA"/>
					<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[No. Periodo]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="176" y="31" width="215" height="12" forecolor="#000000" backcolor="#D4E8FA"/>
					<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[Nombre periodo]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="0" y="43" width="391" height="12" backcolor="#E5E3E3"/>
					<box rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.0"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="8" isBold="true"/>
					</textElement>
					<text><![CDATA[Saldo Anterior:]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="0" y="0" width="120" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#B1D6FB">
						<printWhenExpression><![CDATA[$F{ID_AUXILIAR}!=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[Auxiliar:]]></text>
				</staticText>
				<textField isBlankWhenNull="true">
					<reportElement x="120" y="0" width="80" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[$F{ID_AUXILIAR}!=0]]></printWhenExpression>
					</reportElement>
					<box>
						<pen lineWidth="0.5"/>
						<topPen lineWidth="0.5"/>
						<leftPen lineWidth="0.5"/>
						<bottomPen lineWidth="0.5"/>
						<rightPen lineWidth="0.0"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="6"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{COD_AUX}]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement x="200" y="0" width="552" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[$F{ID_AUXILIAR}!=0]]></printWhenExpression>
					</reportElement>
					<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 verticalAlignment="Middle">
						<font size="6"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{NOMBRE_AUX}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement mode="Opaque" x="0" y="12" width="120" height="12" isRemoveLineWhenBlank="true" forecolor="#000000" backcolor="#B1D6FB">
						<printWhenExpression><![CDATA[$F{ID_MAE_TER}!=-1]]></printWhenExpression>
					</reportElement>
					<box>
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.75"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.75"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
						<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
					</textElement>
					<text><![CDATA[Tercero: ]]></text>
				</staticText>
				<textField>
					<reportElement x="120" y="12" width="80" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[$F{ID_MAE_TER}!=-1]]></printWhenExpression>
					</reportElement>
					<box leftPadding="0" rightPadding="2">
						<pen lineWidth="0.75"/>
						<topPen lineWidth="0.75"/>
						<leftPen lineWidth="0.0"/>
						<bottomPen lineWidth="0.75"/>
						<rightPen lineWidth="0.0"/>
					</box>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font size="6"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{NITOCC}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="200" y="12" width="552" height="12" isRemoveLineWhenBlank="true">
						<printWhenExpression><![CDATA[$F{ID_MAE_TER}!=-1]]></printWhenExpression>
					</reportElement>
					<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 verticalAlignment="Middle">
						<font size="6"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{NOMBRE_MAE_TER}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(#,##0.00)">
					<reportElement mode="Opaque" x="631" y="43" width="121" height="12" backcolor="#E5E3E3"/>
					<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_ANTERIOR1}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="22">
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement mode="Opaque" x="391" y="0" width="120" height="12" 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">
						<font size="6" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{sum_aux_deb}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
					<reportElement mode="Opaque" x="511" y="0" width="120" height="12" 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">
						<font size="6" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{sum_aux_cre}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement mode="Opaque" x="0" y="0" width="391" height="12" backcolor="#D2D0D0"/>
					<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" markup="none">
						<font size="8" isBold="true"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[( $F{ID_AUXILIAR}.toString()=="0" && $F{ID_MAE_TER}.toString()=="-1"
    ? "Saldo Actual:"
    : ( $F{ID_AUXILIAR}.toString()!="0" && $F{ID_MAE_TER}.toString()=="-1"
    ? "Saldo Actual Auxiliar:"
    :  ( $F{ID_AUXILIAR}.toString()=="0" && $F{ID_MAE_TER}.toString()!="-1"
        ? "Saldo Actual Tercero:"
        : "Saldo Actual:"  )
     )
)]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00;(#,##0.00)">
					<reportElement mode="Opaque" x="631" y="0" width="121" height="12" backcolor="#D2D0D0"/>
					<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[$F{SALDO_ACTUAL2}]]></textFieldExpression>
				</textField>
			</band>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="60" splitType="Stretch">
			<textField pattern="dd-MMM-yyyy   hh:mm aaa">
				<reportElement mode="Opaque" x="600" y="22" width="150" 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>
			<staticText>
				<reportElement x="141" y="0" width="460" height="39"/>
				<textElement textAlignment="Center" verticalAlignment="Bottom" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Sistema de Contabilidad
Resumen Análisis Auxiliar]]></text>
			</staticText>
			<textField pattern="dd-MMM-yyyy   hh:mm aaa">
				<reportElement mode="Opaque" x="602" y="46" width="150" 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.lang.String"><![CDATA[$P{nom_cen_op}]]></textFieldExpression>
			</textField>
			<image>
				<reportElement x="0" y="10" width="140" height="40"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
			<staticText>
				<reportElement mode="Opaque" x="601" y="34" width="150" 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[Centro de operacion:]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="600" y="10" width="151" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Fecha de Impresion:]]></text>
			</staticText>
			<textField>
				<reportElement x="141" y="39" width="460" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="10" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Periodo: "+$P{nom_periodo_ini}+" de "+$P{vig_ini}+" a "+$P{nom_periodo_fin}+" de "+$P{vig_fin}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="25" splitType="Stretch"/>
	</pageHeader>
	<detail>
		<band height="10" splitType="Stretch">
			<staticText>
				<reportElement x="631" y="0" width="121" 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>
				<text><![CDATA[]]></text>
			</staticText>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement x="391" y="0" width="120" 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{DEBITO}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="100" y="0" width="76" height="10"/>
				<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">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ID_PERIODO_CONTABLE}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="176" y="0" width="215" 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_PERIODO}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="0" width="100" height="10"/>
				<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">
					<font size="6"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ID_VIGENCIA}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement x="511" y="0" width="120" 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{CREDITO}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<pageFooter>
		<band height="25" splitType="Stretch">
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement mode="Opaque" x="391" 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>
			<textField>
				<reportElement mode="Opaque" x="301" 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>
			<staticText>
				<reportElement mode="Opaque" x="301" y="0" width="150" height="12" forecolor="#575757"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<text><![CDATA[Websafi - Contabilidad]]></text>
			</staticText>
		</band>
	</pageFooter>
	<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>
