Boolean Calculated Fields Return an Error

Summary

When creating calculated fields in Domains and Ad Hoc reports, JasperReports Server returns an exception if the calculated field returns data of type Boolean. This problem only occurs when the data source underlying the Domain or report points to a source that does not natively support the Boolean datatype, most notably Oracle and DB2.

Resolution

While there are workarounds at the database level, JasperReports Server does not yet support them (as of July 7th, 2009).

References:

• http://thinkoracle.blogspot.com/2005/07/oracle-boolean.html