Changing color of font when date is expired

[evanrheenen]

Hi,

I'm new to iReport and have a question that is probabely asked number of times, but i cannot find the answer.

I have a field "End of Support" (type "date") which i retrieved from my postgresql database.  If that date is in the past, i want to change the color of the font to "red", otherwise leave it black.

A second option would be if that field "End of Support" is within 6 months from now i would like to color it "orange".

For the first option i tried the following in the "Print when expression":

((System.currentTimeMillis() > $F{End of Support}) ?

    new String("<style forecolor='red'>"

        + String.valueOf($F{End of Support})

        + "</style>") :

    String.valueOf($F{End of Support}))

But this didn't work

 

I think i need to define 2 styles ?  Please explain how to solve this problem (1 + 2)

Thanks

[matthias.p]

Maybe you can setup two text fields with different style and just add an expression when to display the text or not.

[evanrheenen]

Yes, but how should the test looks like ((System.currentTimeMillis() > $F{End of Support}) ? .. : ..) is not working (cast error). If i can get the test correct, the font will probabely change color.

[jacobs_1]

you can try putting those 3 in different text fields in the printWhereExpression

(new Date() > $F{End of Support} AND new org.joda.time.DateTime().plusMonths(6).toDate() < $F{End of Support})

(new Date() <= $F{End of Support})

(new org.joda.time.DateTime().plusMonths(6).toDate() > $F{End of Support})