How to handle null BLOB in report by using Oracle Database

Posted on April 17, 2017 at 12:44pm

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@gmail.com

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

1 Answer:

Posted on April 17, 2017 at 11:10pm

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.

Mariano

 

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