Insert dynamic images in a Table taking the path from a field of a Table. ?

Rojo · 2008-06-28T21:31:21+00:00

Hi Vdodson, again I need your appreciable help. I have a table like this: Table Name Schools id schoolName pictureName Example: id schoolName pictureName 1 public FOTO1.JPG 1 public FOTO2.JPG ... The pictures…

Rojo

Hi Vdodson, again I need your appreciable help. 
 
I have a table like this: 
 
Table Name Schools 
 
id 
schoolName 
pictureName 
 
Example: 
 
id schoolName pictureName 
1 public FOTO1.JPG 
1 public FOTO2.JPG 
... 
 
 
The pictures are in <a class='bbc_url' href='http://localhost/xampp/proyecto/pictures'>http://localhost/xampp/proyecto/pictures</a> 
 
and then, a do a Report with a Table with two columns like This: 
 
Id SchoolName Picture 
1 Public 
 
 
In the column Picture, i have a image element, and then, I'm trying to 
insert the image as a URL, but I put a expresion like this. 
 
"http://localhost/xampp/proyecto/pictures/"+row["pictureName"] 
 
or like this, I take this from your example in: 
 
this.setURL("http://localhost/xampp/proyecto/pictures/"+row["pictureName"] ); 
 
 
but the Report dont found the image. 
 
in the field pictureName of a dataset, I only have the name of the file that contains the image. 
 
Thank you.

Find more posts tagged with

Comments

Rojo

I have a parcial solution, I saw the example in 
 
<a class='bbc_url' href='http://download.eclipse.org/birt/downloads/examples/reports/Image/Image.html'>http://download.eclipse.org/birt/downloads/examples/reports/Image/Image.html</a> 
 
On the method onFetch of my DataSet, I write this: 
 
row["FotoDeLona"]="http://localhost/xampp/espectaculares/lobo/"+row["FotoDeLona"]; 
 
 
row["FotoDeLona"] has the image name like this PICTURE.JPG 
 
Then, I insert a image element in a field of my table, and Enter URI like this: 
 
Select Picture FROM: 
 
row["FotoDeLona"] 
 
 
It works fine, now I see the images on my report, but, I need to add a Group to my table, when I add the group, the report still show the images, but at the end of the Report, it shows the next error: 
 
The following items have errors: 
 
 
Table (id = 39): 
+ There are errors evaluating script "row["FotoDeLona"]="http://localhost/xampp/espectaculares/lobo/"+row["FotoDeLona"];". 
Error.ScriptEvaluationError ( 12 time(s) ) 
detail : org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "row["FotoDeLona"]="http://localhost/xampp/espectaculares/lobo/"+row["FotoDeLona"];". at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:76) at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleJS(DataSetScriptExecutor.java:159) at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleOnFetch(DataSetScriptExecutor.java:143) at org.eclipse.birt.data.engine.impl.DataSetRuntime.onFetch(DataSetRuntime.java:559) at .........

Rojo

Hi, I still have the error in my report, the report draw all images, but at the end of report, still showing the error:

The following items have errors:
Table (id = 39):
row["foto"]="http://application.estado.gob.mx/lobo/"+row["foto"];

As a I say, I have a Table with the next fields

Id foto
1 picture1.jpg
2 tree.jpg
3 house.jpg
.....

And then, I put a table on my report with some columns, a column must contain the picture or image, then a put a image element in this column.

In the dataset onFetch Method, I put this:

row["foto"]="http://application.estado.gob.mx/pictures/"+row["foto"];

and yes, the report shows the picture, but at the end of report still showing the error:

Can somebody please help me....?

The following items have errors:
Table (id = 39):
row["foto"]="http://application.estado.gob.mx/lobo/"+row["foto"];

Error.ScriptEvaluationError ( 12 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script
row["foto"]="http://application.estado.gob.mx/lobo/"+row["foto"];
at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:76) at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleJS(DataSetScriptExecutor.java:159) at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleOnFetch(DataSetScriptExecutor.java:143) at org.eclipse.birt.data.engine.impl.DataSetRuntime.onFetch(DataSetRuntime.java:559)

Rojo

It was easy to get a solution to insert dynamic images taked from a field of a table.

I only do a concat the name of file, with the path, like this:
<table>
<structure>
<property name="name">RutaFoto</property>
<expression name="expression">"http://aplicacion.estado.gob.mx/images/"+dataSetRow["imageName"]</expression>
<property name="dataType">string</property>
</structure>
....
</table>

and then when insert a image element, in the url, you only needo to write or choose

row["imageName"]

And it was all.

Maybe somebody can use this solution.

Thanks.