dansky

Should it not be.. new java.lang.Integer($F{lineitemtype} ==(0) ? "Artikelen" : ($F{lineitemtype} == (1) ? "Uren" : ($F{lineitemtype} == (2) ? "Kosten" : "other"«») ) )

I figured it out.... new java.math.BigDecimal(( $F{PRICE}.doubleValue() * $F{AMTGAL}.doubleValue() ) * .04)

I want to multiply the following two BigDecimal fields $F{PRICE} * $F{AMTGAL} *.04 How do I do this? Any help would be greatly appreciated.

This fixed the problem.... "Equipment: " + $F{EQ_EQUIP_NO} + "Year " + $F{YEAR}.toString() I had to cast "YEAR" as a string. It works!

I need an expression that will do the following: text + variable + text + variable + text This is what I have working so far... "Equipment: " + $F{EQ_EQUIP_NO} But when I try this it does not work.. "Equipment: " + $F{EQ_EQUIP_NO} + "Year" + $F{YEAR} Any ideas? Thanks.

That did the trick!! Thanks for your help!

I am a newbie to iReport and need help creating a parameter / formula field. I have a data base column called "eq_res". I need a formula that would do something like this... if {eq_res} = "D" then Daily else if {eq_res) = "M" then Monthly else if {eq_res) ="H" then Hourly else no reservation basicly I need the report to display the word "Monthly" if eq_res = M or display "Daily" if eq_res = D etc..... Can anyone help with this????? Post edited by: dansky, at: 2007/03/16 19:07