Ireport Converte String para DATA, comparação de parametros ![resolvido]

juniorsatanas · Outubro 15, 2010, 4:29pm

Tenho um campo data do cadastro, quero pegar todos os clientes que tenha a data do cadastro, igual entre duas datas PARÂMETROS !

[code]SELECT
cliente_fisica."clfi_cpf" AS cliente_fisica_clfi_cpf,
cliente_fisica."clfi_nome" AS cliente_fisica_clfi_nome,
cliente_fisica."clfi_pk_id" AS cliente_fisica_clfi_pk_id,
cliente_fisica."clfi_data_cadastro" AS cliente_fisica_clfi_data_cadastro
FROM
"sigi"."cliente_fisica" cliente_fisica

WHERE clfi_data_cadastro

BETWEEN date’$P{DATAINICIO}’ AND date’$P{DATAFIM}’[/code]

To pegando este erro :

Compiling to file... /home/junior/06102010/Catequese/src/java/br/com/catequese/relatorio/relClientesFisicoAtentidoPorPeriodo.jasper Compilation running time: 337! Filling report... Locale: português (Brasil) Time zone: Default Error filling print... Error preparing statement for executing the report query : SELECT cliente_fisica."clfi_cpf" AS cliente_fisica_clfi_cpf, cliente_fisica."clfi_nome" AS cliente_fisica_clfi_nome, cliente_fisica."clfi_pk_id" AS cliente_fisica_clfi_pk_id, cliente_fisica."clfi_data_cadastro" AS cliente_fisica_clfi_data_cadastro FROM "sigi"."cliente_fisica" cliente_fisica WHERE clfi_data_cadastro BETWEEN date'?' AND date'?' net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query : SELECT cliente_fisica."clfi_cpf" AS cliente_fisica_clfi_cpf, cliente_fisica."clfi_nome" AS cliente_fisica_clfi_nome, cliente_fisica."clfi_pk_id" AS cliente_fisica_clfi_pk_id, cliente_fisica."clfi_data_cadastro" AS cliente_fisica_clfi_data_cadastro FROM "sigi"."cliente_fisica" cliente_fisica WHERE clfi_data_cadastro BETWEEN date'?' AND date'?' at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.java:240) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:131) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:684) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:605) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1281) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:901) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:877) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: org.postgresql.util.PSQLException: O índice da coluna está fora do intervalo: 1, número de colunas: 0. at org.postgresql.core.v3.SimpleParameterList.bind(SimpleParameterList.java:52) at org.postgresql.core.v3.SimpleParameterList.setStringParameter(SimpleParameterList.java:117) at org.postgresql.jdbc2.AbstractJdbc2Statement.bindString(AbstractJdbc2Statement.java:2123) at org.postgresql.jdbc2.AbstractJdbc2Statement.setString(AbstractJdbc2Statement.java:1244) at org.postgresql.jdbc2.AbstractJdbc2Statement.setString(AbstractJdbc2Statement.java:1230) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.setStatementParameter(JRJdbcQueryExecuter.java:411) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.setStatementParameter(JRJdbcQueryExecuter.java:257) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.java:232) ... 12 more Print not filled. Try to use an EmptyDataSource...

Se eu fazer assim :

[code]SELECT
cliente_fisica."clfi_cpf" AS cliente_fisica_clfi_cpf,
cliente_fisica."clfi_nome" AS cliente_fisica_clfi_nome,
cliente_fisica."clfi_pk_id" AS cliente_fisica_clfi_pk_id,
cliente_fisica."clfi_data_cadastro" AS cliente_fisica_clfi_data_cadastro
FROM
"sigi"."cliente_fisica" cliente_fisica

WHERE clfi_data_cadastro

BETWEEN $P{DATAINICIO} AND $P{DATAFIM}[/code]

da este erro :

Filling report... Locale: português (Brasil) Time zone: Default Error filling print... Error executing SQL statement for : relClientesFisicoAtentidoPorPeriodo net.sf.jasperreports.engine.JRException: Error executing SQL statement for : relClientesFisicoAtentidoPorPeriodo at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:143) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:684) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:605) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1281) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:901) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:877) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: org.postgresql.util.PSQLException: ERRO: operador não existe: date >= character varying at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:137) ... 11 more Print not filled. Try to use an EmptyDataSource...

