1 or i.cancelado is null)
and
(i.entrada_saida_natureza_op=0 OR i.entrada_saida_natureza_op=2 )
AND
i.id_empresa= $P{ID_EMPRESA}
group BY
C.codigo]]>
<band height="82" splitType="Stretch">
<textField isBlankWhenNull="true">
<reportElement key="textField-7" x="155" y="8" width="279" height="17" uuid="ede6852b-1a3a-4785-b3d2-296e7ed08b10"/>
<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-21" x="159" y="32" width="27" height="12" uuid="0091f8bf-4ef1-4e58-a833-5e89a86fe517"/>
<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-22" x="268" y="32" width="77" height="12" uuid="b137202f-f61e-4baa-8183-5c2ef827a170"/>
<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-10" x="187" y="32" width="80" height="12" uuid="f983909e-8381-4e44-bf4f-1a4ba383c50c"/>
<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-11" x="346" y="32" width="85" height="12" uuid="70dd149c-7e40-4235-a680-2063cc1faeb9"/>
<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>
<staticText>
<reportElement key="staticText-23" mode="Opaque" x="0" y="55" width="536" height="14" backcolor="#CCCCCC" uuid="50a59f5a-115e-45e0-9e45-f90f5abae746"/>
<box>
<pen lineWidth="0.5" lineStyle="Solid"/>
<topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
<leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
<bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
<rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Top">
<font size="10" isBold="true"/>
</textElement>
<text><![CDATA[REGISTRO DE APURAÇÃO DO ICMS]]></text>
</staticText>
<staticText>
<reportElement key="staticText-27" x="1" y="70" width="30" height="12" uuid="30c4caf4-6f23-4569-b014-d3bb3d3910c7"/>
<textElement textAlignment="Right">
<font size="8" isBold="true"/>
</textElement>
<text><![CDATA[Folha:]]></text>
</staticText>
<textField isBlankWhenNull="false">
<reportElement key="textField" x="30" y="70" width="38" height="12" uuid="9b78ebbd-6bb5-4221-8a21-bb12b245b715"/>
<textElement textAlignment="Center">
<font size="8"/>
</textElement>
<textFieldExpression><![CDATA[$P{FOLHA}]]></textFieldExpression>
</textField>
<image>
<reportElement key="image-1" x="0" y="0" width="154" height="52" uuid="78493eaf-d662-48e9-8fb9-b8dfe2fef123"/>
<imageExpression><![CDATA[$P{LOGO_RELATORIO}]]></imageExpression>
</image>
<staticText>
<reportElement key="staticText-28" x="103" y="70" width="41" height="12" uuid="d483963c-1a4c-43f7-a682-01f46c221b05"/>
<textElement textAlignment="Right">
<font size="8" isBold="true"/>
</textElement>
<text><![CDATA[Período:]]></text>
</staticText>
<textField pattern="dd/MM/yy" isBlankWhenNull="false">
<reportElement key="textField" x="144" y="70" width="41" height="12" uuid="d37a65e8-8243-4d88-8c05-504281af58fc"/>
<textElement textAlignment="Center">
<font size="8"/>
</textElement>
<textFieldExpression><![CDATA[$P{DATA_INICIAL}]]></textFieldExpression>
</textField>
<textField pattern="dd/MM/yy" isBlankWhenNull="false">
<reportElement key="textField" x="193" y="70" width="41" height="12" uuid="760fee9a-2252-47df-bfc5-c61eb38b2ada"/>
<textElement textAlignment="Center">
<font size="8"/>
</textElement>
<textFieldExpression><![CDATA[$P{DATA_FINAL}]]></textFieldExpression>
</textField>
<staticText>
<reportElement key="staticText-29" x="184" y="70" width="10" height="12" uuid="b978aaee-fe6f-4c4e-9648-96afdaf13b9c"/>
<textElement textAlignment="Center">
<font size="8" isBold="true"/>
</textElement>
<text><![CDATA[a]]></text>
</staticText>
<staticText>
<reportElement key="staticText-28" x="355" y="70" width="65" height="12" uuid="7cec3e3c-fc1b-4fec-b89d-7be751b1446a">
<property name="com.jaspersoft.studio.unit.width" value="pixel"/>
<printWhenExpression><![CDATA[new Boolean ($P{EXIBIR_DATA_IMPRESSAO} == 1 )]]></printWhenExpression>
</reportElement>
<textElement textAlignment="Right">
<font size="8" isBold="true"/>
</textElement>
<text><![CDATA[Data empressão:]]></text>
</staticText>
<textField pattern="dd/MM/yyyy HH:mm " isBlankWhenNull="false">
<reportElement key="textField" x="422" y="70" width="92" height="12" uuid="ae978b31-76ab-4d6a-a0b8-281b371cee42">
<printWhenExpression><![CDATA[new Boolean ($P{EXIBIR_DATA_IMPRESSAO} == 1 )]]></printWhenExpression>
</reportElement>
<textElement textAlignment="Center">
<font size="8"/>
</textElement>
<textFieldExpression><![CDATA[new Date()]]></textFieldExpression>
</textField>
</band>