iReport -- Compare "text" Values

[runner1549]

What formula can I use to get the YELLOW results ?
  ** Display "no" since B2 and C2 columns are equal
  ** Display "yes" since B3 and C3 columns are not equal

I use the below in EXCEL, but don't know what to use in iReports

      =if(B2=C2,"No","Yes")

[ckampshoff]

Hi,

If you are using Java, you can put the following String into a Text-Field:

(B2.equals(C2) ? "No":(!B3.equals(C3) ? "Yes":"Your Default Value"))

HTH

Christina

[runner1549]

Doing the below "Solution" worked, but how can I resort the below so all "Yes" items display first ?

Solution
1. drop "TextField" onto page
2. add ($F{USA}.equals($F{CANADA}) ? "No":(!$F{USA}.equals($F{CANADA}) ? "Yes":"Fail"))
3. make no changes to below SQL
    SELECT fmr.fmcode,
           MAX(DECODE(fma.fmpropertyid, 391, REPLACE(FMP.FMMINIMUM,' ',NULL))) usa,
           MAX(DECODE(fma.fmpropertyid, 19933, REPLACE(FMP.FMMINIMUM,' ',NULL))) canada
    FROM fmpropertyassign fma
    INNER JOIN fmpropasschar fmp
    ON fma.fmpropertyassignid = fmp.fmpropertyassignid
    INNER JOIN fmresource fmr
    ON fmr.fmentityobjectid = fma.fmentityobjectid
    WHERE fma.fmpropertyid IN (19933, 391)
    and fmr.FMENTITYID = 1
    group by fmr.fmcode