1 OR CL.ID_CLIENTE_CONT_SISTEMAS BETWEEN $P{CLIENTE_INICIAL} AND $P{CLIENTE_FINAL})
AND (($P{TIPO_DATA} = 0 AND R.DATA_CADASTRO BETWEEN $P{DATA_INICIAL} AND $P{DATA_INICIAL})
OR ($P{TIPO_DATA} = 1 AND R.DATA_FINALIZACAO BETWEEN $P{DATA_INICIAL} AND $P{DATA_FINAL}))
ORDER BY
C.ID_CLASSIFICACAO_MARKETING,
P.ID_PROCEDENCIA_SOLICITACAO]]>
<band height="101" splitType="Stretch">
<textField isBlankWhenNull="true">
<reportElement key="textField-9" x="155" y="10" 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-9" x="434" y="17" 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-10" x="434" y="33" 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-10" x="468" y="17" 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-11" x="468" y="33" 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-11" x="159" y="34" 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-12" x="268" y="34" 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-12" x="187" y="34" 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-13" x="346" y="34" 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>
<reportElement key="image-1" x="0" y="0" width="154" height="52"/>
<imageExpression class="net.sf.jasperreports.engine.JRRenderable"><![CDATA[$P{LOGO_RELATORIO}]]></imageExpression>
</image>
<staticText>
<reportElement key="staticText-13" x="0" y="54" width="535" height="14"/>
<box>
<pen lineWidth="0.5" lineStyle="Solid"/>
<topPen lineWidth="0.5" lineStyle="Solid"/>
<leftPen lineWidth="0.5" lineStyle="Solid"/>
<bottomPen lineWidth="0.5" lineStyle="Solid"/>
<rightPen lineWidth="0.5" lineStyle="Solid"/>
</box>
<textElement textAlignment="Center">
<font isBold="true"/>
</textElement>
<text><![CDATA[Listagem Soluções Versão]]></text>
</staticText>
<staticText>
<reportElement key="staticText-14" positionType="Float" x="0" y="70" width="44" height="10"/>
<textElement textAlignment="Right">
<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
</textElement>
<text><![CDATA[Tipo Data:]]></text>
</staticText>
<staticText>
<reportElement key="staticText-15" positionType="Float" x="-8" y="80" width="53" height="10"/>
<textElement textAlignment="Right">
<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
</textElement>
<text><![CDATA[Data Inicial:]]></text>
</staticText>
<staticText>
<reportElement key="staticText-16" positionType="Float" x="0" y="91" width="44" height="10"/>
<textElement textAlignment="Right">
<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
</textElement>
<text><![CDATA[Data Final:]]></text>
</staticText>
<textField isBlankWhenNull="false">
<reportElement key="textField" x="44" y="70" width="36" height="10"/>
<textElement textAlignment="Left">
<font size="7"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{TIPO_DATA}.intValue() == 0 ? "Cadastro" : "Solução"]]></textFieldExpression>
</textField>
<textField pattern="dd/MM/yyyy" isBlankWhenNull="false">
<reportElement key="textField" x="45" y="80" width="46" height="10"/>
<textElement textAlignment="Left">
<font size="7"/>
</textElement>
<textFieldExpression class="java.util.Date"><![CDATA[$P{DATA_INICIAL}]]></textFieldExpression>
</textField>
<textField pattern="dd/MM/yyyy" isBlankWhenNull="false">
<reportElement key="textField" x="45" y="91" width="46" height="10"/>
<textElement textAlignment="Left">
<font size="7"/>
</textElement>
<textFieldExpression class="java.util.Date"><![CDATA[$P{DATA_FINAL}]]></textFieldExpression>
</textField>
<staticText>
<reportElement key="staticText-17" positionType="Float" x="85" y="69" width="52" height="10"/>
<textElement>
<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
</textElement>
<text><![CDATA[Procedencia:]]></text>
</staticText>
<staticText>
<reportElement key="staticText-18" positionType="Float" x="85" y="80" width="52" height="10"/>
<textElement>
<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
</textElement>
<text><![CDATA[Classificação:]]></text>
</staticText>
<textField isBlankWhenNull="false">
<reportElement key="textField" x="136" y="69" width="96" height="10"/>
<textElement>
<font size="7"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{PROCEDENCIA} == null ? "Todas" : $P{PROCEDENCIA}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="false">
<reportElement key="textField" x="136" y="80" width="96" height="10"/>
<textElement>
<font size="7"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{CLASSIFICACAO} == null ? "Todas" : $P{CLASSIFICACAO}]]></textFieldExpression>
</textField>
<staticText>
<reportElement key="staticText-19" x="234" y="69" width="54" height="10"/>
<textElement textAlignment="Right">
<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
</textElement>
<text><![CDATA[Filtrar Cliente:]]></text>
</staticText>
<textField pattern="dd/MM/yyyy" isBlankWhenNull="true">
<reportElement key="textField-14" x="288" y="69" width="28" height="10"/>
<textElement textAlignment="Center">
<font size="7"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{FILTRAR_CLIENTE}.intValue() == 1 ? "Sim" : "Não"]]></textFieldExpression>
</textField>
<staticText>
<reportElement key="staticText-20" x="316" y="69" width="56" height="10">
<printWhenExpression><![CDATA[new Boolean($P{FILTRAR_CLIENTE}.intValue() == 1)]]></printWhenExpression>
</reportElement>
<textElement textAlignment="Right">
<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
</textElement>
<text><![CDATA[Cliente Inicial:]]></text>
</staticText>
<staticText>
<reportElement key="staticText-21" x="316" y="80" width="56" height="10">
<printWhenExpression><![CDATA[new Boolean($P{FILTRAR_CLIENTE}.intValue() == 1)]]></printWhenExpression>
</reportElement>
<textElement textAlignment="Right">
<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
</textElement>
<text><![CDATA[Cliente Final:]]></text>
</staticText>
<textField pattern="#,##0" isBlankWhenNull="true">
<reportElement key="textField-15" x="372" y="69" width="36" height="10">
<printWhenExpression><![CDATA[new Boolean($P{FILTRAR_CLIENTE}.intValue() == 1)]]></printWhenExpression>
</reportElement>
<textElement textAlignment="Center">
<font size="7"/>
</textElement>
<textFieldExpression class="java.lang.Integer"><![CDATA[$P{CLIENTE_INICIAL}]]></textFieldExpression>
</textField>
<textField pattern="#,##0" isBlankWhenNull="true">
<reportElement key="textField-16" x="372" y="80" width="36" height="10">
<printWhenExpression><![CDATA[new Boolean($P{FILTRAR_CLIENTE}.intValue() == 1)]]></printWhenExpression>
</reportElement>
<textElement textAlignment="Center">
<font size="7"/>
</textElement>
<textFieldExpression class="java.lang.Integer"><![CDATA[$P{CLIENTE_FINAL}]]></textFieldExpression>
</textField>
<staticText>
<reportElement key="staticText-22" positionType="Float" x="288" y="80" width="28" height="10"/>
<textElement textAlignment="Center">
<font size="7" isBold="false" pdfFontName="Helvetica"/>
</textElement>
<text><![CDATA[Sim]]></text>
</staticText>
<textField isBlankWhenNull="false">
<reportElement key="textField" x="234" y="80" width="54" height="10"/>
<textElement textAlignment="Right">
<font size="7" isBold="true" pdfFontName="Helvetica-Bold"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{ANALITICO_SINTETICO}.intValue() == 1 ? "Analítico: " : "Sintético: "]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement key="textField" x="410" y="69" width="125" height="10"/>
<textElement>
<font size="7"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{NOME_CLIENTE_INICIAL}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement key="textField" x="410" y="80" width="125" height="10"/>
<textElement>
<font size="7"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$P{NOME_CLIENTE_FINAL}]]></textFieldExpression>
</textField>
</band>