Que diabos é isso ?

davidbuzatto · Outubro 15, 2010, 6:53pm

Configure os parâmetros com o tipo java.util.Date e insira direto na query.
Obviamente é necessário passar os valores pelo mapa de parâmetros como objetos do tipo date.
Se você quer mesmo usar os parâmetros como Strings p/ usar a função de conversão (cada banco vai ser de um jeito…), vc precisa usar os parênteses ( date($P{nomeParametro}) )

[]´s

juniorsatanas · Outubro 18, 2010, 9:45am

davidbuzatto Bom dia Tudo bem por ai ?

       Vou seguir sua dica aqui ! valeu boa semana

JR.

juniorsatanas · Outubro 18, 2010, 11:00am

Ficou Assim :
SELECT
cliente_fisica.“clfi_cpf” AS cliente_fisica_clfi_cpf,
cliente_fisica.“clfi_nome” AS cliente_fisica_clfi_nome,
cliente_fisica.“clfi_pk_id” AS cliente_fisica_clfi_pk_id,
cliente_fisica.“clfi_data_cadastro” AS cliente_fisica_clfi_data_cadastro
FROM
“sigi”.“cliente_fisica” cliente_fisica

WHERE clfi_data_cadastro

BETWEEN (date($P{DATAINICIO})) AND (date($P{DATAFIM}))

Mas mesmo assim não gerou o PDF, mas não deu erro ! no postgresql pega normal, lista por data etc…

         Será que é BUG do Ireport ?

       [img]http://lh6.ggpht.com/_nTzBoYSeT2I/TLxSMvmDC9I/AAAAAAAAEMI/Rg80xUTw4aI/s720/t1.png[/img]

juniorsatanas · Outubro 18, 2010, 11:29am

Se eu por os parâmetros como jata.util.data

da este erro :

[quote] Compiling to file… /home/junior/06102010/Catequese/src/java/br/com/catequese/relatorio/relClientesFisicoAtentidoPorPeriodo.jasper
Errors compiling /home/junior/06102010/Catequese/src/java/br/com/catequese/relatorio/relClientesFisicoAtentidoPorPeriodo.jasper!
Compilation exceptions: com.jaspersoft.ireport.designer.compiler.ErrorsCollector@1c99a17c net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. Cannot cast from Date to String value = (java.lang.String)(((java.util.Date)parameter_DATAFIM.getValue())); //$JR_EXPR_ID=14$ <----------------------------------------------------------------> 2. Cannot cast from Date to String value = (java.lang.String)(((java.util.Date)parameter_DATAINICIO.getValue())); //$JR_EXPR_ID=15$ <-------------------------------------------------------------------> 3. Cannot cast from Date to String value = (java.lang.String)(((java.util.Date)parameter_DATAFIM.getValue())); //$JR_EXPR_ID=14$ <----------------------------------------------------------------> 4. Cannot cast from Date to String value = (java.lang.String)(((java.util.Date)parameter_DATAINICIO.getValue())); //$JR_EXPR_ID=15$ <-------------------------------------------------------------------> 5. Cannot cast from Date to String value = (java.lang.String)(((java.util.Date)parameter_DATAFIM.getValue())); //$JR_EXPR_ID=14$ <----------------------------------------------------------------> 6. Cannot cast from Date to String value = (java.lang.String)(((java.util.Date)parameter_DATAINICIO.getValue())); //$JR_EXPR_ID=15$ <-------------------------------------------------------------------> 6 errors at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:191) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:498) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)
Compilation running time: 125[/quote]

davidbuzatto · Outubro 18, 2010, 11:44am

Junior,

Não é suficiente apenas passar os parâmetros como Date (pelo mapa de parâmetros). Vc precisa modificar o tipo do parâmetro tbm. Dentro do iReport, no Report Inspector, procure pelos parâmetros que você está usando. Selecione cada um e veja o tipo da Expression Class - ou Parameter Class, não lembro o nome - nas propriedades. Provavelmente lá vai estar como String, por isso o erro. Mude para java.util.Date.

Mude a query para:

