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

Hi all, I have a column in the table dragon_policy which contains a number type datatype Policy_premium. I am to extract value in the monetory form. Example - Values stored inn database - 1520 I am Required - $1520 Thanks and Regards, Ram

I am facing the same problem. I have to sum of rowwise as well column wise of few of the columns.