emanuel.padillaf

Hi all, Some one can help me please... can anybody help me? I have a sql query that returns a huge clob field. In several pages I found that to display the field the following code is necessary this in text expression: $F{CLOB}.getSubString( 1l, ( new Long( $F{CLOB}.length() ) ).intValue() ) The data type is java.lang.string In the preview of ireports it works fine, however, when jasper reports executes the report it shows and error message like net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : $F{CLOB}.getSubString( 1l, ( new Long( $F{CLOB}.length() ) ).intValue() ) I have found that I need a java class to fix it, however I do not know where to apply the class or what class I have to use. Please help Thans emmnuel

Hi Sheng, please..... could you explain how you solved this?? i have the same issue

Can anyone help me please.... I have 2 columns and one of them is too long, even sometimes 1 sheet is not enought to display all content, the problem is when column one exceeds 1 sheet the column number 2 dont display padding and borders in sheet number 2.... I found something like "Print When Details Overflows" and enable it in column number 2 but i dont what to repeat the text in the other sheet... Anyone know how can i solve this?? Thanks to all

Hello everyone, I have little knowledge in Ireports and Jasper Reports and I would like to know if anyone can help me. I have a table with 4 fields, however, field number 4 (CLOB) shows a lot of information and 1 single sheet is not enough to see all the information it contains. The problem is that when you pass to the second sheet, the edges of the other cells do not show them and an empty void appears, someone knows how I can correct this, so that they always show the edges of all cells. Example. SHEET 1 FIELD 1 FIELD 2 FIELD 3 FIELD 4 ROW 1 XXX XXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX SHEET 2 FIELD 1 FIELD 2 FIELD 3 FIELD 4 ROW 1 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ROW 2 XXXXXXXXXX XXXXXXXXXXXX XXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX Thanks a lot!!!!!!!!!!!!