[code]SELECT
cliente_fisica.“clfi_cpf” AS cliente_fisica_clfi_cpf,
cliente_fisica.“clfi_nome” AS cliente_fisica_clfi_nome,
cliente_fisica.“clfi_pk_id” AS cliente_fisica_clfi_pk_id,
cliente_fisica.“clfi_data_cadastro” AS cliente_fisica_clfi_data_cadastro

FROM
“sigi”.“cliente_fisica” cliente_fisica

WHERE
clfi_data_cadastro BETWEEN $P{DATAINICIO} AND $P{DATAFIM}[/code]
Teste e veja se funciona.

[]´s

juniorsatanas · Outubro 18, 2010, 11:51am

Fiz da maneira que vc Falou !

Da este erro :

Compiling to file... /home/junior/06102010/Catequese/src/java/br/com/catequese/relatorio/relClientesFisicoAtentidoPorPeriodo.jasper Errors compiling /home/junior/06102010/Catequese/src/java/br/com/catequese/relatorio/relClientesFisicoAtentidoPorPeriodo.jasper! Compilation exceptions: com.jaspersoft.ireport.designer.compiler.ErrorsCollector@7daf053e net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. Cannot cast from Date to String value = (java.lang.String)(((java.util.Date)parameter_DATAFIM.getValue())); //$JR_EXPR_ID=14$ <----------------------------------------------------------------> 2. Cannot cast from Date to String value = (java.lang.String)(((java.util.Date)parameter_DATAINICIO.getValue())); //$JR_EXPR_ID=15$ <-------------------------------------------------------------------> 3. Cannot cast from Date to String value = (java.lang.String)(((java.util.Date)parameter_DATAFIM.getValue())); //$JR_EXPR_ID=14$ <----------------------------------------------------------------> 4. Cannot cast from Date to String value = (java.lang.String)(((java.util.Date)parameter_DATAINICIO.getValue())); //$JR_EXPR_ID=15$ <-------------------------------------------------------------------> 5. Cannot cast from Date to String value = (java.lang.String)(((java.util.Date)parameter_DATAFIM.getValue())); //$JR_EXPR_ID=14$ <----------------------------------------------------------------> 6. Cannot cast from Date to String value = (java.lang.String)(((java.util.Date)parameter_DATAINICIO.getValue())); //$JR_EXPR_ID=15$ <-------------------------------------------------------------------> 6 errors at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:191) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:498) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Compilation running time: 130

davidbuzatto · Outubro 18, 2010, 12:06pm

Olhe o erro:
[color=red][size=18]Cannot cast from Date to String[/size][/color]

Você precisa mudar o tipo do parâmetro. Vc fez isso?

juniorsatanas · Outubro 18, 2010, 12:37pm

Sim veja na imagem AVAILABLE PARAMETERES ! está como date !

TheKill · Outubro 18, 2010, 12:43pm

Ele só mudou na paleta onde mostra os parameters,

Tem que mudar no seu Query também. porque ele deve estar String

juniorsatanas · Outubro 18, 2010, 12:51pm

[code]<?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=“relClientesFisicoAtentidoPorPeriodo” pageWidth=“595” pageHeight=“842” columnWidth=“555” leftMargin=“20” rightMargin=“20” topMargin=“20” bottomMargin=“20”>
<property name=“ireport.zoom” value=“1.0”/>
<property name=“ireport.x” value=“0”/>
<property name=“ireport.y” value=“0”/>
<parameter name=“DATAINICIO” class=“java.util.Date”>
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name=“DATAFIM” class=“java.util.Date”>
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT
cliente_fisica.“clfi_cpf” AS cliente_fisica_clfi_cpf,
cliente_fisica.“clfi_nome” AS cliente_fisica_clfi_nome,
cliente_fisica.“clfi_pk_id” AS cliente_fisica_clfi_pk_id,
cliente_fisica.“clfi_data_cadastro” AS cliente_fisica_clfi_data_cadastro

FROM
“sigi”.“cliente_fisica” cliente_fisica

