How to compare string value in properties Expression using ireport jasper?

[sanamworld10]

Ans:  I had a pretty rough time comparing string value in ireport and I got the solution which I want to share...(especially for the bigenners) 

To compare String value in "properties expression " we can write the formula as below:

1> select the field and go to properties..

2> Then go to Properties Expression and set the below 2 values::

a>Property name:   net.sf.jasperreports.export.xls.formula

b>Property value:  

"IF(AND((IF(AND(ISBLANK(A"+($V{REPORT_COUNT}+1)+"),ISBLANK(B"+($V{REPORT_COUNT}+1)+")),"+""+",(B"+($V{REPORT_COUNT}+1)+"-"+"A"+($V{REPORT_COUNT}+1)+"))<0.25 ),(OR(((D"+($V{REPORT_COUNT}+1)+")="+""T""+"),((D"+($V{REPORT_COUNT}+1)+")="+""T+1B""+"),((D"+($V{REPORT_COUNT}+1)+")="+""T+2B""+")))),"+""+",(B"+($V{REPORT_COUNT}+1)+"-"+"A"+($V{REPORT_COUNT}+1)+"))"

Explanation of above formula:

first: (ISBLANK(A"+($V{REPORT_COUNT}+1)+"),ISBLANK(B"+($V{REPORT_COUNT}+1)+")) -->It will check if the cell value is blank or not

structure is : "IF(  AND  (                (  IF(  AND(     blank check  of two cells  )       )  ) ,     (  OR((condition1),(condition2),(condition3)   )           ) ," +""+  ",else part)"

less than sign(<) is given by ---><

String comparison: "(          (D"+($V{REPORT_COUNT}+1)+")="+""T+2B""+"    )"

write within -->     "string value" and close it with quotes  (ie   +""string" " )

 

For above code to work : Create a table in sql : Create table Salary(small float,big float,activity varchar(20))

Then connect the ireport with database and fetch the fields from database : (small,big,activity)

Now design the jasper report as:

small               big            idle1            activity   

$F{small}     $F{big}     $V{idle1}     $F{activity}

 

idle1 is a variable which you have to create in : Report Inspector: fx Variables  (after creating variable "idle1" drag and drop in details part)

 

 

  

 

[jasperjones999]

i'd like to know too as apparently:

"The method EQUALS(String) is undefined for the type String"

who wrote this............

no validation on the expression editor have to exit and run the report to check (WASTE OF TIME)

DOES NOT RUN WHEN validation underlines are not shown, repoirt just fall over at runtime  (WASTE OF TIME)

and just look at teh NOISE and clean structure of the guys query above, fancy maintaining that ? anyone? I dont...