JRException: java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Boolean

Question

I have an error using Jaspersoft Studio with Oracle Database. As soon as there is some data, the following line

<printWhenExpression><![CDATA[$P{REPORT_TYPE}.substring(0,1)=="R"? $F{REASON_DELETED}:$F{REASON_ADOC}]]></printWhenExpression>

throws the following error:

net.sf.jasperreports.engine.JRException: java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Boolean

I don't understand, why Jasper Studio would cast it to a Boolean, since it is defined as a String:

<field name="REASON_ADOC" class="java.lang.String"/>
<field name="REASON_DELETED" class="java.lang.String"/>

and the SQL is also fine to me:

NVL(cr.REASON_ADHOC,'-') AS reason_adoc,
NVL(cr.REASON_DELETED,'-') AS reason_deleted,

and also in the view/table:

REASON_DELETED  VARCHAR2(250)
REASON_ADHOC    VARCHAR2(4000)

default locale · Accepted Answer · 2015-01-15 16:43:05Z

up vote 2 down vote accepted

You're right, your expression returns a String. But printWhenExpression expects boolean expression as a content. According to docs:

printWhenExpression Definition of a Boolean expression that will determine if the element or the band should be printed or not.

It's not clear what are you trying to achieve. You might want to use textFieldExpression instead.

answered Jan 15 '15 at 16:43

default locale

6,61992948

Thank you! I'm sure I get it working now ... should have checked the printwhenexpression class! – Stef Jan 15 '15 at 17:01

You're welcome. I'm glad I could help – default locale Jan 15 '15 at 17:03

add a comment |

1 Answer 1