Chart in iReports
I'm trying to create a custom iReport that includes an area chart (e.g. CPU Usage). My series query is as follows:
"SELECT s.val as Value, FROM_UNIXTIME(s.ttime/1000) as Time FROM OpManagerDB.statsdata_hourly s join OpManagerDB.polleddata p ON p.id = s.pollid WHERE p.agent LIKE 'constellation%' AND s.instance LIKE 'CPU%' ORDER BY p.agent, p.name, s.instance, s.ttime". I have tried different ways to set my category and value expressions and resolved it down to $F{Time} and $F{Value} respectively.
When I attempt to execute the report, I receive the following error:
Error�filling�print... java.lang.ClassCastException:�java.lang.Long ����at�net.sf.jasperreports.engine.fill.JRFillChart.evaluateAreaImage(JRFillChart.java:854) ����at�net.sf.jasperreports.engine.fill.JRFillChart.evaluateImage(JRFillChart.java:543) ����at�net.sf.jasperreports.engine.fill.JRFillChart.evaluate(JRFillChart.java:529) ����at�net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:353) ����at�net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1251) ����at�net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:586) ����at�net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:226) ����at�net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:129) ����at�net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:953) ����at�net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:780) ����at�net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) ����at�net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) ����at�net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:163) ����at�it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:625) ����at�java.lang.Thread.run(Unknown�Source) Print�not�filled.�Try�to�use�an�EmptyDataSource...!
There does not appear to be much in the way of useful information on the Net for charting with iReports... Any ideas on the problem? Any tips on good reference sites for iReports?
Thanks,
Eric
"SELECT s.val as Value, FROM_UNIXTIME(s.ttime/1000) as Time FROM OpManagerDB.statsdata_hourly s join OpManagerDB.polleddata p ON p.id = s.pollid WHERE p.agent LIKE 'constellation%' AND s.instance LIKE 'CPU%' ORDER BY p.agent, p.name, s.instance, s.ttime". I have tried different ways to set my category and value expressions and resolved it down to $F{Time} and $F{Value} respectively.
When I attempt to execute the report, I receive the following error:
Error�filling�print... java.lang.ClassCastException:�java.lang.Long ����at�net.sf.jasperreports.engine.fill.JRFillChart.evaluateAreaImage(JRFillChart.java:854) ����at�net.sf.jasperreports.engine.fill.JRFillChart.evaluateImage(JRFillChart.java:543) ����at�net.sf.jasperreports.engine.fill.JRFillChart.evaluate(JRFillChart.java:529) ����at�net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:353) ����at�net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1251) ����at�net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:586) ����at�net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:226) ����at�net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:129) ����at�net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:953) ����at�net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:780) ����at�net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) ����at�net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) ����at�net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:163) ����at�it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:625) ����at�java.lang.Thread.run(Unknown�Source) Print�not�filled.�Try�to�use�an�EmptyDataSource...!
There does not appear to be much in the way of useful information on the Net for charting with iReports... Any ideas on the problem? Any tips on good reference sites for iReports?
Thanks,
Eric