<?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="funciones" language="groovy" pageWidth="572" pageHeight="555" orientation="Landscape" columnWidth="572" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0">
	<property name="ireport.zoom" value="1.771561000000001"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="id_mf" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT
mffe.*,
mffed.codigo,
replace(replace(mffed.funcion,chr(10),''),chr(13),'') as funcion

FROM rh_mf_fe mffe

left join rh_mf_fe_d mffed
on mffed.id_fe = mffe.id_mf_fe

where
mffe.id_mf = $P{id_mf}

order by
mffed.codigo]]>
	</queryString>
	<field name="ID_MF_FE" class="java.math.BigDecimal"/>
	<field name="ID_MF" class="java.math.BigDecimal"/>
	<field name="CODIGO" class="java.math.BigDecimal"/>
	<field name="FUNCION" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<columnHeader>
		<band height="20" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement mode="Opaque" x="0" y="0" width="572" height="20" forecolor="#000000"/>
				<box topPadding="0" leftPadding="2">
					<pen lineWidth="0.0" lineStyle="Solid"/>
					<topPen lineWidth="0.0" lineStyle="Solid"/>
					<leftPen lineWidth="0.0" lineStyle="Solid"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid"/>
					<rightPen lineWidth="0.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="7" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Funciones del cargo:"]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="12" splitType="Stretch">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement mode="Opaque" x="0" y="0" width="572" height="12" forecolor="#000000"/>
				<box topPadding="0" leftPadding="2">
					<pen lineWidth="0.0" lineStyle="Solid"/>
					<topPen lineWidth="0.0" lineStyle="Solid"/>
					<leftPen lineWidth="0.0" lineStyle="Solid"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid"/>
					<rightPen lineWidth="0.0" lineStyle="Solid"/>
				</box>
				<textElement textAlignment="Justified" verticalAlignment="Middle" markup="none">
					<font fontName="SansSerif" size="7" isBold="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{FUNCION}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
</jasperReport>
