<?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:41:04 -->
<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" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="782" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" uuid="819a73e2-7ac8-4a44-9fd6-ba39aef38b99">
	<property name="ireport.scriptlethandling" value="0"/>
	<property name="ireport.encoding" value="UTF-8"/>
	<property name="ireport.zoom" value="2.0"/>
	<property name="ireport.x" value="635"/>
	<property name="ireport.y" value="67"/>
	<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="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="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" class="java.lang.Integer" isForPrompting="false"/>
	<parameter name="IMPRIMIR_PRODUTOS" 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_EMPRESA" class="java.lang.Short"/>
	<parameter name="ID_EMPRESA_INICIAL" class="java.lang.Long"/>
	<parameter name="ID_EMPRESA_FINAL" class="java.lang.Long" isForPrompting="false"/>
	<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)

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})]]>
	</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_PEDIDO" class="java.lang.Double" calculation="Sum"/>
	<variable name="TOTAL_COMISSAO" class="java.lang.Double" calculation="Sum"/>
	<variable name="TOTAL_NOTAS" class="java.lang.Double" calculation="Sum"/>
	<variable name="TOTAL_COMISSAO_NOTAS" class="java.lang.Double" calculation="Sum"/>
	<variable name="TOTAL_DEBITO" class="java.lang.Double" calculation="Sum"/>
	<variable name="TOTAL_CREDITO" class="java.lang.Double" calculation="Sum"/>
	<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="3f0a54bd-45fc-4a24-b0d5-f7698a1f90f0"/>
				<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="db487759-e5f4-4eb6-8cf9-14fbfb3ec4df"/>
				<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="cd4d70d0-0826-4a3a-9d49-9b92347bff3b"/>
				<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="a35d0132-b8c9-4576-8302-ea988f78ce76"/>
				<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="7dc797b0-1fce-4358-bf90-52d9a9074554"/>
				<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="5341d33a-04d5-44f1-8ee6-09a8d8b43a4a"/>
				<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="879a1f54-d689-4094-9d62-ccf3036b5eb9"/>
				<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="28b3ba22-a9cb-4d48-a91a-30808a7bf988"/>
				<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="2a7a858a-cc1d-4c56-b84d-6c703c784c63"/>
				<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="1c1e1432-46df-42e4-9573-3434b7f52d9d"/>
				<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="e1832d97-9736-4740-84ea-72d42f3cb4fe"/>
				<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="2c8ea936-b4ec-4bfb-a2c3-90d4e4bd2dc8"/>
				<graphicElement>
					<pen lineWidth="0.25"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement key="staticText-12" x="241" y="20" width="33" height="10" isRemoveLineWhenBlank="true" uuid="0ca44e73-71f9-4c6b-b67f-76158af09180"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Inicial:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-13" x="243" y="31" width="31" height="10" isRemoveLineWhenBlank="true" uuid="8bcbca3b-977a-4f4d-99ce-c09011d23400"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Final:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-14" x="66" y="31" width="26" height="10" isRemoveLineWhenBlank="true" uuid="62b692e3-2b9a-4ed0-a131-9b23354fe29f"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Final:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-15" x="66" y="20" width="26" height="10" isRemoveLineWhenBlank="true" uuid="f7d8ec43-af22-43c5-ad87-ecb499fe146b"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Inicial:]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement key="textField" x="276" y="20" width="42" height="10" isRemoveLineWhenBlank="true" uuid="acc2d9d2-3f0a-43fc-b644-5ca018d5c5d0"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{ID_REP_INICIAL}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement key="textField" x="276" y="31" width="42" height="10" isRemoveLineWhenBlank="true" uuid="fea65c4a-c172-4978-b05f-fecfb17a36c9"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{ID_REP_FINAL}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement key="textField" x="94" y="20" width="39" height="10" isRemoveLineWhenBlank="true" uuid="5df5b701-3bae-4f09-9249-9af5c5a30c19"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{DATA_INICIAL}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement key="textField" x="94" y="31" width="39" height="10" isRemoveLineWhenBlank="true" uuid="9c739510-ad12-428d-949f-5fc519014560"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{DATA_FINAL}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-16" x="517" y="20" width="56" height="10" isRemoveLineWhenBlank="true" uuid="86291afd-14fe-4a13-b544-1e648034fcd4"/>
				<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="576" y="20" width="72" height="10" isRemoveLineWhenBlank="true" uuid="f855407c-5987-4816-876d-234cd73da19d"/>
				<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="7a94849d-43e1-4526-826a-77028357c680"/>
				<graphicElement>
					<pen lineWidth="0.25"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement key="staticText-12" x="1" y="20" width="48" height="10" isRemoveLineWhenBlank="true" uuid="a554c61e-e007-41a8-8b58-bbf5ad444ae7"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Filtrar Data:]]></text>
			</staticText>
			<textField>
				<reportElement x="51" y="20" width="15" height="10" isRemoveLineWhenBlank="true" uuid="57868d8c-d179-4fb7-9649-30fb7aadb0fe"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{FILTRAR_DATA}.shortValue() == 1 ? "Sim" : "Não"]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-12" x="136" y="20" width="84" height="10" isRemoveLineWhenBlank="true" uuid="f4f9c982-d2d5-44cb-bffe-531309295696"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Filtrar Representante:]]></text>
			</staticText>
			<textField>
				<reportElement x="222" y="20" width="19" height="10" isRemoveLineWhenBlank="true" uuid="cb80c68c-f11f-413f-8ed2-f905c3556f99"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{FILTRAR_REPRESENTANTE}.shortValue() == 1 ? "Sim" : "Não"]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-12" x="320" y="20" width="61" height="10" isRemoveLineWhenBlank="true" uuid="9667696b-e5ed-432d-9dab-a542277369a1"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Filtrar Empresa:]]></text>
			</staticText>
			<textField>
				<reportElement x="383" y="20" width="17" height="10" isRemoveLineWhenBlank="true" uuid="6b3de929-5b6f-440b-ad2e-d7ace145b4a3"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{FILTRAR_EMPRESA}.shortValue() == 1 ? "Sim" : "Não"]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-13" x="400" y="31" width="33" height="10" isRemoveLineWhenBlank="true" uuid="c7cc6d54-7d7d-464d-a24e-73ddb6a2be5d"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Final:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-12" x="400" y="20" width="33" height="10" isRemoveLineWhenBlank="true" uuid="ca0c8a66-d448-4a3b-aebd-975dd5faa128"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Inicial:]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement x="435" y="20" width="37" height="10" isRemoveLineWhenBlank="true" uuid="74b24656-f55b-4440-8809-a7eadf3419ea"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{ID_EMPRESA_INICIAL}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="435" y="31" width="43" height="10" isRemoveLineWhenBlank="true" uuid="d343930b-65cc-4124-9fb8-fcee3d0b4605"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{ID_EMPRESA_FINAL}]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="22" splitType="Stretch">
			<staticText>
				<reportElement key="staticText-10" x="1" y="1" width="54" height="10" isRemoveLineWhenBlank="true" uuid="446f3352-9504-42b5-aa51-450948982b97"/>
				<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="0635087e-56f6-415d-994a-61d486c864e3"/>
				<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="d2ba7ab3-148c-4ccb-a9d2-075d7cc25164"/>
				<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="4cfa0be3-6120-4ca1-ac6d-25a601c2646e"/>
				<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-2" positionType="Float" x="0" y="15" width="782" height="1" isRemoveLineWhenBlank="true" uuid="93631c85-710a-4b19-8f09-d74fd85b5f53">
					<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="IMPRIMIR">
					<subreportParameterExpression><![CDATA[$P{IMPRIMIR}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="IMPRIMIR_PRODUTOS">
					<subreportParameterExpression><![CDATA[$P{IMPRIMIR_PRODUTOS}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="SUBREPORT_DIR_OUTR">
					<subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR_OUTR}]]></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_PEDIDO" toVariable="TOTAL_PEDIDO" calculation="Sum"/>
				<returnValue subreportVariable="TOTAL_VLR_COMISSAO" toVariable="TOTAL_COMISSAO" calculation="Sum"/>
				<returnValue subreportVariable="SUM_VALOR_NOTA_1" toVariable="TOTAL_NOTAS" calculation="Sum"/>
				<returnValue subreportVariable="SUM_COMISSAO_REAL_1" toVariable="TOTAL_COMISSAO_NOTAS" 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="61ce68c2-5dac-469a-833f-458039c0b30b">
					<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="IMPRIMIR">
					<subreportParameterExpression><![CDATA[$P{IMPRIMIR}]]></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="SUM_VALOR_TOTAL_1" toVariable="TOTAL_PEDIDO" calculation="Sum"/>
				<returnValue subreportVariable="SUM_COMISSAO_PROVISIONADO_1" toVariable="TOTAL_COMISSAO" calculation="Sum"/>
				<returnValue subreportVariable="SUM_VALOR_NOTA_1" toVariable="TOTAL_NOTAS" calculation="Sum"/>
				<returnValue subreportVariable="SUM_COMISSAO_REAL_1" toVariable="TOTAL_COMISSAO_NOTAS" calculation="Sum"/>
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR_OUTR} + "SUB_OUTR_VENDAS_REPRESENTANTE_REALIZADOS_SINTETICO.jasper"]]></subreportExpression>
			</subreport>
			<line>
				<reportElement key="line-3" positionType="Float" x="0" y="21" width="782" height="1" isRemoveLineWhenBlank="true" uuid="f0f36296-d3d2-40b3-be4c-5250a9f4558d"/>
				<graphicElement>
					<pen lineWidth="0.25" lineStyle="Dashed"/>
				</graphicElement>
			</line>
			<subreport isUsingCache="true">
				<reportElement key="subreport-2" positionType="Float" x="0" y="19" width="782" height="1" isRemoveLineWhenBlank="true" uuid="2d4a5bb5-73e4-44bf-99ce-fe34cc9f0610"/>
				<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="IMPRIMIR">
					<subreportParameterExpression><![CDATA[$P{IMPRIMIR}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="IMPRIMIR_PRODUTOS">
					<subreportParameterExpression><![CDATA[$P{IMPRIMIR_PRODUTOS}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="SUBREPORT_DIR_OUTR">
					<subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR_OUTR}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="NOTAS_AUTORIZADAS">
					<subreportParameterExpression><![CDATA[$P{NOTAS_AUTORIZADAS}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="EXIBIR_LANCAMENTOS">
					<subreportParameterExpression><![CDATA[$P{EXIBIR_LANCAMENTOS}]]></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_DEBITO" toVariable="TOTAL_DEBITO" calculation="Sum"/>
				<returnValue subreportVariable="SUM_CREDITO" toVariable="TOTAL_CREDITO" 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="13" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement key="textField-6" x="714" y="2" width="23" height="10" isRemoveLineWhenBlank="true" uuid="45880337-9f31-4798-a20a-5ea0d3b58b3e"/>
				<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="2" width="18" height="10" isRemoveLineWhenBlank="true" uuid="1f33b9b0-daec-4b0d-a531-b3fa824527e1"/>
				<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="2" width="8" height="10" isRemoveLineWhenBlank="true" uuid="67a567b0-8f4b-4169-b48b-69cc0b1f4f61"/>
				<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="3" width="113" height="10" isRemoveLineWhenBlank="true" forecolor="#0099FF" uuid="6948fea6-c7d1-4a22-a771-4e151602fb84"/>
				<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>
	</pageFooter>
	<summary>
		<band height="76" splitType="Stretch">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement key="textField" x="-1" y="58" width="782" height="18" isRemoveLineWhenBlank="true" uuid="dba42de2-2ed4-4a07-9ca2-5c666d5c6609"/>
				<textElement textAlignment="Center" markup="html"/>
				<textFieldExpression><![CDATA[$P{FECHO}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement key="textField" x="552" y="1" width="52" height="11" isRemoveLineWhenBlank="true" uuid="3eaa82a9-4fcb-4398-9691-e278f4223a6d"/>
				<textElement textAlignment="Right">
					<font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{TOTAL_PEDIDO}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement key="textField" x="612" y="1" width="52" height="11" isRemoveLineWhenBlank="true" uuid="9c54fb70-ff24-45a4-ab43-834779d76aa2"/>
				<textElement textAlignment="Right">
					<font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{TOTAL_COMISSAO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-17" x="458" y="0" width="85" height="11" isRemoveLineWhenBlank="true" uuid="d2c9692d-a697-477c-a280-879196b7ae24"/>
				<textElement textAlignment="Right">
					<font size="8" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[TOTALIZADORES....:]]></text>
			</staticText>
			<textField pattern="#,##0.00" isBlankWhenNull="true">
				<reportElement key="textField" x="664" y="1" width="53" height="11" isRemoveLineWhenBlank="true" uuid="b4d441a3-2e65-4d73-bd77-ae9b968ac497">
					<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_NOTAS}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0.00" isBlankWhenNull="false">
				<reportElement key="textField" x="726" y="1" width="50" height="11" isRemoveLineWhenBlank="true" uuid="343a880f-8a59-4239-b8b0-a9f6ee5a892a">
					<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_NOTAS}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-17" x="577" y="14" width="144" height="11" isRemoveLineWhenBlank="true" uuid="0f4095a0-7906-404c-b1ef-060969fd832a"/>
				<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="14" width="50" height="11" isRemoveLineWhenBlank="true" uuid="65d3ca4a-b71c-473b-a0a7-a6cf7130ce76">
					<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="27" width="50" height="11" isRemoveLineWhenBlank="true" uuid="e78d3d7c-abd4-48d8-b604-9c5d0d8e447d">
					<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="27" width="144" height="11" isRemoveLineWhenBlank="true" uuid="6828040e-0794-4df3-bd78-8c4dfbef4bc3"/>
				<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="40" width="144" height="11" isRemoveLineWhenBlank="true" uuid="9ce30e4b-2540-475f-9f12-0c7fb41ef759"/>
				<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="40" width="50" height="11" isRemoveLineWhenBlank="true" uuid="cea22951-bea1-434e-bb99-9fd29311e2b4">
					<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>
		</band>
	</summary>
</jasperReport>
