<?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="inf_devolutivo_individual" pageWidth="1650" pageHeight="842" columnWidth="1610" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="0.9313819845887331"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/inventario/inf_devolutivo_individual_anmsgr"/>
	<property name="ireport.jasperserver.url" value="http://192.168.2.43:8090/jasperserver/services/repository"/>
	<parameter name="vigencia" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_meses" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="id_mae_ter" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereCenOp" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTercero" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereEstructura" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereEspacio" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereTipoAlmacenamiento" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereLinea" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereClase" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereCatalogo" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereCostoInicial" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
		<defaultValueExpression><![CDATA["/home/dortega/Reportes Jasper/Reportes Jasper Inventario/Informe Devolutivo Individual/"]]></defaultValueExpression>
	</parameter>
	<parameter name="num_doc" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select *
from interceros_v
where num_doc=$P{num_doc}]]>
	</queryString>
	<field name="ID_MAE_TER" class="java.math.BigDecimal"/>
	<field name="ID_NAT_JUR" class="java.math.BigDecimal"/>
	<field name="ID_TIP_TER" class="java.math.BigDecimal"/>
	<field name="ID_TIPO_DOC" class="java.math.BigDecimal"/>
	<field name="NUM_DOC" class="java.lang.String"/>
	<field name="CODIGO" class="java.math.BigDecimal"/>
	<field name="CAM_COM" class="java.lang.String"/>
	<field name="PNOMBRE" class="java.lang.String"/>
	<field name="SNOMBRE" class="java.lang.String"/>
	<field name="ESTADO_TER" class="java.math.BigDecimal"/>
	<field name="FECHA_DOC" class="java.sql.Timestamp"/>
	<field name="PAPELLIDO" class="java.lang.String"/>
	<field name="SAPELLIDO" class="java.lang.String"/>
	<field name="NMATRICULA" class="java.lang.String"/>
	<field name="NMATRICULAMER" class="java.lang.String"/>
	<field name="PROFESION" class="java.lang.String"/>
	<field name="DV" class="java.math.BigDecimal"/>
	<field name="OBJETIVO" class="java.lang.String"/>
	<field name="RAZON_SOC" class="java.lang.String"/>
	<field name="RETEIVA" class="java.math.BigDecimal"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="77" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="1267" y="27" width="343" height="16" forecolor="#000000" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="6"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="10" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Fecha de Impresión:]]></text>
			</staticText>
			<image>
				<reportElement x="0" y="0" width="220" height="77"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
			<textField pattern="dd/MM/yyyy h:mm a">
				<reportElement x="1267" y="43" width="343" height="16"/>
				<box leftPadding="2" rightPadding="6"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="10"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="209" y="0" width="1000" height="59"/>
				<textElement textAlignment="Center" verticalAlignment="Bottom" markup="none">
					<font fontName="SansSerif" size="24" isBold="true"/>
				</textElement>
				<text><![CDATA[Control De Recursos Físicos
Informe Devolutivo y Consumo Individual]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="209" y="59" width="1000" height="18">
					<printWhenExpression><![CDATA[$P{vigencia} !=null]]></printWhenExpression>
				</reportElement>
				<box leftPadding="2" rightPadding="2">
					<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">
					<font size="14" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Periodo de "+$P{id_meses}+" del "+$P{vigencia}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="25" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="209" height="20" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="13" isBold="true" isUnderline="true"/>
				</textElement>
				<text><![CDATA[Inventario de Devolutivos:]]></text>
			</staticText>
		</band>
	</pageHeader>
	<detail>
		<band height="128" splitType="Stretch">
			<printWhenExpression><![CDATA[$P{vigencia}!=null]]></printWhenExpression>
			<subreport>
				<reportElement x="1" y="0" width="1609" height="125" isRemoveLineWhenBlank="true"/>
				<subreportParameter name="whereCatalogo">
					<subreportParameterExpression><![CDATA[$P{whereCatalogo}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="whereTipoAlmacenamiento">
					<subreportParameterExpression><![CDATA[$P{whereTipoAlmacenamiento}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="id_meses">
					<subreportParameterExpression><![CDATA[$P{id_meses}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="whereEspacio">
					<subreportParameterExpression><![CDATA[$P{whereEspacio}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="num_doc">
					<subreportParameterExpression><![CDATA[$F{NUM_DOC}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="whereTercero">
					<subreportParameterExpression><![CDATA[$P{whereTercero}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="whereEstructura">
					<subreportParameterExpression><![CDATA[$P{whereEstructura}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="vigencia">
					<subreportParameterExpression><![CDATA[$P{vigencia}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="whereCenOp">
					<subreportParameterExpression><![CDATA[$P{whereCenOp}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="whereCostoInicial">
					<subreportParameterExpression><![CDATA[$P{whereCostoInicial}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="whereClase">
					<subreportParameterExpression><![CDATA[$P{whereClase}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="whereLinea">
					<subreportParameterExpression><![CDATA[$P{whereLinea}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression class="java.lang.String"><![CDATA["repo:devolutivo_individual_subreport.jrxml"]]></subreportExpression>
			</subreport>
		</band>
	</detail>
	<pageFooter>
		<band height="24" splitType="Stretch">
			<printWhenExpression><![CDATA[$P{vigencia}!=null]]></printWhenExpression>
			<textField>
				<reportElement mode="Opaque" x="629" 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="718" y="12" width="60" height="12" forecolor="#575757" backcolor="#FFFFFF"/>
				<box leftPadding="2"/>
				<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.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="629" y="0" width="173" height="12" forecolor="#575757"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<text><![CDATA[Websafi - Control De Recursos Físicos
]]></text>
			</staticText>
		</band>
	</pageFooter>
	<summary>
		<band height="314" splitType="Stretch">
			<subreport>
				<reportElement x="209" y="18" width="1401" height="125"/>
				<subreportParameter name="whereCatalogo">
					<subreportParameterExpression><![CDATA[$P{whereCatalogo}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="whereTipoAlmacenamiento">
					<subreportParameterExpression><![CDATA[$P{whereTipoAlmacenamiento}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="id_meses">
					<subreportParameterExpression><![CDATA[$P{id_meses}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="whereEspacio">
					<subreportParameterExpression><![CDATA[$P{whereEspacio}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="num_doc">
					<subreportParameterExpression><![CDATA[$F{NUM_DOC}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="whereTercero">
					<subreportParameterExpression><![CDATA[$P{whereTercero}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="whereEstructura">
					<subreportParameterExpression><![CDATA[$P{whereEstructura}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="vigencia">
					<subreportParameterExpression><![CDATA[$P{vigencia}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="whereCenOp">
					<subreportParameterExpression><![CDATA[$P{whereCenOp}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="whereCostoInicial">
					<subreportParameterExpression><![CDATA[$P{whereCostoInicial}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="whereClase">
					<subreportParameterExpression><![CDATA[$P{whereClase}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="whereLinea">
					<subreportParameterExpression><![CDATA[$P{whereLinea}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression class="java.lang.String"><![CDATA["repo:consumo_individual_subreport.jrxml"]]></subreportExpression>
			</subreport>
			<staticText>
				<reportElement mode="Opaque" x="1" y="18" width="208" height="25" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="14" isBold="true" isUnderline="true"/>
				</textElement>
				<text><![CDATA[Inventario de Consumo:]]></text>
			</staticText>
			<textField>
				<reportElement positionType="FixRelativeToBottom" x="1142" y="188" width="468" height="20"/>
				<box>
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="false" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOC}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement positionType="FixRelativeToBottom" x="428" y="168" width="159" height="20"/>
				<textElement>
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[Observaciones :]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="FixRelativeToBottom" x="587" y="208" width="400" height="20"/>
				<box>
					<bottomPen lineWidth="0.75"/>
				</box>
				<textElement/>
				<text><![CDATA[]]></text>
			</staticText>
			<textField>
				<reportElement positionType="FixRelativeToBottom" x="140" y="168" width="288" height="60"/>
				<box topPadding="3" leftPadding="3">
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Top">
					<font size="11" isBold="false" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOC}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement positionType="FixRelativeToBottom" x="587" y="168" width="400" height="20"/>
				<box>
					<bottomPen lineWidth="0.75"/>
				</box>
				<textElement/>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="FixRelativeToBottom" x="587" y="188" width="400" height="20"/>
				<box>
					<bottomPen lineWidth="0.75"/>
				</box>
				<textElement/>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="FixRelativeToBottom" x="0" y="168" width="140" height="20"/>
				<textElement>
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[Responsable :]]></text>
			</staticText>
			<textField>
				<reportElement positionType="FixRelativeToBottom" x="1142" y="208" width="468" height="20"/>
				<box leftPadding="2" rightPadding="2">
					<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">
					<font size="11" isBold="false" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["CC/NIT "+$F{NUM_DOC}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement positionType="FixRelativeToBottom" mode="Opaque" x="0" y="143" width="141" height="25" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="14" isBold="true" isUnderline="false"/>
				</textElement>
				<text><![CDATA[Firma ANM]]></text>
			</staticText>
			<textField>
				<reportElement positionType="FixRelativeToBottom" x="1143" y="293" width="468" height="20"/>
				<box leftPadding="2" rightPadding="2">
					<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">
					<font size="11" isBold="false" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["CC/NIT "+$F{NUM_DOC}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement positionType="FixRelativeToBottom" mode="Opaque" x="1" y="228" width="139" height="25" backcolor="#FFFFFF"/>
				<box leftPadding="2" rightPadding="2">
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="14" isBold="true" isUnderline="false"/>
				</textElement>
				<text><![CDATA[Firma SGR]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="FixRelativeToBottom" x="1" y="253" width="140" height="20"/>
				<textElement>
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[Responsable :]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="FixRelativeToBottom" x="588" y="273" width="400" height="20"/>
				<box>
					<bottomPen lineWidth="0.75"/>
				</box>
				<textElement/>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="FixRelativeToBottom" x="588" y="253" width="400" height="20"/>
				<box>
					<bottomPen lineWidth="0.75"/>
				</box>
				<textElement/>
				<text><![CDATA[]]></text>
			</staticText>
			<textField>
				<reportElement positionType="FixRelativeToBottom" x="141" y="253" width="288" height="60"/>
				<box topPadding="3" leftPadding="3">
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement verticalAlignment="Top">
					<font size="11" isBold="false" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOC}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement positionType="FixRelativeToBottom" x="588" y="293" width="400" height="20"/>
				<box>
					<bottomPen lineWidth="0.75"/>
				</box>
				<textElement/>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="FixRelativeToBottom" x="429" y="253" width="159" height="20"/>
				<textElement>
					<font size="11" isBold="true"/>
				</textElement>
				<text><![CDATA[Observaciones :]]></text>
			</staticText>
			<textField>
				<reportElement positionType="FixRelativeToBottom" x="1143" y="273" width="468" height="20"/>
				<box>
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="11" isBold="false" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{RAZON_SOC}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
</jasperReport>
