1
OR S.id_situacao_pedidos IN(Select SP.id_situacao_pedidos From situacao_pedidos SP Where UPPER(SP.descricao) Like '%PEDIDO CANCELADO%')))
or
g.id_grupo_de_situacoes between $P{ID_GRUPO_SIT_INICIAL} AND $P{ID_GRUPO_SIT_FINAL})
and p.data_previsao_saida between $P{DATA_INICIAL} AND $P{DATA_FINAL}
AND u.id_cliente between $P{ID_CLIENTE_INICIAL} AND $P{ID_CLIENTE_FINAL}]]>
<band height="55" splitType="Stretch">
<image onErrorType="Blank">
<reportElement key="image-1" x="131" y="1" width="154" height="52" uuid="919225db-0cb7-4266-bb9e-d94a553df35c"/>
<imageExpression><![CDATA[$P{LOGO_RELATORIO}]]></imageExpression>
</image>
<textField isBlankWhenNull="true">
<reportElement key="textField-1" x="286" y="9" width="279" height="17" uuid="337857b7-abd5-4f88-9ccb-994a73c3f202"/>
<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-1" x="565" y="16" width="35" height="14" uuid="673d8dd4-9edf-4041-bacc-c36ba340a6b8"/>
<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-2" x="565" y="32" width="35" height="14" uuid="ee7ddab8-2f8f-44cd-ae74-de1f0c899f22"/>
<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>
<staticText>
<reportElement key="staticText-3" x="290" y="33" width="27" height="12" uuid="5e0fd592-12d0-43de-bbbd-93705f6be067"/>
<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-4" x="399" y="33" width="77" height="12" uuid="4f779282-c975-464b-bcf9-477061c7d6f5"/>
<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-4" x="318" y="33" width="80" height="12" uuid="c7d7b41f-91cf-4db1-9d66-3a4efbbaa2a0"/>
<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="477" y="33" width="85" height="12" uuid="70cd88a3-b700-469f-9bd9-2317f1cf345f"/>
<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>
<textField evaluationTime="Report" pattern="dd/MM/yyyy" isBlankWhenNull="false">
<reportElement key="textField-6" x="600" y="16" width="66" height="14" uuid="90f8bfe0-767c-4655-bf98-ddd771969852"/>
<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
</textField>
<textField evaluationTime="Report" pattern="HH.mm.ss" isBlankWhenNull="false">
<reportElement key="textField-7" x="600" y="30" width="66" height="16" uuid="e0f650ed-c596-4422-8596-1d4cd160734b"/>
<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
</textField>
</band>