How to handle null BLOB in report by using Oracle Database

Dear Sir,

Please help me how to solve this problem

  net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: $F{LOGO}.getBinaryStream()

You can contact me

lucky88edu's picture
Joined: May 18 2015 - 4:12am
Last seen: 6 years 5 months ago

1 Answer:

I think this is not a problem for null value, but try this:

$F{LOGO} == null ?  "": $F{LOGO}.getBinaryStream()

I use for logos an Image component, and Expression: $F{LOGO} directly, being LOGO filed of BLOB type.



mlopez_1's picture
Joined: Oct 21 2013 - 8:08am
Last seen: 1 day 50 min ago