WHERE
clfi_data_cadastro BETWEEN $P{DATAINICIO} AND $P{DATAFIM}]]>
</queryString>
<field name=“cliente_fisica_clfi_cpf” class=“java.lang.String”/>
<field name=“cliente_fisica_clfi_nome” class=“java.lang.String”/>
<field name=“cliente_fisica_clfi_pk_id” class=“java.lang.Integer”/>
<field name=“cliente_fisica_clfi_data_cadastro” class=“java.sql.Date”/>
<filterExpression><![CDATA[]]></filterExpression>
<title>
<band height=“134” splitType=“Stretch”>
<staticText>
<reportElement x=“112” y=“40” width=“348” height=“24”/>
<textElement verticalAlignment=“Middle”>

</textElement>
<text><![CDATA[SISTEMA INTEGRADO E GESTÃO INTEGRADO( SIGI )]]></text>
</staticText>
<staticText>
<reportElement x=“169” y=“101” width=“212” height=“20”/>
<textElement verticalAlignment=“Middle”>

</textElement>
<text><![CDATA[Atendimento Cliente Físico]]></text>
</staticText>
<textField pattern=“dd/MM/yyyy”>
<reportElement x=“455” y=“94” width=“100” height=“20”/>
<textElement verticalAlignment=“Middle”/>
<textFieldExpression class=“java.util.Date”><![CDATA[new java.util.Date()]]></textFieldExpression>
</textField>
<textField>
<reportElement x=“392” y=“114” width=“95” height=“20”/>
<textElement textAlignment=“Right” verticalAlignment=“Middle”/>
<textFieldExpression class=“java.lang.String”><![CDATA[“Página “+$V{PAGE_NUMBER}+” de”]]></textFieldExpression>
</textField>
<textField evaluationTime=“Report”>
<reportElement x=“487” y=“114” width=“40” height=“20”/>
<textElement verticalAlignment=“Middle”/>
<textFieldExpression class=“java.lang.String”><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x=“426” y=“94” width=“27” height=“20”/>
<textElement verticalAlignment=“Middle”/>
<text><![CDATA[Data:]]></text>
</staticText>
<textField>
<reportElement x=“0” y=“84” width=“100” height=“20”/>
<textElement/>
<textFieldExpression class=“java.lang.String”><![CDATA[$P{DATAFIM}]]></textFieldExpression>
</textField>
<textField>
<reportElement x=“0” y=“64” width=“100” height=“20”/>
<textElement/>
<textFieldExpression class=“java.lang.String”><![CDATA[$P{DATAINICIO}]]></textFieldExpression>
</textField>
</band>
</title>
<pageHeader>
<band height=“37” splitType=“Stretch”>
<staticText>
<reportElement x=“0” y=“11” width=“112” height=“20”/>
<textElement verticalAlignment=“Middle”>

</textElement>
<text><![CDATA[CPF]]></text>
</staticText>
<staticText>
<reportElement x=“125” y=“11” width=“430” height=“20”/>
<textElement verticalAlignment=“Middle”>

</textElement>
<text><![CDATA[Cliente ]]></text>
</staticText>
<line>
<reportElement x=“0” y=“10” width=“555” height=“1”/>
</line>
<line>
<reportElement x=“0” y=“31” width=“555” height=“1”/>
</line>
</band>
</pageHeader>
<detail>
<band height=“24” splitType=“Stretch”>
<textField>
<reportElement x=“125” y=“0” width=“430” height=“20”/>
<textElement verticalAlignment=“Middle”/>
<textFieldExpression class=“java.lang.String”><![CDATA[$F{cliente_fisica_clfi_nome}]]></textFieldExpression>
</textField>
<textField>
<reportElement x=“0” y=“0” width=“112” height=“20”/>
<textElement verticalAlignment=“Middle”/>
<textFieldExpression class=“java.lang.String”><![CDATA[$F{cliente_fisica_clfi_cpf}]]></textFieldExpression>
</textField>
</band>
</detail>
<summary>
<band height=“24”>
<staticText>
<reportElement x=“411” y=“0” width=“105” height=“20”/>
<textElement verticalAlignment=“Middle”>

</textElement>
<text><![CDATA[Total de Clientes:]]></text>
</staticText>
<textField>
<reportElement x=“516” y=“0” width=“39” height=“20”/>
<textElement verticalAlignment=“Middle”/>
<textFieldExpression class=“java.lang.Integer”><![CDATA[$V{PAGE_COUNT}]]></textFieldExpression>
</textField>
</band>
</summary>
</jasperReport>
[/code]

