<?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="consol_ingre_reten_func_res" 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="0"/>
	<parameter name="fecha_ini" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="fecha_fin" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereFuncionarioNumDoc" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="whereFuncionarioTipoDoc" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="id_anhos" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select
tab0.num_doc,
tab0.nombre_apellido,
case when sum(DEVENGADOS)<0 then round(abs(sum(DEVENGADOS)*-1),-3) else round(abs(sum(DEVENGADOS)),-3) end as DEVENGADOS,
case when sum(APORTES_SALUD_OBLIG)<0 then round(abs(sum(APORTES_SALUD_OBLIG)*-1),-3) else round(abs(sum(APORTES_SALUD_OBLIG)),-3) end as APORTES_SALUD_OBLIG,
case when sum(APORTES_PENSION_OBLIG_FSP)<0 then round(abs(sum(APORTES_PENSION_OBLIG_FSP)*-1),-3) else round(abs(sum(APORTES_PENSION_OBLIG_FSP)),-3) end as APORTES_PENSION_OBLIG_FSP,
case when sum(APORTES_VOLUN_PENSION_AFC)<0 then round(abs(sum(APORTES_VOLUN_PENSION_AFC)*-1),-3) else round(abs(sum(APORTES_VOLUN_PENSION_AFC)),-3) end as APORTES_VOLUN_PENSION_AFC,
case when sum(RETEFUENTE)<0 then round(abs(sum(RETEFUENTE)*-1),-3) else round(abs(sum(RETEFUENTE)),-3) end as RETEFUENTE
from
(SELECT tab0.num_doc,
  tab0.nombre_apellido,
  tab0.agrupacion_orden,
  tab0.nombre_agrup,
  case when tab0.agrupacion_orden=0 then tab0.valor_total else 0 END as Todos_conceptos,
  case when tab0.agrupacion_orden=1 then tab0.valor_total else 0 END as DEVENGADOS,
  case when tab0.agrupacion_orden=2 then tab0.valor_total else 0 END as APORTES_SALUD_OBLIG,
  case when tab0.agrupacion_orden=3 then tab0.valor_total else 0 END as APORTES_PENSION_OBLIG_FSP,
  case when tab0.agrupacion_orden=4 then tab0.valor_total else 0 END as APORTES_VOLUN_PENSION_AFC,
  case when tab0.agrupacion_orden=5 then tab0.valor_total else 0 END as RETEFUENTE,
  tab0.operadoropcional
FROM
  (SELECT DISTINCT tab0.id_certif_ingre_reten_inf AS id_certif_ingre_reten_inf,
    tab0.id_tipo_doc                              AS id_tipo_doc,
    tab0.num_doc                                  AS num_doc,
    tab0.id_anhos                                 AS id_anhos,
    tab0.id_concep_nomina                         AS id_concep_nomina,
    tab0.valor_enero                              AS valor_enero,
    tab0.valor_febrero                            AS valor_febrero,
    tab0.valor_marzo                              AS valor_marzo,
    tab0.valor_abril                              AS valor_abril,
    tab0.valor_mayo                               AS valor_mayo,
    tab0.valor_junio                              AS valor_junio,
    tab0.valor_julio                              AS valor_julio,
    tab0.valor_agosto                             AS valor_agosto,
    tab0.valor_septiembre                         AS valor_septiembre,
    tab0.valor_octubre                            AS valor_octubre,
    tab0.valor_noviembre                          AS valor_noviembre,
    tab0.valor_diciembre                          AS valor_diciembre,
    tab0.valor_total                              AS valor_total,
    tab0.agrupacion_orden,
    tab5.nombre_agrup,
    tab1.tipo_documento                    AS tipo_documento,
    tab1.primer_nombre                     AS primer_nombre,
    tab1.segundo_nombre                    AS segundo_nombre,
    tab1.primer_apellido                   AS primer_apellido,
    tab1.segundo_apellido                  AS segundo_apellido,
    tab1.nombre_completo                   AS nombre_completo,
    tab1.nombre_apellido                   AS nombre_apellido,
    TO_CHAR(tab1.fecha_nace, 'YYYY-MM-DD') AS fecha_nace,
    tab1.email                             AS email,
    tab1.tel                               AS telefono,
    tab1.direccion                         AS direccion,
    tab1.pais_nace                         AS pais_nace,
    tab1.depto_nace                        AS depto_nace,
    tab1.muni_nace                         AS muni_nace,
    tab1.genero                            AS genero,
    tab1.estado_civil                      AS estado_civil,
    tab1.tipo_sangre                       AS tipo_sangre,
    tab2.codigo                            AS codigo,
    tab2.descripcion                       AS descripcion,
    tab2.codigo
    ||' - '
    ||tab2.descripcion         AS completo,
    tab2.id_tipo_concepto      AS id_tipo_concepto,
    tab2.abreviatura           AS abreviatura,
    tab2.operador              AS operador,
    tab2.operadoropcional      AS operadoropcional,
    tab2.cod2                  AS cod2,
    tab2.cod3                  AS cod3,
    tab2.id_concep_ajuste      AS id_concep_ajuste,
    tab2.id_concep_rein        AS id_concep_rein,
    tab2.id_acreedor           AS id_acreedor,
    tab2.id_rubro              AS id_rubro,
    tab2.id_cpo                AS id_cpo,
    tab2.estado                AS estado,
    tab2.aplica_descuento      AS aplica_descuento,
    tab2.id_clase_fondo        AS id_clase_fondo,
    tab2.usa_dias_calen        AS usa_dias_calen,
    tab3.id_consecutivo_certif AS id_consecutivo_certif,
    tab3.secuencia             AS secuencia,
    tab4.codigo                AS codigo_tipcon,
    tab4.descripcion           AS descripcion_tipcon,
    tab4.orden                 AS orden_tipcon,
    tab4.codigo
    ||' - '
    ||tab4.descripcion AS completo_tipcon
  FROM NO_CERTIF_INGRE_RETEN_INF tab0
  JOIN NO_DATOS_FUNCIONARIO_V tab1
  ON tab0.id_tipo_doc = tab1.id_tipo_doc
  AND tab0.num_doc    = tab1.num_doc
  JOIN NO_CONCEPTOS_V tab2
  ON tab0.id_concep_nomina = tab2.id_concep_nomina
  LEFT JOIN NO_CONSECUTIVO_CERTIF tab3
  ON tab0.id_tipo_doc = tab3.id_tipo_doc
  AND tab0.num_doc    = tab3.num_doc
  AND tab0.id_anhos   = tab3.id_anhos
  JOIN NO_TIPO_CONCEPTO tab4
  ON tab2.id_tipo_concepto = tab4.id_tipo_concepto
  LEFT JOIN no_agrup_nombre tab5
  ON tab5.id_agrup                      = tab0.agrupacion_orden
  WHERE tab0.id_certif_ingre_reten_inf != '-1'
  AND tab0.agrupacion_orden            != '-1'
  AND tab0.agrupacion_orden            != '0'
  AND tab0.id_anhos                     = $P{id_anhos}
    $P!{whereFuncionarioNumDoc}
    $P!{whereFuncionarioTipoDoc}
  )tab0)tab0
