<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.10.0.final using JasperReports Library version 6.10.0-unknown  -->
<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="INDIVIDUAL_FORMULACAO_ITENS" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" uuid="12a3b971-4509-47b8-b372-923ec1632cbf">
	<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="java.util.*"/>
	<import value="net.sf.jasperreports.engine.data.*"/>
	<import value="net.sf.jasperreports.engine.*"/>
	<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="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="SUBREPORT_DIR_IND" class="java.lang.String"/>
	<parameter name="LOGO_RELATORIO" class="net.sf.jasperreports.engine.JRImageRenderer" isForPrompting="false"/>
	<parameter name="ID_FORMULA_PRODUTO" class="java.lang.Long"/>
	<parameter name="F_EXIBIR_COMPRIMENTO" class="java.lang.Short"/>
	<parameter name="F_EXIBIR_LARGURA" class="java.lang.Short"/>
	<parameter name="F_EXIBIR_QUANTIDADE" class="java.lang.Short"/>
	<parameter name="F_EXIBIR_QUANTIDADE_REF" class="java.lang.Short"/>
	<parameter name="F_EXIBIR_OBSERVACAO" class="java.lang.Short"/>
	<parameter name="P_EXIBIR_LINHA_TRACEJADA" class="java.lang.Short"/>
	<queryString>
		<![CDATA[select p.id_produto,
p.nome,
p.codigo_auxiliar,
c.nome as nome_cor,
u.sigla,
G.ID_GRADE_FORMULA_PRODUTO
from grade_formula_produto g
inner join grade_cor gc on gc.id_grade_cor=g.id_grade_cor
inner join produto_grade pg on pg.id_produto_grade=gc.id_produto_grade
inner join produto p on pg.id_produto = p.id_produto
inner join cor c on c.id_cor=gc.id_cor
inner join unidade_medida u on u.id_unidade_medida=p.id_unidade_medida

where g.id_grade_formula_produto=$P{ID_FORMULA_PRODUTO}]]>
	</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="NOME_COR" class="java.lang.String"/>
	<field name="SIGLA" class="java.lang.String"/>
	<field name="ID_GRADE_FORMULA_PRODUTO" class="java.lang.Integer"/>
	<variable name="dataRel" class="java.util.Date" resetType="Page">
		<initialValueExpression><![CDATA[new java.util.Date()]]></initialValueExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="69" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement key="textField-13" x="154" y="8" width="279" height="17" uuid="51462fba-4a29-4d21-9028-6c29cbfdee2f"/>
				<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"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{NOME_EMPRESA}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-16" x="433" y="15" width="35" height="14" uuid="14b33d4b-48f6-4840-a296-5efa06c99f14"/>
				<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"/>
				</textElement>
				<text><![CDATA[Data :]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-17" x="433" y="31" width="35" height="14" uuid="61800282-f502-41af-ae4d-b68bc914c66f"/>
				<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"/>
				</textElement>
				<text><![CDATA[Hora :]]></text>
			</staticText>
			<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement key="textField-14" x="467" y="15" width="67" height="14" uuid="a33e9adb-e74d-4647-b943-95fbebf924e0"/>
				<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-15" x="467" y="31" width="67" height="14" uuid="4dc8f84a-80b3-4c23-a3f3-c5d4ba0d5d01"/>
				<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-18" x="158" y="32" width="27" height="12" uuid="b615c742-deeb-4394-8f7f-0a2fd0a7f95c"/>
				<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"/>
				</textElement>
				<text><![CDATA[CNPJ :]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-19" x="267" y="32" width="77" height="12" uuid="5149d9a1-93af-47a5-a953-9f8621ddcbec"/>
				<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"/>
				</textElement>
				<text><![CDATA[Inscrição Estadual :]]></text>
			</staticText>
			<textField isBlankWhenNull="true">
				<reportElement key="textField-16" x="186" y="32" width="80" height="12" uuid="b530e338-1578-4e77-8010-91ef6a422496"/>
				<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-17" x="345" y="32" width="85" height="12" uuid="e126c78a-1613-4371-a5d1-c64e46620e6f"/>
				<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="0" y="0" width="154" height="52" uuid="45dac1fd-7f26-42a8-979f-aa0fdc3ebd6d"/>
				<imageExpression><![CDATA[$P{LOGO_RELATORIO}]]></imageExpression>
			</image>
			<staticText>
				<reportElement key="staticText-5" x="0" y="55" width="535" height="14" uuid="a68b597e-4c21-4076-b942-914ef062c822"/>
				<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"/>
				</textElement>
				<text><![CDATA[Relatório Individual: Formulação de Produtos]]></text>
			</staticText>
			<line>
				<reportElement key="line-1" x="0" y="53" width="535" height="1" uuid="5657003b-f621-4a60-967d-8674f01b8106"/>
				<graphicElement>
					<pen lineWidth="0.25" lineStyle="Solid"/>
				</graphicElement>
			</line>
		</band>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="33" splitType="Stretch">
			<rectangle>
				<reportElement key="rectangle-1" x="0" y="0" width="535" height="10" forecolor="#CCCCCC" backcolor="#CCCCCC" uuid="602bb998-9eed-4747-a003-d6aae6801601"/>
			</rectangle>
			<staticText>
				<reportElement key="staticText-13" x="104" y="0" width="105" height="11" uuid="4b9bfb04-2782-4d9c-9811-70b950a091ec"/>
				<textElement textAlignment="Left">
					<font size="7" isBold="true"/>
				</textElement>
				<text><![CDATA[Produto/Grade:]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-14" x="468" y="0" width="67" height="11" uuid="86759a38-3156-4ce8-9e0e-351b80845a5d"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true"/>
				</textElement>
				<text><![CDATA[Unidade Medida:]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement key="textField" x="104" y="11" width="262" height="10" uuid="c5105b6e-2673-488a-afbe-514dfed708bd"/>
				<textElement>
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{NOME}+" / "+$F{NOME_COR}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement key="textField" x="468" y="11" width="67" height="10" uuid="7701ba8d-c12a-4397-afa0-33b58d35a8c1"/>
				<textElement textAlignment="Center">
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{SIGLA}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-25" x="367" y="0" width="100" height="11" uuid="2e0b2907-bd95-4e32-99cb-6795b6a38ede"/>
				<textElement textAlignment="Center">
					<font size="7" isBold="true"/>
				</textElement>
				<text><![CDATA[Cód. Aux/NI:]]></text>
			</staticText>
			<subreport isUsingCache="true">
				<reportElement key="subreport-1" positionType="Float" x="0" y="21" width="535" height="12" uuid="c9988933-f903-4e4b-aeed-903bc6a95ba1"/>
				<subreportParameter name="ID_GRADE_FORMULA_PRODUTO">
					<subreportParameterExpression><![CDATA[$F{ID_GRADE_FORMULA_PRODUTO}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="NOME_PROD">
					<subreportParameterExpression><![CDATA[$F{NOME}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="SUBREPORT_DIR_IND">
					<subreportParameterExpression><![CDATA[$P{SUBREPORT_DIR_IND}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="DESC_GRADE">
					<subreportParameterExpression><![CDATA[$F{NOME_COR}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="F_EXIBIR_COMPRIMENTO">
					<subreportParameterExpression><![CDATA[$P{F_EXIBIR_COMPRIMENTO}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="F_EXIBIR_LARGURA">
					<subreportParameterExpression><![CDATA[$P{F_EXIBIR_LARGURA}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="F_EXIBIR_QUANTIDADE_REF">
					<subreportParameterExpression><![CDATA[$P{F_EXIBIR_QUANTIDADE_REF}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="F_EXIBIR_OBSERVACAO">
					<subreportParameterExpression><![CDATA[$P{F_EXIBIR_OBSERVACAO}]]></subreportParameterExpression>
				</subreportParameter>
				<subreportParameter name="P_EXIBIR_LINHA_TRACEJADA">
					<subreportParameterExpression><![CDATA[$P{P_EXIBIR_LINHA_TRACEJADA}]]></subreportParameterExpression>
				</subreportParameter>
				<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
				<subreportExpression><![CDATA[$P{SUBREPORT_DIR_IND} + "SUB_IND_FORMULACAO_ITENS.jasper"]]></subreportExpression>
			</subreport>
			<textField isBlankWhenNull="true">
				<reportElement key="textField" x="367" y="11" width="100" height="10" uuid="6b9b927c-2bc6-49af-9691-4c717be39ebf"/>
				<textElement textAlignment="Center">
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{CODIGO_AUXILIAR}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="false">
				<reportElement key="textField" x="47" y="11" width="52" height="10" uuid="2c0bf5ff-eef3-4d35-bd09-c1199aed6b91"/>
				<textElement textAlignment="Right">
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{ID_PRODUTO}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-26" x="47" y="0" width="52" height="11" uuid="5bcfd939-d2d4-4824-967b-0634f0be77e3"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true"/>
				</textElement>
				<text><![CDATA[Id. Produto]]></text>
			</staticText>
			<staticText>
				<reportElement key="staticText-27" x="1" y="0" width="47" height="11" uuid="e62a8fc1-ccf0-47bf-ac3c-91d265156c3a"/>
				<textElement textAlignment="Right">
					<font size="7" isBold="true"/>
				</textElement>
				<text><![CDATA[Identificador:]]></text>
			</staticText>
			<textField>
				<reportElement x="1" y="10" width="46" height="11" uuid="b7c5c91d-da77-4ffd-a3bc-41aafa64931c"/>
				<textElement textAlignment="Right">
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{ID_GRADE_FORMULA_PRODUTO}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="11" splitType="Stretch">
			<textField isBlankWhenNull="true">
				<reportElement key="textField-8" x="505" y="0" width="11" height="10" uuid="58fa6283-7e24-4d7e-9992-bcdc1d033dba"/>
				<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"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" isBlankWhenNull="true">
				<reportElement key="textField-9" x="524" y="0" width="11" height="10" uuid="672adba0-a404-4d21-8641-ae08ab594e69"/>
				<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"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement key="staticText-8" x="516" y="0" width="8" height="10" uuid="9bd3be63-0b35-4617-9c0e-c3a006ae9918"/>
				<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"/>
				</textElement>
				<text><![CDATA[/]]></text>
			</staticText>
			<textField isBlankWhenNull="false" hyperlinkType="RemotePage">
				<reportElement key="textField-18" x="411" y="1" width="94" height="10" forecolor="#0099FF" uuid="8e21ccff-b63a-41b4-b8f4-b3ebe2e24ab5"/>
				<textElement textAlignment="Center">
					<font size="7" isItalic="true" isUnderline="true"/>
				</textElement>
				<textFieldExpression><![CDATA["www.contatosistemas.com"]]></textFieldExpression>
				<hyperlinkReferenceExpression><![CDATA["HTTP://WWW.CONTATOSISTEMAS.COM"]]></hyperlinkReferenceExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band height="30" splitType="Stretch">
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement key="textField" x="0" y="0" width="535" height="30" uuid="774e219e-fae6-4f53-9922-980859cba84d"/>
				<textElement textAlignment="Center" markup="html">
					<font size="7"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{FECHO}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
</jasperReport>
