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.

Have you tried unchecking the 'opaque' property or checking the 'transparent' one depending on the version of iReport that you are using. I don't have much experience with creating .doc or .docx documents, but have used iReport to create several reports that use rectangles to group text items together into tables.

Instead of using localhost try 127.0.0.1 in your connection string. I have used that successfully on my computer using the local Oracle XE. Try this connection string: jdbc:oracle:thin:@127.0.0.1:1521:XE

I have noticed the same behavior when I use the iReport internal viewer and then go to pdf. You can usually correct the missing text by expanding the containing text fields or static text areas. I have also noticed this when the reports are built on a Windows machine and then used on a UNIX server. As long as you do not go outside the area of the band that the text fields are in you should not have any problems, unless you are using colored backgrounds or borders on the text fields. Post Edited by hangman01 at 04/26/2010 20:40

Has any one else had the problem of iReport 3.7.2 running very slowly on a Windows XP machine. I have a 1.86 ghtz processor and 4 gigs of ram available though XP only recognizes 3.25 or so. When I open iReport is takes a long time to open and then when I click File-> Open it will take 25 to 30 seconds to open the dialog box. Once the dialog is open I click on my documents and it takes 34 seconds to open there. I have tried to increase the memory heap but if I try to go above 1536 on either setting iReport will not even open. I have tried disabling my anti-virus and that did half the time bt it was still 15 or 20 seconds. And since the computer is actually the companies changing the Anti-virus is not really an option for me. By the way the machine had McAfee 8.7. Has any one else noticed this behavior since the NetBeans frame has been in use and more noticable in the later versions?

I have never worked with that type of database so I can't say for certain that this will work but I would try something like this: WHERE "GL"."CATEGORY"='A' AND "GL_ENTRY"."EFFECTIVE_DATE"<=nvl($P{EndDate} ,"GL_ENTRY"."EFFECTIVE_DATE") This structure works on Oracle Databases to allow one report to do both for one individual or a large group of individuals.

I have noticed the same behavior moving from a Windows to an AIX(UNIX) or LINUX environment when producing the reports as PDF. Even though the font seems the same the space required for UNIX/LINUX to display the fonts needs to be larger. I simply increase the size of the text areas and then everything prints correctly and matches the file printed on the Windows machines. Just make sure that the text areas are transparent and if any background color or lines are needed use either rectangles or frames along with the straight lines to create what you need. I hope that this will help you out.

I have never tried this but if I needed to get data from 2 totally different csv files I would create a sub-report for the second one. I have used sub-reports to get different data from a second table that can't be retrieved by one query in one row. This should give you a place to start at least. Hope that it works for you.

I am trying to do an ant compile for Jasper Reports so they can be compiled at the same time as the rest of the website they are being accessed from. If my report does not have a "No Data Found" section it will compile and run correctly. If that very same report is modified to include a "No Data Found" section it will no longer compile using ant but I can compile and run it using iReport. Both reports are being run using the same programs on a UNIX box. I have tried using various jasperreports jar files and currently I am using jasperreports-3.7.1.jar . I am attaching the output of the compile showing the error. Any help or ideas will be appreciated.

Click on the band and adjust the size in the properties window to '0'. If the properties wndow is not visible look for it under the 'Window' heading in the main menu.

I have a project that I am trying to create using iReport 3.7.0 that will read data from a CSV file to produce the report. When I try to read the file my text field is filled with the column names from the file on the first page then the remaining pages are blank, but there are only up to the number of records in the file. When I try the same jrxml and file in version 2.0.4 everything works correctly, except my first page has the column names in the fields. The remaining pages have the name and address as expected. If I check to ignore the first line of the file in connections dialog box the report fails to generate correctly. I am using a class to format the addess correctly and this will work when getting the data from a database table in either 3.7.0 or 2.0.4. Has anyone else had this problem?