When you compile your report in iReports, do you see any problems in the Problems tab?
I’ve seen cases where the report runs fine in iReports, but iReports IS seeing problems, but just quietly reporting them in the Problems tab, whereas if you run the report on the Server, like the Jasper Plugin does, it raises an error.
I’ve checked the jasper forums, but no-one reported this yet.
Did you get any further with it? Does it go wrong with all reports? Or just one? Or all reports that were build in iReports 2.0.4?
Paul
BTW: teh pen tag does seem to be related to the borders, as you suggested
Very interesting, since the beta version Hans-Peter uses has got no changes in the area of the way the report requests are dealt with toward the Jasper engine.
If a new version of the plugin will be released, it will be anounced.
Found out what the problem is and how it happened.
When i installed the Jasper plugin i simply downloaded the version from the Servoy site and installed it.
When i installed 2.0.5 of iReport i renamed the jasperreports.jar in the directory jasperPluginRMI to jasperreports_org.jar and then copied the file jasperreports-2.0.5.jar from the ireport directory and renamed it to jasperreports.jar
If you do this then yoy get the “topPen” error.
If you delete the file jasperreports_org.jar the problem is gone !!!
Aha, yes, that sounds logical: Servoy loads all the jars in the dirs, regardless their name.
So, in your case, you had basically the old and new Jasper jars there and then either the new or the old one gets used.
Always remove old jars from the plugins (and subdirs), the lib dir and the beans dir…
If you wonder why it works this way when you have to specify the name in the jnlp file anyway: the jnlp file is used to send jars to the Client, when starting a Client. The issue you encountered is a conflict ServerSide, so the jnlp has nothing to do with it.
I’m trying to design a report with data and an image taken from a table built in Servoy 3.5.9.
I want insert an image into a print made with iReport 3.0.0?
While the report correctly displays all the data fields, I do not know how to display the column that contains the image.
I do not know how to show it and put it in print.
Can someone tell me how to do?
The image from a database requires a little sleuthing on the iReport forum … but her is my approach.
Try this:
Assume that the BLOB field/column in the database is called “product_image”:
create a variable(give it a name such as “productImage”
specify the type to be java.io.InputStream
define the variable expression to use: ```
new java.io.ByteArrayInputStream((byte)$F{product_image})
4. specify an image to be placed on the design - do not specify any file location
5. for the image properties specify the expression class as java.io.InputStream
5. specify the image expression as the variable "productImage"
6. adjust other image properties to suit.
I tested this with iReport 3.5.0 <img src="{SMILIES_PATH}/icon_smile.gif" alt=":)" title="Smile" />
Tom
Wonderful.
Just two things.
The Customer image in page-header is highlighted correctly, just after the 1st page, while customer data are shown correctly even in 1st page, why?
Jasper 3.0 works well, while version 3.5 does not show the database fields. The connection is ok! Why?
Thanks Thomas, you saved my life.
mike65:
I am not understanding your information.
For my test I used the sample servoy crm database udm and produced the pdf attached. I also have the jrxml for version 3.0.0 in case anyone wants to test drive it.
Regards,
Tom
Also, I see everything ok, but in version 3.5 I do not see the columns to be included in the report. Your report dbserver with UDM is ok, my report with my dbserver is ok.
In 3.00 version I see table columns, but nothing in 3.5 version .
Regards,
Mike
Windows xp - Servoy 359 - java 11.3 - Sybase10
If you are referring to iReport 3.5.0 then the resultant jrxml file cannot be used with Servoy plugin due to different libraries being required. You can try to specify the “.jasper” file produced by the 3.5.0 iReport with the Servoy plugin - I have had some success but it is not always going to work if some feature new to iReport 3.5.0 is not in the library (jasperreports jar file) for the Servoy plugin.
I have a request in to rebuild the Servoy plugin for iReport and JasperReport 3.5.0 but that will not be immediate. Best is to try to use the iReport designer for 3.0.0 and the Servoy Jasper plugin (unless my trick with using the jasper file type works out of iReport 3.5.0).
I would like to print a header with the data and an image at the beginning of each page.
How to get page break in iReport 3.0.0 in servoy 3.5.9?
What options should be set and where?
Are you able to use the Page Header for this requirement?
That is what I do whenever I want the image to be on each page (the header area of course).
Perhaps you could elaborate if this is not the correct interpretation.
i am using the same senerio to show image from a Blob database field. But i am receiving an exception that cannot convert Blob to byte.
i have repated the same steps as mentioned in you guys discussion:
i have a field of type blob in databse called person_image
i created a variable named personimage and passed new java.io.ByteArrayInputStream((byte)$F{person_image})
changed the type to java.io.FileInputStream
when i compiled the report it gives me the error that could not convert from oracle.sql.Blob to byte
if guy has received the problem and has solved this please help me out