pie report creation problem

[sonal]

Hi all,

 

I am new in Jasper Report. Trying to create a pie chart report.

 

my sql is

SELECT person_address_type,COUNT(1)FROM ODSF_PPA_PERSON_ADDRESS

GROUP BY person_address_type

 

I got folowing error.

Errors compiling .chart_report.jasper.

net.sf.jasperreports.engine.JRException:ÂErrorsÂwereÂencounteredÂwhenÂcompilingÂreportÂexpressionsÂclassÂfile: 1.ÂCannotÂcastÂfromÂBigDecimalÂtoÂBoolean ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂvalueÂ=Â(java.lang.Boolean)(((java.math.BigDecimal)field_COUNT40141.getValue()));/*$JR_EXPR_ID=11$*/ ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ<----------------------------------------------------------------------> 2.ÂCannotÂcastÂfromÂBigDecimalÂtoÂBoolean ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂvalueÂ=Â(java.lang.Boolean)(((java.math.BigDecimal)field_COUNT40141.getOldValue()));/*$JR_EXPR_ID=11$*/ ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ<-------------------------------------------------------------------------> 3.ÂCannotÂcastÂfromÂBigDecimalÂtoÂBoolean ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂvalueÂ=Â(java.lang.Boolean)(((java.math.BigDecimal)field_COUNT40141.getValue()));/*$JR_EXPR_ID=11$*/ ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ<----------------------------------------------------------------------> 3Âerrors ÂÂÂÂatÂnet.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:193) ÂÂÂÂatÂit.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:576) ÂÂÂÂatÂjava.lang.Thread.run(UnknownÂSource)

 

 

Please help me to resolve the problem