glenbdcs

Using v4.0.0 ($F{PI_DISCOUNT} == null ? new java.lang.Double(0): $F{PI_DISCOUNT}) If I have not selected (not ticked) the 'Blank When Null' property then I get 'null' in all the rows which have a null value. If I have selected (ticked) the 'Blank When Null' property then I get blank in all the rows which have a null value. ---------------------------------- Using v3.7.6 ($F{PI_DISCOUNT} == null ? new java.lang.Double(0): $F{PI_DISCOUNT}) If I have not selected (not ticked) the 'Blank When Null' property then I get '0.0' in all the rows which have a null value and the Discount value such '10.0' if not a null value. (This is what I was expecting to get). If I have selected (ticked) the 'Blank When Null' property then I get '0.0' in all the rows which have a null value and the Discount value such '10.0' if not a null value. (This is what I was expecting to get). Hopes this helps - Glen.

I have had to move back to v3.7.6 from v4 because I now believe ( <condition> ? exp1: exp2) does not work with nulls. I had been trying to make following work: ($F{PI_DISCOUNT} == null ? new java.lang.Double(0): $F{PI_DISCOUNT}) where $F{PI_DISCOUNT} = holds a Sales Order Line Discount Rate as java.lang.Double. It does correctly display the $F{PI_DISCOUNT} value when != null but I never see 0.0 when a null exists. V3.7.6 and v3.7.4 does work correctly. Fortunately I had downloaded v3.7.6 earlier but not used because I cannot find where you can get this now. I am not a Java programmer so am prepared to accept I could be wrong but at least I now have it working.

Hi Chris, Have you been able to resolve this problem? We now have this error ever since we moved to a new Server. The previous died along with all our JasperReports. We feel we have something left out somewhere but we have almost no Java skills and no idea where to start looking. We really like using the product but it does require huge amounts of Googling ever word when trying to figure out the syntax if we need to manipulate data. Thanks in advance to you and anyone else who can help us please. Glen.