<?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="formato_programacion_comision_planta" language="groovy" pageWidth="1150" pageHeight="300" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="1150" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
	<property name="ireport.zoom" value="1.0000000000000004"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="id_comision" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="vigencia" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT
comi.*,
ter.razsoc,
ter.tipter,
case when ter.tipter = 2 then 'Funcionario' else 'Contratista' end as tipo_tercero,
ter.estado as estado_ter,
ter.email,
ter.sueldo as sueldo_ter,
ter.cargo as cargo_ter,
ter.cargo_texto as cargo_texto_ter,

reg.desreg,
reg.ciuced,

ach.banco,
ach.tipo_cuenta,
ach.tipo_cuenta_texto,
ach.num_cuenta,

obj.codobj,
nvl(obj.valor,0) as valor,
nvl(obj.valor_gasto,0) as valor_gasto,
nvl(obj.viaticos,0) as viaticos,
nvl(obj.acumulado_gastos,0) as acumulado_gastos,
nvl(obj.taxis,0) as taxis,
nvl(obj.tarifa,0) as tarifa

FROM comisionados_planta comi

left join terceros ter
on ter.nitocc = comi.nitocc

left join regionales reg
on reg.codreg = comi.codreg

left join(

    select

    id_comision,
    vigencia,
    nitocc,

    listagg(codobj, ',') within group (order by codobj) as codobj,

    sum(valor) as valor,
    sum(case when codobj = '06' then valor - viaticos else 0 end) as valor_gasto,
    sum(viaticos) as viaticos,
    sum(case when codobj != '06' then valor - viaticos else 0 end) as acumulado_gastos,
    sum(taxis) as taxis,
    max(tarifa) as tarifa

    from comisionados_objs

    where
    estado = 1

    group by
    id_comision,
    vigencia,
    nitocc

)obj
on obj.vigencia = comi.vigencia
and obj.id_comision = comi.id_comision
and obj.nitocc = comi.nitocc

left join(

    SELECT
    ach.id_tercero as ter_ach,
    ter.num_doc,
    bn.descripcion as banco,
    case when reg.tipo_cuenta = 1 then 'Corriente' else 'Ahorros' end as tipo_cuenta_texto,
    reg.*,
    ROW_NUMBER() OVER (
        partition by ter.num_doc
        ORDER BY ter.num_doc, reg.id_reg_ach_distri desc
    ) AS rn

    FROM ts_reg_ach_distri reg

    join ts_reg_ach ach
    on ach.id_reg_ach = reg.id_reg_ach

    left join ts_bn bn
    on bn.id_bn = reg.id_bn

    left join interceros ter
    on ter.id_mae_ter = ach.id_tercero

    ORDER BY ter.num_doc


)ach
on ach.rn = 1
and ach.num_doc = comi.nitocc

where
comi.id_comision = $P{id_comision}
and comi.vigencia = $P{vigencia}

