Jump to content
We've recently updated our Privacy Statement, available here ×

sonal

Members
  • Posts

    3
  • Joined

  • Last visited

sonal's Achievements

Newbie

Newbie (1/14)

  • First Post Rare
  • Conversation Starter Rare
  • Week One Done
  • One Month Later
  • One Year In

Recent Badges

0

Reputation

  1. 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
  2. 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
  3. I am facing the same problem. I have to sum of rowwise as well column wise of few of the columns.
×
×
  • Create New...