<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="OUTROS_EVOLUCAO_VENDAS" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20">
	<property name="ireport.scriptlethandling" value="0"/>
	<property name="ireport.encoding" value="UTF-8"/>
	<property name="ireport.zoom" value="1.0"/>
	<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="DATA_INICIAL" class="java.util.Date"/>
	<parameter name="DATA_FINAL" class="java.util.Date"/>
	<parameter name="ID_ESPECIE_INICIAL" class="java.lang.Integer"/>
	<parameter name="ID_INICIAL" class="java.lang.Long"/>
	<parameter name="NOME_EMPRESA" class="java.lang.String" isForPrompting="false"/>
	<parameter name="CNPJ_NOME" class="java.lang.String" isForPrompting="false"/>
	<parameter name="INSCRICAO_ESTADUAL_NOME" class="java.lang.String" isForPrompting="false"/>
	<parameter name="FECHO" class="java.lang.String" isForPrompting="false"/>
	<parameter name="ID_FINAL" class="java.lang.Long"/>
	<parameter name="ID_ESPECIE_FINAL" class="java.lang.Integer"/>
	<parameter name="ID_SUB_ESPECIE_INICIAL" class="java.lang.Integer"/>
	<parameter name="ID_SUB_ESPECIE_FINAL" class="java.lang.Integer"/>
	<parameter name="ID_EMPRESA" class="java.lang.Long" isForPrompting="false"/>
	<parameter name="LOGO_RELATORIO" class="net.sf.jasperreports.engine.JRImageRenderer" isForPrompting="false"/>
	<parameter name="SUBREPORT_DIR_OUTR" class="java.lang.String">
		<defaultValueExpression><![CDATA["E:\\Projetos\\Projeto Mentor\\Mentor\\relatorios\\outros\\arquivosFontes\\"]]></defaultValueExpression>
	</parameter>
	<parameter name="IMPRIMIR_GRAFICO" class="java.lang.Short" isForPrompting="false"/>
	<queryString>
		<![CDATA[select distinct p.id_produto,
       p.nome,
       p.codigo_auxiliar,
       u.sigla
from produto  p
inner join unidade_medida     u on (p.id_unidade_medida = u.id_unidade_medida)
inner join item_estnota       i on (p.id_produto        = i.id_produto)
inner join item_nota          n on (i.id_item_estnota        = n.id_item_nota)
inner join estnota            e on (i.id_estnota        = e.id_estnota)
INNER JOIN nota_propria np on np.id_nota_propria=e.id_estnota
inner join grade_item_estnota g on (i.id_item_estnota   = g.id_item_estnota)
inner join modelo_fiscal      m on (n.id_modelo_fiscal  = m.id_modelo_fiscal)
where g.data_entrada_saida between $P{DATA_INICIAL} and $P{DATA_FINAL}
and  p.id_produto between $P{ID_INICIAL} and $P{ID_FINAL}
and p.id_especie between $P{ID_ESPECIE_INICIAL} AND $P{ID_ESPECIE_FINAL}
and p.id_sub_especie between $P{ID_SUB_ESPECIE_INICIAL} AND $P{ID_SUB_ESPECIE_FINAL}
and m.compoe_fluxo_venda=1]]>
	</queryString>
	<field name="ID_PRODUTO" class="java.lang.Integer"/>
	<field name="NOME" class="java.lang.String"/>
	<field name="CODIGO_AUXILIAR" class="java.lang.String"/>
	<field name="SIGLA" class="java.lang.String"/>
	<variable name="dataRel" class="java.util.Date" resetType="Page">
		<initialValueExpression><![CDATA[new java.util.Date()]]></initialValueExpression>
	</variable>
	<variable name="VALOR_TOTAL_REL" class="java.lang.Double">
		<initialValueExpression><![CDATA[new Double(0d)]]></initialValueExpression>
	</variable>
	<variable name="VALOR_TOTAL_QTD" class="java.lang.Double">
		<initialValueExpression><![CDATA[new Double(0d)]]></initialValueExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="74" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement key="textField-1" x="155" y="9" width="279" height="17"/>
				<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 class="java.lang.String"><![CDATA[$P{NOME_EMPRESA}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-1" x="434" y="16" width="35" height="14"/>
				<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="434" y="32" width="35" height="14"/>
				<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="468" y="16" width="67" height="14"/>
				<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 class="java.util.Date"><![CDATA[$V{dataRel}]]></textFieldExpression>
			</textField>
			<textField pattern="HH.mm.ss" isBlankWhenNull="true">
				<reportElement key="textField-3" x="468" y="32" width="67" height="14"/>
				<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 class="java.util.Date"><![CDATA[$V{dataRel}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-3" x="159" y="33" width="27" height="12"/>
				<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="268" y="33" width="77" height="12"/>
				<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="187" y="33" width="80" height="12"/>
				<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 class="java.lang.String"><![CDATA[$P{CNPJ_NOME}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement key="textField-5" x="346" y="33" width="85" height="12"/>
				<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 class="java.lang.String"><![CDATA[$P{INSCRICAO_ESTADUAL_NOME}]]></textFieldExpression>
			</textField>
			<image onErrorType="Blank">
				<reportElement key="image-1" x="2" y="2" width="154" height="52"/>
				<imageExpression class="net.sf.jasperreports.engine.JRRenderable"><![CDATA[$P{LOGO_RELATORIO}]]></imageExpression>
			</image>
		</band>
	</title>
	<pageHeader>
		<band height="26" splitType="Stretch">
			<staticText>
				<reportElement key="staticText-8" x="0" y="-19" width="535" height="18"/>
				<box>
					<pen lineWidth="0.5"/>
					<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.5" lineColor="#000000"/>
					<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Top">
					<font size="10" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Evolução de Vendas]]></text>
			</staticText>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="12" splitType="Stretch">
			<rectangle>
				<reportElement key="rectangle-1" x="0" y="2" width="535" height="10" forecolor="#CCCCCC" backcolor="#CCCCCC"/>
			</rectangle>
			<staticText>
				<reportElement key="staticText-9" x="120" y="2" width="40" height="10"/>
				<textElement>
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Produto:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-10" x="452" y="2" width="19" height="10"/>
				<textElement textAlignment="Center">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[UN]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-13" x="16" y="-24" width="44" height="10"/>
				<textElement textAlignment="Right">
					<font size="7"/>
				</textElement>
				<text><![CDATA[Data Inicial:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-14" x="16" y="-13" width="44" height="10"/>
				<textElement textAlignment="Right">
					<font size="7"/>
				</textElement>
				<text><![CDATA[Data Final:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-15" x="117" y="-24" width="64" height="10"/>
				<textElement textAlignment="Right">
					<font size="7"/>
				</textElement>
				<text><![CDATA[Produto Inicial:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-16" x="117" y="-13" width="64" height="10"/>
				<textElement textAlignment="Right">
					<font size="7"/>
				</textElement>
				<text><![CDATA[Produto Final:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-17" x="229" y="-24" width="74" height="10"/>
				<textElement textAlignment="Right">
					<font size="7"/>
				</textElement>
				<text><![CDATA[Espécie Inicial:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-18" x="229" y="-13" width="74" height="10"/>
				<textElement textAlignment="Right">
					<font size="7"/>
				</textElement>
				<text><![CDATA[Espécie Final:]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement key="textField-11" x="180" y="-24" width="31" height="10"/>
				<textElement textAlignment="Right">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.Long"><![CDATA[$P{ID_INICIAL}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement key="textField-12" x="181" y="-13" width="30" height="10"/>
				<textElement textAlignment="Right">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.Long"><![CDATA[$P{ID_FINAL}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement key="textField-13" x="60" y="-24" width="49" height="10"/>
				<textElement textAlignment="Center">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$P{DATA_INICIAL}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement key="textField-14" x="60" y="-13" width="49" height="10"/>
				<textElement textAlignment="Center">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$P{DATA_FINAL}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement key="textField-15" x="305" y="-13" width="100" height="10"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$P{ID_ESPECIE_FINAL}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement key="textField-16" x="305" y="-24" width="100" height="10"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$P{ID_ESPECIE_INICIAL}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-19" x="405" y="-13" width="74" height="10"/>
				<textElement textAlignment="Right">
					<font size="7"/>
				</textElement>
				<text><![CDATA[Sub Espécie Final:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-20" x="405" y="-24" width="74" height="10"/>
				<textElement textAlignment="Right">
					<font size="7"/>
				</textElement>
				<text><![CDATA[Sub Espécie Inicial:]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement key="textField-17" x="479" y="-24" width="44" height="10"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$P{ID_SUB_ESPECIE_INICIAL}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement key="textField-18" x="479" y="-13" width="44" height="10"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$P{ID_SUB_ESPECIE_FINAL}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-23" x="2" y="2" width="46" height="10"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Identificador:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-24" x="54" y="2" width="62" height="10"/>
				<textElement textAlignment="Center">
					<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Cód. Auxiliar]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="19" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement key="textField" x="2" y="0" width="46" height="10"/>
				<textElement textAlignment="Right">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.Integer"><![CDATA[$F{ID_PRODUTO}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement key="textField" x="453" y="0" width="27" height="10"/>
				<textElement textAlignment="Center">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{SIGLA}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement key="textField" x="120" y="0" width="331" height="10"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{ID_PRODUTO}.toString()+" - "+$F{NOME}]]></textFieldExpression>
			</textField>
			<line>
				<reportElement key="line" positionType="Float" x="0" y="17" width="534" height="1"/>
				<graphicElement>
					<pen lineWidth="0.25"/>
				</graphicElement>
			</line>
			<subreport isUsingCache="true">
				<reportElement key="subreport-1" x="0" y="11" width="535" height="5" isPrintWhenDetailOverflows="true"/>
				<subreportParameter name="ID_PRODUTO">
					<subreportParameterExpression><![CDATA[$F{ID_PRODUTO}]]></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_GRAFICO">
					<subreportParameterExpression><![CDATA[$P{IMPRIMIR_GRAFICO}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR_OUTR} + "SUB_OUTR_EVOLUCAO_VENDAS_PRODUTOS.jasper"]]></subreportExpression>
			</subreport>
			<textField isBlankWhenNull="true">
				<reportElement key="textField" x="54" y="0" width="62" height="10"/>
				<textElement textAlignment="Center">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CODIGO_AUXILIAR}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band splitType="Stretch"/>
	</pageFooter>
	<lastPageFooter>
		<band height="18" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement key="textField-8" x="494" y="8" width="11" height="10"/>
				<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 class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" isBlankWhenNull="true">
				<reportElement key="textField-9" x="513" y="8" width="11" height="10"/>
				<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 class="java.lang.Integer"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-7" x="505" y="8" width="8" height="10"/>
				<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-10" x="316" y="8" width="160" height="10" forecolor="#0099FF"/>
				<textElement textAlignment="Center">
					<font size="7" isItalic="true" isUnderline="true" pdfFontName="Helvetica-Oblique"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["www.contatosistemas.com"]]></textFieldExpression>
				<hyperlinkReferenceExpression><![CDATA["HTTP://WWW.CONTATOSISTEMAS.COM"]]></hyperlinkReferenceExpression>
			</textField>
		</band>
	</lastPageFooter>
	<summary>
		<band height="15" splitType="Stretch"/>
	</summary>
</jasperReport>
