Gerar Paramatros no ireport

Como não consegue?
Que erro?

Dar esse erro aqui:

Time zone: Default Error filling print... Error preparing statement for executing the report query : SELECT cliente_fisica."clfi_pk_id" AS cliente_fisica_clfi_pk_id, cliente_fisica."clfi_nome" AS cliente_fisica_clfi_nome, cliente_juridica."clju_nome" AS cliente_juridica_clju_nome, cliente_juridica."clju_pk_id" AS cliente_juridica_clju_pk_id, servicos_dimee."smee_nome" AS servicos_dimee_smee_nome, divisoes."divi_nome" AS divisoes_divi_nome, servicos_dimat."smat_nome" AS servicos_dimat_smat_nome, servicos_ditalq."salq_nome" AS servicos_ditalq_salq_nome, solicitacao."soli_data_finalizacao" AS solicitacao_soli_data_finalizacao, processos."proc_numero_processo" AS processos_proc_numero_processo, cliente_fisica."clfi_pk_id" AS cliente_fisica_clfi_pk_id, cliente_fisica."clfi_nome" AS cliente_fisica_clfi_nome, cliente_juridica."clju_pk_id" AS cliente_juridica_clju_pk_id, cliente_juridica."clju_nome" AS cliente_juridica_clju_nome FROM "sigi"."divisoes" divisoes INNER JOIN "sigi"."servicos_dimee" servicos_dimee ON divisoes."divi_fk_servicos_dimee_id" = servicos_dimee."smee_pk_id" INNER JOIN "sigi"."servicos_dimat" servicos_dimat ON divisoes."divi_fk_servicos_dimat_id" = servicos_dimat."smat_pk_id" INNER JOIN "sigi"."servicos_ditalq" servicos_ditalq ON divisoes."divi_fk_servicos_ditalq_id" = servicos_ditalq."salq_pk_id" INNER JOIN "sigi"."solicitacao" solicitacao ON divisoes."divi_pk_id" = solicitacao."soli_fk_divisoes3_id" AND divisoes."divi_pk_id" = solicitacao."soli_fk_divisoes5_id" AND divisoes."divi_pk_id" = solicitacao."soli_fk_divisoes1_id" AND divisoes."divi_pk_id" = solicitacao."soli_fk_divisoes2_id" AND divisoes."divi_pk_id" = solicitacao."soli_fk_divisoes4_id" INNER JOIN "processos" processos ON divisoes."divi_pk_id" = processos."proc_fk_divisoes1_id" AND solicitacao."soli_pk_id" = processos."proc_fk_solicitacao_id" AND servicos_ditalq."salq_pk_id" = processos."proc_fk_servicos_ditalq_id" AND servicos_dimat."smat_pk_id" = processos."proc_fk_servicos_dimat_id" AND servicos_dimee."smee_pk_id" = processos."proc_fk_servicos_dimee_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos24_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos41_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos38_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos34_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos31_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos28_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos25_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos29_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos46_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos35_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos39_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos42_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos47_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos40_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos37_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos33_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos30_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos27_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos26_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos44_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos32_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos36_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos45_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos43_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos5_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos23_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos16_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos11_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos19_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos4_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos7_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos20_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos13_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos14_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos21_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos8_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos3_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos18_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos10_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos17_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos2_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos9_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos22_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos15_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos12_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos1_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos6_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos52_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos73_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos74_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos50_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos75_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos51_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos63_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos48_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos64_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos49_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos65_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos53_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos66_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos54_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos67_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos55_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos68_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos56_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos69_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos57_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos70_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos58_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos71_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos59_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos72_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos60_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos62_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos61_id" INNER JOIN "sigi"."cliente_fisica" cliente_fisica ON solicitacao."soli_pk_id" = cliente_fisica."clfi_fk_solicitacao_id" AND cliente_fisica."clfi_pk_id" = solicitacao."soli_fk_cliente_fisica_id" INNER JOIN "sigi"."cliente_juridica" cliente_juridica ON solicitacao."soli_pk_id" = cliente_juridica."clju_fk_solicitacao_id" AND cliente_juridica."clju_pk_id" = solicitacao."soli_fk_cliente_juridica_id" WHERE solicitacao."soli_data_finalizacao" BETWEEN '?'and '?' and divisoes."divi_nome" = '?' and servicos_dimee."smee_nome" = '?' and servicos_dimat."smat_nome" = '?' and servicos_ditalq."salq_nome" = '?' and cliente_fisica."clfi_pk_id" = '?' and cliente_juridica."clju_pk_id" = '?' net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query : SELECT cliente_fisica."clfi_pk_id" AS cliente_fisica_clfi_pk_id, cliente_fisica."clfi_nome" AS cliente_fisica_clfi_nome, cliente_juridica."clju_nome" AS cliente_juridica_clju_nome, cliente_juridica."clju_pk_id" AS cliente_juridica_clju_pk_id, servicos_dimee."smee_nome" AS servicos_dimee_smee_nome, divisoes."divi_nome" AS divisoes_divi_nome, servicos_dimat."smat_nome" AS servicos_dimat_smat_nome, servicos_ditalq."salq_nome" AS servicos_ditalq_salq_nome, solicitacao."soli_data_finalizacao" AS solicitacao_soli_data_finalizacao, processos."proc_numero_processo" AS processos_proc_numero_processo, cliente_fisica."clfi_pk_id" AS cliente_fisica_clfi_pk_id, cliente_fisica."clfi_nome" AS cliente_fisica_clfi_nome, cliente_juridica."clju_pk_id" AS cliente_juridica_clju_pk_id, cliente_juridica."clju_nome" AS cliente_juridica_clju_nome FROM "sigi"."divisoes" divisoes INNER JOIN "sigi"."servicos_dimee" servicos_dimee ON divisoes."divi_fk_servicos_dimee_id" = servicos_dimee."smee_pk_id" INNER JOIN "sigi"."servicos_dimat" servicos_dimat ON divisoes."divi_fk_servicos_dimat_id" = servicos_dimat."smat_pk_id" INNER JOIN "sigi"."servicos_ditalq" servicos_ditalq ON divisoes."divi_fk_servicos_ditalq_id" = servicos_ditalq."salq_pk_id" INNER JOIN "sigi"."solicitacao" solicitacao ON divisoes."divi_pk_id" = solicitacao."soli_fk_divisoes3_id" AND divisoes."divi_pk_id" = solicitacao."soli_fk_divisoes5_id" AND divisoes."divi_pk_id" = solicitacao."soli_fk_divisoes1_id" AND divisoes."divi_pk_id" = solicitacao."soli_fk_divisoes2_id" AND divisoes."divi_pk_id" = solicitacao."soli_fk_divisoes4_id" INNER JOIN "processos" processos ON divisoes."divi_pk_id" = processos."proc_fk_divisoes1_id" AND solicitacao."soli_pk_id" = processos."proc_fk_solicitacao_id" AND servicos_ditalq."salq_pk_id" = processos."proc_fk_servicos_ditalq_id" AND servicos_dimat."smat_pk_id" = processos."proc_fk_servicos_dimat_id" AND servicos_dimee."smee_pk_id" = processos."proc_fk_servicos_dimee_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos24_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos41_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos38_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos34_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos31_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos28_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos25_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos29_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos46_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos35_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos39_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos42_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos47_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos40_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos37_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos33_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos30_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos27_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos26_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos44_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos32_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos36_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos45_id" AND servicos_dimee."smee_pk_id" = solicitacao."soli_fk_servicos43_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos5_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos23_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos16_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos11_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos19_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos4_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos7_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos20_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos13_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos14_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos21_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos8_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos3_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos18_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos10_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos17_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos2_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos9_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos22_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos15_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos12_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos1_id" AND servicos_dimat."smat_pk_id" = solicitacao."soli_fk_servicos6_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos52_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos73_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos74_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos50_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos75_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos51_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos63_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos48_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos64_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos49_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos65_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos53_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos66_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos54_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos67_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos55_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos68_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos56_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos69_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos57_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos70_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos58_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos71_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos59_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos72_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos60_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos62_id" AND servicos_ditalq."salq_pk_id" = solicitacao."soli_fk_servicos61_id" INNER JOIN "sigi"."cliente_fisica" cliente_fisica ON solicitacao."soli_pk_id" = cliente_fisica."clfi_fk_solicitacao_id" AND cliente_fisica."clfi_pk_id" = solicitacao."soli_fk_cliente_fisica_id" INNER JOIN "sigi"."cliente_juridica" cliente_juridica ON solicitacao."soli_pk_id" = cliente_juridica."clju_fk_solicitacao_id" AND cliente_juridica."clju_pk_id" = solicitacao."soli_fk_cliente_juridica_id" WHERE solicitacao."soli_data_finalizacao" BETWEEN '?'and '?' and divisoes."divi_nome" = '?' and servicos_dimee."smee_nome" = '?' and servicos_dimat."smat_nome" = '?' and servicos_ditalq."salq_nome" = '?' and cliente_fisica."clfi_pk_id" = '?' and cliente_juridica."clju_pk_id" = '?' 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.setDate(AbstractJdbc2Statement.java:3019) at org.postgresql.jdbc2.AbstractJdbc2Statement.setDate(AbstractJdbc2Statement.java:1300) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.setStatementParameter(JRJdbcQueryExecuter.java:444) 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...

e também na hora de puxar os campos pro relatório não sei como faço ex: são dois cliente o físico e o jurídico então não posso puxar os dois só um (a mesma coisa pro serviços são 3).

obrigado.

O que você quer fazer? Que tipo de relatório?
Isso ‘a data eu já consegui mas o ouro não, por que so pode ser um e tem 3 serviço’ não me permite entender…
Isso “também na hora de puxar os campos pro relatório não sei como faço ex: são dois cliente o físico e o jurídico então não posso puxar os dois só um (a mesma coisa pro serviços são 3).”, também não.

Não pode fazer relatórios distintos?