order by
obj.nitocc]]>
	</queryString>
	<field name="ID_COMISION" class="java.math.BigDecimal"/>
	<field name="NITOCC" class="java.math.BigDecimal"/>
	<field name="ID_TRANSPORTE" class="java.math.BigDecimal"/>
	<field name="SUELDO" class="java.math.BigDecimal"/>
	<field name="CARGO" class="java.math.BigDecimal"/>
	<field name="FECHA_SALIDA" class="java.sql.Timestamp"/>
	<field name="DIAS" class="java.math.BigDecimal"/>
	<field name="CODREG" class="java.lang.String"/>
	<field name="TOTAL_COMISION" class="java.math.BigDecimal"/>
	<field name="ESTADO" class="java.math.BigDecimal"/>
	<field name="FECHA_REGRESO" class="java.sql.Timestamp"/>
	<field name="VIGENCIA" class="java.math.BigDecimal"/>
	<field name="GASTOS_TAXIS" class="java.math.BigDecimal"/>
	<field name="DIAS_MANU" class="java.math.BigDecimal"/>
	<field name="NITOCC_JEFE" class="java.math.BigDecimal"/>
	<field name="FECHA_REAL" class="java.sql.Timestamp"/>
	<field name="CARGO_TEXTO" class="java.lang.String"/>
	<field name="RAZSOC" class="java.lang.String"/>
	<field name="TIPTER" class="java.lang.String"/>
	<field name="TIPO_TERCERO" class="java.lang.String"/>
	<field name="ESTADO_TER" class="java.math.BigDecimal"/>
	<field name="EMAIL" class="java.lang.String"/>
	<field name="SUELDO_TER" class="java.math.BigDecimal"/>
	<field name="CARGO_TER" class="java.lang.String"/>
	<field name="CARGO_TEXTO_TER" class="java.lang.String"/>
	<field name="DESREG" class="java.lang.String"/>
	<field name="CIUCED" class="java.lang.String"/>
	<field name="BANCO" class="java.lang.String"/>
	<field name="TIPO_CUENTA" class="java.lang.String"/>
	<field name="TIPO_CUENTA_TEXTO" class="java.lang.String"/>
	<field name="NUM_CUENTA" class="java.lang.String"/>
	<field name="CODOBJ" class="java.lang.String"/>
	<field name="VALOR" class="java.math.BigDecimal"/>
	<field name="VALOR_GASTO" class="java.math.BigDecimal"/>
	<field name="VIATICOS" class="java.math.BigDecimal"/>
	<field name="ACUMULADO_GASTOS" class="java.math.BigDecimal"/>
	<field name="TAXIS" class="java.math.BigDecimal"/>
	<field name="TARIFA" class="java.math.BigDecimal"/>
	<variable name="total" class="java.math.BigDecimal" calculation="Sum">
		<variableExpression><![CDATA[$F{VALOR}]]></variableExpression>
		<initialValueExpression><![CDATA[0]]></initialValueExpression>
	</variable>
	<columnHeader>
		<band height="30" splitType="Stretch">
			<staticText>
				<reportElement mode="Transparent" x="0" y="10" width="70" height="20" backcolor="#FEFEFE"/>
				<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="8" isBold="true"/>
				</textElement>
				<text><![CDATA[TIPO DE COMISIONADO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="70" y="10" width="100" height="20" backcolor="#FEFEFE"/>
				<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="8" isBold="true"/>
				</textElement>
				<text><![CDATA[NOMBRE COMISIONADO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="170" y="10" width="60" height="20" backcolor="#FEFEFE"/>
				<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="8" isBold="true"/>
				</textElement>
				<text><![CDATA[CEDULA No.]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="230" y="10" width="60" height="20" backcolor="#FEFEFE"/>
				<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="8" isBold="true"/>
				</textElement>
				<text><![CDATA[SUELDO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="290" y="10" width="100" height="20" backcolor="#FEFEFE"/>
				<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="8" isBold="true"/>
				</textElement>
				<text><![CDATA[CARGO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="390" y="10" width="70" height="20" backcolor="#FEFEFE"/>
				<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="8" isBold="true"/>
				</textElement>
				<text><![CDATA[VALOR VIÁTICO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="630" y="10" width="70" height="20" backcolor="#FEFEFE"/>
				<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="8" isBold="true"/>
				</textElement>
				<text><![CDATA[TIPO CUENTA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="530" y="10" width="100" height="20" backcolor="#FEFEFE"/>
				<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="8" isBold="true"/>
				</textElement>
				<text><![CDATA[No. CUENTA BANCARIA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="460" y="10" width="70" height="20" backcolor="#FEFEFE"/>
				<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="8" isBold="true"/>
				</textElement>
				<text><![CDATA[SEDE]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="700" y="10" width="50" height="20" backcolor="#FEFEFE"/>
				<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="8" isBold="true"/>
				</textElement>
				<text><![CDATA[FECHA INICIAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="750" y="10" width="50" height="20" backcolor="#FEFEFE"/>
				<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="8" isBold="true"/>
				</textElement>
				<text><![CDATA[FECHA FINAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="960" y="10" width="50" height="20" backcolor="#FEFEFE"/>
				<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="8" isBold="true"/>
				</textElement>
				<text><![CDATA[No. DÍAS]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="880" y="10" width="80" height="20" backcolor="#FEFEFE"/>
				<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="8" isBold="true"/>
				</textElement>
				<text><![CDATA[CIUDAD O MUNICIPIO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="800" y="10" width="80" height="20" backcolor="#FEFEFE"/>
				<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="8" isBold="true"/>
				</textElement>
				<text><![CDATA[DEPARTAMENTO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="1010" y="10" width="50" height="20" backcolor="#FEFEFE"/>
				<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="8" isBold="true"/>
				</textElement>
				<text><![CDATA[TOTAL DÍAS]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="1060" y="10" width="90" height="20" backcolor="#FEFEFE"/>
				<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="8" isBold="true"/>
				</textElement>
				<text><![CDATA[TOTAL VIÁTICOS]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="20" splitType="Stretch">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="0" y="0" width="70" height="20" backcolor="#FEFEFE"/>
				<box leftPadding="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="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TIPO_TERCERO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="70" y="0" width="100" height="20" backcolor="#FEFEFE"/>
				<box leftPadding="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="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZSOC}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="170" y="0" width="60" height="20" backcolor="#FEFEFE"/>
				<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="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NITOCC}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="$ #,##0;(-#,##0)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="230" y="0" width="60" height="20" backcolor="#FEFEFE"/>
				<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="8"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{SUELDO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="290" y="0" width="100" height="20" backcolor="#FEFEFE"/>
				<box leftPadding="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="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CARGO} + " " + $F{CARGO_TEXTO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="$ #,##0;(-#,##0)" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="390" y="0" width="70" height="20" backcolor="#FEFEFE"/>
				<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="8"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{TARIFA}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="460" y="0" width="70" height="20" backcolor="#FEFEFE"/>
				<box leftPadding="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="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CIUCED}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="530" y="0" width="100" height="20" backcolor="#FEFEFE"/>
				<box leftPadding="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="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[( $F{NUM_CUENTA}.length() > 0
    ? $F{NUM_CUENTA} + "\n" + $F{BANCO}
    : null
)]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="630" y="0" width="70" height="20" backcolor="#FEFEFE"/>
				<box leftPadding="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="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TIPO_CUENTA_TEXTO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1010" y="0" width="50" height="20" backcolor="#FEFEFE"/>
				<box leftPadding="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="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DIAS}]]></textFieldExpression>
			</textField>
			<textField pattern="$ #,##0.00;(#,##0.00)">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1060" y="0" width="90" height="20" backcolor="#FEFEFE"/>
				<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" markup="none">
					<font size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR}]]></textFieldExpression>
			</textField>
			<subreport>
				<reportElement stretchType="RelativeToTallestObject" x="700" y="0" width="310" height="20"/>
				<subreportParameter name="id_comision">
					<subreportParameterExpression><![CDATA[$F{ID_COMISION}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="nitocc">
					<subreportParameterExpression><![CDATA[$F{NITOCC}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="vigencia">
					<subreportParameterExpression><![CDATA[$F{VIGENCIA}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression class="java.lang.String"><![CDATA["repo:formato_programacion_comision_destinos"]]></subreportExpression>
			</subreport>
		</band>
	</detail>
	<summary>
		<band height="40">
			<staticText>
				<reportElement mode="Opaque" x="880" y="7" width="180" height="25" backcolor="#D1E9FE"/>
				<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="8" isBold="true"/>
				</textElement>
				<text><![CDATA[TOTAL SOLICITUD FUNCIONARIOS]]></text>
			</staticText>
			<textField pattern="$ #,##0.00;(#,##0.00)">
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="1060" y="7" width="90" height="25" backcolor="#D1E9FE"/>
				<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" markup="none">
					<font size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
	<noData>
		<band height="40">
			<textField pattern="$ #,##0.00;(#,##0.00)">
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="1060" y="8" width="90" height="25" backcolor="#D1E9FE"/>
				<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" markup="none">
					<font size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{total}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="880" y="8" width="180" height="25" backcolor="#D1E9FE"/>
				<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="8" isBold="true"/>
				</textElement>
				<text><![CDATA[TOTAL SOLICITUD FUNCIONARIOS]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