TheKill · Outubro 18, 2010, 12:52pm

                 &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$P{DATAFIM}]]&gt;&lt;/textFieldExpression&gt;  
             &lt;/textField&gt;  
             &lt;textField&gt;  
                 &lt;reportElement x="0" y="64" width="100" height="20"/&gt;  
                 &lt;textElement/&gt;  
                 &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[$P{DATAINICIO}]]&gt;&lt;/textFieldExpression&gt;

Repare nao é String

davidbuzatto · Outubro 18, 2010, 12:56pm

Todos os componentes que usarem as datas tem que estar com o mesmo tipo.
Seu problema não está na query, mas nos campos de texto apontados pelo TheKill.

[]´s

juniorsatanas · Outubro 18, 2010, 1:16pm

<textField pattern="dd/MM/yyyy"> <reportElement x="0" y="84" width="100" height="20"/> <textElement/> <textFieldExpression class="java.util.Date"><![CDATA[$P{DATAFIM}]]></textFieldExpression> </textField> <textField pattern="dd/MM/yyyy"> <reportElement x="0" y="64" width="100" height="20"/> <textElement/> <textFieldExpression class="java.util.Date"><![CDATA[$P{DATAINICIO}]]></textFieldExpression> </textField>

davidbuzatto · Outubro 18, 2010, 1:18pm

E funcionou?

juniorsatanas · Outubro 18, 2010, 1:21pm

juniorsatanas · Outubro 18, 2010, 1:22pm

não mostrou nada ! mas não deu erro !

          Mas no banco eu tenho Registros !

Que parto esse negócio !

       Pessoal Muito obrigado mesmo !

juniorsatanas · Outubro 18, 2010, 1:29pm

no final ficou assim :

   Mas não gera nada !

[code]<?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=“relClientesFisicoAtentidoPorPeriodo” pageWidth=“595” pageHeight=“842” columnWidth=“555” leftMargin=“20” rightMargin=“20” topMargin=“20” bottomMargin=“20”>
<property name=“ireport.zoom” value=“1.0”/>
<property name=“ireport.x” value=“0”/>
<property name=“ireport.y” value=“0”/>
<parameter name=“DATAINICIO” class=“java.util.Date”>
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name=“DATAFIM” class=“java.util.Date”>
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT
cliente_fisica.“clfi_cpf” AS cliente_fisica_clfi_cpf,
cliente_fisica.“clfi_nome” AS cliente_fisica_clfi_nome,
cliente_fisica.“clfi_pk_id” AS cliente_fisica_clfi_pk_id,
cliente_fisica.“clfi_data_cadastro” AS cliente_fisica_clfi_data_cadastro
FROM
“sigi”.“cliente_fisica” cliente_fisica

WHERE clfi_data_cadastro

BETWEEN date($P{DATAINICIO}) AND date($P{DATAFIM})]]>
</queryString>
<field name=“cliente_fisica_clfi_cpf” class=“java.lang.String”/>
<field name=“cliente_fisica_clfi_nome” class=“java.lang.String”/>
<field name=“cliente_fisica_clfi_pk_id” class=“java.lang.Integer”/>
<field name=“cliente_fisica_clfi_data_cadastro” class=“java.sql.Date”/>
<filterExpression><![CDATA[]]></filterExpression>
<title>
<band height=“134” splitType=“Stretch”>
<staticText>
<reportElement x=“112” y=“40” width=“348” height=“24”/>
<textElement verticalAlignment=“Middle”>

</textElement>
<text><![CDATA[SISTEMA INTEGRADO E GESTÃO INTEGRADO( SIGI )]]></text>
</staticText>
<staticText>
<reportElement x=“169” y=“101” width=“212” height=“20”/>
<textElement verticalAlignment=“Middle”>

