[Problem open file exported]

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á

[Variable in query]

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?

[image]

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?

[image]

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