<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 6.3.1  -->
<!-- 2019-12-13T12:50:32 -->
<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="OUTROS_VENDAS_REPRESENTANTE_QUEBRA" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="782" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" uuid="3df4b07f-b017-41cb-b606-6c6f21fa25ea">
	<property name="ireport.scriptlethandling" value="0"/>
	<property name="ireport.encoding" value="UTF-8"/>
	<property name="ireport.zoom" value="1.5"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<import value="net.sf.jasperreports.engine.*"/>
	<import value="java.util.*"/>
	<import value="net.sf.jasperreports.engine.data.*"/>
	<parameter name="LOGO" class="java.lang.String" isForPrompting="false"/>
	<parameter name="NOME_EMPRESA" class="java.lang.String"/>
	<parameter name="CNPJ_NOME" class="java.lang.String"/>
	<parameter name="INSCRICAO_ESTADUAL_NOME" class="java.lang.String"/>
	<parameter name="FECHO" class="java.lang.String" isForPrompting="false"/>
	<parameter name="TIPO_RELATORIO" class="java.lang.Integer" isForPrompting="false"/>
	<parameter name="SUBREPORT_DIR_OUTR" class="java.lang.String">
		<defaultValueExpression><![CDATA["D:\\Projetos\\Projeto Mentor\\Mentor\\relatorios\\outros\\arquivosFontes\\"]]></defaultValueExpression>
	</parameter>
	<parameter name="LOGO_RELATORIO" class="net.sf.jasperreports.engine.JRImageRenderer" isForPrompting="false"/>
	<parameter name="IMPRIMIR_PRODUTOS" class="java.lang.Integer" isForPrompting="false"/>
	<parameter name="IMPRIMIR" class="java.lang.Integer" isForPrompting="false"/>
	<parameter name="FILTRAR_REPRESENTANTE" class="java.lang.Short"/>
	<parameter name="ID_REP_INICIAL" class="java.lang.Long"/>
	<parameter name="ID_REP_FINAL" class="java.lang.Long"/>
	<parameter name="FILTRAR_DATA" class="java.lang.Short"/>
	<parameter name="DATA_INICIAL" class="java.util.Date" isForPrompting="false"/>
	<parameter name="DATA_FINAL" class="java.util.Date" isForPrompting="false"/>
	<parameter name="FILTRAR_EMPRESA" class="java.lang.Short"/>
	<parameter name="ID_EMPRESA_INICIAL" class="java.lang.Long"/>
	<parameter name="ID_EMPRESA_FINAL" class="java.lang.Long"/>
	<parameter name="FILTRAR_MODELO_DOC_FISCAL" class="java.lang.Short"/>
	<parameter name="ID_MODELO_DOC_FISCAL_INICAL" class="java.lang.Long"/>
	<parameter name="ID_MODELO_DOC_FISCAL_FINAL" class="java.lang.Long"/>
	<parameter name="NOTAS_AUTORIZADAS" class="java.lang.Short"/>
	<parameter name="EXIBIR_LANCAMENTOS" class="java.lang.Short"/>
	<queryString>
		<![CDATA[SELECT
DISTINCT

    PE.ID_REPRESENTANTE,
    P.NOME,
    C.CNPJ

       FROM NOTA_PROPRIA NP
INNER JOIN EXPEDICAO    EX ON (EX.ID_EXPEDICAO   = NP.ID_EXPEDICAO)
INNER JOIN PEDIDO       PE ON (PE.ID_PEDIDO      = EX.ID_PEDIDO)
INNER JOIN REPRESENTANTE R ON (R.ID_REPRESENTANTE= PE.ID_REPRESENTANTE)
INNER JOIN PESSOA        P ON (P.ID_PESSOA       = R.ID_PESSOA)
INNER JOIN COMPLEMENTO   C ON (C.ID_COMPLEMENTO  = P.ID_COMPLEMENTO)
INNER JOIN MODELO_DOC_FISCAL MDF ON (MDF.ID_MODELO_DOC_FISCAL = NP.ID_MODELO_DOC_FISCAL)

WHERE
    ($P{FILTRAR_DATA} <> 1          OR NP.DATA_EMISSAO    BETWEEN $P{DATA_INICIAL}       AND $P{DATA_FINAL})
AND ($P{FILTRAR_REPRESENTANTE} <> 1 OR R.ID_REPRESENTANTE BETWEEN $P{ID_REP_INICIAL}     AND $P{ID_REP_FINAL})
AND ($P{FILTRAR_EMPRESA} <> 1       OR NP.ID_EMPRESA      BETWEEN $P{ID_EMPRESA_INICIAL} AND $P{ID_EMPRESA_FINAL})
AND ($P{FILTRAR_MODELO_DOC_FISCAL} <> 1 OR NP.ID_MODELO_DOC_FISCAL BETWEEN $P{ID_MODELO_DOC_FISCAL_INICAL} AND $P{ID_MODELO_DOC_FISCAL_FINAL})]]>
	</queryString>
	<field name="ID_REPRESENTANTE" class="java.lang.Integer"/>
	<field name="NOME" class="java.lang.String"/>
	<field name="CNPJ" class="java.lang.String"/>
	<variable name="dataRel" class="java.util.Date">
		<initialValueExpression><![CDATA[new java.util.Date()]]></initialValueExpression>
	</variable>
	<variable name="TOTAL_DEBITO" class="java.lang.Double" calculation="Sum"/>
	<variable name="TOTAL_CREDITO" class="java.lang.Double" calculation="Sum"/>
	<variable name="TOTAL_COMISSAO" class="java.lang.Double" calculation="Sum"/>
	<group name="ID_REPRESENTANTE" isStartNewPage="true">
		<groupExpression><![CDATA[$F{ID_REPRESENTANTE}]]></groupExpression>
		<groupHeader>
			<band splitType="Stretch"/>
		</groupHeader>
		<groupFooter>
			<band height="40" splitType="Stretch">
				<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
				<staticText>
					<reportElement key="staticText-17" x="577" y="3" width="144" height="11" isRemoveLineWhenBlank="true" uuid="b61948e5-70fe-4dae-8fa1-59ad501060c2"/>
					<textElement textAlignment="Right">
						<font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Total de Débito:]]></text>
				</staticText>
				<textField pattern="#,##0.00" isBlankWhenNull="false">
					<reportElement key="textField" x="726" y="3" width="50" height="11" isRemoveLineWhenBlank="true" uuid="02da276f-7d87-47f2-b712-b0e317ed4fb0">
						<printWhenExpression><![CDATA[new Boolean($P{IMPRIMIR}.intValue()==1)]]></printWhenExpression>
					</reportElement>
					<textElement textAlignment="Right">
						<font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{TOTAL_DEBITO}]]></textFieldExpression>
				</textField>
				<textField pattern="#,##0.00" isBlankWhenNull="false">
					<reportElement key="textField" x="726" y="16" width="50" height="11" isRemoveLineWhenBlank="true" uuid="d711a29d-2ee7-494f-8354-8c4c541614d0">
						<printWhenExpression><![CDATA[new Boolean($P{IMPRIMIR}.intValue()==1)]]></printWhenExpression>
					</reportElement>
					<textElement textAlignment="Right">
						<font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{TOTAL_CREDITO}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement key="staticText-17" x="577" y="16" width="144" height="11" isRemoveLineWhenBlank="true" uuid="841f4136-ac14-4966-8be1-817a7cb79087"/>
					<textElement textAlignment="Right">
						<font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Total de Crédito:]]></text>
				</staticText>
				<staticText>
					<reportElement key="staticText-17" x="577" y="29" width="144" height="11" isRemoveLineWhenBlank="true" uuid="86125b0f-c088-44a3-8742-7541127cbec9"/>
					<textElement textAlignment="Right">
						<font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<text><![CDATA[Liquido Comissão:]]></text>
				</staticText>
				<textField pattern="#,##0.00" isBlankWhenNull="false">
					<reportElement key="textField" x="726" y="29" width="50" height="11" isRemoveLineWhenBlank="true" uuid="22b4bf5c-f5d0-4ccb-8fa8-e742cd354b6d">
						<printWhenExpression><![CDATA[new Boolean($P{IMPRIMIR}.intValue()==1)]]></printWhenExpression>
					</reportElement>
					<textElement textAlignment="Right">
						<font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{TOTAL_COMISSAO} - $V{TOTAL_DEBITO} + $V{TOTAL_CREDITO}]]></textFieldExpression>
				</textField>
				<line>
					<reportElement x="577" y="1" width="205" height="1" isRemoveLineWhenBlank="true" uuid="a9c153a9-3041-4ee9-a6a4-850b192aeab6"/>
				</line>
			</band>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="53" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement key="textField-1" x="220" y="9" width="357" height="17" isRemoveLineWhenBlank="true" uuid="dc5cb29c-9302-444c-bc33-a2365f3206db"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Top">
					<font size="10" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{NOME_EMPRESA}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-1" x="613" y="16" width="35" height="14" isRemoveLineWhenBlank="true" uuid="523a4d66-7e5b-43fb-b27d-e3433233339e"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement>
					<font size="10" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Data :]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-2" x="613" y="32" width="35" height="14" isRemoveLineWhenBlank="true" uuid="855b2917-284c-4818-a46e-5c35b9b2c352"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement>
					<font size="10" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Hora :]]></text>
			</staticText>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement key="textField-2" x="647" y="16" width="67" height="14" isRemoveLineWhenBlank="true" uuid="3ad1e06e-1228-4e46-8e91-77205719566c"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{dataRel}]]></textFieldExpression>
			</textField>
			<textField pattern="HH.mm.ss" isBlankWhenNull="true">
				<reportElement key="textField-3" x="647" y="32" width="67" height="14" isRemoveLineWhenBlank="true" uuid="de8e4d21-762e-4e41-aa28-ce46a0560457"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="10"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{dataRel}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-3" x="259" y="33" width="27" height="12" isRemoveLineWhenBlank="true" uuid="9a3fad9c-d2d1-4b1a-91b2-15d3ea145106"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement>
					<font size="8" isBold="true" isItalic="true" pdfFontName="Helvetica-BoldOblique"/>
				</textElement>
				<text><![CDATA[CNPJ :]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-4" x="368" y="33" width="77" height="12" isRemoveLineWhenBlank="true" uuid="a2706aa3-7d1f-4696-aa87-da3a0a61c195"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement>
					<font size="8" isBold="true" isItalic="true" pdfFontName="Helvetica-BoldOblique"/>
				</textElement>
				<text><![CDATA[Inscrição Estadual :]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement key="textField-4" x="287" y="33" width="80" height="12" isRemoveLineWhenBlank="true" uuid="8b6a4b9c-b228-40f7-841a-64a9a184affa"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{CNPJ_NOME}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement key="textField-5" x="446" y="33" width="85" height="12" isRemoveLineWhenBlank="true" uuid="933b460e-724c-4255-bf3b-46c21a6f59f9"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{INSCRICAO_ESTADUAL_NOME}]]></textFieldExpression>
			</textField>
			<image onErrorType="Blank">
				<reportElement key="image-1" x="2" y="1" width="154" height="52" isRemoveLineWhenBlank="true" uuid="e0795048-9fa9-4100-8b64-5b2b5a94b246"/>
				<imageExpression><![CDATA[$P{LOGO_RELATORIO}]]></imageExpression>
			</image>
		</band>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="43" splitType="Stretch">
			<staticText>
				<reportElement key="staticText-5" x="0" y="5" width="782" height="14" isRemoveLineWhenBlank="true" uuid="4a2ade9e-6bcc-427c-b5c0-ca71af329211"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Top">
					<font size="10" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Listagem Vendas por Representante]]></text>
			</staticText>
			<line>
				<reportElement key="line-1" x="0" y="1" width="782" height="1" isRemoveLineWhenBlank="true" uuid="1660af0b-e3bf-4444-bdd1-6e6aaeb14607"/>
				<graphicElement>
					<pen lineWidth="0.25"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement key="staticText-16" x="499" y="20" width="56" height="10" isRemoveLineWhenBlank="true" uuid="6d9adfc1-b354-44d6-94b9-d60841e66776"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Tp. Relatório:]]></text>
			</staticText>
			<textField isBlankWhenNull="false">
				<reportElement key="textField-11" x="558" y="20" width="72" height="10" isRemoveLineWhenBlank="true" uuid="8676d5b8-367c-42a0-b441-967e103167da"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{TIPO_RELATORIO}.intValue()==0?"Sintético":"Analítico"]]></textFieldExpression>
			</textField>
			<line>
				<reportElement key="line-4" x="0" y="42" width="782" height="1" isRemoveLineWhenBlank="true" uuid="70e959aa-bc03-41c4-8861-c88ed1d9d4b3"/>
				<graphicElement>
					<pen lineWidth="0.25"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement key="staticText-14" x="68" y="31" width="26" height="10" isRemoveLineWhenBlank="true" uuid="ec3e9eec-d128-4300-84f2-6eabba358743"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Final:]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="437" y="31" width="43" height="10" isRemoveLineWhenBlank="true" uuid="7887a18a-c9ab-4cb9-b6c8-6534e8aee27f"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{ID_EMPRESA_FINAL}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-12" x="3" y="20" width="48" height="10" isRemoveLineWhenBlank="true" uuid="ec4778e9-e7b4-4bd7-9444-7d3c292ecb25"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Filtrar Data:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-13" x="245" y="31" width="31" height="10" isRemoveLineWhenBlank="true" uuid="f9395820-22a8-453c-b535-6034be58ddd5"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Final:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-12" x="138" y="20" width="84" height="10" isRemoveLineWhenBlank="true" uuid="d906e7f3-5e05-45e4-a152-6ce7fd1a39d7"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Filtrar Representante:]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="437" y="20" width="37" height="10" isRemoveLineWhenBlank="true" uuid="0426ffe6-628d-453b-8151-d3582c787ee6"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{ID_EMPRESA_INICIAL}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-12" x="322" y="20" width="61" height="10" isRemoveLineWhenBlank="true" uuid="9279be15-4443-477a-9b9a-15331f43b037"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Filtrar Empresa:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-15" x="68" y="20" width="26" height="10" isRemoveLineWhenBlank="true" uuid="757596d8-44ed-4bab-a544-ab4bff50b77e"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Inicial:]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement key="textField" x="278" y="20" width="42" height="10" isRemoveLineWhenBlank="true" uuid="a988f4fb-3970-432d-bef7-0baa26e01e27"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{ID_REP_INICIAL}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement key="textField" x="278" y="31" width="42" height="10" isRemoveLineWhenBlank="true" uuid="502277c8-f695-4325-a215-537f2f2b51bb"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{ID_REP_FINAL}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement key="textField" x="96" y="20" width="39" height="10" isRemoveLineWhenBlank="true" uuid="fdb4dbd9-3d90-49bf-977e-abe1d5b972ef"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{DATA_INICIAL}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="385" y="20" width="17" height="10" isRemoveLineWhenBlank="true" uuid="7f43a43b-1ec6-4fb9-a5bf-171c85174f75"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{FILTRAR_EMPRESA}.shortValue() == 1 ? "Sim" : "Não"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="53" y="20" width="15" height="10" isRemoveLineWhenBlank="true" uuid="61508283-e539-4a24-a87e-075816b04f29"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{FILTRAR_DATA}.shortValue() == 1 ? "Sim" : "Não"]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="224" y="20" width="19" height="10" isRemoveLineWhenBlank="true" uuid="174881ca-7738-49b4-b3a7-0ac2f3181ee1"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{FILTRAR_REPRESENTANTE}.shortValue() == 1 ? "Sim" : "Não"]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-13" x="402" y="31" width="33" height="10" isRemoveLineWhenBlank="true" uuid="e8d7e95d-bafb-417c-a24c-71c77cf39c7b"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Final:]]></text>
			</staticText>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement key="textField" x="96" y="31" width="39" height="10" isRemoveLineWhenBlank="true" uuid="3e390e7b-d8d2-4187-9f7d-6b68dadce908"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{DATA_FINAL}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-12" x="402" y="20" width="33" height="10" isRemoveLineWhenBlank="true" uuid="835acb7e-518d-4a0a-bc58-485a8653f705"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Inicial:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-12" x="243" y="20" width="33" height="10" isRemoveLineWhenBlank="true" uuid="98299b70-287b-4911-98be-2a88f84b5312"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Inicial:]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="24" splitType="Stretch">
			<staticText>
				<reportElement key="staticText-10" x="1" y="1" width="54" height="10" isRemoveLineWhenBlank="true" uuid="fb41e602-9893-41fe-84f4-e907016e815b"/>
				<textElement>
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Representante:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-11" x="403" y="1" width="27" height="10" isRemoveLineWhenBlank="true" uuid="56078d2b-7261-4a14-9ed3-83803a382e8d"/>
				<textElement>
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[CNPJ:]]></text>
			</staticText>
			<textField isBlankWhenNull="false">
				<reportElement key="textField" x="60" y="1" width="342" height="10" isRemoveLineWhenBlank="true" uuid="95dd6559-d06f-410d-8a22-a344b81d041e"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{ID_REPRESENTANTE}.toString()+" - "+$F{NOME}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement key="textField" x="429" y="1" width="106" height="10" isRemoveLineWhenBlank="true" uuid="d0f90981-21f3-4d65-9cff-0995037c99da"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CNPJ}.length()>11?($F{CNPJ}.substring( 0, 2 )+"."+
$F{CNPJ}.substring( 2, 5 )+"."+
$F{CNPJ}.substring( 5, 8 )+"/"+
$F{CNPJ}.substring( 8, 12 )+"-"+
$F{CNPJ}.substring( 12 )):(
$F{CNPJ}.substring( 0, 3 )+"."+
$F{CNPJ}.substring( 3, 6 )+"."+
$F{CNPJ}.substring( 6, 9 )+"-"+
$F{CNPJ}.substring( 9))]]></textFieldExpression>
			</textField>
			<subreport isUsingCache="true">
				<reportElement key="subreport-1" positionType="Float" x="0" y="15" width="782" height="1" isRemoveLineWhenBlank="true" uuid="d7ea25f8-1cbd-48fb-8299-cf84fe42c3bd">
					<printWhenExpression><![CDATA[new Boolean($P{TIPO_RELATORIO}.intValue()==1)]]></printWhenExpression>
				</reportElement>
				<subreportParameter name="ID_REPRESENTANTE">
					<subreportParameterExpression><![CDATA[$F{ID_REPRESENTANTE}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="DATA_INICIAL">
					<subreportParameterExpression><![CDATA[$P{DATA_INICIAL}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="DATA_FINAL">
					<subreportParameterExpression><![CDATA[$P{DATA_FINAL}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="FILTRAR_EMPRESA">
					<subreportParameterExpression><![CDATA[$P{FILTRAR_EMPRESA}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="ID_EMPRESA_INICIAL">
					<subreportParameterExpression><![CDATA[$P{ID_EMPRESA_INICIAL}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="ID_EMPRESA_FINAL">
					<subreportParameterExpression><![CDATA[$P{ID_EMPRESA_FINAL}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR_OUTR} + "SUB_OUTR_VENDAS_REPRESENTANTE_PROVISAO.jasper"]]></subreportExpression>
			</subreport>
			<subreport isUsingCache="true">
				<reportElement key="subreport-2" positionType="Float" x="0" y="15" width="782" height="1" isRemoveLineWhenBlank="true" uuid="adf4c7c2-2209-4501-ad61-9e2e07832dae">
					<printWhenExpression><![CDATA[new Boolean($P{TIPO_RELATORIO}.intValue()==1)]]></printWhenExpression>
				</reportElement>
				<subreportParameter name="ID_MODELO_DOC_FISCAL_INICIAL">
					<subreportParameterExpression><![CDATA[$P{ID_MODELO_DOC_FISCAL_INICAL}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="IMPRIMIR">
					<subreportParameterExpression><![CDATA[$P{IMPRIMIR}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="SUBREPORT_DIR_OUTR">
					<subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR_OUTR}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="ID_MODELO_DOC_FISCAL_FINAL">
					<subreportParameterExpression><![CDATA[$P{ID_MODELO_DOC_FISCAL_FINAL}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="DATA_INICIAL">
					<subreportParameterExpression><![CDATA[$P{DATA_INICIAL}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="ID_REPRESENTANTE">
					<subreportParameterExpression><![CDATA[$F{ID_REPRESENTANTE}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="IMPRIMIR_PRODUTOS">
					<subreportParameterExpression><![CDATA[$P{IMPRIMIR_PRODUTOS}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="DATA_FINAL">
					<subreportParameterExpression><![CDATA[$P{DATA_FINAL}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="NOTAS_AUTORIZADAS">
					<subreportParameterExpression><![CDATA[$P{NOTAS_AUTORIZADAS}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="FILTRAR_EMPRESA">
					<subreportParameterExpression><![CDATA[$P{FILTRAR_EMPRESA}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="ID_EMPRESA_INICIAL">
					<subreportParameterExpression><![CDATA[$P{ID_EMPRESA_INICIAL}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="ID_EMPRESA_FINAL">
					<subreportParameterExpression><![CDATA[$P{ID_EMPRESA_FINAL}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<returnValue subreportVariable="TOTAL_VLR_COMISSAO" toVariable="TOTAL_COMISSAO" calculation="Sum"/>
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR_OUTR} + "SUB_OUTR_VENDAS_REPRESENTANTE_REALIZADOS.jasper"]]></subreportExpression>
			</subreport>
			<subreport isUsingCache="true">
				<reportElement key="subreport-3" positionType="Float" x="0" y="17" width="782" height="1" isRemoveLineWhenBlank="true" uuid="511d4b37-c2a1-498f-9869-017ddd0403c9">
					<printWhenExpression><![CDATA[new Boolean($P{TIPO_RELATORIO}.intValue()==0)]]></printWhenExpression>
				</reportElement>
				<subreportParameter name="ID_REPRESENTANTE">
					<subreportParameterExpression><![CDATA[$F{ID_REPRESENTANTE}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="DATA_INICIAL">
					<subreportParameterExpression><![CDATA[$P{DATA_INICIAL}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="DATA_FINAL">
					<subreportParameterExpression><![CDATA[$P{DATA_FINAL}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="FILTRAR_EMPRESA">
					<subreportParameterExpression><![CDATA[$P{FILTRAR_EMPRESA}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="ID_EMPRESA_INICIAL">
					<subreportParameterExpression><![CDATA[$P{ID_EMPRESA_INICIAL}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="ID_EMPRESA_FINAL">
					<subreportParameterExpression><![CDATA[$P{ID_EMPRESA_FINAL}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<returnValue subreportVariable="SUM_COMISSAO_PROVISIONADO_1" toVariable="TOTAL_COMISSAO" calculation="Sum"/>
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR_OUTR} + "SUB_OUTR_VENDAS_REPRESENTANTE_REALIZADOS_SINTETICO.jasper"]]></subreportExpression>
			</subreport>
			<subreport isUsingCache="true">
				<reportElement key="subreport-4" positionType="Float" x="0" y="19" width="782" height="1" isRemoveLineWhenBlank="true" uuid="bfbe556b-5dd1-4954-94d2-6ec98f6c97e1">
					<printWhenExpression><![CDATA[new Boolean($P{TIPO_RELATORIO}.intValue()==0)]]></printWhenExpression>
				</reportElement>
				<subreportParameter name="ID_REPRESENTANTE">
					<subreportParameterExpression><![CDATA[$F{ID_REPRESENTANTE}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="DATA_INICIAL">
					<subreportParameterExpression><![CDATA[$P{DATA_INICIAL}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="DATA_FINAL">
					<subreportParameterExpression><![CDATA[$P{DATA_FINAL}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="FILTRAR_EMPRESA">
					<subreportParameterExpression><![CDATA[$P{FILTRAR_EMPRESA}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="ID_EMPRESA_INICIAL">
					<subreportParameterExpression><![CDATA[$P{ID_EMPRESA_INICIAL}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="ID_EMPRESA_FINAL">
					<subreportParameterExpression><![CDATA[$P{ID_EMPRESA_FINAL}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR_OUTR} + "SUB_OUTR_VENDAS_REPRESENTANTE_PROVISAO_SINTETICO.jasper"]]></subreportExpression>
			</subreport>
			<line>
				<reportElement key="line-3" positionType="Float" x="0" y="23" width="782" height="1" isRemoveLineWhenBlank="true" uuid="82d5e42a-6665-4fff-a6c5-8739c4355f3d"/>
				<graphicElement>
					<pen lineWidth="0.25" lineStyle="Dashed"/>
				</graphicElement>
			</line>
			<subreport>
				<reportElement positionType="Float" x="0" y="21" width="782" height="1" isRemoveLineWhenBlank="true" uuid="ae26e1a3-82fa-4428-a827-9d10802e78df">
					<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.width" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.x" value="pixel"/>
				</reportElement>
				<subreportParameter name="ID_REPRESENTANTE">
					<subreportParameterExpression><![CDATA[$F{ID_REPRESENTANTE}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="DATA_INICIAL">
					<subreportParameterExpression><![CDATA[$P{DATA_INICIAL}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="DATA_FINAL">
					<subreportParameterExpression><![CDATA[$P{DATA_FINAL}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="EXIBIR_LANCAMENTOS">
					<subreportParameterExpression><![CDATA[$P{EXIBIR_LANCAMENTOS}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="SUBREPORT_DIR_OUTR">
					<subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR_OUTR}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="FILTRAR_EMPRESA">
					<subreportParameterExpression><![CDATA[$P{FILTRAR_EMPRESA}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="ID_EMPRESA_INICIAL">
					<subreportParameterExpression><![CDATA[$P{ID_EMPRESA_INICIAL}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="ID_EMPRESA_FINAL">
					<subreportParameterExpression><![CDATA[$P{ID_EMPRESA_FINAL}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<returnValue subreportVariable="SUM_CREDITO" toVariable="TOTAL_CREDITO" calculation="Sum"/>
				<returnValue subreportVariable="SUM_DEBITO" toVariable="TOTAL_DEBITO" calculation="Sum"/>
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR_OUTR} + "SUB_OUTR_VENDAS_REPRESENTANTE_LANCAMENTOS_MANUAIS.jasper"]]></subreportExpression>
			</subreport>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="18" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement key="textField-9" x="714" y="8" width="21" height="10" isRemoveLineWhenBlank="true" uuid="bec34a74-a711-49a2-a621-24c32c62f7b7"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" isBlankWhenNull="true">
				<reportElement key="textField-10" x="743" y="8" width="20" height="10" isRemoveLineWhenBlank="true" uuid="2d68520e-a442-4107-93da-bd7b7c8c0b2e"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-8" x="735" y="8" width="8" height="10" isRemoveLineWhenBlank="true" uuid="285ccf54-b72e-43a9-b038-6784509349bb"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[/]]></text>
			</staticText>
		</band>
	</pageFooter>
	<lastPageFooter>
		<band height="23" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement key="textField-6" x="714" y="12" width="23" height="10" isRemoveLineWhenBlank="true" uuid="a73875c5-a079-4227-ab3b-887dbac5446f"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" isBlankWhenNull="true">
				<reportElement key="textField-7" x="745" y="12" width="18" height="10" isRemoveLineWhenBlank="true" uuid="3726fa50-8ce6-437f-b277-212cee185781"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-7" x="737" y="12" width="8" height="10" isRemoveLineWhenBlank="true" uuid="417a7a4e-bc9b-43b1-a683-aa534bdb5ea3"/>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[/]]></text>
			</staticText>
			<textField isBlankWhenNull="false" hyperlinkType="RemotePage">
				<reportElement key="textField-8" x="595" y="13" width="113" height="10" isRemoveLineWhenBlank="true" forecolor="#0099FF" uuid="aa6a7628-6e5b-490f-91ae-907290b80655"/>
				<textElement textAlignment="Center">
					<font size="7" isItalic="true" isUnderline="true" pdfFontName="Helvetica-Oblique"/>
				</textElement>
				<textFieldExpression><![CDATA["TOUCHComp.com.br"]]></textFieldExpression>
				<hyperlinkReferenceExpression><![CDATA["HTTP://WWW.CONTATOSISTEMAS.COM"]]></hyperlinkReferenceExpression>
			</textField>
		</band>
	</lastPageFooter>
	<summary>
		<band height="19" splitType="Stretch">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement key="textField" x="0" y="1" width="782" height="18" isRemoveLineWhenBlank="true" uuid="bf8e7ebc-95fc-4fbf-ab2d-cd202745d128"/>
				<textElement textAlignment="Center" markup="html"/>
				<textFieldExpression><![CDATA[$P{FECHO}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
</jasperReport>