</textElement>
<text><![CDATA[Atendimento Cliente Físico]]></text>
</staticText>
<textField pattern=“dd/MM/yyyy”>
<reportElement x=“455” y=“94” width=“100” height=“20”/>
<textElement verticalAlignment=“Middle”/>
<textFieldExpression class=“java.util.Date”><![CDATA[new java.util.Date()]]></textFieldExpression>
</textField>
<textField>
<reportElement x=“392” y=“114” width=“95” height=“20”/>
<textElement textAlignment=“Right” verticalAlignment=“Middle”/>
<textFieldExpression class=“java.lang.String”><![CDATA[“Página “+$V{PAGE_NUMBER}+” de”]]></textFieldExpression>
</textField>
<textField evaluationTime=“Report”>
<reportElement x=“487” y=“114” width=“40” height=“20”/>
<textElement verticalAlignment=“Middle”/>
<textFieldExpression class=“java.lang.String”><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x=“426” y=“94” width=“27” height=“20”/>
<textElement verticalAlignment=“Middle”/>
<text><![CDATA[Data:]]></text>
</staticText>
<textField>
<reportElement x=“0” y=“84” width=“100” height=“20”/>
<textElement/>
<textFieldExpression class=“java.util.Date”><![CDATA[$P{DATAFIM}]]></textFieldExpression>
</textField>
<textField>
<reportElement x=“0” y=“64” width=“100” height=“20”/>
<textElement/>
<textFieldExpression class=“java.util.Date”><![CDATA[$P{DATAINICIO}]]></textFieldExpression>
</textField>
</band>
</title>
<pageHeader>
<band height=“37” splitType=“Stretch”>
<staticText>
<reportElement x=“0” y=“11” width=“112” height=“20”/>
<textElement verticalAlignment=“Middle”>

</textElement>
<text><![CDATA[CPF]]></text>
</staticText>
<staticText>
<reportElement x=“125” y=“11” width=“430” height=“20”/>
<textElement verticalAlignment=“Middle”>

</textElement>
<text><![CDATA[Cliente ]]></text>
</staticText>
<line>
<reportElement x=“0” y=“10” width=“555” height=“1”/>
</line>
<line>
<reportElement x=“0” y=“31” width=“555” height=“1”/>
</line>
</band>
</pageHeader>
<detail>
<band height=“24” splitType=“Stretch”>
<textField>
<reportElement x=“125” y=“0” width=“430” height=“20”/>
<textElement verticalAlignment=“Middle”/>
<textFieldExpression class=“java.lang.String”><![CDATA[$F{cliente_fisica_clfi_nome}]]></textFieldExpression>
</textField>
<textField>
<reportElement x=“0” y=“0” width=“112” height=“20”/>
<textElement verticalAlignment=“Middle”/>
<textFieldExpression class=“java.lang.String”><![CDATA[$F{cliente_fisica_clfi_cpf}]]></textFieldExpression>
</textField>
</band>
</detail>
<summary>
<band height=“24”>
<staticText>
<reportElement x=“411” y=“0” width=“105” height=“20”/>
<textElement verticalAlignment=“Middle”>

</textElement>
<text><![CDATA[Total de Clientes:]]></text>
</staticText>
<textField>
<reportElement x=“516” y=“0” width=“39” height=“20”/>
<textElement verticalAlignment=“Middle”/>
<textFieldExpression class=“java.lang.Integer”><![CDATA[$V{PAGE_COUNT}]]></textFieldExpression>
</textField>
</band>
</summary>
</jasperReport>
[/code]

TheKill · Outubro 18, 2010, 1:31pm

                 &lt;reportElement x="392" y="114"  width="95" height="20"/&gt;  
                 &lt;textElement textAlignment="Right" verticalAlignment="Middle"/&gt;  
                 &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA["Página "+$V{PAGE_NUMBER}+" de"]]&gt;&lt;/textFieldExpression&gt;  
             &lt;/textField&gt;  
             &lt;textField evaluationTime="Report"&gt;  
                 &lt;reportElement x="487" y="114" width="40" height="20"/&gt;  
                 &lt;textElement verticalAlignment="Middle"/&gt;  
                 &lt;textFieldExpression class="java.lang.String"&gt;&lt;![CDATA[" " + $V{PAGE_NUMBER}]]&gt;&lt;/textFieldExpression&gt;

Não é String!!!

juniorsatanas · Outubro 18, 2010, 1:33pm

é tudo data ?

Ireport Converte String para DATA, comparação de parametros ![resolvido]

Cursos de Mobile

Cursos de Programação

Cursos de Front-end

Cursos de DevOps

Cursos de Design & UX

Cursos de Business

Cursos de Data & BI