sql and subdataset charts

[2006 JR Open Discussion]

By: Thomas Ludwig Kast - tomkast

sql and subdataset charts

2005-12-31 17:10

hiho,

 

two ideas -

1: for the demo subdataset chart report change the sql from "OrderDate != null" to "OrderDate is not null" (try mysql 4.1)

 

2: need a better error when a seriesName is null. running the demo subdataset chart report, here was the error that i was working with (below). maybe a sql error could be thrown?

 

thanks

 

tom

 

java.lang.NullPointerException

at net.sf.jasperreports.charts.fill.JRFillTimeSeriesDataset.customIncrement(JRFillTimeSeriesDataset.java:133)

at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:134)

at net.sf.jasperreports.engine.fill.JRFillChartDataset.getDataset(JRFillChartDataset.java:57)

at net.sf.jasperreports.engine.fill.JRFillChart.evaluateTimeSeriesImage(JRFillChart.java:1327)

at net.sf.jasperreports.engine.fill.JRFillChart.evaluateImage(JRFillChart.java:586)

at net.sf.jasperreports.engine.fill.JRFillChart.evaluate(JRFillChart.java:534)

at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:211)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1307)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:639)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:230)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:826)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:697)

at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)

at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247)

at net.sf.ussrp.web.CachingReportViewController.handle(CachingReportViewController.java:186)

at org.springframework.web.servlet.mvc.AbstractCommandController.handleRequestInternal(AbstractCommandController

.java:79)

at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:139)

at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java

:44)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)

at org.springframework.web.servlet.FrameworkServlet.serviceWrapper(FrameworkServlet.java:386)

at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:346)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)

at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)

at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)

at java.lang.Thread.run(Thread.java:534)

 

 

 

 

 

 

By: Lucian Chirita - lucianc

RE: sql and subdataset charts

2006-01-03 08:29

Hi

 

The sub dataset sample was already modified on CVS to use "IS NOT NULL".

 

Regards,

Lucian