<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.8.0.final using JasperReports Library version 6.8.0-2ed8dfabb690ff337a5797129f2cd92902b0c87b  -->
<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="Colaboradores_sin_asignacion" pageWidth="792" pageHeight="612" orientation="Landscape" columnWidth="572" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="4eedbb89-b4f6-4469-9ab6-f642a1688cf7">
	<property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true"/>
	<property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns" value="true"/>
	<property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>
	<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="Inceptio"/>
	<property name="com.jaspersoft.studio.unit." value="pixel"/>
	<property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
	<property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
	<property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="214"/>
	<property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="775"/>
	<style name="Title" forecolor="#FFFFFF" fontName="Times New Roman" fontSize="50" isBold="false" pdfFontName="Times-Bold"/>
	<style name="SubTitle" forecolor="#CCCCCC" fontName="Times New Roman" fontSize="18" isBold="false" pdfFontName="Times-Roman"/>
	<style name="Column header" forecolor="#666666" fontName="Times New Roman" fontSize="14" isBold="true"/>
	<style name="Detail" mode="Transparent" fontName="Times New Roman"/>
	<style name="Row" mode="Transparent" fontName="Times New Roman" pdfFontName="Times-Roman">
		<conditionalStyle>
			<conditionExpression><![CDATA[$V{REPORT_COUNT}%2 == 0]]></conditionExpression>
			<style mode="Opaque" backcolor="#EEEFF0"/>
		</conditionalStyle>
	</style>
	<style name="Table">
		<box>
			<pen lineWidth="1.0" lineColor="#000000"/>
			<topPen lineWidth="1.0" lineColor="#000000"/>
			<leftPen lineWidth="1.0" lineColor="#000000"/>
			<bottomPen lineWidth="1.0" lineColor="#000000"/>
			<rightPen lineWidth="1.0" lineColor="#000000"/>
		</box>
	</style>
	<style name="Table_TH" mode="Opaque" backcolor="#FFFFFF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
			<topPen lineWidth="0.5" lineColor="#000000"/>
			<leftPen lineWidth="0.5" lineColor="#000000"/>
			<bottomPen lineWidth="0.5" lineColor="#000000"/>
			<rightPen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="Table_CH" mode="Opaque" backcolor="#CACED0">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
			<topPen lineWidth="0.5" lineColor="#000000"/>
			<leftPen lineWidth="0.5" lineColor="#000000"/>
			<bottomPen lineWidth="0.5" lineColor="#000000"/>
			<rightPen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="Table_TD" mode="Opaque" backcolor="#FFFFFF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
			<topPen lineWidth="0.5" lineColor="#000000"/>
			<leftPen lineWidth="0.5" lineColor="#000000"/>
			<bottomPen lineWidth="0.5" lineColor="#000000"/>
			<rightPen lineWidth="0.5" lineColor="#000000"/>
		</box>
		<conditionalStyle>
			<conditionExpression><![CDATA[$V{REPORT_COUNT}%2 == 0]]></conditionExpression>
			<style backcolor="#D8D8D8"/>
		</conditionalStyle>
	</style>
	<subDataset name="tableDataset" uuid="f13e6d36-5148-4ecc-bbe3-3035def80980">
		<queryString>
			<![CDATA[]]>
		</queryString>
	</subDataset>
	<parameter name="logo" class="java.lang.String" isForPrompting="false">
		<parameterDescription><![CDATA[Ruta de la imagen]]></parameterDescription>
		<defaultValueExpression><![CDATA["D:/Inceptio/E360/Servicios/src/JasperFiles/Img/logo.png"]]></defaultValueExpression>
	</parameter>
	<queryString language="SQL">
		<![CDATA[SELECT c.Nomina, c.Nombre, c.ApellidoPaterno, c.ApellidoMaterno, c.FechaNacimiento, c.RFC, c.CURP, c.TelefonoCelular, c.EmailPersonal  FROM e3_colaborador c
LEFT JOIN e3_puestoporcolaborador ep ON c.ColaboradorId = ep.ColaboradorId 
WHERE c.EstatusColaboradorId = 1 GROUP BY c.ColaboradorId 
HAVING  SUM(IFNULL(Activo,0)) = 0]]>
	</queryString>
	<field name="Nomina" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="Nomina"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_colaborador"/>
	</field>
	<field name="Nombre" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="Nombre"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_colaborador"/>
	</field>
	<field name="ApellidoPaterno" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="ApellidoPaterno"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_colaborador"/>
	</field>
	<field name="ApellidoMaterno" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="ApellidoMaterno"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_colaborador"/>
	</field>
	<field name="FechaNacimiento" class="java.util.Date">
		<property name="com.jaspersoft.studio.field.label" value="FechaNacimiento"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_colaborador"/>
	</field>
	<field name="RFC" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="RFC"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_colaborador"/>
	</field>
	<field name="CURP" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="CURP"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_colaborador"/>
	</field>
	<field name="TelefonoCelular" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="TelefonoCelular"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_colaborador"/>
	</field>
	<field name="EmailPersonal" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="EmailPersonal"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="e3_colaborador"/>
	</field>
	<title>
		<band height="71" splitType="Stretch">
			<line>
				<reportElement x="0" y="67" width="750" height="1" uuid="806ce5df-1219-4876-ae0c-ca7405b1f246">
					<property name="local_mesure_unitheight" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
			</line>
			<image hAlign="Center">
				<reportElement x="0" y="0" width="65" height="60" uuid="94883631-a913-43e2-b182-ab8d77d0181e"/>
				<imageExpression><![CDATA[$P{logo}]]></imageExpression>
			</image>
			<staticText>
				<reportElement x="95" y="0" width="535" height="60" uuid="e622555d-198b-4ccd-a4a1-c59c53304058">
					<property name="local_mesure_unitheight" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Center">
					<font size="19" isBold="true"/>
				</textElement>
				<text><![CDATA[Lista de colaboradores sin asignación]]></text>
			</staticText>
		</band>
	</title>
	<columnHeader>
		<band height="42">
			<staticText>
				<reportElement x="0" y="17" width="50" height="18" uuid="052318c5-9ecb-414e-8fed-d7ede4daeb87">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="103777e8-ae85-44dc-ba0e-89bb71fb8076"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Nómina]]></text>
			</staticText>
			<staticText>
				<reportElement x="50" y="17" width="84" height="18" uuid="b7b5cfa1-608a-4361-8761-b8ff8ee9cba8">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="357673c3-51d3-4dd2-8933-1cc6ae973579"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Nombre]]></text>
			</staticText>
			<staticText>
				<reportElement x="134" y="17" width="84" height="18" uuid="d0f45439-b8e8-456e-9a42-2774b09cae85">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="99825fe5-ce40-404d-acdf-8df4809db482"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Ap. paterno]]></text>
			</staticText>
			<staticText>
				<reportElement x="218" y="17" width="87" height="18" uuid="f1bb77b9-4f87-4593-bd96-e2b31113645e">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="492bf301-1654-4dd6-beec-6360230bfaa4"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Ap. materno]]></text>
			</staticText>
			<staticText>
				<reportElement x="305" y="17" width="81" height="18" uuid="faf2d7c5-3887-4be2-946f-9d3c32c9c5e7">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="95130b7d-ada0-4615-b192-0445540138e8"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Fe. nacimiento]]></text>
			</staticText>
			<staticText>
				<reportElement x="386" y="17" width="76" height="18" uuid="df028420-c227-4ab6-84f7-4079b222aebe">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a709d6d5-8f4a-4a3f-ab5a-368f0b8cf880"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[RFC]]></text>
			</staticText>
			<staticText>
				<reportElement x="462" y="17" width="112" height="18" uuid="40e8ffcf-7c77-4a59-9531-527453e99b3f">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="46a77bd8-042b-4b41-a7fd-2a0fadf3627c"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[CURP]]></text>
			</staticText>
			<staticText>
				<reportElement x="574" y="17" width="76" height="18" uuid="345ef9b9-caf0-49c4-bb0a-aac49592214e">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ba90ca1e-c184-4000-8bcb-2e7658bd8813"/>
					<property name="com.jaspersoft.studio.unit.y" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Celular]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="FixRelativeToBottom" x="650" y="17" width="100" height="18" uuid="03b4553e-d08f-40f4-b232-ae5144dda319">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="9ea11ca4-bd34-4b57-8cd0-a3c37a4f5824"/>
				</reportElement>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[Correo personal]]></text>
			</staticText>
			<line>
				<reportElement x="0" y="36" width="743" height="1" uuid="04b83069-c7ac-47ee-a3aa-f64068baa582"/>
			</line>
		</band>
	</columnHeader>
	<detail>
		<band height="21">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="0" y="0" width="50" height="21" uuid="4ae2b458-224c-4e69-9a06-33da5b5ef7e3">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="103777e8-ae85-44dc-ba0e-89bb71fb8076"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{Nomina}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="50" y="0" width="84" height="21" uuid="ae9c61d2-1d37-42cb-b42b-083bac73c094">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="357673c3-51d3-4dd2-8933-1cc6ae973579"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{Nombre}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="134" y="0" width="84" height="21" uuid="edef20fb-8373-45de-8089-80c7d2f6b422">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="99825fe5-ce40-404d-acdf-8df4809db482"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{ApellidoPaterno}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="218" y="0" width="87" height="21" uuid="759d5ab7-b2d7-484e-9ec3-c3ac299a346a">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="492bf301-1654-4dd6-beec-6360230bfaa4"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{ApellidoMaterno}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="386" y="0" width="76" height="21" uuid="b94b07f2-ef18-4cde-b49b-db9c5eec4b52">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a709d6d5-8f4a-4a3f-ab5a-368f0b8cf880"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{RFC}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="462" y="0" width="112" height="21" uuid="2df43727-5afe-4e2f-96eb-be96f25c9b6d">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="46a77bd8-042b-4b41-a7fd-2a0fadf3627c"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{CURP}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="574" y="0" width="76" height="21" uuid="a2d75f2e-dd6e-48d4-876c-b77da844d84d">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ba90ca1e-c184-4000-8bcb-2e7658bd8813"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textElement textAlignment="Justified">
					<paragraph lineSpacing="Single" lineSpacingSize="1.0"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{TelefonoCelular}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="650" y="0" width="100" height="21" uuid="ca6ac23e-3977-4403-990c-42634a1d47a8">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="9ea11ca4-bd34-4b57-8cd0-a3c37a4f5824"/>
					<property name="com.jaspersoft.studio.unit.width" value="px"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{EmailPersonal}]]></textFieldExpression>
			</textField>
			<line>
				<reportElement positionType="FixRelativeToBottom" x="0" y="20" width="743" height="1" uuid="e1d20be1-76d9-49c5-8f8e-319b79bf0792"/>
			</line>
			<textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="305" y="0" width="81" height="21" uuid="3539f60f-57c3-4900-8d12-61e6faa8ad6d">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="492bf301-1654-4dd6-beec-6360230bfaa4"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{FechaNacimiento}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
</jasperReport>
