bhanuchandharchalla

Got the answer for above question. Somehow database connection got deleted from iReport tool. Created a new one. Thanks, BBhanu Chandar.

I have a main report which is having 4 groups and 5 sub reports under it. Now as an enhancement, I have created one more group and added a sub report under it. But when I try to write Report Query, It is not retrieving fields and throwing an error message like " The active connection is not type of JDBC. Activate a JDBC connection first" even though I have added $P(REPORT_CONNECTION) as connection parameter for that report. Please suggest me a solution for this issue ... Thanks in advance.

It worked for me

Hi All, I have an issue regarding Text Field expression. 1. by using SUM(Y) in database, getting integer value for SUM_Y Field in iReport. ( I have made a Field in Fields list) 2. Here I need to display Integer value coming from database in my Report By using following expression : [ $F{SUM_Y} != null ? $F{SUM_Y} : ""] But i'm getting below the compilation error. Incompatible conditional operand types Integer and int value = (java.lang.Integer)(((java.lang.Integer)field_SUM_Y.getValue()) == null ? ((java.lang.Integer)field_SUM_Y.getValue()) : 0); //$JR_EXPR_ID=43$ <-----------------------------------------------------------------------------------------------------> Please help on above the issue. Thanks in Advance.

Thanks for ur help. I have added this: Boolean.valueOf($F{REMARKS != null} It is working fine now.

Thanks for the quick reply. I have written this: $F{REMARKS} != null But getting compilation error: Errors were encountered when compiling report expressions class file: 1. Cannot cast from boolean to Boolean value = (java.lang.Boolean)(((java.lang.String)field_REMARKS.getValue()) != null); //$JR_EXPR_ID=71$ <-----------------------------------------------------------------------> 2. Cannot cast from boolean to Boolean value = (java.lang.Boolean)(((java.lang.String)field_REMARKS.getOldValue()) != null); //$JR_EXPR_ID=71$ <--------------------------------------------------------------------------> 3. Cannot cast from boolean to Boolean value = (java.lang.Boolean)(((java.lang.String)field_REMARKS.getValue()) != null); //$JR_EXPR_ID=71$ <-----------------------------------------------------------------------> 3 errors why it is not working here although it is working in some other condition?

Hi All, I have a situation in which I need to display "detail" band dynamically. 1. There is a StaticText field and TextField(will display REMARKS). 2. If REMARKS available, detail band should display on the Report. 3. If REMARKS not available, detail band should not display on the Report. Any help would be very grateful on above issue. Thanks in Advance