Number Format

[spmkkmps]

Hi,

I need to apply pattern for textfield of type String. Please post your answers as soon as possible. It is of high priority and I need to do it in a short period of time.

 

Thanks

S. PradeepMadhanKumar

[rameshinpower]

Hi Pradeep

 

Try dis one

new DecimalFormat("###0.00;-###0.00").format(    ur feild (String)   )

Hope dis Helps...........

 

Regards

-Ramesh

[spmkkmps]

Hi Ramesh

Thanks for your Reply. And one more thing where do i need to place the code in iReport.

[rameshinpower]

In the Text Feild Expression.......

[spmkkmps]

no ramesh, it is not working. it gives me the following error,

 

net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression :
    Source text : new DecimalFormat("###0.00;-###0.00").format($F{Period})
    at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:197)
    at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:537)
    at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:505)
    at net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:826)
    at net.sf.jasperreports.engine.fill.JRFillTextField.evaluateText(JRFillTextField.java:368)
    at net.sf.jasperreports.engine.fill.JRFillTextField.evaluate(JRFillTextField.java:353)
    at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:275)
    at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:426)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1380)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:692)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:255)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:113)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:879)
    at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:123)
    at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:420)
    at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:383)
    at com.jeevan.ProfitLossBusiness.runReport(ProfitLossBusiness.java:259)
    at com.jeevan.RunReport.doGet(RunReport.java:62)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.IllegalArgumentException: Cannot format given Object as a Number
    at java.text.DecimalFormat.format(Unknown Source)
    at java.text.Format.format(Unknown Source)
    at IncomeReportNew45july08_1247046899293_679318.evaluate(IncomeReportNew45july08_1247046899293_679318:271)
    at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:186)
    ... 31 more
 

 

any idea from your side.

[softboxkid]

Got the same problem... is there any solution???

[prabhudar]

Hi Pradeep,

 

I belive you need to convert the string to Double and then you can pass the pattern.

 

[mark.torres]

This one worked for me..

($V{member_id_MEASURE1} != 0 ? (new DecimalFormat(".00").format(($V{member_id_MEASURE1}/$V{member_id_MEASURE1_deny_reasons1_ALL}) * 100)) : 0 ) + "%"

I added the new DecimalFormat(".00").format( calculations)  the + "%" is to give it like a percent look.