hangman01

I am not sure that it would work but my first thought is to use a to_date() function in the query. That should turn the timestampltz into a date and then ireport should be able to handle it correctly.

Is it possible that you are using McAfee anitvirus? NetBeans and some versions of McAfee have been known to cause the slowness. If anyone knows a good answer that does not involve changing antivirus programs please post it here.

are you selecting the blob from an Oracle database? In my reports I select the blob which is stored in a field such as PICTURE. It is on this field that change the datatype from blob to java.io.InputStream then continue as stated before. You seem to be using a java getValue() method to try to insert the blob and I really have never tried to use this structure in my reports. I will be interested to find out the answer to this problem too. Good luck.

I think I see the cause of the error, apparently you are using groovy language in the report. I have been using java in my examples and all my reports. Unfortunitely I do not know much about the groovy language. I can tell you that for sure the examples I have given here do work when the report is written using java language. Hopefully someone with better knowledge of groovy can supply the answer to this question. Sorry that I cannot be more help on this part of the error.

The field class of the blob is set to java.io.InputStream as is the expression class of the image object. Both of these are available on both the earlier versions of iReport and the latest ones. These can be found in the properties window when the correct object is selected.

You can find some information here: http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=131 You change the datatype on the blob's field and the image element to java.io.InputStream.

I might be missing something but just where are temp1 and temp2 query created? Do you do this inside the the iReport sql dialog? Are you adding xml code to the jrxml outside of iReport? With the nested tables everything is all in one area and not scattered in many places. I have used the nested tables such as I described for so very large and complex queries and they both are easy to maintain and upgrade. Each nested query will be complete and able to produce data when run by itself in a program such as Toad (Quest) This allows you to work on one 'table' and not change any of the other ones.

You can use a query to create a virtual temporary table and then use that table in the from statement of the next query. Select name, address, city, state, zip from (Select * from registrations) where name ='JONES' This is a very simple example but much more complex queries can be created in the same manner. Also several virtual tables can be joined just as normal tables using the where clause.

You can use a sub-report or a list item. Either of them has its own query. I have created reports that contain as many as 6 queries using various combinations of list items and sub-reports that also contain list items. I would advise you to use the list item if at all possible as that seems to run quicker than the sub-report.

Use a seperate sub-report item for each type possible and then use the "print when expression" to decide which one actually prints. I do this regularly with passing and failing version of score reports.

My guess would be that you need to set the properties of the text_field from "java.math.BigDecimal" to "java.lang.String".

I am not sure that this would actually be considered a kick in the right direction or not but for one thing your report is using groovy and not java. You need to either use groovy in your expression or switch the report properties to Java for the language. If you switch to Java the expression will need to be something like: $F{afgemeld}.intValue()==1?"Yes":"No" I do not know any groovy so I can not help you if you go that direction. You will notice that as you create new reports iReport defaults to language=groovy and you must remember to make that change to use Java. I hope that this helps you.

Has anyone found a way to have more than one hyperlink within a single text field? I am attempting to create a report that has one large block of text with 2 or more links in that text. The text also contains variables that change in length for every report. This makes creating a seperate text field for each link and matching those up with the remaining text impossible. I want to limit the amount of text that is clickable for each link, so that click here would be a link and not the entire post. In html it would be done something like: "<a href="http://www.google.com" target="blank">click here<a/>" And one more thing these links will need to be accessable to readers for handicapped persons like the one in Adobe Reader or Jaws and the user will need to "tab" through the links.

As of this posting I have not found any reason for the slowdown other than the fact that NetBeans does not seem to play well with the McAfee anti-virus. Since this is a company owned computer I can not change my anti-virus. I have a personal computer and installed the same version of iReport on it and it runs much better.

I have similar problems when I try to run any of the later versions of iReport. I also maintain reports that were built using an older version of iReport and they are much easier to work with. I think that the actual problem is with the NetBeans frame more than the iReport plugin. I have tried to run NetBeans on my computer and I have very similar performance issues. I am not sure that this information will actually help anyone but I thought that I would toss it out there to see if anyone else has noticed the same things. I have tried increasing the memory available to iReport as far as it allows. I have 4 gigs of ram on my machine and every other program runs reasonably quickly. I only notice performance issues with NetBeans and the NetBeans based versions of iReport.