Utilizando gráficos, não consigo colocar na categories(onde vc configura o VALUES, CATEGOREIS E SERIES), uma string, só funciona com numero, dá esse erro
illing report… Error filling print… java.lang.NumberFormatException: For input string: “DIA01” at java.lang.NumberFormatException.forInputString(Unknown Source) at java.lang.FloatingDecimal.readJavaFormatString(Unknown Source) at java.lang.Double.valueOf(Unknown Source) at java.lang.Double.<init>(Unknown Source) at it.businesslogic.ireport.chart.DefaultChartFactory.drawChart(DefaultChartFactory.java:187) at atendimentosPorDiaGrafico.evaluate(atendimentosPorDiaGrafico.java:87) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:426) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:362) at net.sf.jasperreports.engine.fill.JRFillImage.evaluateImage(JRFillImage.java:364) at net.sf.jasperreports.engine.fill.JRFillImage.evaluate(JRFillImage.java:347) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:383) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummarySamePage(JRVerticalFiller.java:831) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummary(JRVerticalFiller.java:761) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportEnd(JRVerticalFiller.java:286) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:169) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:691) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:120) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:291) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:207) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:521) at java.lang.Thread.run(Unknown Source) NESTED BY : java.lang.NumberFormatException: For input string: “DIA01” at java.lang.NumberFormatException.forInputString(Unknown Source) at java.lang.FloatingDecimal.readJavaFormatString(Unknown Source) at java.lang.Double.valueOf(Unknown Source) at java.lang.Double.<init>(Unknown Source) at it.businesslogic.ireport.chart.DefaultChartFactory.drawChart(DefaultChartFactory.java:187) at atendimentosPorDiaGrafico.evaluate(atendimentosPorDiaGrafico.java:87) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:426) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:362) at net.sf.jasperreports.engine.fill.JRFillImage.evaluateImage(JRFillImage.java:364) at net.sf.jasperreports.engine.fill.JRFillImage.evaluate(JRFillImage.java:347) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:383) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummarySamePage(JRVerticalFiller.java:831) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummary(JRVerticalFiller.java:761) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportEnd(JRVerticalFiller.java:286) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:169) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:691) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:120) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:291) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:207) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:521) at java.lang.Thread.run(Unknown Source) NESTED BY : net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : image_1 Source text : (java.awt.Image)it.businesslogic.ireport.chart.DefaultChartFactory.drawChart(new String[]{“antialias=true”,“tooltips=true”,“legend=false”,“chartName=Line”,“plotOrientation=2”,“foregroundAlpha=0.33”,“valueLabel=TOTAL DE ATENDIMENTOS”,“subtitle=”,“plotBackground=[255,255,255]”,“quality=1”,“height=302”,“titlePosition=1”,“chartBackground=[255,255,255]”,“width=775”,“depthFactor=0.2”,“serie2=”,“serie1=SERIE_DIAS”,“serie0=SERIE_TOTAL”,“categoryLabel=DIAS”,“title=TOTAL DE ATENDIMENTOS POR DIA”}, (it.businesslogic.ireport.IReportScriptlet)$P{REPORT_SCRIPTLET}) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:433) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:362) at net.sf.jasperreports.engine.fill.JRFillImage.evaluateImage(JRFillImage.java:364) at net.sf.jasperreports.engine.fill.JRFillImage.evaluate(JRFillImage.java:347) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:383) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummarySamePage(JRVerticalFiller.java:831) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummary(JRVerticalFiller.java:761) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportEnd(JRVerticalFiller.java:286) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:169) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:691) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:120) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:291) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:207) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:521) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.NumberFormatException: For input string: “DIA01” at java.lang.NumberFormatException.forInputString(Unknown Source) at java.lang.FloatingDecimal.readJavaFormatString(Unknown Source) at java.lang.Double.valueOf(Unknown Source) at java.lang.Double.<init>(Unknown Source) at it.businesslogic.ireport.chart.DefaultChartFactory.drawChart(DefaultChartFactory.java:187) at atendimentosPorDiaGrafico.evaluate(atendimentosPorDiaGrafico.java:87) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:426) … 15 more Print not filled. Try to use an EmptyDataSource…!
A query é esta
SELECT ‘DIA01’ AS DIAS , NVL(SUM(QTDIA01),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘02’ AS DIAS, NVL(SUM(QTDIA02),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘03’ AS DIAS, NVL(SUM(QTDIA03),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘04’ AS DIAS , NVL(SUM(QTDIA04),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘05’ AS DIAS, NVL(SUM(QTDIA05),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘06’ AS DIAS, NVL(SUM(QTDIA06),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘07’ AS DIAS , NVL(SUM(QTDIA07),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘08’ AS DIAS, NVL(SUM(QTDIA08),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘09’ AS DIAS, NVL(SUM(QTDIA09),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘10’ AS DIAS , NVL(SUM(QTDIA10),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘11’ AS DIAS, NVL(SUM(QTDIA11),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘12’ AS DIAS, NVL(SUM(QTDIA12),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘13’ AS DIAS , NVL(SUM(QTDIA13),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘14’ AS DIAS, NVL(SUM(QTDIA14),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘15’ AS DIAS, NVL(SUM(QTDIA15),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘16’ AS DIAS , NVL(SUM(QTDIA16),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘17’ AS DIAS, NVL(SUM(QTDIA17),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘18’ AS DIAS, NVL(SUM(QTDIA18),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘19’ AS DIAS , NVL(SUM(QTDIA19),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘20’ AS DIAS, NVL(SUM(QTDIA20),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘21’ AS DIAS, NVL(SUM(QTDIA21),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘22’ AS DIAS , NVL(SUM(QTDIA22),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘23’ AS DIAS, NVL(SUM(QTDIA23),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘24’ AS DIAS, NVL(SUM(QTDIA24),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘25’ AS DIAS , NVL(SUM(QTDIA25),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘26’ AS DIAS, NVL(SUM(QTDIA26),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘27’ AS DIAS, NVL(SUM(QTDIA27),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘28’ AS DIAS , NVL(SUM(QTDIA28),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘29’ AS DIAS, NVL(SUM(QTDIA29),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘30’ AS DIAS, NVL(SUM(QTDIA30),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
union
SELECT ‘31’ AS DIAS, NVL(SUM(QTDIA31),0) AS TOTAL
FROM RDA_T_ATEND_ASSUNTO
Alguem poderia me ajudar??