GROUP BY tab0.num_doc,
  tab0.nombre_apellido
ORDER BY
  tab0.num_doc]]>
	</queryString>
	<field name="NUM_DOC" class="java.lang.String"/>
	<field name="NOMBRE_APELLIDO" class="java.lang.String"/>
	<field name="DEVENGADOS" class="java.math.BigDecimal"/>
	<field name="APORTES_SALUD_OBLIG" class="java.math.BigDecimal"/>
	<field name="APORTES_PENSION_OBLIG_FSP" class="java.math.BigDecimal"/>
	<field name="APORTES_VOLUN_PENSION_AFC" class="java.math.BigDecimal"/>
	<field name="RETEFUENTE" class="java.math.BigDecimal"/>
	<variable name="suma_devengados" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{DEVENGADOS}]]></variableExpression>
	</variable>
	<variable name="suma_fsp" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{APORTES_PENSION_OBLIG_FSP}]]></variableExpression>
	</variable>
	<variable name="suma_afc" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{APORTES_VOLUN_PENSION_AFC}]]></variableExpression>
	</variable>
	<variable name="suma_retefuente" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{RETEFUENTE}]]></variableExpression>
	</variable>
	<variable name="suma_obl_salud" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{APORTES_SALUD_OBLIG}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="60" splitType="Stretch">
			<staticText>
				<reportElement x="208" y="0" width="412" height="40"/>
				<textElement textAlignment="Center" verticalAlignment="Top" markup="none">
					<font fontName="SansSerif" size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[Sistema General de Nómina
Consolidado de Ingresos y Retenciones por Funcionario - Resumido]]></text>
			</staticText>
			<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="620" y="28" width="132" height="12" forecolor="#000000" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Fecha de Impresión:]]></text>
			</staticText>
			<textField pattern="dd-MMM-yyyy   hh:mm aaa">
				<reportElement x="620" y="40" width="132" height="12"/>
				<box rightPadding="3"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="208" y="40" width="412" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="12" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Periodo: " + $P{fecha_ini} + " a " +$P{fecha_fin}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="20" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="28" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="72" y="0" width="180" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<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[Funcionario]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="252" y="0" width="100" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Total Devengados]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="352" y="0" width="100" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Total Aportes Obligatorio Salud]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="452" y="0" width="100" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[TotalAportes Obligatorio Pension FSP]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="552" y="0" width="100" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Aportes voluntarios, a fondos de pensiones y cuentas AFC]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="652" y="0" width="100" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Valor de la retención en la fuente por pagos al empleado]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="72" height="28" forecolor="#000000" backcolor="#AED6FB"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Número Documento]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="10" splitType="Stretch">
			<textField isStretchWithOverflow="true">
				<reportElement stretchType="RelativeToTallestObject" x="72" y="0" width="180" 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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NOMBRE_APELLIDO}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00">
				<reportElement stretchType="RelativeToTallestObject" x="252" y="0" 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="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{DEVENGADOS}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00">
				<reportElement stretchType="RelativeToTallestObject" x="352" y="0" 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="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{APORTES_SALUD_OBLIG}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00">
				<reportElement stretchType="RelativeToTallestObject" x="452" y="0" 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="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{APORTES_PENSION_OBLIG_FSP}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00">
				<reportElement stretchType="RelativeToTallestObject" x="552" y="0" 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="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{APORTES_VOLUN_PENSION_AFC}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00">
				<reportElement stretchType="RelativeToTallestObject" x="652" y="0" 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="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{RETEFUENTE}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="72" 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="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_DOC}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="24" 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 - Nómina]]></text>
			</staticText>
		</band>
	</pageFooter>
	<summary>
		<band height="13" splitType="Stretch">
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="0" y="0" width="252" height="13" forecolor="#000000" backcolor="#C1C7D1"/>
				<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" 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"]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="252" y="0" width="100" height="13" forecolor="#000000" backcolor="#C1C7D1"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_devengados}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="352" y="0" width="100" height="13" forecolor="#000000" backcolor="#C1C7D1"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_obl_salud}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="452" y="0" width="100" height="13" forecolor="#000000" backcolor="#C1C7D1"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_fsp}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(-#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="552" y="0" width="100" height="13" forecolor="#000000" backcolor="#C1C7D1"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_afc}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00;(#,##0.00)" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="652" y="0" width="100" height="13" forecolor="#000000" backcolor="#C1C7D1"/>
				<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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{suma_retefuente}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
	<noData>
		<band height="19"/>
	</noData>
</jasperReport>
