jorjao

Hi to all: I have one problem with file create with jasperreports (jasperreports 3.7.4). If I open it with Microsoft Word, it shows correctly. But if I open with the OpenOffice Writer, everything that is written does not appear, showing only images. I have thought being the typeface but everything is in Arial letters is a common type in both. Any help? Thank for all Jorge Sá

I would like to make you a question on iREPORTS. It is possible to define a variable as one of a select field? SELECT clientes."numero" AS quala_crm_clientes_numero, entidades_cli."nome" AS entidades_nome, entidades_cli."tlf" AS entidades_tlf, entidades_inst."tlf" AS telefone_estab, fichas."processo" AS processo, entidades_cli."tiponif" AS $V{teste} FROM entidades as entidades_inst, entidades as entidades_cli, quala_crm_clientes as clientes, quala_crm_fichas_inscricao as fichas, inst_estabelecimentos as inst_estabelecimentos WHERE clientes.entidade= entidades_cli.identidade and fichas.cliente = clientes.id_cliente and fichas.estabelecimento = inst_estabelecimentos.id_estabelecimento and inst_estabelecimentos.dados = entidades_inst.identidade and clientes."id_cliente" = $P{cliente}::int If I do well it gives me this error. __________________________________________________________________________________________________________ Error filling print... Error executing SQL statement for : teste1 net.sf.jasperreports.engine.JRException: Error executing SQL statement for : teste1 at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.create Datasource(JRJdbcQueryExecuter.java:141) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource (JRFillDataset.java:656) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource (JRFillDataset.java:588) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters (JRBaseFiller.java:1212) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:849) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill (JRBaseFiller.java:798) at net.sf.jasperreports.engine.fill.JRFiller.fillReport (JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport (JasperFillManager.java:402) at net.sf.jasperreports.engine.JasperFillManager.fillReport (JasperFillManager.java:234) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:947) at java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "AS $" at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse (QueryExecutorImpl.java:1559) 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:135) ... 10 more Print was not filled. Try using an EmptyDataSource... ____________________________________________________________________________________________________________Needed to subject it to the type of customer, presenting a text on the report. Does anyone know if this is possible or how is it done?

Thank you Svenn. Imagine, for the implementation of report he will go to this link: http://www.jasperforge.org/index.php, and place on the report generated a image of ireports, for example. Instead of having the image in the disc, the image to be put is in a page of internet. Understand my problem? Is possible?

Hello everyone. I have a question. Is possible to refer to the way an image of an image that there is a page of internet? Instead of the image be in our disc, was on the internet. Understand my question? Excuse my english Thank Jorge