<?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_conexo" language="groovy" pageWidth="1600" pageHeight="800" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="1560" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.207882500000003"/>
	<property name="ireport.x" value="491"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/comisiones/formato_programacion_comision_conexo_2021"/>
	<property name="ireport.jasperserver.url" value="http://3.22.202.200:8080/jasperserver/services/repository"/>
	<parameter name="id_comision" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="vigencia" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="entidad" class="java.lang.String">
		<defaultValueExpression><![CDATA["PGN"]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT

sysdate as fecha_impresion,
case when nvl(tab0.pasaje_aereo,0) = 1 then 'Si' else 'No' end as pasaje_aereoo,
tab0.vigencia,
tab0.activo,
tab0.valor,
tab0.id,
tab0.descomi,
tab0.objetivo,
tab0.actividad,
tab0.razon_soc_terlog,
to_char(nvl(tab0.cdp,'')) as no_cdp,
case when tab0.viaticos > 0 then 'Si' else 'No' end as genera_viaticos,
to_char(tab0.observa) as observacion,
jefproy.razon_soc as razon_soc_jefe_proy,
jefproy.num_doc as num_doc_jefe_proy,
tab9.descripcion as descripcion_area,
tab0.codpro as codpro,
tab10.descripcion as descripcion_proyectos,
tab0.tipo_transporte,

case when tab0.interrupcion = 1 then ' - Con Interrupción ' else ' ' end as text_interrupcion,

tab0.id_original,
case when comori.id is not null then ' - No.' || comori.id
else ' ' end as text_comorig,

tab0.tipo_gasto,
case when comdep.id is not null then 'Si' || ' - No.' || comdep.id
else 'No' end AS TEXT_TIPO_GASTO,

tab0.nitocc_vobo as  nitocc_vobo,
to_char(tervobo.razsoc) as razsoc_tervobo,
to_char(tervobo.tipter) as tipter_tervobo


FROM comisiones_v tab0
left join proyectos proy on proy.id=tab0.id_proyectos
left join interceros jefproy on jefproy.id_mae_ter = proy.jefe_proyecto
left join areas tab9 on tab0.codare = tab9.codigo
left join proyectos tab10 on tab0.codpro=tab10.codigo and tab0.vigencia=tab10.ano_fiscal

left join comisiones comdep
on  comdep.id_original = tab0.id
and comdep.vigencia = tab0.vigencia
and comdep.activo != -1

left join comisiones comori
on  comori.id = tab0.id_original
and comori.vigencia = tab0.vigencia
and comori.activo != -1

left join terceros tervobo
on tervobo.nitocc = tab0.nitocc_vobo

where
tab0.id_comisiones = $P{id_comision}
and tab0.vigencia = $P{vigencia}
and rownum=1

order by
tab0.vigencia,
tab0.id_comisiones]]>
	</queryString>
	<field name="FECHA_IMPRESION" class="java.sql.Timestamp"/>
	<field name="PASAJE_AEREOO" class="java.lang.String"/>
	<field name="VIGENCIA" class="java.math.BigDecimal"/>
	<field name="ACTIVO" class="java.math.BigDecimal"/>
	<field name="VALOR" class="java.math.BigDecimal"/>
	<field name="ID" class="java.math.BigDecimal"/>
	<field name="DESCOMI" class="java.lang.String"/>
	<field name="OBJETIVO" class="java.lang.String"/>
	<field name="ACTIVIDAD" class="java.lang.String"/>
	<field name="RAZON_SOC_TERLOG" class="java.lang.String"/>
	<field name="NO_CDP" class="java.lang.String"/>
	<field name="GENERA_VIATICOS" class="java.lang.String"/>
	<field name="OBSERVACION" class="java.lang.String"/>
	<field name="RAZON_SOC_JEFE_PROY" class="java.lang.String"/>
	<field name="NUM_DOC_JEFE_PROY" class="java.lang.String"/>
	<field name="DESCRIPCION_AREA" class="java.lang.String"/>
	<field name="CODPRO" class="java.lang.String"/>
	<field name="DESCRIPCION_PROYECTOS" class="java.lang.String"/>
	<field name="TIPO_TRANSPORTE" class="java.lang.String"/>
	<field name="TEXT_INTERRUPCION" class="java.lang.String"/>
	<field name="ID_ORIGINAL" class="java.math.BigDecimal"/>
	<field name="TEXT_COMORIG" class="java.lang.String"/>
	<field name="TIPO_GASTO" class="java.math.BigDecimal"/>
	<field name="TEXT_TIPO_GASTO" class="java.lang.String"/>
	<field name="NITOCC_VOBO" class="java.math.BigDecimal"/>
	<field name="RAZSOC_TERVOBO" class="java.lang.String"/>
	<field name="TIPTER_TERVOBO" class="java.lang.String"/>
	<background>
		<band height="760" splitType="Stretch">
			<image>
				<reportElement x="433" y="0" width="808" height="760">
					<printWhenExpression><![CDATA[$F{ACTIVO}.toString()=="0" ?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:wmcerrado"]]></imageExpression>
			</image>
			<image>
				<reportElement x="433" y="0" width="808" height="760">
					<printWhenExpression><![CDATA[$F{ACTIVO}.toString()=="1" ?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:wmactivo"]]></imageExpression>
			</image>
			<image>
				<reportElement x="433" y="0" width="808" height="760">
					<printWhenExpression><![CDATA[$F{ACTIVO}.toString()=="-1" ?Boolean.TRUE:Boolean.FALSE]]></printWhenExpression>
				</reportElement>
				<imageExpression class="java.lang.String"><![CDATA["repo:wmanulado"]]></imageExpression>
			</image>
		</band>
	</background>
	<pageHeader>
		<band height="122">
			<frame>
				<reportElement x="140" y="0" width="1420" height="60"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
			</frame>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="92" width="250" height="20" backcolor="#E6E6E6"/>
				<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">
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESCRIPCION_AREA}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="0" y="72" width="250" 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="9" isBold="true"/>
				</textElement>
				<text><![CDATA[AREA]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="994" y="92" width="126" height="20" backcolor="#E6E6E6"/>
				<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="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TIPO_TRANSPORTE}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="994" y="72" width="126" 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="9" isBold="true"/>
				</textElement>
				<text><![CDATA[TIPO DE TRANSPORTE]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="1120" y="72" width="105" 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="9" isBold="true"/>
				</textElement>
				<text><![CDATA[REQUIERE PASAJES AEREOS]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="1120" y="92" width="105" height="20" backcolor="#E6E6E6"/>
				<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="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{PASAJE_AEREOO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="1400" y="72" width="160" 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="9" isBold="true"/>
				</textElement>
				<text><![CDATA[FECHA Y HORA DE IMPRESIÓN]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" pattern="dd/MM/yyyy H:m:s" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="1400" y="92" width="160" height="20" backcolor="#E6E6E6"/>
				<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="9"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{FECHA_IMPRESION}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="1325" y="72" width="75" 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="9" isBold="true"/>
				</textElement>
				<text><![CDATA[CONSECUTIVO]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="1325" y="92" width="75" height="20" backcolor="#E6E6E6"/>
				<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="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ID}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="764" y="92" width="95" height="20" backcolor="#E6E6E6"/>
				<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="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{GENERA_VIATICOS}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="859" y="92" width="135" height="20" backcolor="#E6E6E6"/>
				<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">
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESCOMI} + $F{TEXT_COMORIG} + $F{TEXT_INTERRUPCION}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="764" y="72" width="95" 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="9" isBold="true"/>
				</textElement>
				<text><![CDATA[GENERA VIÁTICOS]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="674" y="92" width="90" height="20" backcolor="#E6E6E6"/>
				<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="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NO_CDP}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="674" y="72" 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="9" isBold="true"/>
				</textElement>
				<text><![CDATA[N° CDP DE VIÁTICOS]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="859" y="72" width="135" 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="9" isBold="true"/>
				</textElement>
				<text><![CDATA[TIPO DE COMISIÓN]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="250" y="72" width="124" 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="9" isBold="true"/>
				</textElement>
				<text><![CDATA[CÓDIGO DE PROYECTO]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="250" y="92" width="124" height="20" backcolor="#E6E6E6"/>
				<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">
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CODPRO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="374" y="72" width="300" 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="9" isBold="true"/>
				</textElement>
				<text><![CDATA[NOMBRE DEL PROYECTO]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="374" y="92" width="300" height="20" backcolor="#E6E6E6"/>
				<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">
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DESCRIPCION_PROYECTOS}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="1225" y="72" 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="9" isBold="true"/>
				</textElement>
				<text><![CDATA[REQUIERE GASTOS CONEXOS]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="1225" y="92" width="100" height="20" backcolor="#E6E6E6"/>
				<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="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{TEXT_TIPO_GASTO}]]></textFieldExpression>
			</textField>
			<rectangle>
				<reportElement x="0" y="0" width="140" height="60"/>
			</rectangle>
			<textField>
				<reportElement x="140" y="0" width="1420" height="45"/>
				<box>
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="16" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["PROGRAMACIÓN DE RECURSOS POR COMISIÓN O DESPLAZAMIENTO  - " + $P{entidad}]]></textFieldExpression>
			</textField>
			<image>
				<reportElement x="0" y="0" width="140" height="60"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa.jpg"]]></imageExpression>
			</image>
		</band>
	</pageHeader>
	<detail>
		<band height="62" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="734" height="12" backcolor="#E6E6E6"/>
				<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="9" isBold="true"/>
				</textElement>
				<text><![CDATA[OBJETO DE LA COMISIÓN]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement mode="Transparent" x="0" y="12" width="734" height="50" backcolor="#FEFEFE"/>
				<box topPadding="2" 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="Justified" verticalAlignment="Top" markup="html">
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{OBJETIVO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="834" y="0" width="726" height="12" backcolor="#E6E6E6"/>
				<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="9" isBold="true"/>
				</textElement>
				<text><![CDATA[ACTIVIDADES]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement mode="Transparent" x="834" y="12" width="726" height="50" backcolor="#FEFEFE"/>
				<box topPadding="2" 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="Justified" verticalAlignment="Top" markup="html">
					<font size="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ACTIVIDAD}]]></textFieldExpression>
			</textField>
		</band>
		<band height="52" splitType="Stretch">
			<subreport>
				<reportElement stretchType="RelativeToTallestObject" x="0" y="12" width="1560" height="40" isRemoveLineWhenBlank="true"/>
				<subreportParameter name="id_comision">
					<subreportParameterExpression><![CDATA[$F{ID}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="entidad">
					<subreportParameterExpression><![CDATA[$P{entidad}]]></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_planta"]]></subreportExpression>
			</subreport>
		</band>
		<band height="52">
			<subreport>
				<reportElement stretchType="RelativeToTallestObject" x="0" y="12" width="1560" height="40" isRemoveLineWhenBlank="true"/>
				<subreportParameter name="id_comision">
					<subreportParameterExpression><![CDATA[$F{ID}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="entidad">
					<subreportParameterExpression><![CDATA[$P{entidad}]]></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_contrato"]]></subreportExpression>
			</subreport>
		</band>
	</detail>
	<pageFooter>
		<band height="25">
			<textField>
				<reportElement x="1270" y="10" width="145" height="15"/>
				<box>
					<topPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="12" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Paginas"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Opaque" x="1415" y="10" width="55" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<topPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="12" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{PAGE_NUMBER}+" de "]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement mode="Opaque" x="1470" y="10" width="90" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<topPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="12" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<lastPageFooter>
		<band height="210">
			<staticText>
				<reportElement mode="Transparent" x="384" y="150" width="350" height="20" backcolor="#FEFEFE"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[FIRMA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Transparent" x="0" y="180" width="100" height="30" forecolor="#000000" backcolor="#FFFFFF"/>
				<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="9" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[PROGRAMADOR]]></text>
			</staticText>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="100" y="180" width="190" height="30" forecolor="#000000" backcolor="#E6E6E6"/>
				<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="9" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOC_TERLOG}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement mode="Opaque" x="384" y="170" width="350" height="20" backcolor="#E6E6E6"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font size="9" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOC_JEFE_PROY}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement mode="Opaque" x="384" y="190" width="350" height="20" backcolor="#E6E6E6"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font size="9" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NUM_DOC_JEFE_PROY}]]></textFieldExpression>
			</textField>
			<textField pattern="$ #,##0.00;(#,##0.00)">
				<reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="1455" y="0" width="105" height="25" backcolor="#B6D2A2"/>
				<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="Center" verticalAlignment="Middle" markup="none">
					<font size="9" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VALOR}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="140" y="0" width="1090" height="75" backcolor="#E6E6E6"/>
				<box topPadding="2" leftPadding="2" 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="Justified" verticalAlignment="Middle" markup="html">
					<font fontName="SansSerif" size="10" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{OBSERVACION}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="0" y="0" width="140" height="75" forecolor="#000000" backcolor="#FFFFFF"/>
				<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="9" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Justificación - Observaciones]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1270" y="0" width="185" height="25" backcolor="#B6D2A2"/>
				<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="9" isBold="true"/>
				</textElement>
				<text><![CDATA[TOTAL SOLICITUD COMISIÓN FUNCIONARIOS Y CONTRATISTAS]]></text>
			</staticText>
			<textField>
				<reportElement mode="Opaque" x="1415" y="195" width="55" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<topPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="12" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{PAGE_NUMBER}+" de "]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement mode="Opaque" x="1470" y="195" width="90" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<topPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="12" 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 x="1270" y="195" width="145" height="15"/>
				<box>
					<topPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="12" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Paginas"]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement mode="Opaque" x="834" y="170" width="350" height="20" backcolor="#E6E6E6"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font size="9" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZSOC_TERVOBO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="834" y="150" width="350" height="20" backcolor="#FEFEFE"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="9" isBold="true"/>
				</textElement>
				<text><![CDATA[Vo.Bo]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement mode="Opaque" x="834" y="190" width="350" height="20" backcolor="#E6E6E6"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="none">
					<font size="9" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{NITOCC_VOBO}]]></textFieldExpression>
			</textField>
		</band>
	</lastPageFooter>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="1560" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
